Microsoft
70-467 · Question #159
70-467 Question #159: Real Exam Question with Answer & Explanation
Sign in or unlock 70-467 to reveal the answer and full explanation for question #159. The question stem and answer options stay visible for context.
Design a reporting solution
Question
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.)
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.
Unlock 70-467 to see the answer
You've previewed enough free 70-467 questions. Unlock 70-467 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#PowerPivot data refresh#SharePoint#schedule optimization#source load minimization