Microsoft 70-466 Exam Practice Test Instant Access

Question 1

You are developing a BI Semantic Model (BISM) based on a simple and small dataset sourced from SQL Server. The data size and complexity of the data relationships will not change. The model will be used to produce reports in Power View. The reports will show the relationship between product sales and rainfall over time.

You need to use an appropriate project type.

Which project types should you use? (Each answer presents a complete solution. Choose all that apply.)

AA tabular project that uses the In-Memory query mode

BA tabular project that uses the DirectQuery query mode

CA multidimensional project that uses the MOLAP storage mode and proactive cache

DA multidimensional project that uses the ROLAP storage mode and columnstore indexes

EA PowerPivot workbook that is deployed to Microsoft SharePoint Server 2010

Answer : A, B, E

Question 2

You need to develop the executive reports.

What should you do? (Each correct answer presents part of the solution. Choose ail that apply.)

AProvide default values for all parameters.

BSet the data source to use Windows authentication.

CRemove default values from all parameters.

DImplement dataset filters to filter data.

ESet the data source to use stored Windows credentials.

FImplement dataset query parameters to filter data.

Answer : A, D, E

Question 3

You are designing a SQL Server Reporting Services (SSRS) report based on a SQL Server Analysis Services (SSAS) cube. The cube is used to measure sales growth by salesperson.

The cube contains a Key Performance Indicator (KPI) to show if a salesperson's sales are off target slightly off target, or on target.

You need to add a report item that visually displays the KPI status value as a red, yellow, or green flag.

Which report item should you add?

AAn Indicator

BA Gauge that uses the Radial type

CA Gauge that uses the Linear type

DA Sparkline

EA Data Bar

Answer : A

Question 4

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

In the data warehouse, a table named Sales Persons and Territories defines a relationship between a salesperson's name, logon ID, and assigned sales territory.

You need to ensure that each salesperson has access to data from only the sales territory assigned to that salesperson. You need to use the least amount of development effort to achieve this goal.

What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)

ACreate a new role named Sales Persons with Read permission. Add each salesperson's logon as a member to the role.

BAdd the Sales Persons and Territories table to the model, define the relationships, and then implement dynamic security by using row filters. Grant each salesperson access to the model.

CCreate a new Active Directory Domain Services (AD DS) security group and add each salesperson as a member. Then create a new role named Sales Persons with Read permission. Add the group as a member to the new role.

DCreate a separate tabular model for each sales territory and assign each tabular model a corresponding sales territory name. Grant each salesperson access to the corresponding tabular model of the assigned sales territory.

Answer : B

Question 5

You are modifying a SQL Server Analysis Services (SSAS) multidimensional database.

You have identified a dimension that is no longer used by any cubes.

You need to delete the dimension.

What should you do?

AWrite a Multidimensional Expressions (MDX) command to drop the dimension from the database.

BWrite a Data Mining Extensions (DMX) command to drop the dimension from the database.

CScript the deletion of the dimension as an XMLA command for execution against the production model.

DWrite a T-SQL command to drop the dimension from the database.

Answer : C

Question 6

You are developing a new SQL Server Reporting Services (SSRS) report in SQL Server Data Tools (SSDT). This report has a table named Table1 and a textbox named Textbox1.

Table1 is initially visible but the user must be able to choose when to hide it.

You need to develop the report to meet the requirement.

What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)

AFor the properties of Table1, configure the Display can be toggled by this report item option to use Textbox1.

BConfigure Textbox1 to drill through to rerun the report to toggle the display of Table1.

CFor the properties of Table1, configure the Display can be toggled by this report item option to use Table1

DAdd a parameter to the report so users can choose the display state of Table1.

Answer : A

Question 7

You need to create the KPI in the AdhocReports project.

What should you do?

ACreate a measure by using the SUM([OrderQuantity]) expression. Then use the CREATE KPI CURRENTCUBE statement to define the KPI and target value.

BCreate a measure by using the SUM([OrderQuantity]) expression and create a KPI based on the measure. Then set the target value.

CCreate a measure by using the COUNT([OrderQuantity]) expression and create a KPI based on the measure. Then set the target value.

DCreate a KPI based on the OrderQuantity column and then set the target value.

Answer : A

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