070-448 試験問題を無料オンラインアクセス

You are developing a SQL Server 2008 Integration Services (SSIS) package.
The package performs the following tasks:
Processes multiple files by using a ForEach Loop container.
Imports the contents of the files to a table by using a Data Flow task.
Logs the results of the status into a table by using an Execute SQL task.
You need to ensure that all the tasks of the package except the Execute SQL task execute within a single
transaction.
Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)

• A.In the package, configure the TransactionOption property to NotSupported.
• B.In the Data Flow task, configure the TransactionOption property to Required.
• C.In the Execute SQL task, configure the TransactionOption property to NotSupported.
• D.In the Foreach Loop container, configure the TransactionOption property to NotSupported.
• E.In the Execute SQL task, configure the TransactionOption property to Supported.
• F.In the package, configure the TransactionOption property to Required.

You create a SQL Server 2008 Integration Services (SSIS) package by using SQL Server 2008.
You use a development server named SQL_DEV1. There is no network connectivity between the
development server and the production server.
You deploy the package to the SQL_PROD1 server.
The package fails to execute. The error message states that the package cannot connect to the
SQL_DEV1
server.
You need to modify the package to refer to the SQL_PROD1 server when being executed.
What should you do?

• A.Modify the properties of the package to use the DontSaveSensitive package protection level.
• B.Modify the deployment manifest file in Microsoft Notepad, and then modify the connection string manually.
• C.Modify the properties of the package to use the ServerStorage package protection level.
• D.On the Connection Managers tab of the Execute Package utility, select the Connection Manager check box, and then modify the connection string.

You manage the security in SQL Server 2008 R2 Reporting Services (SSRS).
You create a new role.
You need to grant the following permissions to the role:
View and modify security settings for reports, folders, resources, and shared data sources.
Create and delete reports.
Modify report properties.
View content, definition, and property for reports.
Which three actions should you perform? (Each correct answer presents part of the solution, Choose
three.)

• A.Assign the Manage Reports task to the role.
• B.Assign the Manage All Subscriptions task to the role.
• C.Assign Set Security Policies for Items task to the role.
• D.Assign the Manage Resources task to the role.
• E.Assign the Consume Reports task to the role.

You are developing a SQL Server 2008 Reporting Service (SSRS) report for a DotNetNuke (DNN) application. The DNN application and SSRS are located on the same server. A custom module has been built in DNN to display the reports.
You need to enable the DNN application to connect to the report.
What should you do?

• A.Modify the properties of ServerURL.
• B.Use the SSRS Web service.
• C.Modify the RSReportServer.config file.
• D.Deploy the report to the Report Server.

You maintain a SQL Server 2008 Analysis Services (SSAS) database on a production server. The
database contains a cube.
You add new functionality to the cube on a development server.
You need to deploy the new functionality from the development server to the production server by ensuring
that the effect on the users is minimized.
What should you do?

• A.Detach the production database. Copy the appropriate files to the production server, and then attach the database on the production server.
• B.Use the Synchronize Database Wizard.
• C.Copy the appropriate files from the development server to the production server.
• D.Modify the Target Server property to the production server by using Business Intelligence Development Studio (BIDS). Deploy the solution.