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…

Refreshing outside business hours misses Source A's 9:00 A.M. update window entirely, delaying fresh lookup data for most of the business day and directly violating the requirement to refresh as soon as possible.

This choice is identical to choice A - an outside-business-hours schedule still fails to capture Source A's 9:00 A.M. lookup update in a timely manner.

Setting the default refresh to 9:00 A.M. daily directly aligns with Source A's 9:00 A.M. update time, meaning the lookup tables are refreshed immediately after new data becomes available with no user involvement. A 9 AM schedule precedes peak business activity, minimizing concurrent load on both source systems and the SharePoint environment throughout the workday. This timing satisfies all three requirements simultaneously - timeliness, reduced load, and automation.

A 3:00 P.M. schedule occurs during peak business hours and lags Source A's 9:00 A.M. update by six hours, adding unnecessary load mid-day and delaying the availability of refreshed lookup data.

This choice is identical to choice C and represents the same valid 9:00 A.M. daily configuration - it is listed as a duplicate distractor in this question.