
Ultimate access to all questions.
You are managing a complex data ecosystem where your primary relational data is stored and analyzed using Google Cloud's BigQuery, with all stored data contained within the US regions. Additionally, you utilize a range of object stores spread across Microsoft Azure and Amazon Web Services (AWS), also located within the US regions. Your requirement is to query all this data within BigQuery on a daily basis, while minimizing the movement of data across these platforms. What approach should you take to achieve this?
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.