Certification vendors revise their blueprints without much warning, and stale material is worse than none at all. 2Pass4sure reviews and updates its 70-460 practice questions on a continuous basis, with 365 days of free updates, so the 82 items you study stay aligned with the live Microsoft Transition Your MCITP: Business Intelligence Developer 2008 to MCSE: Business Intelligence exam.

Microsoft 70-460 Exam Overview:

Microsoft 70-460 Exam Syllabus Topics:

Answers to the Most Common Questions About Microsoft Transition Your MCITP: Business Intelligence Developer 2008 to MCSE: Business Intelligence

Microsoft Transition Your MCITP: Business Intelligence Developer 2008 to MCSE: Business Intelligence Sample Questions:

Question 1

You are developing a SQL Server Analysis Services (SSAS) tabular project.
The model includes a table named Dim Employee. The table contains employee details,
including the sales territory for each employee. The table also defines a column named EmployeeAlias which contains the Active Directory Domain Services (AD DS) domain and logon name for each employee. You create a role named Employees.
You need to configure the Employees roles so that users can query only sales orders for their respective sales territory.
What should you do?

A. Add a row filter that implements the LOOKUPVALUE and USERNAME functions.
B. Add a row filter that implements only the USERNAME function.
C. Add a row filter that implements only the CUSTOMDATA function.
D. Add a row filter that implements the LOOKUPVALUE and CUSTOMDATA functions.

Question 2

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

The Geography dimension has three attribute hierarchies:
---
City
State-Province
Country
The attributes have the following relationships defined: City > State-Province > Country. Each attribute has a key and a name sourced from the related key and name columns in the DimGeography 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_DimGeography, Column: StateProvinceKey', Value: '23'. The attribute is 'State-Province'."
You verify that the data is accurate.
You need to ensure that the dimension processes successfully.
What should you do?

A. Relate the State-Province and Country attributes directly to the City attribute.
B. Remove the State-Province attribute.
C. Remove the duplicate data from the DimGeography table.
D. Delete the Geography hierarchy.

Question 3

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.

Question 4

You are developing a SQL Server Analysis Services (SSAS) cube named Sales Planning. The cube consists of two measure groups named Sales and Planning. Each measure group is based on a data warehouse fact table and consists of a single MOLAP partition that has the same name as its measure group.
The Planning measure group consists of two measures:
- Forecast, which uses the Sum aggregate function
- Forecast Count, which uses the Count aggregate function
Users contribute planning values by using a legacy application. An extract, transform, load (ETL) process is scheduled to periodically transfer the planning values from the database of the legacy application to the data warehouse.
Financial analysts query the Sales Planning cube and report that the planning values are sometimes out of date. A new company requirement mandates that the planning values be entered directly into the cube by using Microsoft Excel 2010 PivotTable What-If Analysis.
You need to write-enable the Planning partition.
What should you do before write-enabling the partition?

A. Set the Type property of the Planning measure group to Budget.
B. Set the ProcessingMode property of the Planning measure group to LazyAggregations.
C. Remove the Forecast Count measure.
D. Convert the Planning measure group to a linked measure group.
E. Set the ProcessingMode property of the Planning partition to LazyAggregations.
F. Set the StorageMode property of the Planning partition to Rolap

Question 5

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. Implement the cube as a local cube.
B. Implement the linked measure group as a local measure group.
C. Ensure that the measure group measures only use nonadditive aggregation functions
D. Ensure that the measure group measures only use semiadditive aggregation functions.

Solutions: