Microsoft 70-466 Study Guides 2021

NEW QUESTION 1
DRAG DROP
You are developing a SQL Server Analysis Services (SSAS) multidimensional project. The project file includes two cubes named Finance and Operations. The project also includes a dimension named Date. The Date dimension includes two hierarchies named Fiscal and Calendar. The Date dimension has been added to both cubes.
You need to disable the Fiscal hierarchy in the Operations cube without impacting other database objects.
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.)

Answer:

Explanation: Box 1:

Box 2:

Box 3:

Note:
* The value of the AttributeHierarchyEnabled property determines whether an attribute hierarchy is created. If this property is set toFalse, the attribute hierarchy is not created and the attribute cannot be used as a level in a user hierarchy; the attribute hierarchy exists as a member property only. However, a disabled attribute hierarchy can still be used to order the members of another attribute. If the value of the AttributeHierarchyEnabled property is set toTrue, the value of the AttributeHierarchyVisible property determines whether the attribute hierarchy is visible independent of its use in a user-defined hierarchy.
* To set the attribute hierarchy properties in the Employee dimension
Etc.
✑ Switch to Dimension Designer for the Employee dimension, and then click the Browser tab.
✑ Verify that the following attribute hierarchies appear in the Hierarchy list:
✑ Switch to the Dimension Structure tab, and then select the following attributes in the Attributes pane, by using the CTRL key to select multiple attributes at the same time:
✑ In the Properties window, set the value of the AttributeHierarchyEnabled property to False for the selected attributes.

NEW QUESTION 2
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 rol
• D. Then create a Data Analysis Expressions (DAX) filter.
• E. Use SQL Server Management Studio to create a rol
• F. Then create a Multidimensional Expressions (MDX) filter.

Answer: C

NEW QUESTION 3
HOTSPOT
You are developing a SQL Server Analysis Services (SSAS) cube.
Revenue must be compared to a goal and described by a status and a trend. Revenue, goal, status, and trend will be defined by Multidimensional Expressions (MDX) expressions.
You need to add the Revenue measure.
Which tab should you select? (To answer, select the appropriate tab in the answer area.)

Answer:

Explanation:

NEW QUESTION 4
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.)

Answer:

Explanation:

NEW QUESTION 5
DRAG DROP
You manage a SQL Server Reporting Services (SSRS) instance running in native mode.
You are troubleshooting a performance problem and need to know which reports are frequently executed. You discover that the report server execution logs are empty, despite significant report activity.
You need to ensure that the server is configured for report execution logging.
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.)

Answer:

Explanation: Box 1:

Box 2:

Box 3:

Note: This server is running in NATIVE mode (not Sharepoint mode)
To enable execution logging (in Native mode):
✑ Start SQL Server Management Studio with administrative privileges. For example right-click the Management Studio icon and click ‘Run as administrator’.
✑ Connect to the desired report server.
✑ Right-click the server name and click Properties. If the Properties option is disabled, verify you ran SQL Server Management Studio with administrative privileges.
✑ Click the Logging page.
✑ Select Enable report execution Logging.
Ref: http://msdn.microsoft.com/en-us/library/ms159110.aspx

NEW QUESTION 6
You are designing a SQL Server Analysis Services (SSAS) cube. You need to create a measure to count unique customers.
What should you do?

• A. Use role playing dimensions.
• B. Use the Business Intelligence Wizard to define dimension intelligence.
• C. Add a measure that uses the Count aggregate function to an existing measure group.
• D. Add a measure that uses the DistinctCount aggregate function to an existing measure group.
• E. Add a measure group that has one measure that uses the DistinctCount aggregate function.
• F. Add a calculated measure based on an expression that counts members filtered by the Exists and NonEmpty functions.
• G. Add a hidden measure that uses the Sum aggregate functio
• H. Add a calculated measure aggregating the measure along the time dimension.
• I. Create several dimension
• J. Add each dimension to the cube.
• K. Create a dimensio
• L. Then add a cube dimension and link it several times to the measure group.
• M. Create a dimensio
• N. Create regular relationships between the cube dimension and the measure grou
• O. Configure the relationships to use different dimension attributes.
• P. Create a dimension with one attribute hierarch
• Q. Set the IsAggrcgatable property to False and then set the DefaultMember propert
• R. Use a regular relationship between the dimension and measure group.
• S. Create a dimension with one attribute hierarch
• T. Set the IsAggregatable property to False and then set the DefaultMember propert
• U. Use a many-to-many relationship to link the dimension to the measure group.
• V. Create a dimension with one attribute hierarch
• W. Set the IsAggregatable property to False and then set the DefaultMember propert
• X. Use a many-to-many relationship to link the dimension to the measure group.
• Y. Create a dimension with one attribute hierarch
• Z. Set the ValueColumn property, set the IsAggregatable property to False, and then set the DefaultMember propert
• BA. Configure the cube dimension so that it does not have a relationship with the measure grou
• BB. Add a calculated measure that uses the MemberValue attribute property.
• BC. Create a new named calculation in the data source view to calculate a rolling su
• BD. Add a measure that uses the Max aggregate function based on the named calculation.

Answer: E

NEW QUESTION 7
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

Answer: F

NEW QUESTION 8
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:
✑ Product Id
✑ Unit Sales Price
The Unit Sales Price column stores the unit price of the product sold.
The Products table has the following columns:
✑ Product Id
✑ 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.)

• A. Option A
• B. Option B
• C. Option C
• D. Option D

Answer: BC

NEW QUESTION 9
You deploy a tabular model in DirectQuery mode to a server named Server1. Server1 has SQL Server Analysis Services (SSAS) installed. The model uses a relational data source named DB1.
You need to ensure that Server1 passes the credentials of the current user browsing the model to DB1.
What should you do?

• A. Register a Service Principal Name (SPN) for Server1.
• B. From the SQL Server Data Tools, modify the impersonation settings.
• C. From the Web.config file, modify the impersonation settings.
• D. Register a Service Principal Name (SPN) for DB1.

Answer: A

NEW QUESTION 10
You need to develop the multidimensional project to meet the requirements of the Excel users.
What should you do?

• A. Create a separate cube for the executive team so that it contains only the data they want to see.
• B. Create a perspective for the executive team.
• C. Create security roles to restrict access to the executive team.
• D. Create a view for the executive team.

Answer: B

NEW QUESTION 11
You need create the data source view for the StandardReports project. What should you do?

• A. Create a data source, connect it to the data warehouse, and then use the Data Source View wizard.
• B. Generate a relational schema from the dimensions and cubes by using the Schema Generation wizard.
• C. Create a new data source view and then use the Import from Table wizard.
• D. Execute the Import from Table wizard and then use the Data Source View wizard.

Answer: A

NEW QUESTION 12
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.

Answer: B

NEW QUESTION 13
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.

Answer: C

NEW QUESTION 14
You are creating a SQL Server Analysis Services (SSAS) cube.
You need to create a time dimension. It must be linked to a measure group named Sales at the day granularity level. It must also be linked to a measure group named Salary at the month granularity level.
What should you do?

• A. Use role playing dimensions.
• B. Use the Business Intelligence Wizard to define dimension intelligence.
• C. Add a measure that uses the Count aggregate function to an existing measure group.
• D. Add a measure that uses the DistinctCount aggregate function to an existing measure group.
• E. Add a measure group that has one measure that uses the DistinctCount aggregate function.
• F. Add a calculated measure based on an expression that counts members filtered by the Exists and NonEmpty functions.
• G. Add a hidden measure that uses the Sum aggregate functio
• H. Add a calculated measure aggregating the measure along the time dimension.
• I. Create several dimension
• J. Add each dimension to the cube.
• K. Create a dimensio
• L. Then add a cube dimension and link it several times to the measure group.
• M. Create a dimensio
• N. Create regular relationships between the cube dimension and the measure grou
• O. Configure the relationships to use different dimension attributes.
• P. Create a dimension with one attribute hierarch
• Q. Set the IsAggregatable property to False and then set the DefaultMember propert
• R. Use a regular relationship between the dimension and measure group.
• S. Create a dimension with one attribute hierarch
• T. Set the IsAggregatable property to False and then set the DefaultMember propert
• U. Use a many-to-many relationship to link the dimension to the measure group.
• V. Create a dimension with one attribute hierarch
• W. Set the IsAggregatable property to False and then set the DefaultMember propert
• X. Use a many-to-many relationship to link the dimension to the measure group.
• Y. Create a dimension with one attribute hierarch
• Z. Set the ValueColumn property, set the IsAggregatable property to False, and then set the DefaultMember propert
• BA. Configure the cube dimension so that it does not have a relationship with the measure grou
• BB. Add a calculated measure that uses the MemberValue attribute property.
• BC. Create a new named calculation in the data source view to calculate a rolling su
• BD. Add a measure that uses the Max aggregate function based on the named calculation.

Answer: J

NEW QUESTION 15
You are developing a SQL Server Reporting Services (SSRS) report that renders in HTML. The report includes a dataset with fields named Description, Price, and Color. The report layout includes a table that displays product details and also includes columns named Description, Price, and Color.
You need to modify the report so that users can sort products by the Price column. What should you do?

• A. Set the SortExpression value to = Fields!Price.Description for the Price text box.
• B. Set the SortExpression property to =Fields!Price.Name for the Price text box.
• C. Set the SortExpression property to =Fields!Price.Value for the Price text box.
• D. Add a custom action to the Price text box.

Answer: C

NEW QUESTION 16
You are adding dimensions and a new measure group named Service Quality to an existing SQL Server Analysis Services (SSAS) cube.
Date is one of the existing dimensions in the SSAS database. The underlying fact table for the measure group is associated with multiple dates, including FirstServiceDate, SecondServiceDate, and ThirdServiceDate.
You need to ensure that users can slice the Service Quality measures by FirstServiceDate, SecondServiceDate, and ThirdServiceDate. You also need to ensure that the time required to process the database is minimized.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)

• A. Create cube dimensions named FirstServiceDate, SecondServiceDate, and ThirdServiceDate by using the existing date dimension in the database.
• B. Create three independent dimensions named FirstServiceDate, SecondServiceDate, and ThirdServiceDate and then link all three of them to the Service Quality measure group.
• C. Create three new perspectives named FirstServiceDat
• D. SecondServiceDate, and ThirdServiceDate.
• E. Add three attributes named FirstServiceDate, SecondServiceDate, and ThirdServiceDate to the existing date dimension in the database.

Answer: A