| Braindumps
of 70-445
Microsoft SQL Server 2005 Business
Intelligence – Implementation and Maintenance
Exam Questions, Answers, Braindumps
(70-445)
You can have the real stuff from www.examcheets.com
All exhibits , drag and drops and pass it as quickly
as you can. Best of Luck.
QUESTION 1
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
QUESTION 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
QUESTION 3
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: A, D, F
QUESTION 4
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: B, C
QUESTION 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 DR 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: A, D
QUESTION 6
You are designing a Microsoft SQL Server 2005 Integration
Services (SSIS) package. The package is named UpdateTable.dtsx
and contains a variable named runlD. The package must
run by using the dtexec utility. The runlD 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:\ssisPackages\UpdateTable.dtsx"
/SET \packages.variables[runlD].Value;5.
B. Execute dtexec /F "c:\ssisPackages\UpdateTable.dtsx"
/SET \packages.variables.runlD=5.
C. Create a text file that specifies the variable
name and value in the format package.variables[runlD].Value
= 5. Execute dtexec /F "c:\ssisPackages\UpdateTable.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 runlD=5. Execute dtexec
/F "c:\ssisPackages\UpdateTable.dtsx" /COM
<filename> where <filename> is the name
of the text file you just created.
QUESTION 7
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: D, E, F
QUESTION 8
You are designing a Microsoft SQL Server 2005 Reporting
Services (SSRS) report. The execution of the report
must trigger an event for Notification Services by
using a custom assembly. You need to write a custom
code function named RSNotify that will parse the data
from a field named ProductValue and execute the custom
assembly within the report. Which three tasks should
you perform? (Each correct answer presents part of
the solution. Choose three.)
A. Add a reference to the custom assembly on the Code
tab of the Report Properties dialog box.
B. Add the RSNotify function to the Custom code field
on the Code tab of the Report Properties dialog box.
C. Call the code in an expression by using the following
format: =Code.RSNotify( Fields!ProductValue.Value)
D. Call the code in an expression by using the following
format =Report.ParameterslCode(RSNotify( Fields!ProducrValue.Value))
E. Add a parameter to the Report Parameters dialog
box to reference the custom assembly that contains
the RSNotify function.
F. Add a reference to the custom assembly in the Assembly
name field on the References tab of the Report Properties
dialog box.
Answer: A, C, F
QUESTION 9
You are designing a Microsoft SQL Server 2005 Reporting
Services (SSRS) report. The report uses a dataset
that is based on a Data Mining Extensions (DMX) prediction
query. The query forecasts the probability of purchases
for buyers when specific inputs are given. Users want
to select the values at runtime that might be used
to forecast the probability of a purchase. You need
to implement two report parameters named buyer and
probability that will be used to control the DMX query
at report runtime. Which DMX WHERE clause should you
use?
A. WHERE Buyer = @buyer AND (PredictProbability([Buyer]))
> probability
B. WHERE (Predict([Buyer])) = buyer AND Probability
> probability
C. WHERE (Predict([Buyer])) = buyer AND (PredictProbability(Buyer]))
> probability
D. WHERE (Predict([Probability])) > probability
AND Buyer = buyer
Answer: C
70-445
|
