Microsoft TS:MS SQL Server 2008.Business Intelligence Dev and Maintenan : 070-448

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 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 a SQL Server 2008 Reporting Services (SSRS) instance for a shoe company.
An existing report on shoe sales allows the user to see the company's revenue across many different
attributes.
You need to create a drop down list that filters the report by one or more shoe colors.
You alter the main dataset and configure the report parameter to accept multiple values.
What should you do next?

• A. Create a dynamic data source from a dataset that includes a list of distinct servers.
• B. Configure the Internal Visibility option for the parameter.
• C. Create a dynamic dataset that utilizes the WHERE clause to filter by the parameter.
• D. Create a dynamic dataset that includes a list of the different users.
• E. Create a distinct dataset that includes all possible values and attach it to the parameter.
• F. Develop a report for each environment.
• G. Configure the Hidden Visibility property.
• H. Create a dynamic data source from a dataset by using the IN operator.

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 Partial cache option
• B. a Fuzzy Lookup transformation
• C. a Lookup transformation along with the No cache option
• D. a Lookup transformation along with the Full cache option

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 many-to-many 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 reference relationship between the DimTime dimension and the FactSales measure group.

You design a SQL Server 2008 Integration Services (SSIS) data flow that inserts data from a source
query to a destination table.
You need to insert only those rows that do not already exist in the destination tablE.What are two possible
ways to achieve this goal? (Each correct answer presents a complete solution. Choose two.)

• A. Use the Fuzzy Grouping transformation.
• B. Use the Merge transformation.
• C. Use the Lookup transformation.
• D. Use the Merge Join transformation.
• E. Use the Fuzzy Lookup transformation.
• F. Use the Union All transformation.

You develop a SQL Server 2008 Reporting Services (SSRS) project.
The report will display data from a SQL Server 2005 Analysis Services databasE.You need to ensure that
the report displays member properties and extended properties.
What should you do?

• A. Use the SQL Server Analysis Services data source.
• B. Use the OLE DB for the Analysis Services 8.0 data source.
• C. Use the SQL Server data source.
• D. Use the OLE DB for SQL Server data source.