Microsoft Recertification for MCSE: Business Intelligence - 70-470 Exam Practice Test
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?
- 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?
Correct Answer: D
Vote an answer
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 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?
Correct Answer: C
Vote an answer
You need to create the Package Activity report.
What should you do?
What should you do?
Correct Answer: A
Vote an answer
You need to ensure that managers can successfully run reports.
What should you do?
What should you do?
Correct Answer: A
Vote an answer
You need to use Reporting Services Configuration Manager to configure SSRS to complete the installation on SSRS02.
What should you do? (Each correct answer presents a partial solution. Choose all that apply.)
What should you do? (Each correct answer presents a partial solution. Choose all that apply.)
Correct Answer: A,B,D
Vote an answer
Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).
You deploy a PowerPivot workbook to a PowerPivot Gallery in a Microsoft SharePoint site. Workbook data comes from two different sources: Source A and Source B.
The workbook contains five tables with a total of 20 million rows from Source A, and three small lookup tables from Source B.
Data from Source A is updated throughout the day. Data from Source B is updated at 3:00 P.M.
You have the following requirements:
- Refresh the PowerPivot workbook with updated lookup data as soon as possible.
- Minimize load on the source systems and the SharePoint environment during business hours.
- Minimize user involvement in the data refresh process.
You enable automatic data refresh for the workbook.
You need to configure a data refresh schedule for the workbook that meets the requirements.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)
The workbook contains five tables with a total of 20 million rows from Source A, and three small lookup tables from Source B.
Data from Source A is updated throughout the day. Data from Source B is updated at 3:00 P.M.
You have the following requirements:
- Refresh the PowerPivot workbook with updated lookup data as soon as possible.
- Minimize load on the source systems and the SharePoint environment during business hours.
- Minimize user involvement in the data refresh process.
You enable automatic data refresh for the workbook.
You need to configure a data refresh schedule for the workbook that meets the requirements.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)
Correct Answer: E
Vote an answer
Your network contains the following components:
---
Microsoft SharePoint Server 2010 SQL Server 2008 Service Pack 2 (SP2) SQL Server 2008 Service Pack 1 (SP1) in Reporting Services Native Mode
You need to recommend a solution to upgrade the network to SQL Server 2014. The solution must meet the following requirements:
--
Minimize the amount of time that SharePoint services are unavailable. Deploy the upgraded Reporting Services instance in Reporting Services SharePoint Integrated Mode.
You upgrade the Database Engine to SQL Server 2014.
Which three actions should you recommend performing next? Each correct answer presents part of the solution.
---
Microsoft SharePoint Server 2010 SQL Server 2008 Service Pack 2 (SP2) SQL Server 2008 Service Pack 1 (SP1) in Reporting Services Native Mode
You need to recommend a solution to upgrade the network to SQL Server 2014. The solution must meet the following requirements:
--
Minimize the amount of time that SharePoint services are unavailable. Deploy the upgraded Reporting Services instance in Reporting Services SharePoint Integrated Mode.
You upgrade the Database Engine to SQL Server 2014.
Which three actions should you recommend performing next? Each correct answer presents part of the solution.
Correct Answer: B,D,E
Vote an answer
HOTSPOT
You are designing a SQL Server Reporting Services (SSRS) report that sources data from a SQL Azure database.
You need to design the report to show the sum of sales. The sales must be grouped by region on the rows and year on the columns.
Which report item should you add? To answer, select the appropriate setting in the answer area.
You are designing a SQL Server Reporting Services (SSRS) report that sources data from a SQL Azure database.
You need to design the report to show the sum of sales. The sales must be grouped by region on the rows and year on the columns.
Which report item should you add? To answer, select the appropriate setting in the answer area.
Correct Answer:
You need to create the Sales Reporting shared SSRS data source.
Which SSRS data connection type should you use?
Which SSRS data connection type should you use?
Correct Answer: D
Vote an answer