70-467 · Question #144
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…
The correct answer is A. Power View. This question appears to have mismatched content - the stem describes a PowerPivot data refresh scheduling scenario but the answer choices list report authoring tools; the designated correct answer is Power View (A).
Question
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.)
Options
- APower View
- BReport Designer
- CReport Builder
- DPerformancePoint Services
How the community answered
(30 responses)- A83% (25)
- B10% (3)
- C3% (1)
- D3% (1)
Why each option
This question appears to have mismatched content - the stem describes a PowerPivot data refresh scheduling scenario but the answer choices list report authoring tools; the designated correct answer is Power View (A).
Per the provided correct answer, Power View is designated as correct; Power View is a self-service interactive data exploration and visualization tool in SharePoint and SQL Server BI. However, the answer choices do not align with the PowerPivot refresh scheduling scenario described in the question stem, suggesting this item may contain a content mismatch from the source exam bank.
Report Designer is a full-featured SSRS report authoring environment hosted inside Visual Studio, unrelated to configuring PowerPivot workbook data refresh schedules in SharePoint.
Report Builder is a standalone end-user SSRS report authoring tool, unrelated to scheduling or configuring PowerPivot data refresh operations.
PerformancePoint Services is a SharePoint dashboard and scorecard analytics service, unrelated to PowerPivot workbook data refresh scheduling.
Concept tested: PowerPivot data refresh scheduling in SharePoint environment
Source: https://learn.microsoft.com/en-us/sql/analysis-services/power-pivot-sharepoint/schedule-data-refresh-and-data-sources-no-windows-authentication
Topics
Community Discussion
No community discussion yet for this question.