examsoon 70-445 pdf dumps.pdf

About Global Documents

Global Documents provides you with documents from around the globe on a variety of topics for your enjoyment.
Global Documents utilizes edocr for all its document needs due to edocr's wonderful content features. Thousands of professionals and businesses around the globe publish marketing, sales, operations, customer service and financial documents making it easier for prospects and customers to find content.
Microsoft SQL Server package report Data Flow task Exam control Flow task property
70-445 TS Braindump 
ExamSoon 70-445 Exams
Microsoft TS:MS SQL Server 2005 Business Intelligence-Implem & Mainte
 
O rder : 70-445 Exam
Practice Exam: 70-445
Exam Number/Code: 70-445
Exam Name: TS:MS SQL Server 2005 Business Intelligence-Implem & Mainte
Questions and Answers: 105 Q&As 
Free 70-445 Braindumps
  
  
Exam : Microsoft 70-445
Title : TS:MS SQL Server 2005 Business Intelligence-Implem & Mainte
1. You are designing a Microsoft SQL Server 2005 Reporting Services (SSRS) report. The report uses a dataset that 
is constructed from an SQL table named Employees. The table has an employeeID field and a managerID field. The 
managerID field in each row represents the employeeID field.
You execute the following Transact-SQL query to get the dataset from the report:
SELECT CONVERT(varchar(255), c.FirstName + ' ' + c.LastName)
as Name,
e.EmployeeID,
e.ManagerID
FROM HumanResources.Employee AS e
JOIN Person.Contact AS c
ON e.ContactID = c.ContactID
You need to display the dataset as a hierarchical, organizational chart, as shown in the Exhibit. (Click the Exhibit 
button.)
What should you do?
A. Use the Level function in the Left property of the Padding property of the cell.
B. Group the report by the employeeID field and set the managerID field as the group parent.
C. Group the report by the managerID field and set the employeeID field as the group parent. Use the Level function in 
the Left property of the Padding property of the cell.
D. Group the report by the employeeID field and set the managerID field as the group parent. Use the Level function in 
the Left property of the Padding property of the cell.
Answer: D
2. Microsoft SQL Server Management Studio (SSMS) is installed on your workstation. Microsoft Business Intelligence 
Development Studio (BIDS) is not installed on your workstation.
You need to create a package that must meet the following requirements:
It must be transactional.
It must be optimized for 20 tables.
It must be stored securely in the msdb database of a remote server.
What should you do?
A. Create the package by using DTS Designer.
B. Create the package by using the Package Migration Wizard.
 
 

 
 
C. Create the package by using the Microsoft SQL Server Import and Export Wizard.
D. On the Microsoft SQL Server 2005 Integration Services (SSIS) menu, click the Create Package submenu.
Answer: C
3. You are designing a Microsoft SQL Server 2005 Reporting Services (SSRS) report.
You create a report parameter named DisplayCol that contains the following properties:
Data Type: Integer
Prompt: Display Column
Available Values: Non-queried with the following Label/Value pairs: 
oYes/1
oNo/0
Default Values: Null
The report parameter is used to control the visibility of the column. You need to use the appropriate expression in the 
Hidden property for the column.
Which expression should you use?
A. "=Parameters!DisplayCol.Value"
B. "=Parameters!rc:DisplayCol.Value"
C. "=Iif(Parameters!DisplayCol.Value=1,False,True)"
D. "=Iif(Parameters!rc:DisplayCol.Value=1,False,True)"
Answer: C
4. You are designing a Microsoft SQL Server 2005 Integration Services (SSIS) package. The package contains 30 
Data Flow tasks and 30 Control Flow tasks. The package runs slower than expected. You need to capture the start 
time, the finish time, and the elapsed time for the validation and execution of the package. What should you do?
A. Enable the OnProgress event handler and use the Control Flow tasks to write the information to a log.
B. Monitor the Progress tab during the execution of the package, and then monitor the Execution Results tab.
C. Use the Performance Monitor tool to capture the counters from the SQL Server: SSIS Service object. Analyze the 
output for the required information.
D. Use the Performance Monitor tool to capture the counters from the SQL Server: SSIS Pipeline object. Analyze the 
output for the required information.
Answer: B
5. You are designing a Microsoft SQL Server 2005 Integration Services (SSIS) package.
The package uses at least one sequence container in one transaction. Each transaction controls a Data Flow task 
and a Control Flow task. Each Data Flow task has a Success constraint.
The Control Flow task follows the Success constraint. The package must include the following requirements:
Each Data Flow task must use its own transaction.
The Control Flow task and the Data Flow task that precedes it must succeed or fail as an atomic unit.
A restart point must restart each Data Flow task and the Control Flow task that follows it as an atomic unit.
You need to make changes in the control flow designer to meet the outlined requirements.
Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)
A. Add all the Data Flow tasks and the Control Flow tasks to one sequence container.
B. Add a sequence container for each Control Flow task and the Data Flow task that precedes it.
C. Change the FailPackageonFailure property to true for each new sequence container that is added to the package.
D. Change the FailPackageonFailure property to false for each new sequence container that is added to the package.
Answer: BC
6. You create 25 Microsoft SQL Server 2005 Integration Services (SSIS) packages on the development server. You 
decide to deploy the SSIS packages on the test server. You need to create a repeatable process that will allow you to 
deploy the packages to the package store on the test server if the packages change. You also need to ensure that 
this is achieved with minimum effort. What should you do?
A. Use Microsoft SQL Server Business Intelligence Development Studio (BIDS) to save each package to the remote 
server.
B. Use the dtutil utility in a batch file to deploy each of the package .dtsx files to the remote server with the /Fi option. 
 
 
 

 
 
 
C. Copy the Microsoft SQL Server Business Intelligence Development Studio (BIDS) files to the remote server and 
build the SSIS project on the remote server.
D. Create a package deployment utility in Microsoft SQL Server Business Intelligence Development Studio (BIDS) and 
use the Deployment Wizard to deploy all the packages.
Answer: D
7. You are designing a Microsoft SQL Server 2005 Reporting Services (SSRS) report that supports drilldown. You 
need to modify the report so that the detailed data is hidden when the report is initially rendered. What should you do?
A. Add the detailed data to a Group. Set the Hidden property of the Group to true.
B. Add the detailed data to a Matrix. Set the IsToggleChild property of the Matrix to true.
C. Add the detailed data to a Subreport. Set the Hidden property of the Subreport to true.
D. Add the detailed data to a Subreport. Set the IsToggleChild property of the Subreport to true.
Answer: A
8. You are designing a Microsoft SQL Server 2005 Integration Services (SSIS) package.
While testing, a Transact-SQL user-defined function causes duplicate key values that stop the transformation. 
To permit the transformation to continue, the package must perform the following tasks:
1. Ascertain which rows are affected.
2. Insert the rows that fail into a table.
3. Continue with the process.
You need to change certain properties in the package to meet the requirements.
Which three tasks should you perform? (Each correct answer presents part of the solution. Choose three.)
A. Choose the Redirect Row option for the Error property on the key column.
B. Choose the Ignore Failure option for the Error property on the key column.
C. Choose the Fail Component option for the Error property on the key column.
D. Add a DataReader source to use a new Data Flow destination when the Failure constraint is fired.
E. Add a DataReader source to use a new Data Flow destination when the Completion constraint is fired.
F. Edit the Error Output properties for each DataReader source and configure each data source for error handling.
Answer: ADF
9. You are designing a Microsoft SQL Server 2005 Integration Services (SSIS) package. The package is connected to 
a database on your development server by using a connection manager. You decide to use the DTExecUI utility to run 
the package. You need to change the connection of the connection manager to a different server at run time without 
using a package configuration file. What should you do?
A. Specify an appropriate command file by using the Command Files dialog box.
B. Specify an appropriate Connection String variable in the Set Values dialog box.
C. Specify an appropriate package configuration by using the Configurations dialog box.
D. Specify a different connection string for the connection manager by using the Connection Manager dialog box.
Answer: D
10. You are designing a Microsoft SQL Server 2005 Integration Services (SSIS) package. The package is named 
UpdateTable.dtsx and contains a variable named runID. The package must run by using the dtexec utility. The runID 
variable must be set at runtime to a value of 5. You need to meet the outlined requirements. What should you do?
A. Execute dtexec /F "c:ssisPackagesUpdateTable.dtsx" /SET packages.variables[runID].Value;5.
B. Execute dtexec /F "c:ssisPackagesUpdateTable.dtsx" /SET packages.variables.runID=5.
C. Create a text file that specifies the variable name and value in the format package.variables[runID].Value = 5. 
Execute dtexec /F "c:ssisPackagesUpdateTable.dtsx" /COM <filename> where <filename> is the name of the file you 
just created.
D. Create a text file that specifies the variable name and value in the format runID=5. Execute dtexec /F 
"c:ssisPackagesUpdateTable.dtsx" /COM <filename> where <filename> is the name of the text file you just created.
Answer: A
11. You are designing a Microsoft SQL Server 2005 Reporting Services (SSRS) report. The report must use a custom 
assembly to perform real-time lookup and currency conversion. The assembly has a static class named 
 
 
 

 
 
  
CurrencyConversion that exists in the namespace FinancialCalc. The class has a method named ToEUR that requires 
two arguments, Currency and CurrencyCode. You need to reference the ToEUR method in an expression to convert 
USD to EURO when the report runs. Which expression should you use?
A. =Code.FinancialCalc.CurrencyConversion.ToEUR (Fields!Currency.Value,"USD")
B. =Code!FinancialCalc.CurrencyConversion.ToEUR (Fields!Currency.Value,"USD")
C. =FinancialCalc.CurrencyConversion.ToEUR (Fields!Currency.Value,"USD")
D. =FinancialCalc!CurrencyConversion.ToEUR (Fields!Currency.Value,"USD")
Answer: C
12. You are designing a Microsoft SQL Server 2005 Reporting Services (SSRS) report. You notice that while printing a 
report, blank pages are printed after every page that contains the data. But the report appears correctly when you view 
it on screen. You need to ensure that the blank pages are not printed. Which report property should you use?
A. Page Size
B. Grid Spacing
C. Interactive Size
D. DataTransform
Answer: A
13. You are designing a Microsoft SQL Server 2005 Reporting Services (SSRS) report. The report has three columns 
in a table. The columns are named MachineName, MachineMfr, and MachineModel. The report navigation options 
must allow users to click on a row from the MachineName column and drill through to another report, and then pass 
the contents of the MachineName column as a parameter named MachineName. You need to configure the report 
navigation options to satisfy the user requirements. Which three tasks should you perform? (Each correct answer 
presents part of the solution. Choose three.)
A. On the General tab, select the data region.
B. On the Visibility tab, select the expression for the report item.
C. On the Navigation tab, select the report for the Hyperlink action.
D. On the Navigation tab, select the bookmark for the Hyperlink action.
E. On the Navigation tab, add an expression to the Hyperlink action parameters.
F. On the Navigation tab, add the name and the value to the Hyperlink action parameters.
Answer: DEF
14. You are designing a Microsoft SQL Server 2005 Reporting Services (SSRS) report model. Users must develop 
their own SSRS reports by using your report model in the Report Builder tool. The data source for the report model is 
a Microsoft SQL Server 2000 database that contains 900 tables and 700 views. You need to build a report model that 
allows users access to only the 10 tables that they require for reporting. What should you do?
A. Select the Create roles rule when you generate the report model.
B. Create a data source view and select the Restrict to Schema(s) option.
C. Create a data source view and select only the required tables and views.
D. Clear the Create entities for all tables rule when you generate the report model.
Answer: C
15. You are designing a Microsoft SQL Server 2005 Integration Services (SSIS) package.
The package has the following features:
Two Data Flow tasks and two Control Flow tasks
A success constraint between each Data Flow task and the subsequent Control Flow task
The package uses one transaction for all the tasks.
You need to configure the package so that the two Data Flow tasks use their own transactions. You also need to 
ensure that each Control Flow task is enlisted in the same transaction as its preceding Data Flow task.
Which three actions should you perform? (Each correct answer presents part of the solution. Choose three.)
A. Change the TransactionOption property to Supported for the package.
B. Change the TransactionOption property to Required for the package.
C. Change the TransactionOption property to Supported for each Data Flow task.
D. Change the TransactionOption property to Required for each Data Flow task.
 
 
 

 
 
E. Change the TransactionOption property to Supported for each Control Flow task.
F. Change the TransactionOption property to Required for each Control Flow task.
Answer: ADE
16. You are designing a Microsoft SQL Server 2005 Reporting Services (SSRS) accounting report. Every other line of 
output in the report table must have a green background. You need to use the appropriate expression for the 
BackgroundColor property of the table. Which expression should you use?
A. =Iif((RowNumber("Odd")),"Green","White")
B. =Iif((RowNumber(Nothing)),"Green","White")
C. =Iif((RowNumber(Nothing) MOD 2),"Green","White")
D. =Iif((RowNumber(InScope("Odd"))),"Green","White")
Answer: C
17. You are designing a Microsoft SQL Server 2005 Integration Services (SSIS) package.
The OLE DB data source for the package is a database that is updated frequently.
You need to create a package that accomplishes the following tasks:
Implement the IRowsetFastLoad interface.
Support various data flow destinations.
Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)
A. Use an OLE DB data flow destination.
B. Use a Recordset data flow destination.
C. Use a DataReader data flow destination.
D. Create separate data flow destinations within the same Data Flow task.
Answer: AD
18. You are designing a Microsoft SQL Server 2005 Integration Services (SSIS) package. You create a table and 
populate the table with the required data. You receive an error message "destination table not found" when you run the 
package without the package destination objects. You need to set a package property that runs the package without 
giving the "destination table not found" error message when the configuration setting of the Connection Manager fails. 
Which package property should you set?
A. DelayValidation = true
B. MaximumErrorCount = 2
C. DisableEventHandler = true
D. FailPackageOnFailure = false
Answer: A
19. You are designing a Microsoft SQL Server 2005 Reporting Services (SSRS) report. The report is based on the 
multidimensional data from a Microsoft SQL Server 2005 Analysis Services (SSAS) cube. You need to use the Report 
Wizard to create a Matrix report by using the [Change Count] measure in the Details field. Which Multidimensional 
Expressions (MDX) query should you use?
A. SELECT NON EMPTY { [Measures].[Change Count] } ON ROWS, DIMENSION PROPERTIES 
MEMBER_CAPTION { [Measures]. [Change Count] } ON COLUMNS
B. SELECT NON EMPTY { [Measures].[Change Count] } ON COLUMNS, DIMENSION PROPERTIES 
MEMBER_CAPTION { [Measures]. [Change Count] } ON ROWS
C. SELECT DIMENSION PROPERTIES MEMBER_CAPTION { [Measures].[Change Count] } ON ROWS
D. SELECT DIMENSION PROPERTIES MEMBER_CAPTION { [Measures].[Change Count] } ON COLUMNS
Answer: B
20. You are designing a Microsoft SQL Server 2005 Integration Services (SSIS) package. You need to ensure that the 
package came from a trusted source. What should you do?
A. Change the CheckSignatureOnLoad property of the package to false.
B. Change the CheckSignatureOnLoad property of the package to true.
C. Create a certificate. Change the CheckSignatureOnLoad property of the package to false.
D. Create a certificate. Change the CheckSignatureOnLoad property of the package to true.
 

 
 
Answer: D
More 70-445 Braindumps Information 
Exam Description
1. ExamSoon offer free update service for three month.
After you purchase our product, we will offer free update in time for three month. 
2. High quality and Value for the 70-445 Exam. 
ExamSoon Practice Exams for 70-445 are written to the highest standards of technical accuracy, provided by our 
certified subject matter experts and published authors for development.
3. 100% Guarantee to Pass Your TS exam and get your TS Certification.
We guarantee your success in the first attempt. If you do not pass the TS "70-445" (TS:MS SQL Server 2005 
Business Intelligence-Implem & Mainte on your first attempt, send us the official result. We will give you a FULLY 
REFUND of your purchasing fee and send you another same value product for free.
4. ExamSoon TS 70-445 Exam Downloadable. 
Our PDF or Testing Engine Preparation Material of TS 70-445 exam provides everything which you need to pass your 
exam. The TS Certification details are researched and produced by our Professional Certification Experts who are 
constantly using industry experience to produce precise, and logical. You may get "70-445 exam" questions from 
different websites or books, but logic is the key. Our Product will help you not only pass in the first TS:MS SQL 
Server 2005 Business Intelligence-Implem & Mainte( TS ) exam try, but also save your valuable time. 
Comprehensive questions with complete details about 70-445 exam.  
70-445 exam questions accompanied by exhibits. Verified Answers Researched by Industry Experts and almost 
100% correct. 
Drag and Drop questions as experienced in the Real TS exam. 70-445 exam questions updated on regular basis.  
Like actual TS Certification exams, 70-445 exam preparation is in multiple-choice questions (MCQs). Tested by many 
real TS exams before publishing. 
Try free TS exam demo before you decide to buy it in http://www.ExamSoon.com 
High quality and Valued for the 70-445 Exam: 100% Guarantee to Pass Your 70-445 exam and get your TS 
Certification. Come to http://www.ExamSoon.com The easiest and quickest way to get your TS Certification.
ExamSoon professional provides TS 70-445 the newest Q&A, completely covers 70-445 test original topic. With our 
completed TS resources, you will minimize your TS cost and be ready to pass your 70-445 test on Your First Try, 
100% Money Back Guarantee included! 
70-445 Exam Study Guide 
70-445 exam is regarded as one of the most favourite TS Certifications. Many IT professionals prefer to add 70-445 
exam among their credentials. ExamSoon not only caters you all the information regarding the 70-445 exam but also 
provides you the excellent 70-445 study guide which makes the certification exam easy for you. 
ExamSoon Engine Features
Comprehensive questions and answers about 70-445 exam  
70-445 exam questions accompanied by exhibits 
Verified Answers Researched by Industry Experts and almost 100% correct
 
  
 
 
  
  
 

 
70-445 exam questions updated on regular basis 
Same type as the certification exams, 70-445 exam preparation is in multiple-choice questions (MCQs). 
Tested by multiple times before publishing
Try free 70-445 exam demo before you decide to buy it in ExamSoon.com 
ExamSoon Help You Pass Any IT Exam
ExamSoon.com offers incredib le career enhancing opportunities. We are a team of IT professionals that focus on providing 
our customers with the most up to date material for any IT certification exam. This material is so effective that we Guarantee 
you will pass the exam or your money back.
70-640  TS: Windows Server 2008 Active Directory, Configuring  
83-640  TS: Windows Server 2008 Active Directory, Configuring  
70-433  TS: Microsoft SQL Server 2008, Database Development  
70-647  Pro: Windows Server 2008,Enterprise Administrator  
70-642  TS: Windows Server 2008 Network Infrastructure, Configuring  
70-432  TS:MS SQL Server@ 2008,Implementation and Maintenance  
70-643  TS: Windows Server 2008 Applications Infrastructure, Configuring  
70-450  PRO:MS SQL Serv 08,Design,Optimize, & Maintain DB Admin Solu  
70-448  TS:MS SQL Server 2008.Business Intelligence Dev & Maintenan  
70-660  TS:Windows® Internals  
70-561  TS: MS .NET Framework 3.5, ADO.NET Application Development  
70-673  TS: Designing, Assessing, and Optimizing Software Asset Management (SAM)  
70-505  TS: Microsoft .NET Framework 3.5,Windows Forms Application Development  
70-562  TS: MS .NET Framework 3.5, ASP.NET Application Development  
70-541  TS: MS Windows SharePoint Srvics3.0 Application Development  
70-568  Upgrade: Transition your MCPD Enterprise Application Developer Skills to MCPD Enterprise Applications 
Developer 3.5, Par 
70-653  TS:Windows Small Business Server 2008, Configuring  
70-567  Upgrade: Transition your MCPD Web Developer Skills to MCPD ASP.NET Developer 3.5  
70-562CSharp  TS:MS.NET Framework 3.5, ASP.NET Application Development  
70-351  TS: MS Internet Security & Acceleration Serv 2006, Configuring  
Related 70-445 Exams
Other Microsoft Exams
MB6-291 
70-536VB 
70-554VB 
MB2-633 
70-216 
74-139 
70-
431Chinese 
70-632 
70-502 
70-547 
70-673 
70-562VB 
70-528 
MB2-634 
MB6-205 
MB3-207 
70-
642Big5 
70-
442GB2312 
MB3-529 
70-654