Google
ASSOCIATE-CLOUD-ENGINEER · Question #191
You have an application that uses Cloud Spanner as a database backend to keep current state information about users. Cloud Bigtable logs all events triggered by users. You export Cloud Spanner data…
The correct answer is D. Create two separate BigQuery external tables on Cloud Storage and Cloud Bigtable. https://cloud.google.com/bigquery/external-data-sources
Submitted by kevin_r· Mar 30, 2026Planning and configuring a cloud solution
Question
You have an application that uses Cloud Spanner as a database backend to keep current state information about users. Cloud Bigtable logs all events triggered by users. You export Cloud Spanner data to Cloud Storage during daily backups. One of your analysts asks you to join data from Cloud Spanner and Cloud Bigtable for specific users. You want to complete this ad hoc request as efficiently as possible. What should you do?
Options
- ACreate a dataflow job that copies data from Cloud Bigtable and Cloud Storage for specific users.
- BCreate a dataflow job that copies data from Cloud Bigtable and Cloud Spanner for specific users.
- CCreate a Cloud Dataproc cluster that runs a Spark job to extract data from Cloud Bigtable and
- DCreate two separate BigQuery external tables on Cloud Storage and Cloud Bigtable.
How the community answered
(35 responses)- A11% (4)
- B9% (3)
- C26% (9)
- D54% (19)
Explanation
Topics
#BigQuery external tables#Cloud Bigtable#data federation#ad hoc queries
Community Discussion
No community discussion yet for this question.