You design a SQL Server 2008 Integration Services (SSIS) package that contains several data flows.
You need to monitor the data that passes through each path in the data flow by using the Business
Intelligence Development Studio. You also need to ensure that data flow logic is retained.
What should you do?

• A. Use the Data Viewer tool.
• B. Use the Data Profiling task.
• C. Use the Audit transformation.
• D. Use breakpoints in the Script component.

Note: This question is part of a series of questions that use the same or similar answer choices. An answer choice may be correct for more than one question in this series. Information and details provided in a question apply only to the question.
You maintain the SQL Server 2008 Integration Services (SSIS) instance for a healthcare supply chain data management company. Your company uses third-party event based scheduler.
You develop a package named Memberinformation.dtsx and save it in the SSISpackages folder on the company network. You need to deploy this package to the ProdSSISpackages file system on the production server. You need to rename the package to Memberinformation_Prod.dtsx, and the event based scheduler will execute the renamed package.
Which command syntax should you use?

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

You develop a SQL Server 2008 Reporting Services (SSRS) report.
The report contains a parameter named Category that is used to filter a list of products. The list uses a
dataset that contains the following query:
SELECT p.ProductID, p.Name, p.ListPrice
FROM Production.Product AS p
WHERE p.Category = @Category;
You modify the report parameter to allow multiple values.
You need to modify the report to help search for multiple Category values by using minimum amount of
development effort.
What should you do?

• A. Implement the query in a view.
• B. Implement the query in a table-valued user-defined function.
• C. Implement the query in a stored procedure that uses dynamic SQL to execute the query.
• D. Modify the query to use the IN operator instead of the = operator.

You create a SQL Server 2008 Analysis Services (SSAS) solution.
The solution contains a time dimension named DimTime. You have a table named FactSales that contains
the two columns named OrderDate and ShipDate. The two columns refer to the DimTime dimension.
You need to ensure that the DimTime dimension can be used to browse through measures in the FactSales
table for both OrderDate and ShipDate.
What should you do?

• A. Create a reference relationship between the DimTime dimension and the FactSales measure group.
• B. Create two regular relationships between the DimTime dimension and the FactSales measure group. Use identical measure group columns.
• C. Create two regular relationships between the DimTime dimension and the FactSales measure group. Use different measure group columns.
• D. Create a many-to-many relationship between the DimTime dimension and the FactSales measure group.