web analytics

What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)

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