Microsoft 70-466 Exam Practice Test Instant Access

Question 1

You need to create the AD Sales measure.

Which aggregation function should you use?

ASum

BAverage

CByAccount

DAverageOfChildren

Answer : D

Question 2

You are developing a SQL Server Reporting Services (SSRS) report. The report includes a dataset with fields named Year, MonthNumber, and RegCount. The report includes a table that displays the number of recorded registration occurrences per year, as shown in the following table.

You need to modify the table to include a graphical item displaying the monthly registration trend to the right of the Reg Count column.

What should you do?

AAdd an Indicator item to a new column on the right of the Reg Count column. Select the Directional Indicator Type and then assign the MonthNumber field to the Start property.

BAdd an Indicator item to a new column on the right of the Reg Count column. Select the Directional Indicator Type and then select the MonthNumber field for Value.

CAdd a Sparkline item to a new column on the right of the Reg Count column. Then select the RegCount field for Values and the MonthNumber field for Series Groups.

DAdd a text box to a new column on the right of the Reg Count column. Then use a Go to report action to link to a separate report showing the monthly trend.

EAdd a Sparkline item to a new column on the right of the Reg Count column. Then select the RegCount field for Values and the MonthNumber field for Category Groups.

Answer : E

Question 3

You need to create a measure for DOD sales.

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

AUse the Data Analysis Expressions (DAX) PARALLELPERIOD ( ) function.

BCreate a date dimension by using the Dimension wizard with a date template.

CSpecify a date table by using a Mark the Date table.

DUse the Multidimensional Expressions (MDX) PARALLELPERIOD( ) function.

Answer : A, C

Question 4

You are developing a SQL Server Analysis Services (SSAS) cube for the sales department at your company.

The sales department requires the following set of metrics:

Unique count of customers

Unique count of products sold

Sum of sales

You need to ensure that the cube meets the requirements while optimizing query response time.

What should you do? (Each answer presents a complete solution. Choose all that apply.)

APlace the measures in a single measure group.

BPlace the distinct count measures in separate measure groups.

CUse the additive measure group functions.

DUse the semiadditive measure group functions.

EUse the Count and Sum measure aggregation functions.

FUse the Distinct Count and Sum measure aggregation functions.

Answer : B, F

Question 5

You have a SQL Server 2012 instance that hosts a single-user database. The database does not contain usercreated stored procedures or user-created functions. You need to minimize the amount of memory used for query plan caching.

Which advanced server option should you modify?

AEnable Contained Databases

BAllow Triggers to Fire Others

COptimize for Ad hoc Workloads

DScan for Startup Procs

Answer : C

The optimize for ad hoc workloads option is used to improve the efficiency of the plan cache for workloads that contain many single use ad hoc batches. When this option is set to 1, the Database Engine stores a small compiled plan stub in the plan cache when a batch is compiled for the first time, instead of the full compiled plan. This helps to relieve memory pressure by not allowing the plan cache to become filled with compiled plans that are not reused.

References: https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/optimize-for-ad-hocworkloads-server-configuration-option

Question 6

You need to configure SSRS to meet the maximum number of snapshots requirement.

What should you do? (Each answer presents a complete solution. Choose all that apply.)

AIn SharePoint Central Administration, set the System Snapshot Limit option to 5.

BIn Reporting Services Configuration Manager, set the Limit number of snapshots option to 5.

CFor each report, set the System Snapshot Limit option to 5.

DUse PowerShell to set the System Snapshot Limit option to 5.

Answer : A, C

Question 7

You are deploying an update to a SQL Server Analysis Services (SSAS) cube to a production environment.

The production database has been configured with security roles.

You need to preserve the existing security roles in the production database. Database roles and their user accounts from the development environment must not be deployed to the production server.

Which deployment method should you use?

AUse the SQL Server Analysis Services Deployment Wizard.

BBackup and restore the database.

CUse the SQL Server Analysis Services Migration Wizard.

DDeploy the project from SQL Server Data Tools to the production server.

Answer : A

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