New Updated Microsoft MCSE 70-466 Real Exam Questions and Answers Download 41-50

Ensurepass

QUESTION 41

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 data model. Which role permission should you use?

 

A.

Explorer

B.

Process

C.

Browser

D.

Administrator

E.

Select

F.

Read

 

Correct Answer: F

 

 

 

QUESTION 42

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.)

 

A.

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

B.

Add 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.

C.

Create 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.

D.

Create 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.

 

Correct Answer: B

 

 

QUESTION 43

You are troubleshooting query performance for a SQL Server Analysis Services (SSAS) cube. A user reports that a Multidimensional Expressions (MDX) query is very slow. You need to identify the MDX query statement in a trace by using SQL Server Profiler. Which event class should you use?

 

A.

Get Data From Aggregation

B.

Query Subcube

C.

Query Begin

D.

Progress Report Begin

E.

Calculate Non Empty Begin

F.

Execute MDX Script Begin

 

Correct Answer: C

 

 

QUESTION 44

DRAG DROP

You install a SQL Server Analysis Services (SSAS) instance in tabular mode on a server.

 

While processing a very large tabular model, you receive an out-of-memory error. You identify that the amount of physical memory in the server is insufficient. Additio
nal physical memory cannot be installed in the server.

 

You need to configure the server to allow paging to disk by using the operating system page file (pagefile.sys).

 

Which four 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_image002

 

Correct Answer:

clip_image004

 

 

QUESTION 45

You maintain SQL Server Analysis Services (SSAS) instances. You need to configure an installation of PowerPivot for Microsoft SharePoint in a SharePoint farm. Which tool should you use? (Each correct answer presents a complete solution. Choose all that apply.)

 

A.

SQL Server Configuration Manager

B.

PowerPivot Configuration Tool

C.

SharePoint Products Configuration Wizard

D.

SharePoint Central Administration

E.

PowerShell

 

Correct Answer: ABD

 

 

QUESTION 46

You are developing a tabular Business Intelligence Semantic Model (BISMJ database based on a SQL Server database. In the data source, the FactlnternetSales table is partitioned by month. Data from the current month has been updated and new data has been inserted in the FactlnternetSales table, in the DimProduct table, and in the DimCustomer table. In the model, the FactlnternetSales table is also partitioned by month. You need to ensure that the model has the most recent data while minimizing the processing time. What should you do?

 

A.

Process the latest FactlnternetSales model table partition, the DimProduct table, and the DimCustomer table with the Process Clear processing option. Then process the database with the Process Data processing option.

B.

Process the latest FactlnternetSales model table partition, the DimProduct table, and the DimCustomer table with the Process Clear processing option. Then process the database with the Process Full processing option.

C.

Process the latest FactlnternetSales model table partition, the DimProduct table, and the DimCustomer table with the Process Defrag processing option. Then process the database with the Process Recalc processing option.

D.

Process the latest FactlnternetSales model table partition, the DimProduct table, and the DimCustomer table with the Process Data processing option. Then process the database with the Process Defrag processing option.

E.

Process the latest FactlnternetSales model table partition, the DimProduct table, and the DimCustomer table with the Process Data processing option. Then process the database with the Process Recalc processing option.

 

Correct Answer: D

 

 

QUESTION 47

HOTSPOT

You maintain a multidimensional Business Intelligence Semantic Model (BISM) that was developed with default settings.

 

The model has one cube and the cube has one measure group. The measure group is based on a very large fact table and is partitioned by month. The fact table is incrementally loaded each day with approximately 800,000 new rows.

 

You need to ensure that all rows are available in the cube while minimizing the processing time.

 

Which processing option should you use? (To answer, select the appropriate option in the answer area.)

 

clip_image005

 

Correct Answer:

clip_image006

 

 

QUESTION 48

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?

 

A.

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

B.

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

C.

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

D.

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

 

Correct Answer: C

 

 

QUESTION 49

DRAG DROP

You are developing a SQL Server Analysis Services (SSAS) multidimensional project that is configured to source data from a Microsoft Azure SQL Database database. The cube is processed e
ach night at midnight.

 

The largest partition in the cube takes 12 hours to process, and users are unable to access the cube until noon. The partition must be available for querying as soon as possible after processing commences.

 

You need to ensure that the partition is available for querying as soon as possible, without using source data to satisfy the query.

 

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_image008

 

Correct Answer:

clip_image010

 

 

QUESTION 50

DRAG DROP

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

 

You identify that a dimension, which has a large number of attributes, is issuing a separate (SELECT DISTINCT) query for each attribute even though they all come from a single database table. The table does not have a large number of rows.

 

You need to configure the processing of the dimension to issue only a single SQL query to the underlying database, and processing must continue if any errors are encountered.

 

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_image012

 

Correct Answer:

clip_image014

 

 

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

Try Microsoft MCSE 70-466 Free Demo