Practice Test 4 | Google Cloud Certified Professional Data Engineer | Dumps | Mock Test

Correct Answer: E

• Option E is CORRECT because these all are the possible ways to load data into BigQuery. Lets understand these one by one –

1. Batch Ingestion – This involves ingesting large, bounded datasets that don’t have to be processed in real-time.

To implement batch ingestion, one can use Google Cloud Storage, Cloud Dataflow, Cloud Dataproc, Cloud Data Fusion etc.

1. Stream Ingestion  – This involves ingesting large, unbounded data that is processed in real-time.

         To implement Stream Ingestion, one can use Apache Kafka to BQ connector, Cloud Pub/Sub, Cloud Dataflow, Cloud Dataproc etc.

1. Data Transfer Service (DTS) – This is a fully managed service to load data from external cloud storage providers such as Amazon S3, Google SaaS applications such as Google Ads, and transferring data from data warehouse technologies such as Teradata etc.
2. Partner Integrations – These are the data integration alternatives from Google Cloud Partners.

This includes, Confluent, Informatica, snapLogic, Talend and many more.

1. Query Materialization – This is the best way to simplify extract, transform and load patterns in BigQuery. Using federated queries in BigQuery, one can persist their analysis results in Big Query to derive any insights.

Please find the image attached below having details about all the possible ways to ingest data into BigQuery.

For more information on the Big Query, please visit the below URL:

• https://cloud.google.com/blog/topics/developers-practitioners/bigquery-explained-data-ingestion