New Updated Microsoft MCSE 70-466 Real Exam Questions and Answers Download 141-150

Ensurepass

 

QUESTION 141

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. The calculations are used to calculate the budget and forecast for the current quarter. You need to hide the tables and columns. What should you do?

 

A.

Before adding the forecast calculations to the model, right-click the applicable tables and columns and select the Hide option.

B.

After adding the budget calculations to the model, in the Properties window for the applicable tables and columns, set the Visible property to True.

C.

Before adding the forecast calculations to the model, right-click the applicable tables and columns and select the Hide from Client Tools option.

D.

After adding the budget calculations to the model, in the Properties window for the applicable tables and columns, set the Enabled property to False.

 

Correct Answer: C

 

 

QUESTION 142

You are developing a SQL Server Analysis Services (SSAS) tabular project. A model defines a measure named Revenue and includes a table named Date. The table includes year, semester, quarter, month, and date columns. The Date column is of data type Date. The table contains a set of contiguous dates. You need to create a measure to report on year-over-year growth of revenue. What should you do? (Each answer presents a complete solution. Choose all that apply.)

 

clip_image002

 

A.

Option A

B.

Option B

C.

Option C

D.

Option D

 

Correct Answer: CD

 

 

QUESTION 143

You are developing a SQL Server Analysis Services (SSAS) tabular project. The model has tables named Invoice Line Items and Products.

 

The Invoice Line Items table has the following columns:

 

clip_image004Product Id

clip_image004[1]Unit Sales Price

 

The Unit Sales Price column stores the unit price of the product sold.

 

The Products table has the following columns:

 

clip_image004[2]Product Id

clip_image004[3]Maximum Sales Price

 

The Maximum Sales Price column is available only in the Products table.

 

You add a column named Is Overpriced to the Invoice Line Items table. The Is Overpriced column must store a value of TRUE if the value of the Unit Sales Price is greater than the value of the Maximum Sales Price. Otherwise, a value of FALSE must be stored.

 

You need to define the Data Analysis Expressions (DAX) expression for the Is Overpriced column.

 

Which DAX formula should you use? (Each answer represents a complete solution. Choose all that apply.)

 

clip_image006

 

A.

Option A

B.

Option B

C.

Option C

D.

Option D

 

Correct Answer: AC

 

 

QUESTION 144

You are developing a SQL Server Analysis Services (SSAS) tabular project. The model includes a table named DimEmployee. The table contains employee details, including the sales territory for each employee. The table also defines a column named EmployeeAlias which contains the Active Directory Domain Services (AD DS) domain and logon name for each employee. You create a role named Employees. You need to configure the Employees roles so that users can query only sales orders for their respective sales territory. What should you do?

 

A.

Add a row filter that implements the LOOKUPVALUE and USERNAME functions.

B.

Add a row filter that implements only the CUSTOMDATA function.

C.

Add a row filter that implements the LOOKUPVALUE and CUSTOMDATA functions.

D.

Add a row filter that implements only the USERNAME function.

 

Correct Answer: A

 

 

QUESTION 145

You are developing a SQL Server Analysis Services (SSAS) tabular project for a Power View solution. You need to grant permission for salespersons to view only the data based on their sales territory. What should you do?

 

A.

Create a member and then create a Data Analysis Expressions (DAX) filter.

B.

Create a member and then create a Multidimensional Expressions (MDX) filter.

C.

Use SQL Server Management Studio to create a role. Then create a Data Analysis Expressions (DAX) filter.

D.

Use SQL Server Management Studio to create a role. Then create a Multidimensional Expressions (MDX) filter.

 

Correct Answer: C

 

 

QUESTION 146

You are developing a SQL Server Analysis Services (SSAS) tabular database. To maximize performance, the queries must be resolved by using cache unless otherwise specified in the connection string. You need to configure the appropriate query mode. Which query mode should you select?

 

A.

In-Memory with DirectQuery

B.

DirectQuery with In-Memory

C.

In-Memory

D.

DirectQuery

 

Correct Answer: A

 

 

QUESTION 147

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?

 

A.

Process Data

B.

Process Full

C.

Process Add

D.

Process Clear

E.

Process Default

 

Correct Answer: E

 

 

QUESTION 148

DRAG DROP

You have a single SQL Server 2008 R2 Analysis Services (SSAS) instance. You are planning to upgrade the instance to SQL Server 2014. You need to import an existing PowerPivot workbook to create a tabular project. 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 149

A production SQL Server Analysis Services (SSAS) cube is processed daily. The users query products by using a hierarchy named Products from a dimension named Product.

 

The DimProduct table in the data source view is used as the source of the Product dimension. The table has the following structure.

 

clip_image011

 

The Product dimension has three attribute hierarchies:

 

clip_image004[4]Product

clip_image004[5]Subcategory

clip_image004[6]Category

 

The attributes have the following relationships defined: Product > Subcategory > Category. Each attribute has a key and a name sourced from the related key and name columns in the DimProduct table.

 

During processing, you receive the following error message: ‘Errors in the OLAP storage engine: A duplicate attribute key has been found when processing: Table:

‘dbo_DimProduct’, Column: ‘SubCategoryKey1, Value: “23′. The attribute is Subcategory’.”

 

You verify that the data is accurate.

 

You need to ensure that the dimension processes successfully.

 

What should you do?

 

A.

Delete the Products hierarchy.

B.

Relate the Subcategory and Category attributes directly to the Product attribute.

C.

Remove the duplicate data from the DimProduct table.

D.

Remove the Subcategory attribute.

 

Correct Answer: B

 

 

QUESTION 150

You have a SQL Server Analysis Services (SSAS) database named DB1 on a server named Server1. You need to deploy DB1 from Server1 to four other servers. If the destination server already contains a copy of DB1, the database must be updated only. If the destination server does not contain a copy of DB1, the database must be copied to the destination server. What is the best deployment option to use? More than one answer choice may achieve the goal. Select the BEST answer.

 

A.

Analysis Services Deployment Wizard

B.

Analysis Management Objects (AMO) automation

C.

Backup and Restore

D.

Synchronize Database Wizard

 

Correct Answer: C

 

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

Try Microsoft MCSE 70-466 Free Demo