Exam Professional Data Engineer topic 1 question 221 discussion

Actual exam question from Google's Professional Data Engineer

Question #: 221
Topic #: 1

[All Professional Data Engineer Questions]

You store and analyze your relational data in BigQuery on Google Cloud with all data that resides in US regions. You also have a variety of object stores across Microsoft Azure and Amazon Web Services (AWS), also in US regions. You want to query all your data in BigQuery daily with as little movement of data as possible. What should you do?

A. Use BigQuery Data Transfer Service to load files from Azure and AWS into BigQuery.
B. Create a Dataflow pipeline to ingest files from Azure and AWS to BigQuery.
C. Load files from AWS and Azure to Cloud Storage with Cloud Shell gsutil rsync arguments.
D. Use the BigQuery Omni functionality and BigLake tables to query files in Azure and AWS.

Show Suggested Answer

Suggested Answer: D 🗳️

by e70ea9e at Dec. 30, 2023, 9:47 a.m.

Comments

Submit Cancel

raaad

Highly Voted 11 months, 2 weeks ago

Selected Answer: D

- BigQuery Omni allows us to analyze data stored across Google Cloud, AWS, and Azure directly from BigQuery without having to move or copy the data. - It extends BigQuery's data analysis capabilities to other clouds, enabling cross-cloud analytics.

upvoted 7 times

...

e70ea9e

Highly Voted 11 months, 2 weeks ago

Selected Answer: D

Direct Querying: BigQuery Omni allows you to query data in Azure and AWS object stores directly without physically moving it to BigQuery, reducing data transfer costs and delays. BigLake Tables: Provide a unified view of both BigQuery tables and external object storage files, enabling seamless querying across multi-cloud data.

upvoted 6 times

...