You need to ensure that users can continue to use parameters to filter the report
You maintain a report in a SQL Server 2008 Reporting Services (SSRS) instance.
The report contains query parameters that allow users to filter the contents of the report. The
report queries the data source randomly.
You configure the report to be rendered from a report execution snapshot.
You need to ensure that users can continue to use parameters to filter the report.
What should you do?
Which Transact-SQL statement should you include at the beginning of the stored procedure?
You create a stored procedure that will update multiple tables within a transaction.
You need to ensure that if the stored procedure raises a run-time error, the entire transaction is
terminated and rolled back.
Which Transact-SQL statement should you include at the beginning of the stored procedure?
Which three tasks should you perform?
You administer a SQL Server 2008 infrastructure. You implement log shipping for several
databases on three SQL Server instances. The logs are shipped to a fourth SQL Server
instance. You plan a manual failover. You need to ensure that the database applications
use the secondary server after failover. You also need to ensure that users can access the
most recent data. Which three tasks should you perform? (Each correct answer presents
part of the solution. Choose three.)
You need to grant the permissions to the user to publish reports and manage content only in a private folder
You are managing the security in SQL Server 2008 Reporting Services (SSRS).
You assign a new user to a role. You need to grant the permissions to the user to publish
reports and manage content only in a private folder.
What should you do?
You need to configure the report server for e-mail message delivery by using a remote SMTP server
You install and configure SQL Server 2008 Reporting Services (SSRS) instance. The users
of the report server plan to deliver reports through e-mail messages. You need to configure
the report server for e-mail message delivery by using a remote SMTP server. What should
you do?
Which message type should you use?
You plan to create a Service Broker solution. The solution will transport data from one
queue to another queue. You need to identify which message type must be used to
transport binary data. The solution must minimize the amount of data transported. Which
message type should you use?
You need to ensure that when the report project is deployed in future, the existing reports are unaffected
You maintain an instance of SQL Server 2008 Reporting Services (SSRS). The instance
contains several reports.
You deploy a report project on the instance by using the Business Intelligence Development
Studio (BIDS). You discover that the production data sources on the instance are replaced
by the test data sources of the report project.
You need to ensure that when the report project is deployed in future, the existing reports
are unaffected.
What should you do?
You need to ensure that the backup jobs have a minimal effect on the performance of the server
You administer a SQL Server 2008 instance that hosts a large database. The database
experiences high volumes of queries and transactions that are processor-intensive. You
plan to implement an incremental backup strategy for the database. You also plan to use
backup compression. You need to ensure that the backup jobs have a minimal effect on the
performance of the server. What should you do?
Which two actions should you perform?
You implement a SQL Server 2008 Integration Services (SSIS) package. The package
contains the following components:
• A Foreach Loop container for the Collection property as shown in the following exhibit.
(Click the Exhibit button.)
• A Foreach Loop container for the Variable Mappings property as shown in the following
exhibit.
(Click the Exhibit button.)
• A String variable named FileName.
• A String variable named DirectoryPath.
You need to update the package so that the DirectoryPath variable returns the directory path
for the file path stored in the FileName variable. Which two actions should you perform?
(Each correct answer presents part of the solution. Choose two.)
Which two actions should you perform?
You are designing a SQL Server 2008 Integration Services (SSIS) package. The package
includes a Data Flow task.
You need to modify the package to write all rows that generate errors to a text file.
Which two actions should you perform? (Each correct answer presents part of the solution.
Choose two.)