You need to ensure that data-driven subscriptions successfully execute for this report
You develop a SQL Server 2008 Reporting Services (SSRS) report.
The report uses the “User!UserID” expression in a text box within the report header.
You need to ensure that data-driven subscriptions successfully execute for this report.
What should you do?
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?
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?
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?
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.)
You need to monitor the data that passes through each path in the data flow by using the Business Intelligence
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?
Which data flow component should you select?
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?
You need to apply the configuration to the deployed package
You build and deploy a SQL Server 2008 Integration Services (SSIS) package.
During package development, the XML configuration is not specified.
You need to apply the configuration to the deployed package.
What should you do?