Microsoft 70-466 Exam Practice Test Instant Access

Question 1

You are developing a new SQL Server Reporting Services (SSRS) report in SQL Server Data Tools (SSDT).

The report must define a report parameter to prompt the user for the business unit. Each business unit has a unique font scheme combination of font and size properties.

You need to ensure that all of the text boxes in the table headers use the correct business unit font properties.

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

AAdd one report variable for FontFamily Assign it with an expression to return the appropriate colors. For each header text box, set the Color and FontSize properties by using the variables.

BFor each header text box, assign expressions to the FontFamily and FontSize properties.

CAdd two report variables named FontFamily and FontSize. Assign them with expressions to return the appropriate colors. For each header text box, use expressions to set the FontFamily and FontSize properties by using the variables.

DAdd two Microsoft Visual C# functions to the code block of the report to implement FontFamily and FontSize functions. For each header text box, use expressions to set the FontFamily and FontSize properties by using the functions.

Answer : D

Question 2

You are developing a SQL Server Analysis Services (SSAS) multidimensional database. The underlying data source does not have a time dimension table.

You need to implement a time dimension.

What should you do?

AUse the SQL Server Data Tools Dimension Wizard and generate a time table in the data source.

BUse the SQL Server Data Tools Dimension Wizard and generate a time dimension by using the Use an existing table option.

CCreate a CSV file with time data and use the DMX IMPORT statement to import data from the CSV file.

DCreate a script by using a sample time dimension from a different multidimensional database. Then create a new dimension in an existing multidimensional database by executing the script.

Answer : A

In Microsoft SQL Server Analysis Services, you can use the Dimension Wizard in SQL Server Data Tools

(SSDT) to create a time dimension when no time table is available in the source database.

Generate a time table in the data source Select this option when you have permission to create objects in

the underlying data source. The wizard will then generate a time table and store this table in the data

source. The wizard then creates the time dimension from this time table.

Generate a time table on the server Select this option when you do not have permission to create objects in the underlying data source. The wizard will then generate and store a table on the server instead of in the data source. (The dimension created from a time table on the server is called a server time dimension.) The wizard then creates the server time dimension from this table.

References: https://docs.microsoft.com/en-us/sql/analysis-services/multidimensional-models/create-a-timedimension-by-generating-a-time-table

Question 3

You are developing a multidimensional project that includes a dimension named Organization. The dimension is based on the DimOrganization table in the data warehouse. The following diagram illustrates the table design.

The Organization dimension includes a parent-child hierarchy named Organizations. The dimension includes the following dimension attributes:

Organization, which is a key attribute

Organizations, which defines the parent-child hierarchy

Currency Code, which is a regular attribute

PercentageOfOwnership, which is a regular attribute

When users browse the dimension, four hierarchies are visible to them.

You need to ensure that the Organization and PercentageOfOwnership hierarchies are not visible to users.

What should you do?

ASet the AttributeHierarchyVisible property to False for the Organization and PercentageOfOwnership attributes.

BSet the AttributeHierarchyEnabled property to False for the Organization and PercentageOfOwnership attributes.

CDelete the Organization and the PercentageOfOwnership attributes.

DSet the AttributHierarchyDisplayFolder property to Null for the Organization and PercentageOfOwnership attributes.

Answer : A

Question 4

You need to create the sales territory and product measures.

Which aggregate function should you use for both measures?

ACount

BCOUNT(DIST1NCT column_name)

CDistinctCount

DDistinct

Answer : C

Question 5

You are modifying a SQL Server Analysis Service (SSAS) cube.

The cube consists of a single measure group that contains the following measures:

* Total Quantity On Hand

* Average Quantity On Hand

The measure group has a single partition that uses the MOLAP storage mode.

You need to modify the cube design to ensure that the Total Quantity On Hand measure is updated in real-time and that Average Quantity On Hand measure is updated hourly.

What should you do?

AChange the storage mode of the partition to use proactive caching with minimum latency.

BCreate an XMLA script that will process the cube and then use SQL Server Agent to execute the script continuously.

CCreate a new measure group for the Average Quantity On Hand measure. Configure the storage mode for the new measure group's partition to ROLAP.

DCreate a new measure group for the Total Quantity On Hand measure. Configure the storage mode for the new measure group's partition to ROLAP.

Answer : D

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 have a tabular model hosted in SQL Server Analysis Services (SSAS).

You need to add new rows to an existing table. The solution must load only the new rows to the table.

Which processing mode should you use?

AProcess Data

BProcess Full

CProcess Add

DProcess Clear

EProcess Default

Answer : C

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