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

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 are SQL Server 2008 Reporting Services (SSRS) developer. You develop a report with two parameters
names State and City in that order.
When the State parameter is selected, the City parameter should be filtered by the State selected.
You need to enable this functionality.
What should you do?

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

You are developing a SQL Server 2008 Integration Services (SSIS) data flow that loads data to a SQL Server 2008 database.
You need to ensure that the data flow updates the existing records and inserts the updated records into the SQL Server database by using data from the rows in your data flow.
Which three data flow components should you use? (Each correct answer presents part of the solution. Choose three.)

• A. OLE DB Command Transformation
• B. Data Conversion Transformation
• C. OLE DB Destination
• D. Lookup Transformation
• E. Conditional Split Transformation

You design a SQL Server 2008 Integration Services (SSIS) package. The package extracts data from flat
files and loads this data to a SQL Server 2008 database.
The package contains two Boolean variables named @IsWeekday and @IsHoliday. When the package is
executed on week days, the @IsWeekday variable is set to True. When the package is executed on
holidays, the @IsHoliday variable is set to TruE.You need to implement the following business logic in the
control flow of the package:
When the @IsWeekday variable is set to True, the Perform Weekday Processing Data Flow task is
executed.
When the @IsWeekday variable is set to False, the Perform Weekend Processing Data Flow task is
executed.
When the @IsHoliday variable is set to True, the Perform Holiday Processing Data Flow task is executed.
Which control flow logic should you implement?

• A. Option A
• B. Option B
• C. Option C
• D. Option D