New Updated Microsoft MCSE 70-466 Real Exam Questions and Answers Download 81-90

Ensurepass

QUESTION 81

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?

 

A.

Use the SQL Server Data Tools Dimension Wizard and generate a time table on the server.

B.

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

C.

Create a time dimension by using the Define dimension intelligence option in the Business Intelligence Wizard.

D.

Create a time dimension by using the Define time intelligence option in the Business Intelligence Wizard.

 

Correct Answer: A

 

 

QUESTION 82

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.

Set the Type property of the partition’s measure group to Forecast.

B.

Implement the linked measure group as a local measure group.

C.

Implement the local measure group as a linked measure group.

D.

Set the StorageMode property of the linked measure group to Rolap.

 

Correct Answer: B

 

 

QUESTION 83

DRAG DROP

You have a database named DB1. DB1 contains four tables named FactSales, DimTime, DimCustomer, and DimEmployee. A sample from DimEmployee is shown in the following table.

 

clip_image001

 

A sample from DimCustomer is shown in the following table.

 

clip_image002

 

A sample from FactSales is shown in the following table.

 

clip_image003

 

You need to identify which type of dimension must be created for each table.

 

Which type of dimension should you create for each table? To answer, drag the appropriate dimensions to the correct tables. Each dimension may be used once, more than once, or not at all.

 

You may need to drag the split bar between panes or scroll to view content.

 

clip_image004

 

Correct Answer:

clip_image005

 

 

QUESTION 84

DRAG DROP

You are developing a SQL Server Analysis Services (SSAS) cube. You need to add a calculated member to the Customer dimension to evaluate the sum of values for the United Kingdom and the United States. Which expression should you use? (To answer, drag the appropriate expression to the answer area.)

 

clip_image007

 

Correct Answer:

clip_image009

 

QUESTION 85

You are working with multiple tabular models deployed on a single SQL Server Analysis Services (SSAS) instance. You need to ascertain the memory consumed by each object in the SSAS instance. What should you do?

 

A.

Use the $System.discover_object_memory_usage dynamic management view.

B.

Use SQL Server Profiler to review session events for active sessions.

C.

Use the Usage Based Optimization wizard to design appropriate aggregations.

D.

Use the Performance Counter group named Processing.

 

Correct Answer: A

 

 

QUESTION 86

DRAG DROP

You are developing a SQL Server Analysis Services (SAS) multidimensional project that is configured to source data from a SQL Azure database. You plan to use multiple servers to process different partitions simultaneously. You create and configure a new data source. You need to create a new partition and configure SQL Server Analysis Services (SSAS) to use a remote server to process data contained within the partition. Which three actions should you perform in sequence? (To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.)

 

clip_image011

 

Correct Answer:

clip_image013

 

QUESTION 87

DRAG DROP

You are planning the installation of PowerPivot for SharePoint. You install SharePoint Server 2010 Enterprise Edition with Service Pack 1. You need to install the PowerPivot for SharePoint instance. Then you need to configure the Default Account username used to provision shared services in the SharePoint farm. Which three actions should you perform in sequence? (To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.)

 

clip_image015

 

Correct Answer:

clip_image017

 

 

QUESTION 88

You are developing a SQL Server Analysis Services (SSAS) tabular project. A model contains tables and columns that must not be visible to the user. The columns and tables cannot be removed because they are used in calculations. You need to hide the tables and columns. What should you do?

 

A.

In the Properties window for the applicable tables and columns, set the Visible property to True.

B.

Right-click the applicable tables and columns and select the Hide option.

C.

Right-click the applicable tables and columns and select the Hide from Client Tools option.

D.

In the Properties window for the applicable tables and columns, set the Enabled property to False.

 

Correct Answer: C

 

 

QUESTION 89

You are planning to develop a SQL Server Analysis Services (SSAS) tabular project. The project will be deployed to a SSAS server that has 16 GB of RAM. The project will source data from a SQL Server database that contains a fact table named Sales. The fact table has more than 60 billion rows of data. You need to select an appropriate design to maximize query performance. Which data access strategy should you use? (More than one answer choice may achieve the goal. Select the BEST answer.)

 

A.

Configure the database to use DirectQuery mode. Create a clustered index which includes all of the foreign key columns of the fact table.

B.

Configure the database to use In-Memory mode. Create a clustered index which includes all of the foreign key columns of the fact table.

C.

Configure the database to use In-Memory mode. Create a columnstore index on all the columns of the fact table.

D.

Configure the database to use DirectQuery mode. Create a columnstore index on all the columns of the fact table.

 

Correct Answer: D

 

 

QUESTION 90

You are developing a SQL Server Analysis Services (SSAS) tabular project. You need to grant the minimum permissions necessary to enable users to query data in a tabular model. Which role permission should you use?

 

A.

Explorer

B.

Select

C.

Process

D.

Browser

E.

Read Definition

F.

Read

 

Correct Answer: F

 

Instant Access to Download Latest Complete Collection of Microsoft MCSE 70-466 Real Exam

Try Microsoft MCSE 70-466 Free Demo