Online Access Free 70-448 Practice Test

You maintain a SQL Server 2008 Analysis Service (SSAS) database in a test environment. You plan to deploy changes from as SSAS project in a development environment to the test environment are replaced by the deployment.
What should you do?

• A.Back up the development database and restore it to the test environment.
• B.Process the database by using the Business Intelligence Design Studio (BIDS).
• C.Update the database by using the Synchronize Database Wizard.
• D.Update the database by using the Deployment Wizard.

You maintain a SQL Server 2008 Reporting Services Instance.
Some users need to view and run reports in the USA Region folder on the Report Server.
You need to assign these users the minimum permissions required.
Which role should you use?

• A.Content Manager
• B.Brower
• C.Publisher
• D.Report Builder

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

You design a report by using SQL Server 2008 Reporting Services (SSRS).
The report uses a Table data region and contains a dataset. The dataset has a column named LastName.
You need to ensure that the report items are grouped by the first character in the LastName column.
Which expression in the Group properties dialog box should you use?

• A.=First(Fields!LastName)
• B.=Fields!LastName.Value.Substring(0,1)
• C.=First(Fields!LastName.Value)
• D.=Fields!LastName.Value

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.Use the Synchronize Database Wizard.
• B.Detach the production database. Copy the appropriate files to the production server, and then attach the database on the production server.
• 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.