Online Access Free 070-448 Exam Questions

You develop a SQL Server 2008 Integration Services (SSIS) package.
The structure of the package is as shown in the following exhibit.
You need to define a variable that contains sensitive information that is only available to the Sequence
Container, the Data Flow Task, and the Execute SQL Task.
What should you do?

• A.Create the variable at the Data Flow Task scope.
• B.Create the variable at the package scope.
• C.Create the variable at the Execute SQL Task scope.
• D.Create the variable at the Sequence Container scope.

You are designing a SQL Server 2008 Integration Services (SSIS) package.
The package includes a Data Flow task that copies several million rows. The data flow requires a match
against a reference table that contains 10,000 rows. Each row in the reference table will be used during the
data flow.
Same row are not matching due to a mismatched case type
You need to ensure that the data flow executes to match all rows correctly.
Which data flow component should you select?

• A.A Lookup transformation along with the Partial cache option
• B.A Lookup transformation along with the Full cache option
• C.A Lookup transformation along with the No cache option
• D.A Fuzzy Lookup transformation

Note: This question is part of a series of questions that use the same of similar answer choices. An answer choice may be correct for more than one question in the series. Each question is independent of the other questions in this series. Information and details provided in a question apply only to that question.
You maintain the SQL Server 2008 Integration Services (SSIS) instance for a healthcare device manufacturing company.
You develop a package named Memberinformation.dtsx with Windows authentication. You deploy it to SQL Server.
You need to validate Memberinformation.dtsx packages without package execution.
Which command syntax should you use?

• A.dtutil /FILE c:\ SSISpackages|Memberinformation.dstx /DestServer DBPROD /COPY SQL; Memberinformation.dtsx
• B.dtexec /f " Z:\ Memberinformation.dtsx " /conf "
  Z: \Memberinformationconfig,cfg "
• C.dtutil /FILE c:\SSISpackages\Memberinformation.dtsx /COPY FILE;W: \ProdSSISpackages\ Memberinformation_Prod.dtsx
• D.dtexec /sq Memberinformation /ser productionServer / va
• E.dtexec /f "c: \ Memberinformation .dtsx" /1 " DTS.LogProviderTextFile;Y:\Loginformation.txt"
• F.dtutil /SQL Memberinformation /COPY DTS;c:\SSISpackages\Memberinformation
• G.dtutil /FILE c:\ SSISpackages|Memberinformation.dstx /COPY SQL; Memberinformation.dtsx
• H.dtexec /sq Memberinformation / verify (a400e860-38d5-11c5-11ce-ae62-08002b2b79ef)

You are designing a SQL Server 2008 Integration Services (SSIS) packagE.The package includes a Data
Flow task that copies several million rows. The data flow requires a match against a reference table that
contains 10,000 rows. Each row in the reference table will be used during the data flow.
You need to ensure that the data flow executes in the minimum amount of time.
Which data flow component should you select?

• A.a Lookup transformation along with the Full cache option
• B.a Lookup transformation along with the Partial cache option
• C.a Lookup transformation along with the No cache option
• D.a Fuzzy Lookup transformation

You administer a SQL Server 2008 Analysis Services (SSAS) instance.
You plan to troubleshoot query performance by using a Dynamic Management View (DMV).
You need to identify query sessions that execute more than 10 commands prior to disconnecting.
Which DMV should you use?

• A.Discover_Commands
• B.Discover_Connections
• C.Discover_Traces
• D.Discover_Sessions