Microsoft 70-466 Exam Practice Test Instant Access

Question 1

Answer : J

Question 2

You are developing a SQL Server Analysis Services (SSAS) tabular project.

The model includes a table named DimEmployee. 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?

AAdd a row filter that implements the LOOKUPVALUE and USERNAME functions.

BAdd a row filter that implements only the CUSTOMDATA function.

CAdd a row filter that implements the LOOKUPVALUE and CUSTOMDATA functions.

DAdd a row filter that implements only the USERNAME function.

Answer : A

Question 3

You are developing a SQL Server Analysis Services (SSAS) tabular project that will be used by the finance, sales, and marketing teams.

The sales team reports that the model is too complex and difficult to use. The sales team does not need any information other than sales-related resources in the tabular model. The finance and marketing teams need to see all the resources in the tabular model.

You need to implement a solution that meets the needs of the sales team while minimizing development and administrative effort.

What should you do?

ACreate a separate partition for each team.

BCreate a separate data source for each team.

CCreate a perspective for the sales team.

DEnable client side security to filter non-sales data.

Answer : C

Question 4

You develop a SQL Server Analysis Services (SSAS) stored procedure.

You need to ensure that developers can create Multidimensional Expressions (MDX) calculations that use the stored procedure.

What should you do?

ARegister the assembly on the SSAS server instance.

BCopy the assembly to the SSAS installation directory and register it by using the CREATE ASSEMBLY T-SQL command.

CRegister the assembly on the SSAS server by using regedit.exe.

DRegister the assembly on the SharePoint server by using regedit.exe.

Answer : A

Question 5

Answer : E

Question 6

You need to meet the browsing requirements for the Products hierarchy.

Which property should you modify?

ADefaultMember

BAttributeHierarchyDisplayFolder

CHideMemberIf

DRootMemberIf

Answer : C

Question 7

You need to modify the Sales Regions hierarchy to meet the reporting requirements.

Which SSAS feature should you use?

ACalculation

BTranslation

CPerspective

DAction

Answer : B

Microsoft Implementing Data Models and Reports with Microsoft SQL Server 2012 70-466 Exam Practice Test