Exam Associate-Data-Practitioner Topic 1 Question 34 Discussion

Actual exam question for Google's Associate-Data-Practitioner exam
Question #: 34
Topic #: 1
Your team uses Google Sheets to track budget data that is updated daily. The team wants to compare budget data against actual cost data, which is stored in a BigQuery table. You need to create a solution that calculates the difference between each day's budget and actual costs. You want to ensure that your team has access to daily-updated results in Google Sheets. What should you do?

Suggested Answer: D Vote an answer

Comprehensive and Detailed in Depth Explanation:
Why D is correct:Creating a BigQuery external table directly from the Google Sheet allows for real-time updates.
Joining the external table with the actual cost table in BigQuery performs the calculation.
Connected Sheets allows the team to access and analyze the results directly in Google Sheets, with the data being updated.
Why other options are incorrect:A: Saving as a CSV file loses the live connection and daily updates.
B: Downloading and uploading as a CSV file adds unnecessary steps and loses the live connection.
C: Same issue as B, losing the live connection.

by Paula at Jul 09, 2025, 07:21 AM

Limited Time Offer

15%

Off

Get Premium Associate-Data-Practitioner Questions as Interactive Self Test Engine or PDF

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
Nick name: Submit Cancel
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
0
0
0
10