Exam DA0-001 topic 1 question 168 discussion

Actual exam question from CompTIA's DA0-001

Question #: 168
Topic #: 1

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.

Show Suggested Answer

Suggested Answer: C 🗳️

by Swift_and_Quick at April 17, 2024, 10:23 p.m.

Comments

Submit Cancel

Swift_and_Quick

8 months, 1 week ago

C. Connect the input to a live connection within the data warehouse that refreshes daily. Connecting the input to a live connection within the data warehouse that refreshes daily would be the best approach for ensuring that the data is automatically refreshed at approximately the same time every day. This method allows for seamless automation, as the data refresh process can be scheduled within the data warehouse system itself. It eliminates the need for manual intervention and ensures that the reporting process is consistent and reliable.

upvoted 1 times

...