Microsoft 70-448 real exam prep : TS:MS SQL Server 2008.Business Intelligence Dev and Maintenan

You have a SQL Server 2008 R2 Analysis Services (SSAS) solution.
You add a new Data Source View (DSV) to the solution. The DSV includes a SalesOrder table with columns for OrderTotal and CostTotal.
You need to derive the profit for each order without modifying the underlying data.
What should you do?

• A. Add a Named Query to the DSV, using Select *,OrderTotal CostTotal from SalesOrder as the expression.
• B. Create a view, SalesProfit, as Select * from SalesOrder.
• C. Create a view, SalesProfit, as Select *, OrderTotal CostTotal as Profit from SalesOrder.
• D. Add a Named Calculation to the SalesOrder table, using OrderTotal,CostTotal as the expression.
• E. Add a Named Query to the DSV and then ass a Named Calculation to that query, using OrderTotal -CostTotal as the expression.
• F. Add a Named Query to the DSV, using Select * from SalesOrder as the expression.
• G. Add a Named Calculation to the SalesOrder table, using OrderTotal CostTotal as the expression.
• H. Add a Named Calculation to the SalesOrder table, using OrderTotal + CostTotal as the expression.

You manage the security in SQL Server 2008 Reporting Services (SSRS). The report server contains a
folder named Management Reports.
All groups can view and modify reports in any folder.
You need to ensure that only the Managers group can view and modify reports in the Management Reports
folder.
What should you do?

• A. Create a Managers rolE. Assign the Managers role to the root folder. Remove all groups from the Management Reports folder.
• B. Add the Managers group to the root folder and assign the Content Manager rolE. Remove all groups from the Management Reports folder.
• C. Remove all groups from the Management Reports folder. Add the Managers group to the folder and assign the Content Manager role.
• D. Create a Managers role. Assign the Managers role to the Management Reports folder. Remove all other groups from the Management Reports folder.

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 users can view, execute, and delete their own packages. What should you do?

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

You are a server administrator of a SQL Server 2008 Analysis Services (SSAS) instance. The instance
contains a database that is used by the members of the Sales group.
You configure a new role named Northern Region by using the "{[Customers].[Region].[Region].[Northern]}"
allowed permission set.
You assign the Sales group to the Northern Region role.
You need to verify that users in the Northern Region role can view data only for their region.
What should you do?

• A. Add the Roles=Northern Region; parameter to the connection string.
• B. Add the User ID=Northern Region; parameter to the connection string.
• C. Select the Enable Visual Totals check box for the Northern Region role.
• D. Temporarily add your account to the Northern Region role.

You develop a SQL Server 2008 Integration Services (SSIS) package.
You need to modify the package to log event data from a text file to the SQL Server database.
What should you do?

• A. Move the package file to the new path.
• B. Modify the log provider.
• C. Modify the Connection Manager.
• D. Modify the Flat File Destination.