70-470 Latest Exam Braindumps
Question 6: 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.
Correct Answer: C
