70-460 by Microsoft Valid Free Exam Practice Test

Question 1

You are developing a SQL Server Analysis Services (SSAS) cube. The cube contains several dimensions, a local measure group, and a linked measure group. Both measure groups use MOLAP partitions.
You need to write-enable one of the linked measure group partitions to support Microsoft Excel 2010 PivotTable What-If Analysis.
What should you do before the partition can be write-enabled?

A. Ensure that the measure group measures only use semiadditive aggregation functions. B. Implement the cube as a local cube. C. Implement the linked measure group as a local measure group. D. Ensure that the measure group measures only use nonadditive aggregation functions

Correct Answer: C

Question 2

You have two servers named Server1 and Server2. Both servers have SQL Server 2012 installed. Both servers have a SQL Server Integration Services (SSIS) catalog.
You are preparing a disaster recovery plan for a business intelligence (BI) solution.
You need to ensure that the SSIS catalog from Server1 can be restored to Server2.
Which two actions should you perform on Server1? Each correct answer presents part of the solution.

A. Run sp.configure 'clr enabled', 0. B. Run sp_configure 'clr enabled', 1. C. Back up the master key of the SSISDB database. D. Back up the master database. E. Back up the master key of the master database. F. Back up the SSISDB database.

Correct Answer: C,F

Question 3

HOTSPOT
You are designing a dimension named Employee for a SQL Server Analysis Services
multidimensional project.
The Employee dimension contains a DateOfBirth attribute and a MaritalStatus attribute.
You need to minimize the amount of time required to process the cube.
What should you do? To answer, select the appropriate relationship type for each attribute
in the answer area.

Correct Answer:

Question 4

DRAG DROP
You are developing a SQL Server Reporting Services (SSRS) report that sources data from a SQL Azure database and a SQL Server Analysis Services (SSAS) cube. The cube contains a date dimension and other dimensions. The report design includes two report
parameters named StartDate and FinishDate as shown in the following diagram.

The Data Type property of the parameters is set to Date/Time.
You need to create the dataset based on the SSAS cube. You also need to ensure that the dataset is filtered by the existing report parameters.
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.)

Correct Answer:

Question 5

HOTSPOT
You are designing a SQL Server Analysis Services (SSAS) cube that contains two measure groups named Sales History and Current Sales.
The Sales History measure group has the following characteristics:
----
Data changes on a monthly basis.
The measure group contains a very high data volume.
Queries that use the measure group only reference aggregate data.
The measure group includes SUM, MIN, MAX, and COUNT aggregate functions.
The Current Sales measure group has the following characteristics:
----
Data changes frequently.
The measure group contains a low data volume.
Queries that use the measure group often reference non-aggregate data.
The measure group includes SUM, MIN, MAX, and COUNT aggregate functions.
You need to select a storage mode for each measure group. The solution must meet the following requirements:
- For the Sales History measure group, query performance must be optimized over data latency.
- For the Current Sales measure group, data latency must be optimized over query performance.
What should you do? To answer, select the appropriate storage mode for each measure group in the answer area.

Correct Answer:

Question 6

You need to restrict access to data in the tables in the data warehouse.
What should you do?

A. Configure application roles. B. Configure column-level permissions. C. Create views and grant permissions to the views. D. Configure database roles.

Correct Answer: A

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

Question 7

You need to use SQL Server Management Studio (SSMS) to make the SSAS databases available for application testing.
What should you do?

A. Restore the SSAS databases from the latest backup to SSAS01. B. Script the databases as a Create script to a new window and then execute the script on SSAS01. C. Detach the SSAS databases from the SSASCluster, and then attach them to SSAS01. D. Use the Import/Export Wizard to copy the databases from the production server to the development server.

Correct Answer: B

Question 8

A production SQL Server Analysis Services (SSAS) cube is processed daily. The users query products by using a hierarchy named Products from a dimension named Product.
The DimProduct table in the data source view is used as the source of the Product dimension. The table has the following structure.

The Product dimension has three attribute hierarchies:
---
Product
Subcategory
Category
The attributes have the following relationships defined: Product > Subcategory - Category. Each attribute has a key and a name sourced from the related key and name columns in theDimProduct table.
During processing, you receive the following error message: "Errors in the OLAP storage engine: A duplicate attribute key has been found when processing: Table: 'dbo_DimProducf, Column: 'SubCategoryKey', Value: '23'. The attribute is Subcategory'."
You verify that the data is accurate.
You need to ensure that the dimension processes successfully.
What should you do?

A. Remove the duplicate data from the DimProduct table. B. Remove the Subcategory attribute. C. Delete the Products hierarchy. D. Relate the Subcategory and Category attributes directly to the Product attribute.

Correct Answer: D

Question 9

After you deploy the RegionalSales report, users report that they cannot see product data when they receive the reports by email.
You need to ensure that the sales department managers can see all of the data.
In the report, you update the Hidden property of each group.
What should you do next?

A. In When the report is initially run, select Hide. B. In When the report is initially run, select Show or hide based on an expression. Set the expression to = (GlobalsIRenderFormaUsInteractive). C. In when the report is initially run, select Show. D. In When the report is initially run, select Show or hide based on an expression. Se: The expression to =NOT (GlobalslRenderFormat.IsInteractive)

Correct Answer: A

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