Microsoft Transition Your MCITP: Business Intelligence Developer 2008 to MCSE: Business Intelligence 70-460 Prüfungsfragen mit Lösungen:

1. DRAG DROP
You are developing a SQL Server Analysis Services (SSAS) cube.
You need to reuse a Revenue measure group from a different database.
In SQL Server Data Tools (SSDT), which three 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.)

2. 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 Definition
C) Select
D) Read
E) Process
F) Explorer

3. You are developing a SQL Server Analysis Services (SSAS) tabular project.
A model contains tables and columns that must not be visible to the user. The columns and tables cannot be removed because they are used in calculations.
You need to hide the tables and columns.
What should you do?

A) In the Properties window for the applicable tables and columns, set the Visible property to True
B) In the Properties window for the applicable tables and columns, set the Enabled property to False
C) Right-click the applicable tables and columns and select the Hide from Client Tools option.
D) Right-click the applicable tables and columns and select the Hide option.

4. You are modifying a star schema data mart that feeds order data from a Microsoft Azure SQL Database database into a SQL Server Analysis Services (SSAS) cube. The data mart contains two large tables that include flags and indicators for some orders. There are 100 different flag columns, each with 10 different indicator values. Some flags reuse indicators. The tables both have a granularity that matches the fact table.
You have the following requirements:
- Allow users to slice data by all flags and indicators. - Modify the date dimension table to include a surrogate key of a numeric data type and add the surrogate key to the fact table. - Use the most efficient design strategy for cube processing and queries.
You need to modify the schema.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)

A) Define the surrogate key as an INT data type. Create a single fact dimension in each table for its flags and indicators.
B) Define the surrogate key as a BIGINT data type. Combine the distinct flag/indicator combinations into a single dimension.
C) Define the surrogate key as an INT data type. Combine the distinct flag/indicator combinations into a single dimension.
D) Define the surrogate key as a BIGINT data type. Create a single fact dimension in each table for its flags and indicators.

5. After you deploy the RegionalSales report, you attempt to configure the subscriptions.
You discover that the subscription creation screen does not display the option to deliver the
report by email.
You need to ensure that subscriptions can be delivered by using email.
What should you do?

A) From Central Administration, modify the properties of the Reporting Service Application.
B) Modify the Rsmgrpolicy.config file.
C) From Central Administration, modify the SMTP settings of the SharePoint Server server farm.
D) Modify the Rssrvrpolicy.config file.

Fragen und Antworten: