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.)
A.
Set the default schedule to refresh outside of business hours. Do not manually refresh the
workbook.
B.
Set the default schedule to refresh outside of business hours. Manually refresh the
workbook at 9:00 A.M. every day.
C.
Set the default schedule to refresh at 9:00 A.M. every day. Create a separate schedule for
Source B’s connection to refresh outside of business hours.
D.
Set the default schedule to refresh at 3:00 P.M. every day. Do not create individual source
schedules.
E.
Set the default schedule to refresh at 9:00 A.M. every day. Do not create individual source
schedules.