ExamTopics Logo
Mail Us[email protected]
Menu
Google Discussions
exam questions

Exam Professional Data Engineer All Questions

View all questions & answers for the Professional Data Engineer exam
Go to Exam

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 Hide Answer
Suggested Answer: D 🗳️
by e70ea9e at Dec. 30, 2023, 9:47 a.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
raaad
Highly Voted 10 months 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 10 months 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
...
josech
Most Recent 5 months, 1 week ago
https://cloud.google.com/blog/products/data-analytics/introducing-bigquery-omni https://cloud.google.com/bigquery/docs/omni-introduction
upvoted 2 times
...
Ramon98
8 months, 1 week ago
Option A, B, and C all involve moving data, which is described as something that shouldn't happen.
upvoted 2 times
...
JyoGCP
8 months, 2 weeks ago
Selected Answer: D
BigQuery Omni
upvoted 2 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago