Learn the best step to connect data and automate daily refresh for accurate and timely reporting.
Table of Contents
Question
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?
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.
Answer
C. Connect the input to a live connection within the data warehouse that refreshes daily.
Explanation
This option provides the most reliable and automated way to ensure that the data is refreshed at approximately the same time every day. The data warehouse is a central repository for data, and it is typically refreshed on a regular schedule. By connecting the input to a live connection within the data warehouse, the team can ensure that the data is always up-to-date and that the reports are generated with the most recent data.
CompTIA DA0-001 certification exam practice question and answer (Q&A) dump with detail explanation and reference available free, helpful to pass the CompTIA DA0-001 exam and earn CompTIA DA0-001 certification.