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…

Refreshing outside business hours delays availability of Source B's 3:00 P.M. lookup data until late night or early morning, significantly postponing access to updated lookup data and failing the requirement to refresh as soon as possible.

This choice is identical to choice A - scheduling outside business hours still fails to make Source B's 3:00 P.M. lookup updates available in a timely manner at the start of the business day.

Setting the default refresh to 9:00 A.M. daily ensures the workbook is automatically updated at the start of each business day, capturing Source B's prior-day 3:00 P.M. lookup update as soon as the business day begins without any user involvement. Scheduling at 9 AM is before peak business activity, which minimizes concurrent load on both Source A's large 20-million-row dataset processing and the SharePoint environment. This provides the best balance between data freshness and resource impact compared to the other available options.

Scheduling at 3:00 P.M. occurs during peak business hours when processing the 20-million-row Source A dataset alongside Source B would violate the requirement to minimize load on source systems and SharePoint during business hours.

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.