Microsoft 70-466 Dumps 2021

NEW QUESTION 1
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 2
You are developing a SQL Server Analysis Services (SSAS) cube.
You must create a four-level hierarchy for the employee dimension. Each level must be associated with an attribute in the employee dimension table. Two thirds of the dimension data contain values for all four attributes. The remainder of the dimension data contains values for the first three of the four attributes only.
You need to create the hierarchy so that logically missing members will not be shown by the reporting tool.
Which type of hierarchy should you create?

• A. A parent-child hierarchy
• B. A sparse hierarchy
• C. A ragged hierarchy
• D. A balanced hierarchy

Answer: C

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

The Product dimension has three attribute hierarchies:
✑ Product
✑ Subcategory
✑ 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.

Answer: B

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

NEW QUESTION 5
You are designing a SQL Server Analysis Services (SSAS) cube for the sales department at your company.
The sales department has the following requirements for the cube:
✑ Include a year-over-year (YOY) calculation
✑ Include a month-over-month (MOM) calculation
You need to ensure that the calculations are implemented in the cube. Which Multidimensional Expressions (MDX) function should you use?

• A. UNREGINTERCEPT()
• B. LASTPERIODS()
• C. TIMEINTELLIGENCE()
• D. PARALLELPERIOD()

Answer: D

NEW QUESTION 6
You are designing a SQL Server Reporting Services (SSRS) report that sources data from a Microsoft Azure SQL Database database.
The report must display the value and status of a Key Performance Indicator (KPI).
Which report item should you use? (Each answer presents a complete solution. Choose all that apply.)

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

Answer: AE

NEW QUESTION 7
You need to ensure that all reports meet the reporting requirements.
What is the best way to achieve the goal? More than one answer choice may achieve the goal. Select the BEST answer.

• A. Create a report par
• B. Publish the report part to a server that has SSRS installe
• C. Add the report part to each new report that is created.
• D. Create a report par
• E. Publish the report part to a SharePoint sit
• F. Add the report part to each new report that is created.
• G. Create a repor
• H. Copy the report to source code contro
• I. Create each new report by using the report template in source code control.
• J. Create a repor
• K. Copy the report to the PrivateAssembliesProjectItemsReportProject folder in the Visual Studio director
• L. Create each new report by using the locally stored report

Answer: D

NEW QUESTION 8
You are working with multiple tabular models deployed on a single SQL Server Analysis Services (SSAS) instance.
You need to ascertain the memory consumed by each object in the SSAS instance. What should you do?

• A. Use the $System.discover_object_memory_usage dynamic management view.
• B. Use SQL Server Profiler to review session events for active sessions.
• C. Use the Usage Based Optimization wizard to design appropriate aggregations.
• D. Use the Performance Counter group named Processing.

Answer: A

NEW QUESTION 9
HOTSPOT
You are developing a SQL Server Analysis Services (SSAS) cube that contains the data for a running team.
The data warehouse used by the cube contains the time durations of laps run by each runner on the team. The time durations are stored in seconds as an integer.
You need to build the following two measures in the cube:
✑ A measure named Measure1 that must contain the average time duration of the laps run by each runner.
✑ A measure named Measure2 that must contain the lap-time duration and the name
of the runner who ran the fastest lap.
What should you do? To answer, select the appropriate Aggregation Function property for each measure in the answer area.

Answer:

Explanation: Note: For Measure1 we use Average, and for Measure2 Min to get the fastest time.

NEW QUESTION 10
You need to create the AD Sales measure. Which aggregation function should you use?

• A. Sum
• B. Average
• C. ByAccount
• D. AverageOfChildren

Answer: D

NEW QUESTION 11
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 12
You are developing a BI Semantic Model (BISM) based on a simple and small dataset sourced from SQL Server. The data size and complexity of the data relationships will not change. The model will be used to produce reports in Power View. The reports will show the relationship between product sales and rainfall over time.
You need to use an appropriate project type.
Which project types should you use? (Each answer presents a complete solution. Choose all that apply.)

• A. A tabular project that uses the In-Memory query mode
• B. A tabular project that uses the DirectQuery query mode
• C. A multidimensional project that uses the MOLAP storage mode and proactive cache
• D. A multidimensional project that uses the ROLAP storage mode and columnstore indexes
• E. A PowerPivot workbook that is deployed to Microsoft SharePoint Server 2010

Answer: ABE

NEW QUESTION 13
DRAG DROP
You are developing a SQL Server Reporting Services (SSRS) report to display a list of employees. The report will be embedded into a Microsoft SharePoint Server Web Part Page of the company intranet site.
The report consists of a single table. The design of the table is shown in the following diagram.

You need to configure the EmailAddress detail text box to create a new email message. The email message must be addressed to the email address that was clicked by the user.
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:

Box 2:

Box 3:

Box 4:

Note:
* Select Action on the Text Box Properties dialog box to enable hyperlink options for the text box.
* Go to URL
Choose this option to define a link to a Web page. Type or select the URL of a Web page or an expression that evaluates to the URL of a Web page. Click the Expression (fx) button to change the expression. This expression can include a field that contains a URL.

NEW QUESTION 14
You are developing a new SQL Server Reporting Services (SSRS) report in SQL Server Data Tools (SSDT). This report has a table named Table1 and a textbox named Textbox1.
Table1 is initially visible but the user must be able to choose when to hide it. You need to develop the report to meet the requirement.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)

• A. For the properties of Table1, configure the Display can be toggled by this report item option to use Textbox1.
• B. Configure Textbox1 to drill through to rerun the report to toggle the display of Table1.
• C. For the properties of Table1, configure the Display can be toggled by this report item option to use Table1
• D. Add a parameter to the report so users can choose the display state of Table1.

Answer: A

NEW QUESTION 15
A large manufacturing company has manufacturing plants in many states. Each state has a dedicated SQL Server instance that stores its manufacturing data. Each SQL Server instance is configured identically and all instances have identical database structures.
You are developing a daily report that summarizes information on manufacturing activity. The report has the following requirements:
•It must have a stale name as one of the report parameters.
•It must provide a daily summary of manufacturing activity of a selected state.
•It must require minimal development and maintenance effort. You need to develop the report to meet the requirements.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)

• A. Build one report for each state and instruct users to execute reports as needed.
• B. Use a report-specific data source that defines an expression-based connection string based on the state parameter.
• C. Build a centralized data repository, schedule a regular Extract Transform, and Load (ETL) process on all manufacturing data, and then use the repository to generate the report.
• D. Use a shared data source that defines an expression-based connection string based on the state parameter.

Answer: B

NEW QUESTION 16
You work in the Business Intelligence (BI) department of a multinational company.
To share its sales data between the various subsidiaries, the company has requested a new corporate BI solution that meets the following requirements:
✑ The solution must use SQL Server Analysis Services (SSAS) multidimensional or tabular Business Intelligence Semantic Model (BISM).
✑ The model must incrementally add 10 million fact rows of sales data per month.
✑ The model must be translated to English, German, Chinese, or Spanish based on users' locale.
✑ The model must be able to contain the most recent 36 months of data, in order to let users query the data.
You need to select the appropriate model type and partitioning strategy to meet the requirements.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)

• A. Create and deploy a BISM multidimensional model with one partition for all of the data.
• B. Create and deploy a BISM tabular model with one partition for each of the 36 months.
• C. Create and deploy a BISM multidimensional model with one partition for each of the 36 months.
• D. Create and deploy a BISM tabular model with one partition for all of the data.

Answer: C