ExamGecko
Question list
Search
Search

List of questions

Search

Related questions











Question 146 - Associate Cloud Engineer discussion

Report
Export

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?

A.
Create a dataflow job that copies data from Cloud Bigtable and Cloud Storage for specific users.
Answers
A.
Create a dataflow job that copies data from Cloud Bigtable and Cloud Storage for specific users.
B.
Create a dataflow job that copies data from Cloud Bigtable and Cloud Spanner for specific users.
Answers
B.
Create a dataflow job that copies data from Cloud Bigtable and Cloud Spanner for specific users.
C.
Create a Cloud Dataproc cluster that runs a Spark job to extract data from Cloud Bigtable and Cloud Storage for specific users.
Answers
C.
Create a Cloud Dataproc cluster that runs a Spark job to extract data from Cloud Bigtable and Cloud Storage for specific users.
D.
Create two separate BigQuery external tables on Cloud Storage and Cloud Bigtable. Use the BigQuery console to join these tables through user fields, and apply appropriate filters.
Answers
D.
Create two separate BigQuery external tables on Cloud Storage and Cloud Bigtable. Use the BigQuery console to join these tables through user fields, and apply appropriate filters.
Suggested answer: D

Explanation:

'The Cloud Spanner to Cloud Storage Text template is a batch pipeline that reads in data from a Cloud Spanner table, optionally transforms the data via a JavaScript User Defined Function (UDF) that you provide, and writes it to Cloud Storage as CSV text files.'

https://cloud.google.com/dataflow/docs/guides/templates/provided-batch#cloudspannertogcstext

'The Dataflow connector for Cloud Spanner lets you read data from and write data to Cloud Spanner in a Dataflow pipeline'

https://cloud.google.com/spanner/docs/dataflow-connector

https://cloud.google.com/bigquery/external-data-sources

asked 18/09/2024
gdgd gdgd
25 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first