70-445 Exam
TS:MS SQL Server 2005 Business Intelligence-Implem & Mainte
- Exam Number/Code : 70-445
- Exam Name : TS:MS SQL Server 2005 Business Intelligence-Implem & Mainte
- Questions and Answers : 105 Q&As
- Update Time: 2011-09-21
- Price:
$ 119.00$ 69.00
Free 70-445 Demo Download
Test4pass offers free demo for TS 70-445 exam (TS:MS SQL Server 2005 Business Intelligence-Implem & Mainte). You can check out the interface, question quality and usability of our practice exams before you decide to buy it. We are the only one site can offer demo for almost all products.
Exam Description
It is well known that 70-445 exam test is the hot exam of Microsoft certification. Test4pass offer you all the Q&A of the 70-445 real test . It is the examination of the perfect combination and it will help you pass 70-445 exam at the first time!
Why choose Test4pass 70-445 braindumps
Quality and Value for the 70-445 Exam
100% Guarantee to Pass Your 70-445 Exam
Downloadable, Interactive 70-445 Testing engines
Verified Answers Researched by Industry Experts
Drag and Drop questions as experienced in the Actual Exams
Practice Test Questions accompanied by exhibits
Our Practice Test Questions are backed by our 100% MONEY BACK GUARANTEE.
Microsoft TS 70-445 exam braindumps questions and answers
¡¡
¡¡
Exam : Microsoft 70-445
Title : TS:MS SQL Server 2005 Business Intelligence-Implem & Mainte
1. 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
2. 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
3. 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
4. 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
5. 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
6. 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
7. 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
8. 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
9. 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
10. 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
11. 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
12. 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
13. 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
14. 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
Click Online chat to talk with us , get more informations about Microsoft TS 70-445 practice exam study guides questions and answers
¡¡
Exam : Microsoft 70-445
Title : TS:MS SQL Server 2005 Business Intelligence-Implem & Mainte
1. 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
2. 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
3. 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
4. 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
5. 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
6. 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
7. 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
8. 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
9. 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
10. 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
11. 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
12. 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
13. 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
14. 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
Click Online chat to talk with us , get more informations about Microsoft TS 70-445 practice exam study guides questions and answers
Test4pass 70-445 Exam Features
Quality and Value for the 70-445 Exam
Test4pass Practice Exams for Microsoft 70-445 are written to the highest standards of technical accuracy, using only certified subject matter experts and published authors for development.
100% Guarantee to Pass Your 70-445 Exam
If you prepare for the exam using our Test4pass testing engine, we guarantee your success in the first attempt. If you do not pass the TS 70-445 exam (ProCurve Secure WAN) on your first attempt we will give you a FULL REFUND of your purchasing fee AND send you another same value product for free.
Microsoft 70-445 Downloadable, Printable Exams (in PDF format)
Our Exam 70-445 Preparation Material provides you everything you will need to take your 70-445 Exam. The 70-445 Exam details are researched and produced by Professional Certification Experts who are constantly using industry experience to produce precise, and logical. You may get questions from different web sites or books, but logic is the key. Our Product will help you not only pass in the first try, but also save your valuable time.
70-445 Downloadable, Interactive Testing engines
We are all well aware that a major problem in the IT industry is that there is a lack of quality study materials. Our Exam Preparation Material provides you everything you will need to take a certification examination. Like actual certification exams, our Practice Tests are in multiple-choice (MCQs) Our Microsoft 70-445 Exam will provide you with free 70-445 dumps questions with verified answers that reflect the actual exam. These questions and answers provide you with the experience of taking the actual test. High quality and Value for the 70-445 Exam:100% Guarantee to Pass Your TS exam and get your TS Certification.
Test4pass 70-445 examTest4pass 70-445 pdf exam
Test4pass 70-445 braindumps
Test4pass 70-445 study guides
Test4pass 70-445 trainning materials
Test4pass 70-445 simulations
Test4pass 70-445 testing engine
Test4pass 70-445 vce
Test4pass 70-445 torrent
Test4pass 70-445 dumps
free download 70-445
Test4pass 70-445 practice exam
Test4pass 70-445 preparation files
Test4pass 70-445 questions
Test4pass 70-445 answers
http://www.test4pass.com/70-445-exam.html The safer.easier way to get TS Certification
.
