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 A.M. every day.
C.
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.
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.
This question is repeated elsewhere. But here the question itself is different -source B update time says 3pm in the question. it should say 9am like it does else where, and then the correct answer (c) makes sense.
0
0