Microsoft 70-466 Dumps 2021

NEW QUESTION 1
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 2
You are developing a SQL Server Analysis Services (SSAS) tabular project that will be used by the finance, sales, and marketing teams.
The sales team reports that the model is too complex and difficult to use. The sales team does not need any information other than sales-related resources in the tabular model. The finance and marketing teams need to see all the resources in the tabular model.
You need to implement a solution that meets the needs of the sales team while minimizing development and administrative effort.
What should you do?

• A. Create a separate partition for each team.
• B. Create a separate data source for each team.
• C. Create a perspective for the sales team.
• D. Enable client side security to filter non-sales data.

Answer: C

NEW QUESTION 3
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 permissio
• B. Add each salesperson's logon as a member to the role.
• C. Add the Sales Persons and Territories table to the model, define the relationships, and then implement dynamic security by using row filter
• D. Grant each salesperson access to the model.
• E. Create a new Active Directory Domain Services (AD DS) security group and add each salesperson as a membe
• F. Then create a new role named Sales Persons with Read permissio
• G. Add the group as a member to the new role.
• H. Create a separate tabular model for each sales territory and assign each tabular model a corresponding sales territory nam
• I. Grant each salesperson access to the corresponding tabular model of the assigned sales territory.

Answer: B

NEW QUESTION 4
DRAG DROP
You are developing a SQL Server Analysis Services (SSAS) tabular project based on a Microsoft Azure SQL Database database. The ProcessingOption property for the project is set to Do Not Process.
Several calculated columns have been added to a table. The project has been deployed to the production server.
You need to ensure that newly added data is processed on the production server.
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:
* To process a table
✑ In SQL Server Management Studio, in the tabular model database which contains the table you want to process, expand theTablesnode, then right-click on the table you want to process, and then clickProcess Table.
✑ In theProcess Tabledialog box, in theModelistbox, select one of the following process modes:
Etc-

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

• A. Create a member and then create a Multidimensional Expressions (MDX) filter.
• B. Create a member and then create a Data Analysis Expressions (DAX) filter.
• C. Create a role and then create a Multidimensional Expressions (MDX) filter.
• D. Create a role and then create a Data Analysis Expressions (DAX) filter.

Answer: D

NEW QUESTION 6
DRAG DROP
You are developing a SQL Server Analysis Services (SSAS) tabular project. You need to add a calculated column to a table in the model.
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:
✑ In the model designer, in Data View, select the table to which you want to add a calculated column, then click the Column menu, and then click Add Column.
* To create a new calculated columnAdd Column is highlighted over the empty rightmost column, and the cursor moves to the formula bar.
To create a new column between two existing columns, right-click an existing column, and then click Insert Column.
✑ In the formula bar, do one of the following:
✑ Press ENTER to accept the formula.
* Calculated columns, in tabular models, allow you to add new data to your model. Instead of pasting or importing values into the column, you create a DAX formula that defines the column’s row level values. The calculated column can then be used in a report, PivotTable, or PivotChart as would any other column.
* A calculated column is DAX expression that creates a new column in a table and the obtained values are stored in the table; the calculated column expression is evaluated every time the table is processed.
* In tabular object models the calculated column is a column in a table whose values are calculated upon definition of the column, from an expression.

NEW QUESTION 7
You are developing a new SQL Server Reporting Services (SSRS) report in SQL Server Data Tools (SSDT).
The report contains tables, images, charts, page breaks, gauges, and indicators.
You need to ensure that the reports can be exported to Microsoft Excel and PDF formats and do not have any layout issues.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)

• A. During development, preview the report in the SSDT preview tab to validate its default HTML rendering.
• B. After development, test the report in a web browser.
• C. Increase the value of the Width property of the report body.
• D. During development, preview the report in the SSDT preview tab and export it to the other rendering formats.

Answer: D

NEW QUESTION 8
You are managing a SQL Server Reporting Services (SSRS) instance in native mode. A system role named Developer Support is present on the server.
Members of the Developer Support role cannot modify the report execution timeout period. You need to enable members of the Developer Support role to modify the report execution
timeout period.
Which task should you add to the Developer Support role?

• A. Manage report server properties
• B. Manage shared schedules
• C. Execute report definitions
• D. Manage jobs

Answer: A

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

Answer: C

NEW QUESTION 10
You are developing a SQL Server Analysis Services (SSAS) multidimensional database. The underlying data source does not have a time dimension table.
You need to implement a time dimension. What should you do?

• A. Use the SQL Server Data Tools Dimension Wizard and generate a time table on the server.
• B. Create a CSV file with time data and use the DMX IMPORT statement to import data from the CSV file.
• C. Create a time dimension by using the Define dimension intelligence option in the Business Intelligence Wizard.
• D. Create a time dimension by using the Define time intelligence option in the Business Intelligence Wizard.

Answer: A

NEW QUESTION 11
You create a materialized reference dimension between a dimension named Regions and a measure group named Orders.
You use a table named Customers as a bridge as shown in the exhibit. (Click the Exhibit button.)

You need to ensure that data is updated to reflect any changes in the relationship. The solution must NOT require that the entire cube be reprocessed.
What should you reprocess?

• A. The Sales partition
• B. The Regions dimension
• C. The Customers dimension
• D. The Orders partition

Answer: C

NEW QUESTION 12
HOTSPOT
You create a new report in SQL Server Data Tools (SSDT). The report queries a Microsoft Azure SQL Database database table.
In a report table showing sales by cities, you need to enable users to interactively drill through to another report to show details of the customer sales within a chosen city.
Which text box property page should you use? (To answer, select the appropriate tab in the answer area.)

Answer:

Explanation:

NEW QUESTION 13
You are designing a SQL Server Reporting Services (SSRS) report. The report defines a single SQL Server data source and dataset.
You need to include additional data sourced from a Microsoft Azure SQL Database in the report.
What should you do?

• A. Create a SQL Server data source and then add a dataset that uses the new data source.
• B. Create a Microsoft Azure SQL Database data source and then add a dataset that uses the new data source.
• C. Generate an Atom-compliant data feed for the report.
• D. Create a Microsoft Azure SQL Database dataset that uses the existing data source.

Answer: B

NEW QUESTION 14
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 15
You need to meet the browsing requirements for the Products hierarchy. Which property should you modify?

• A. DefaultMember
• B. AttributeHierarchyDisplayFolder
• C. HideMemberIf
• D. RootMemberIf

Answer: C

Explanation: Topic 3, Data Architect
General Background
You are the data architect for a company that uses SQL Server 2012 Enterprise Edition. You design data modeling and reporting solutions that are based on a sales data warehouse.
Background
The solutions will be deployed on the following servers:
✑ ServerA runs SQL Server Database Engine, ServerA is the data warehouse server.
✑ ServerB runs SQL Server Database Engine, SQL Server Analysis Services (SSAS) in multidimensional mode, and SQL Server Integration Services (SSIS).
✑ ServerC runs SSAS in tabular mode, SQL Server Reporting Services (SSRS) running in SharePoint mode, and Microsoft SharePoint 2010 Enterprise Edition with SP1.
The data warehouse schema currently contains the tables shown in the exhibit. (Click the Exhibit button.)

Business Requirements
The reporting solution must address the requirements of the sales team, as follows:
✑ Team members must be able to view standard reports from SharePoint.
✑ Team members must be able to perform ad-hoc analysis by using Microsoft Power View and Excel.
✑ Team members can have standard reports delivered to them on a schedule of their choosing.
The standard reports
✑ Will use a sales territory hierarchy for organizing data by region.
✑ Will be accessible from SharePoint.
The Excel ad-hoc reports
✑ Will use the same data store as the standard reports.
✑ Will provide direct access to the data store for the sales team and a simplified view for the executive team.
Technical Requirements
The standard reports must be based on an SSAS cube. The schema of the data warehouse on ServerA must be able to support the ability to slice the fact data by the following dates:
✑ Order date (OrderDateKey)
✑ Due date (DueDateKey)
✑ Ship date (ShipDateKey)
Additions and modifications to the data warehouse schema must adhere to star schema design principles to minimize maintenance and complexity
.The multidimensional and tabular models will be based on the data warehouse. The tabular and multidimensional models will be created by using SQL Server Data Tools (SSDT). The tabular project is named AdhocReports and the multidimensional project is named Standard Reports.
The cube design in the Standard Reports project must define two measures for the unique count of sales territories (SalesTerritoryKey) and products (ProductKey).
A deployment script that can be executed from a command-line utility must be created to deploy the StandardReports project to ServerB.
The tabular model in the AdhocReports project must meet the following requirements:
✑ A hierarchy must be created that consists of the SalesTerritoryCountry and SalesTerritoryRegion columns from the DimSalesTerritory table and the EmployeeName column from the DimEmployee table.
✑ A key performance indicator (KPI) must be created that compares the total quantity sold (OrderQuantity) to a threshold value of 1,000.
✑ A measure must be created to calculate day-over-day (DOD) sales by region based on order date.
SSRS on ServerC must be configured to meet the following requirements:
✑ It must use a single data source for the standard reports.
✑ It must allow users to create their own standard report subscriptions.
✑ The sales team members must be limited to only viewing and subscribing to reports in the Sales Reports library.
A week after the reporting solution was deployed to production, Marc, a salesperson, indicated that he has never received reports for which he created an SSRS subscription. In addition, Marc reports that he receives timeout errors when running some reports on demand.

NEW QUESTION 16
You are developing a SQL Server Analysis Services (SSAS) cube for the sales department at your company.
The sales department requires the following set of metrics:
✑ Unique count of customers
✑ Unique count of products sold
✑ Sum of sales
You need to ensure that the cube meets the requirements while optimizing query response time.
What should you do? (Each answer presents a complete solution. Choose all that apply.)

• A. Place the measures in a single measure group.
• B. Place the distinct count measures in separate measure groups.
• C. Use the additive measure group functions.
• D. Use the semiadditive measure group functions.
• E. Use the Count and Sum measure aggregation functions.
• F. Use the Distinct Count and Sum measure aggregation functions.

Answer: BF