70-470 Exam
Update Microsoft 70-470 - An Overview 171 to 179
If you realize nothing about Microsoft Microsoft exam or perhaps our corresponding exam merchandise, please seek for support from the study guide and customer assistance. Whats more you can take a quiz just before buying our own Microsoft 70-470 exam. This phase measures your knowledge and abilities to make for the Microsoft 70-470 exam. With regard to more information, take a look at our FAQs about Ucertifys home site.
2021 Dec 70-470 exam cram
Q171. - (Topic 10)
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 SQL Azure database in the report.
What should you do?
A. Create a SQL Azure dataset that uses the existing data source.
B. Create a SQL Azure data source and then add a dataset that uses the new data source.
C. Create a SQL Server data source and then add a dataset that uses the new data source.
D. Generate an Atom-compliant data feed for the report.
Answer: B
Q172. - (Topic 10)
... .
You work in the Business Intelligence (BI) department of a multinational company.
The company has requested a new corporate BI solution that meets the following requirements:
The solution must use SQL Server Analysis Services (SSAS).
The model must incrementally add 10 million fact rows per month.
The model must be translated to English, French, or Spanish based on users'
locale.
The model must be able to contain the most recent 36 months of 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 a multidimensional model with one partition for all of the data.
B. Create a multidimensional model with one partition for each month.
C. Create a tabular model with one partition for all of the data.
D. Create a tabular model with one partition for each month.
Answer: C
Q173. - (Topic 10)
You are modifying a SQL Server Analysis Service (SSAS) cube. The cube consist of a single measure group that contains the following measures:
. Total Quantity On Hand
. Average Quantity On Hand
The measure group has a single partition that uses the MOLAP storage mode.
You need to modify the cube design to ensure that the Total Quantity On Hand measure is updated in real-time and that Average Quantity On Hand measure is updated hourly.
What should you do?
A. Create a new measure group for the Total Quantity On Hand measure. Configure the storage mode for the new measure group's partition to ROLAP.
B. Create an XMLA script that will process the cube and then use SQL Server Agent to execute the script continuously.
C. Change the storage mode of the partition to use proactive caching with minimum latency.
D. Create a new measure group for the Average Quantity On Hand measure. Configure the storage mode for the new measure group's partition to ROLAP.
Answer: A
Q174. DRAG DROP - (Topic 9)
A SQL Server Analysis Services (SSAS) cube named Sales includes a dimension named Date that defines a hierarchy named Calendar. The Calendar hierarchy consists of Year, Quarter, and Month levels. The Type properties of the Date dimension and its attributes are appropriately configured to mark the dimension as a time dimension.
You are creating a Multidimensional Expressions (MDX) query that will return sales for each month of 2011 and a three-month moving average of sales (labeled 3MMA), as shown in the following diagram.
You need to complete the MDX query.
Which set expression should you use? To answer, drag the appropriate expression to the answer area.
Answer:
Leading 70-470 torrent:
Q175. DRAG DROP - (Topic 9)
You are the administrator of a SQL Server Integration Services (SSIS) catalog. You have
access to the original password that was used to create the SSIS catalog. A full database backup of the SSISDB database on the production server is made each day. The server used for disaster recovery has an operational SSIS catalog.
The production server that hosts the SSISDB database fails.
Sensitive data that is encrypted in the SSISDB database must not be lost.
You need to restore the production SSIS catalog to the disaster recovery server.
Which three steps 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:
Q176. HOTSPOT - (Topic 9)
You administer a SQL Server Analysis Services (SSAS) cube.
You plan to optimize the cube partitions by using usage-based optimization.
You need to configure the SSAS instance.
Which properties should you configure? To answer, select the appropriate properties in the
dialog box in the answer area.
Answer:
Q177. DRAG DROP - (Topic 10)
You are developing a SQL Server Analysis Services (SSAS) cube.
You need to reuse a Revenue measure group from a different database.
In SQL Server Data Tools (SSDT), 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:
Q178. - (Topic 10)
You are modifying a SQL Server Analysis Services (SSAS) cube.
Users of the cube report that the precision for the TransactionCost measure is five digits.
You need to ensure that the TransactionCost measure stores values to two digits of precision.
What should you do?
A. Add a named calculation in the data source view that casts the data source column to two digits of precision. Bind the TransactionCost measure to the new column.
B. Add a named query in the data source view that casts the data source column to two digits of precision. Bind the TransactionCost measure to the new query.
C. Use the FormatString measure property to format TransactionCost as #,##0.00;-#,##0.00.
D. Use the FormatString measure property to format TransactionCost as Currency.
E. Use the MeasureExpression measure property to change the precision of TransactionCost to two digits.
Answer: A
241. - (Topic 10)
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. Use SQL Server Management Studio to create a role. Then create a Data Analysis Expressions (DAX) filter.
B. Create a member and then create a Data Analysis Expressions (DAX) filter.
C. Create a member and then create a Multidimensional Expressions (MDX) filter.
D. Use SQL Server Management Studio to create a role. Then create a Multidimensional Expressions (MDX) filter.
Answer: A
Q179. - (Topic 3)
You need to configure data refresh for the Manufacturing Performance PowerPivot workbook.
What should you do? (Each correct answer presents part of the solution. Choose ail that apply.)
A. Configure the PowerPivot Data Refresh Timer Job to run every 60 minutes.
B. Restore the PowerPivot workbook to an SSAS instance in tabular mode.
C. Script a process command and configure a SQL Server Agent job to execute the command every 60 minutes.
D. Restore the PowerPivot workbook to an SSAS instance in PowerPivot for SharePoint mode.
Answer: A