A team is planning to automate daily reporting for a company. Prior to this rollout, the team wants to determine how to ensure the data is refreshed at approximately the same time every day. Which…

Connecting to a CSV file that is replaced daily would require manual intervention or a separate automation process to replace the file, which is less reliable and scalable than a data warehouse.

Connecting to an extract that can be replaced daily by a team member is a manual process and does not meet the requirement for automated daily refreshing.

Connecting the input to a live connection within a data warehouse that refreshes daily is the best solution because data warehouses are designed for reliable, scalable data storage and often have built-in scheduling for automated data refreshes, ensuring consistency for daily reporting.

Connecting to a Microsoft Excel macro that is updated daily is generally not a scalable or robust solution for enterprise-level automated reporting due to potential reliability issues and dependence on local environments.