70-466 | Real 70-466 Dumps Questions 2021

NEW QUESTION 1
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 2
You need to identify the reports that produce the errors that Marc is receiving.
What should you do?

• A. Write a query by using the Subscriptions table in the report server database.
• B. Write a query by using the Execution Log 3 view in the report server database.
• C. Use the Windows Event Viewer to search the Application log for errors.
• D. Search the ReportServerService_<timestamp>.log file for errors.

Answer: B

NEW QUESTION 3
DRAG DROP
You are making changes to a cube named Sales.
You must increase the value of the measure named Sales Amount by 10%. The increase must be applied only to the children of the member named East in the dimension named Customer.
You need to complete the Multidimensional Expressions (MDX) statement in the calculations section of the Sales cube.
Which statement fragments should you use? (To answer, drag the appropriate statement component to the correct location or locations in the answer area. Use only components that apply.)

Answer:

Explanation: Note:
SCOPE THIS END SCOPE
* SCOPE Statement (MDX)
Limits the scope of specified Multidimensional Expressions (MDX) statements to a specified subcube.
* Example: cope
(
[Date].[Fiscal Year].&[2002], [Date].[Fiscal].[Month].Members
) ;
This = [Date].[Fiscal].CurrentMember.Parent / 3 ; End Scope;

NEW QUESTION 4
You need to create a measure for DOD sales.
What should you do? (Each correct answer presents part of the solution. Choose all that apply.)

• A. Use the Data Analysis Expressions (DAX) PARALLELPERIOD ( ) function.
• B. Create a date dimension by using the Dimension wizard with a date template.
• C. Specify a date table by using a Mark the Date table.
• D. Use the Multidimensional Expressions (MDX) PARALLELPERIOD( ) function.

Answer: AC

NEW QUESTION 5
DRAG DROP
You are using Multidimensional Expressions (MDX) to query a SQL Server Analysis Services (SSAS) cube.
You need to compute the aggregate value of the 10 most-ordered produces in the Product Categories hierarchy. The Product level is the lowest in the hierarchy.
Which functions should you use to complete the MDX query? (To answer, drag the appropriate functions from the list of functions to the correct locations in the answer area.)

Answer:

Explanation: Note:
* Example (order of TopCount and Aggregate): WITH
SET
[Top25Customers] as
TopCount([Customers].[All Customers].Children, 25.0, [Measures].[Sales]) MEMBER [Customers].[All Customers].[Rest of Customers] as Aggregate(Except([Customers].[All Customers].Children,[Top25Customers])) SELECT
NON EMPTY {CROSSJOIN([Markets].[All Markets].Children,{[Measures].Sales})} ON COLUMNS,
Union([Top25Customers],{[Customers].[All Customers].[Rest of Customers]}) ON ROWS from [SteelWheelsSales]
* TopCount: Sorts a set in descending order and returns the specified number of elements with the highest values.
*Aggregate:
Returns a number that is calculated by aggregating over the cells returned by the set expression. If a numeric expression is not provided, this function aggregates each measure within the current query context by using the default aggregation operator that is specified for each measure. If a numeric expression is provided, this function first evaluates, and then sums, the numeric expression for each cell in the specified set.
* Example:
One can extract the leaf members of a parent child hierarchy by asking the descendants of the root member with the following
expression: Descendants([Organization].[Organizations].&[1], , LEAVES)
* Incorrect:
/ Not TopSUM: Returns, in order of decreasing rank, the top-most rows of a table whose cumulative total is at least a specified value.

NEW QUESTION 6
You need to modify the environment before you create the QuarterSales report. What should you do?

• A. Add a date table to the model that contains columns for the fiscal and calendar quarters.
• B. Add a date table to the model that contains measures for the fiscal and calendar quarters.
• C. Configure a time dimension by using the Time Intelligence Wizard.
• D. Configure SSAS to use a server time dimension.

Answer: C

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

• A. Explorer
• B. Select
• C. Process
• D. Browser
• E. Read Definition
• F. Read

Answer: F

NEW QUESTION 8
You need to develop an SSRS report that retrieves currency exchange rate data. How should you configure the data source for the report?

• A. Use the Microsoft Azure SQL Database data source type and then set a username and password for the credentials.
• B. Use the SQL Server data source type and then set Windows authentication for the credentials.
• C. Use the Microsoft Azure SQL Database data source type and then set Windows authentication for the credentials.
• D. Use the SQL Server data source type and then set a username and password for the credentials.

Answer: A

NEW QUESTION 9
DRAG DROP
You have a cube named Cube1 that contains the sales data for your company. You plan to build a report based on the cube.
You need to write an MDX expression that returns the total sales from the first month of the 2009 fiscal year and the total sales from the same period of the 2008 fiscal year.
Which code segments should you insert at line 03 and line 05? To answer, drag the appropriate code segments to the correct lines. Each code segments 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.

Answer:

Explanation:

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

Answer: A

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 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 14
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

Answer: ABD

NEW QUESTION 15
You are designing a SQL Server Reporting Services (SSRS) report based on a SQL Server Analysis Services (SSASJ cube.
The cube contains a Key Performance Indicator (KPI) to show if a salesperson's sales are off target slightly off target, or on target.
You need to add a report item that visually displays the KPI status value as a red, yellow, or green circle.
Which report item should you add?

• A. Linear Gauge
• B. Indicator
• C. Data Bar
• D. Radial Gauge
• E. Sparkline

Answer: B

NEW QUESTION 16
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 France and Germany.
Which expression should you use? (To answer, drag the appropriate expression to the answer area.)

Answer:

Explanation:

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

A sample from DimCustomer is shown in the following table.

A sample from FactSales is shown in the following table.

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.

Answer:

Explanation:

NEW QUESTION 18
DRAG DROP
You manage a SQL Server Reporting Services (SSRS) instance in native mode. You are building a shared dataset for your weekly performance reports. The shared dataset uses a data source that is configured to use credentials that are stored in the Report Server.
You have a predefined shared schedule to perform cleanup and maintenance tasks for SSRS.
You need to enable caching on the shared dataset. You also need to use an existing shared schedule to discard the cache.
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.)

Answer:

Explanation: Box 1: Open Report Manager and then click the shared dataset.
We should use Report Manager (not SharePoint Central Administration).
Box 2: Select the Caching page and then click the Cache shared dataset checkbox. We set up caching.
Box 3: Select the Expire the cache on the following schedule option and then select the Shared Schedule option.
We configure caching further.
Box 4: From the combo box, select the shared schedule and then click Apply. Finally we define scheduling.
Note on caching:
To open the Caching properties page for a shared dataset
✑ Open Report Manager, and locate the report for which you want to configure shared dataset properties.
✑ Point to the shared dataset, and click the drop-down arrow.
✑ In the drop-down list, click Manage. The General properties page for the report opens.
✑ Click the Caching tab. Options include:
Cache shared dataset (Box 2 above)
Places a temporary copy of the data in a cache when a user first opens a report that uses this shared dataset. Subsequent users who run the report within the caching period receive the cached copy of the data. Caching usually improves performance because the data is returned from the cache instead of running the dataset query again.
Expire the cache on the following schedule (box 3 above)
Schedule the time when the cached data is no longer valid and is removed from the cache. The schedule can be a shared schedule or one that is specific for only the current shared dataset.

NEW QUESTION 19
You manage an environment that has SharePoint Server 2010 and a SQL Server Reporting Services (SSRS) instance in SharePoint integrated mode. Several report subscriptions are configured to deliver reports through email by using a shared schedule.
The email server will be going offline.
You need to temporarily suspend the shared schedule until the email server is brought back online.
What should you do?

• A. In Report Manager, pause the shared schedule.
• B. In SharePoint Central Administration, pause the shared schedule.
• C. In Report Manager, delete the shared schedule.
• D. In SharePoint Central Administration, delete the shared schedule.

Answer: B

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

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

Answer: D