REAL QUESTIONS SUBMIT MATERIAL ADVERTISE
Braindumps

Microsoft

Cisco

Citrix

CIW

CompTia

CWNA

Apple

Adobe

HP

Legato

Exin

Filemaker

Brocade

Ericsson

TIA

Veritas

ISEB

SCP

IISFA

ISM

OMG

Apc

Mile2

Foundry

Huawei

McData

Symantec

TeraData

RedHat

Solar Winds

Blue Coat

Riverbed

 

 
 
Click on name of dumper to view the dump
 

Morten

Logan

 
 

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.examcheats.net 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


 

 

Braindumps Real exam questions and verified answers - 100% passing guarantee - cheap prices.

 

Free brain dumps Braindumps, notes, books for free

 

Braindumps and Exams - Instant download real exam questions - Passing guarantee.

Follow us on FaceBook
Braindumps on Facebook
 
 
 
 
 

CheckPoint

Linux

Novell

DB/2

Network Appliance

EC-Council

Nortel

McAfee

Juniper

ISACA

PMI

Sybase

EMC

HDI

SNIA

ISC

Sair

IBM

Lotus

Exam Express

3COM

BICSI

DeLL

Enterasys

Extreme Networks

Guidance Software

Computer Associates

Network General

SAS Institute

Alcatel Lucent

SeeBeyond

TruSecure

Polycom

Hyperion

Hitachi

Nokia

Fortinet

Vmware

Fujitsu

Tibco

Intel

PostgreSQLCE

BusinessObjects

RESSoftware

BlackBerry

AccessData

ICDL

Isilon

SAP

The Open Group

ACSM

Altiris

Avaya

Cognos

F5

Genesys

SDI

ACI

ASQ

Google

H3C

HIPAA

HRCI

SOA

IIBA

Zend