70-448最も有効な質問と解答で勉強

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. Conditional Split Transformation
• B. Lookup Transformation
• C. OLE DB Command Transformation
• D. OLE DB Destination
• E. Data Conversion Transformation

You implement a SQL Server 2008 Analysis Services (SSAS) solution. You use data mining extensions
(DMX) to query a data mining model.
You write the following DMX code segment to query a Bike Buyer data mining model in a Decision Tree
data mining structure. (Line numbers are included for reference only.)
01 SELECT
02 [Decision Tree].[Bike Buyer] AS Buyer
03 FROM
04 [Decision Tree] 06 (SELECT 28 AS [Age],
07 '2-5 Miles' AS [Commute Distance],
08 '1' AS [House Owner Flag],
09 1 AS [Number Cars Owned],
10 2 AS [Total Children]) AS t
You need to ensure that the input columns automatically map to the columns in the data mining structure.
Which code fragment should you insert at line 05?

• A. NATURAL PREDICTION JOIN
• B. PREDICTION JOIN
• C. INNER JOIN
• D. OPEN QUERY

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 Resources task to the role.
• B. Assign the Consume Reports task to the role.
• C. Assign Set Security Policies for Items task to the role.
• D. Assign the Manage All Subscriptions task to the role.
• E. Assign the Manage Reports task to the role.

You design a package by using SQL Server 2008 Integration Services (SSIS). The package is designed by using your local development environment.
The package extracts data from a remote server and inserts it in the PROD database on the local SQL
Server 2008 instance. You deploy the package to the MSDB database on the production server.
You need to ensure that only users that belong to an appropriate database role can modify and execute the
deployed package. You also need to ensure that these users cannot access other packages that are
deployed to the server.
What should you do?

• A. Assign the users to the db_ssisltduser role.
• B. Assign the users to the db_ssisoperator role.
• C. Assign the users to a custom database role in the PROD database.
• D. Assign the users to a custom database role in the MSDB database.

You maintain a SQL Server 2008 Reporting Services (SSRS) database server.
The instance contains a large number of reports that take a long time to execute. The reports contain
multiple execution snapshots.
You have a new production server along with SSRS installed.
You need to migrate the reports and their snapshots to the production server in the minimum amount of
time.
What should you do?

• A. Use the rs.exe utility.
• B. Deploy the solutions by using Business Intelligence Development Studio (BIDS).
• C. Use the rskeymgmt.exe utility.
• D. Copy the Report Server databases to the production server. Configure the server by using the Reporting Services Configuration tool.