Transition Your MCITP: Business Intelligence Developer 2008 to MCSE: Business Intelligence

Question 1

You install SQL Server Reporting Services (SSRS). You need to restore a copy of the symmetric key. Which command should you run?

A. Rskeymgmt -i

B. Rskeymgmt -e -f %temp%\rs.key -p Password1

C. Rskeymgmt -a -f %temp%\rs.key -p Password1

D. Rskeymgmt -d

Correct Answer: C

Question 2

HOTSPOT
A company maintains separate environments for test, production, and quality assurance. The company uses the project deployment model for SQL Server Integration Services (SSIS) deployments.
You create an SSIS project to perform a weekly refresh of the company's data warehouse and cubes. The project has three packages.
You need to configure the project to ensure so that the test and production teams can run each package without manually adding server-specific information.
Which program should you use?
To answer, select the appropriate program in the answer area.

Correct Answer:

Question 3

DRAG DROP
You are developing a SQL Server Reporting Services (SSRS) report to display a list of employees. The report will be embedded into a Microsoft SharePoint Server Web Part Page of the company intranet site.
The report consists of a single table. The design of the table is shown in the following diagram.

You need to configure the EmailAddress detail text box to create a new email message. The email message must be addressed to the email address that was clicked by the user.
Which four actions should you perform in sequence? (To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.)

Correct Answer:

Question 4

You are designing a subscription strategy for a SQL Server Reporting Services (SSRS) report. You have an application that populates a table with user-specific subscription
schedules and report formats.
You need to ensure that users can receive reports by email according to their preferences. Email messages will be sent via an internal mail server.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)

A. Create a standard SSRS subscription for each subscription schedule.

B. Create a data-driven SSRS subscription for each record in the schedule table.

C. Create one data-driven SSRS subscription. Schedule the subscription to frequently retrieve user preferences.

D. Create a standard SSRS subscription for each record in the table.

Correct Answer: C

Explanation: Only visible for Actualtests4sure members. You can sign-up / login (it's free).

Question 5

You need to grant appropriate permissions to the SSISOwners SQL Server login. What should you do?

A. Map the login to the SSISDB database. Assign the user to the ssis.admin role.

B. Map the login to the SSISDB database. Assign the user to the db_owner role.

C. Map the login to the msdb database. Assign the user to the ssis_admin role.

D. Map the login to the SSISDB database. Assign the user to the db.ssisadmin role.

E. Map the login to the msdb database. Assign the user to the db_ssisadmin role.

F. Map the login to the msdb database. Assign the user to the db_owner role.

Correct Answer: A

Question 6

You are developing a SQL Server Analysis Services (SSAS) tabular project.
You need to grant the minimum permissions necessary to enable users to query data in a tabular model.
Which role permission should you use?

A. Browser

B. Read

C. Explorer

D. Select

E. Read Definition

F. Process

Correct Answer: B

Question 7

You need to implement security in the cube to limit the sites visible to each user.
What should you do?

A. Create an SSAS database role in the cube for each user and assign the sites each user can access to his or her database role.

B. Create an SSAS server role for each user and assign the sites each user can access to his or her server role.

C. Create a view on the SalesTransactions table that uses the SecurityFilter and User table data to limit the sites for each user.

D. Create an SSAS database role and define a Multidimensional Expressions (MDX) calculation to implement dynamic dimension security.

Correct Answer: D

Question 8

HOTSPOT
You have an OLAP cube named Cube1. Cube1 has two partitions named partition1 and
partition2.
You need to configure the storage mode for each cube partition.
The solution must meet the following requirements:
- Users must be able to retrieve aggregate data from partition1 as quickly as
possible.
- The processing time for partition1 and partition2 must be minimized.
- The least possible amount of storage must be used for partition2.
What should you do? To answer, select the appropriate storage mode for each partition in the answer area.

Correct Answer:

Question 9

You are designing a SQL Server Reporting Services (SSRS) report to display vineyard names and their year-to-date (YTD) grape yield. Grape yield values are classified in three bands:
High Yield
Medium Yield
Low Yield
You add a table to the report. Then you define two columns based on the fields named VineyardName and YTDGrapeYield.
You need to set the color of the vineyard text to red, yellow, or blue, depending on the value of the YTD grape yield values.
What should you do?

A. Use an expression for the TextDecoration property of the vineyard text box.

B. Use an expression for the Style property of the vineyard text box.

C. Add an indicator to the table.

D. Use an expression for the Font property of the vineyard text box.

E. Use an expression for the Color property of the vineyard text box.

Correct Answer: E

Microsoft Transition Your MCITP: Business Intelligence Developer 2008 to MCSE: Business Intelligence - 070-460 Exam Practice Test

Latest Update

Useful Links

Contact Us