New Year Sale 2026! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

Google Associate Data Practitioner Exam - Topic 4 Question 20 Discussion

Actual exam question for Google's Associate Data Practitioner exam
Question #: 20
Topic #: 4
[All Associate Data Practitioner Questions]

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?

Show Suggested Answer Hide Answer
Suggested Answer: D

Comprehensive and Detailed in Depth

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.


BigQuery External Tables: https://cloud.google.com/bigquery/docs/external-tables

Connected Sheets: https://support.google.com/sheets/answer/9054368?hl=en

by Kerry at Jan 05, 2026, 05:16 AM

Limited Time Offer

25%

Off

Get Premium Associate Data Practitioner Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

0/2000 characters
Submit Cancel
Nettie
3 days ago
Haha, option C reminds me of the good old days of manual data wrangling.
upvoted 0 times
...
Joye
8 days ago
Option B looks good, but I'm not a fan of the extra steps involved.
upvoted 0 times
...
Lindsey
13 days ago
I like how option D leverages the power of BigQuery and Connected Sheets.
upvoted 0 times
...
Glenn
19 days ago
Option D seems the most straightforward solution.
upvoted 0 times
...
Rex
24 days ago
I think option D might be the right choice since it mentions using the Drive URI, but I'm not completely confident about the details.
upvoted 0 times
...
Chana
29 days ago
I feel like we practiced something similar where we joined tables in BigQuery, but I can't remember if we used external tables or not.
upvoted 0 times
...
Lorean
1 month ago
I think option B sounds familiar, but I can't recall if uploading to Cloud Storage is necessary.
upvoted 0 times
...
Stephane
1 month ago
I remember we discussed using Connected Sheets for real-time data access, but I'm not sure if that's the best option here.
upvoted 0 times
...
King
1 month ago
I think I'd lean towards option D as well. Creating the external table in BigQuery sounds like the most efficient way to keep the data synced up without a lot of manual work. Plus, using Connected Sheets means we don't have to worry about downloading and uploading files. Seems like the cleanest solution overall.
upvoted 0 times
...
Melda
2 months ago
Option B seems like the easiest approach to me. Downloading the budget data as a CSV, uploading it to Cloud Storage, and then creating a BigQuery table from that. Then I can just use Connected Sheets to pull the data directly into the Google Sheet. Seems pretty straightforward and low-risk.
upvoted 0 times
...
Vinnie
2 months ago
Hmm, I'm a little unsure about this one. I'm not super familiar with BigQuery and external tables. Do we have to set up any special permissions or configurations to make that work? I'm worried it might be a bit more complicated than the other options.
upvoted 0 times
...
Esteban
2 months ago
This looks like a pretty straightforward data integration problem. I'd probably go with option D - creating a BigQuery external table from the Google Sheet and joining it with the actual cost data. That way, the data stays up-to-date in the sheet without having to manually download and upload files.
upvoted 0 times
...

Save Cancel