You create a SQL Server 2008 Analysis Services (SSAS) solution.
Your organization wants to track the times that products are ordered, shipped, and received
in an existing cube.
You need to enable this tracking based on Sales, Orders, and Shipments fact tables.
What should you do?

You are a SQL Server 2008 Reporting Services (SSRS) developer. You develop a report
with two parameters named Region and City in that order.
When the Region parameter is selected, the City parameter should be filtered by the Region
selected.
You need to enable this functionality.
What should you do?

You create a SQL Server 2008 Reporting Services (SSRS) report. The report is hosted in a
SharePoint environment.
The UserID is passed into the report automatically when the user views the report. The
UserID will be used to link to other pages on the SharePoint site via url.
You need to prevent the user from seeing their UserID
What should you do?

You develop a SQL Server 2008 Reporting Services (SSRS) instance of a report model.
The organization requires that users of a report be able to dynamically change the server
environment.
You need to create a parameter that gives the user the option to choose the server before
report execution.
What should you do?

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?

You develop reports by using SQL Server 2008 Reporting Services (SSRS) Enterprise
Edition.
You need to use data-driven subscription to distribute reports based on dynamic subscription
data.
Which role should you use?

DRAG DROP
You have a SQL Server 2008 Reporting Services (SSRS) Enterprise Edition instance.
You need to add a second report server to this instance.
In which order should you perform the steps? (To answer, move the appropriate five actions
from the list of actions to the answer area and arrange them in the correct order.)

You are responsible for the SQL Server 2008 Integration Services (SSIS) instance at your
organization. This instance uses SQL Server Authentication.
Other developers develop, configure, and deploy packages to the MSDB database.
You need to determine whether a package named “DailyLoad” exists in the MSDB database
on the local instance of SQL Server.
What is the correct dtutil command syntax?

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?

You are a BI developer for a financial firm.
You are developing a SQL Server 2008 Integration Services (SSIS) instance to load 13
million records into TABLE_C three times daily from TABLE_A and TABLE_B,
TABLE_A is in DATABASE_A hosted on SERVER_A, TABLE_B is in DATABASE_B hosted
on
SERVER_B, TABLE_C is in DATABASE_C hosted on SERVER_C
You are logged on to SERVER_C, You have read-only permissions on SERVER_A and
SERVER_B, These two servers are on different domains with individual firewall settings.
You need to load the records into TABLE_C by performing an inner join on TABLE_A and
TABLE_B,

What should you do?