Microsoft 70-466 Dumps Questions 2021

NEW QUESTION 1
You need to deploy the StandardReports project at the end of the current business day.
What should you do? (Each correct answer presents a complete solution. Choose all that apply.)

• A. Use the Analysis Services Deployment utility to create an XMLA deployment script and run it at the end of the day.
• B. Use the Analysis Services Deployment wizard to create an MDX deployment script and run it at the end of the day.
• C. Use the Analysis Services Deployment wizard to create an XMLA deployment script and run it at the end of the day.
• D. Deploy the project from SQL Server Data Tools (SSDT) at the end of the day.

Answer: CD

Explanation: Topic 4, Mix Questions

NEW QUESTION 2
You need to modify the Sales Regions hierarchy to meet the reporting requirements. Which SSAS feature should you use?

• A. Calculation
• B. Translation
• C. Perspective
• D. Action

Answer: B

NEW QUESTION 3
You are restructuring an existing cube. One of the measures in the cube is Amount. The Sum aggregation function is used for the Amount measure. The cube includes a dimension named Account and the dimension's Type property is set to Accounts. The Account dimension includes an account type attribute.
You need to ensure that the Amount measure aggregates correctly according to the account type classification. Development effort must be minimized.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)

• A. Develop a .NET application that uses Analysis Management Objects (AMO) to change the existing AggregateFunction property value of the Amount measure to FirstNonEmpty and then use the application.
• B. Develop a .NET application that uses Analysis Management Objects (AMO) to change the existing AggregateFunction property value of the Amount measure to ByAccount and then use the application.
• C. Use SQL Server Data Tools to change the AggregateFunction property value of the Amount measure to ByAccount.
• D. Add the ByAccount attribute to the account dimension.

Answer: C

NEW QUESTION 4
You are developing a SQL Server Analysis Services (SSAS) cube named Sales Planning. The cube consists of two measure groups named Sales and Planning. Each measure group is based on a data warehouse fact table and consists of a single MOLAP partition that has the same name as its measure group.
The Planning measure group consists of two measures:
•Forecast, which uses the Sum aggregate function
•Forecast Count, which uses the Count aggregate function
Users contribute planning values by using a legacy application. An extract, transform, load (ETL) process is scheduled to periodically transfer the planning values from the database of the legacy application to the data warehouse.
Financial analysts query the Sales Planning cube and report that the planning values are sometimes out of date. A new company requirement mandates that the planning values be entered directly into the cube by using Microsoft Excel 2010 PivotTable What-If Analysis.
You need to write-enable the Planning partition.
What should you do before write-enabling the partition?

• A. Set the StorageMode property of the Planning partition to Rolap
• B. Set the ProcessingMode property of the Planning partition to LazyAggregations.
• C. Set the ProcessingMode property of the Planning measure group to LazyAggregations.
• D. Remove the Forecast Count measure.
• E. Set the Type property of the Planning measure group to Budget.
• F. Convert the Planning measure group to a linked measure group.

Answer: D

Explanation: A cube can be write-enabled only if all its measures use the Sum aggregate function.

NEW QUESTION 5
You are administrating a SQL Server Analysis Services (SSAS) tabular database.
You need to create a new role that allows its members to query data and to refresh data in the model.
Which permission should you use? (More than one answer choice may achieve the goal. Select the BEST answer.)

• A. Browse and Manage
• B. Administrator
• C. Read and Process
• D. Explore and Manage

Answer: C

Explanation: * Giving a database role permission to process an Analysis Services database means that the role has permission to perform all processing options on the database. This includes the processing of all cubes, dimensions, mining structures, and mining models in the database. However, the role does not have permission to read database metadata or access any data in the database itself.

NEW QUESTION 6
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. Implement the cube as a local cube.
• B. Ensure that the measure group measures only use semiadditive aggregation functions.
• C. Implement the linked measure group as a local measure group.
• D. Ensure that the measure group measures only use nonadditive aggregation functions

Answer: C

NEW QUESTION 7
HOTSPOT
You create a new report in SQL Server Data Tools (SSDT). The report queries a Windows Azure SQL Database database table.
In a report table showing sales by countries and cities, you need to enable users to hide or show cities by clicking the name of a country.
Which property page of the city text box should you use? (To answer, select the appropriate tab in the answer area.)

Answer:

Explanation:

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

Answer: A

NEW QUESTION 9
You are managing a SQL Server Reporting Services (SSRS) instance.
A website must pass credentials to the local security authority for Reporting Services.
You need to configure Reporting Services to issue a challenge/response when a connection is made without credentials.
Which authentication type should you configure in the RSReportServer.config file?

• A. RSWindowsKerberos only
• B. RSWindowsKerberos and RSWindowsNTLM
• C. RSWindowsBasic
• D. RSWindowsKerberos and RSWindowsNegotiate

Answer: C

Explanation: Ref: http://msdn.microsoft.com/en-us/library/ms157273.aspx

NEW QUESTION 10
You are developing a SQL Server Analysis Services (SSAS) tabular project. The model includes a table named Sales. The Sales table includes a single date column.
The Sales table must meet the following requirements:
✑ Queries must be able to return all rows.
✑ Must be able to support four different processing schedules for different date ranges.
✑ Date ranges must not include any overlapping data.
You need to implement a solution that meets the requirements. What should you do?

• A. Create four partitions for the Sales tabl
• B. Create four role
• C. Use the same row filter queries for each role and partition.
• D. Convert the Sales table into four smaller tables by using row filter querie
• E. Use one perspective for all four tables.
• F. Create four partitions for the Sales tabl
• G. Use row filter queries for each partition.
• H. Convert the Sales table into four smaller tables by using row filter querie
• I. Use one perspective for each of the four tables.

Answer: C

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

• A. Process Index
• B. Process Data
• C. Process Add
• D. Process Default
• E. Process Clear
• F. Process Full

Answer: C

NEW QUESTION 12
DRAG DROP
You are developing a SQL Server Analysis Services (SSAS) cube. The cube consists of a single measure group.
The measure group consists of one partition that uses MOLAP. The proactive caching policy has the following requirements:
✑ The cache must be updated when data is changed in the table named tblOrders.
✑ Changes must be notified through the use of the XML for Analysis (XMLA) NotifyTableChange command.
You need to configure the proactive caching policy to meet the requirements.
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: On the Partitions tab, Click Storage Settings
We specify the Storage Settings for the correct partition.
Box 2: Enable proactive caching. We enable proactive caching.
Box 3: Select the Client initiated notification type, and then select the tblOrders table. On the Notifications tab, there are three options out of which, as shown below, you can
select any one at a time.
* SQL Server - With this option, SSAS uses SQL Server notification services/specialized trace mechanism to identify data changes.
* Client initiated - With this option, client can specify the XMLA (XML for Analysis) command (NotifyTableChange) to identify data changes.
* Scheduled polling - With this option, SSAS uses a series of queries to see (polling at defined interval) if there is any data change at the underlying relational database.

Note:
You use the Storage Settings dialog box in BIDS (Business Intelligence Development Studio) to set the proactive caching feature, storage location, and notification settings for a dimension, cube, measure group, or measure group partition.
✑ In the Cube Browser, open your cube and select the Partitions tab.
✑ Expand the measure group and select the partition for which you want to enable proactive caching.
✑ Click the Storage Setting link to open the Partition Storage Settings dialog box similar to the one as shown in below image. (Box 1)

The Custom Setting allows you to explicitly enable proactive caching (if you don't want to use Standard Setting), set storage mode, and notification options. (Box 2)

NEW QUESTION 13
You are developing a SQL Server Analysis Services (SSAS) tabular database. To maximize performance, queries must be resolved only by using cache.
You need to configure the appropriate query mode. Which query mode should you select?

• A. DirectQuery with In-Memory
• B. In-Memory with DirectQuery
• C. In-Memory
• D. DirectQuery

Answer: C

NEW QUESTION 14
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 mod
• B. Create a clustered index which includes all of the foreign key columns of the fact table.
• C. Configure the database to use In-Memory mod
• D. Create a clustered index which includes all of the foreign key columns of the fact table.
• E. Configure the database to use In-Memory mod
• F. Create a columnstore index on all the columns of the fact table.
• G. Configure the database to use DirectQuery mod
• H. Create a columnstore index on all the columns of the fact table.

Answer: D

NEW QUESTION 15
HOTSPOT
You are developing a SQL Server Analysis Services (SSAS) cube.
You create a degenerate dimension.
You need to define a relationship type for the dimension.
Which relationship type should you select? (To answer, configure the appropriate option or options in the dialog box in the answer area.)

Answer:

Explanation:

NEW QUESTION 16
You install SQL Server Reporting Services (SSRS). You need to back up a copy of the symmetric key. Which command should you run?

• A. rskeymgmt -a -f %temp%rs.key -p Password1
• B. rskeymgmt -d
• C. rskeymgmt -i
• D. rskeymgmt -e -f %temp%rs.key -p Password1

Answer: D