CompTIA Data+ (DA0-001) — Question 159

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 of the following would be the BEST step for the team to take to get the data connected and refreshed on a daily automated schedule?

Answer options

• A. Connect the input to a CSV file that can be replaced daily.
• B. Connect the input to an extract that can be replaced daily by a member of the team.
• C. Connect the input to a live connection within the data warehouse that refreshes daily.
• D. Connect the input to a Microsoft Excel macro that is updated daily on schedule and then fed into the connection.

Correct answer: C

Explanation

The best option is C because a live connection to the data warehouse ensures that data is continuously updated and available in real-time, which meets the requirement for daily automation. Options A and B rely on manual updates, which can lead to inconsistencies and delays. Option D, while automated, still depends on a macro and could introduce errors or require oversight.