Microsoft
70-467 · Question #161
70-467 Question #161: Real Exam Question with Answer & Explanation
The correct answer is C: Set the default schedule to refresh at 9:00 A.M. every day.. A PowerPivot data refresh schedule must deliver updated lookup data from Source A as soon as possible while avoiding peak-hour load on source systems and SharePoint.
Question
You deploy a PowerPivot workbook to a document library in a Microsoft SharePoint site. Workbook data comes from two different sources: Source A and Source B. The workbook contains three small lookup tables from Source A, and five tables with a total of 20 million rows from Source B. Data from Source A is updated at 9:00 A.M. and data from Source B is updated throughout the day. 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
- ASet the default schedule to refresh outside of business hours.
- BSet the default schedule to refresh outside of business hours.
- CSet the default schedule to refresh at 9:00 A.M. every day.
- DSet the default schedule to refresh at 3:00 P.M. every day.
- ESet the default schedule to refresh at 9:00 A.M. every day.
Explanation
A PowerPivot data refresh schedule must deliver updated lookup data from Source A as soon as possible while avoiding peak-hour load on source systems and SharePoint.
Common mistakes.
- A. Refreshing outside business hours misses Source A's 9:00 A.M. update window entirely, delaying fresh lookup data for most of the business day and directly violating the requirement to refresh as soon as possible.
- B. This choice is identical to choice A - an outside-business-hours schedule still fails to capture Source A's 9:00 A.M. lookup update in a timely manner.
- D. A 3:00 P.M. schedule occurs during peak business hours and lags Source A's 9:00 A.M. update by six hours, adding unnecessary load mid-day and delaying the availability of refreshed lookup data.
- E. This choice is identical to choice C and represents the same valid 9:00 A.M. daily configuration - it is listed as a duplicate distractor in this question.
Concept tested. PowerPivot per-data-source refresh scheduling alignment in SharePoint
Reference. https://learn.microsoft.com/en-us/previous-versions/sql/sql-server-2008-r2/ee210579(v=sql.105)
Community Discussion
No community discussion yet for this question.