Google Professional Data Engineer
Get started today
Ultimate access to all questions.
Comments
Loading comments...
Ultimate access to all questions.
Your organization has implemented a multi-cloud data storage strategy that involves storing data in Google Cloud Storage and AWS S3 storage buckets, all within US regions. The goal is to enable querying of the most current data using BigQuery, irrespective of the cloud where the data is stored. Additionally, users should be able to query the tables in BigQuery without having direct access to the underlying storage buckets. What actions should you take to achieve this?
A
Setup a BigQuery Omni connection to the AWS S3 bucket data. Create BigLake tables over the Cloud Storage and S3 data and query the data using BigQuery directly.
B
Set up a BigQuery Omni connection to the AWS S3 bucket data. Create external tables over the Cloud Storage and S3 data and query the data using BigQuery directly.
C
Use the Storage Transfer Service to copy data from the AWS S3 buckets to Cloud Storage buckets. Create BigLake tables over the Cloud Storage data and query the data using BigQuery directly.
D
Use the Storage Transfer Service to copy data from the AWS S3 buckets to Cloud Storage buckets. Create external tables over the Cloud Storage data and query the data using BigQuery directly.