A company needs to import data from a legacy on-premises Oracle database into BigQuery on a daily basis. The database is accessible over VPN. They want a fully managed solution that requires minimal coding. What should they use?

A Dataflow pipeline using the JDBC IO connector to read from Oracle and write to BigQuery.

A Dataproc cluster running Sqoop to import data from Oracle to BigQuery.

BigQuery Data Transfer Service for Oracle.

Cloud Data Fusion with a JDBC connector to read from Oracle and write to BigQuery.

A gaming company wants to process player activity events in real time to update leaderboards. Events are generated by millions of devices. They need a scalable ingestion service that can handle bursts and decouple producers from consumers. What should they use for ingestion?

Apache Kafka on Compute Engine for ingestion, with a Spark Streaming job for processing.

Pub/Sub for ingesting events, with a Dataflow pipeline consuming from Pub/Sub for processing.

Cloud Storage for ingesting events, with a Cloud Function to process each file.

BigQuery for direct streaming inserts from devices.

Google CloudProfessional Data Engineer

Domain 2Objective 2

2.2 Building the Pipelines PROFESSIONAL-DATA-ENGINEER Practice Questions (Page 5)

Part of the Ingesting and processing the data domain, which accounts for ~25% of the PROFESSIONAL-DATA-ENGINEER exam. Google Cloud does not publish an official question count, but from its 120-minute exam (~50–80 total, ~13–20 in this domain), expect 4–7 from this objective — we provide 38 practice questions to prepare you well beyond it. (estimate)

38questions here

8free pages

10concepts

~25%of the exam

Questions 21–25

21foundation · easy
Which component of the Hadoop ecosystem is commonly used with Dataproc to provide a SQL-like interface for querying data stored in HDFS?
Select an answer first
22application · medium
A company needs to import data from a legacy on-premises Oracle database into BigQuery on a daily basis. The database is accessible over VPN. They want a fully managed solution that requires minimal coding. What should they use?
Select an answer first
23foundation · easy
A dataset has a column with missing values. Which data cleansing technique is specifically used to replace missing values with a calculated estimate?
Select an answer first
24foundation · easy
Which open-source framework is designed for large-scale data processing using in-memory computing and provides APIs for batch and streaming?
Select an answer first
25application · medium
A gaming company wants to process player activity events in real time to update leaderboards. Events are generated by millions of devices. They need a scalable ingestion service that can handle bursts and decouple producers from consumers. What should they use for ingestion?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back to PROFESSIONAL-DATA-ENGINEER

Free Basic Practice is a study aid with revealable answers — not a scored exam. Examers.io is independent and not affiliated with or endorsed by Google Cloud. “PROFESSIONAL-DATA-ENGINEER” is a trademark of its owner, used for identification only.

2.2 Building the Pipelines PROFESSIONAL-DATA-ENGINEER Practice Questions (Page 5)

Questions 21–25

Which component of the Hadoop ecosystem is commonly used with Dataproc to provide a SQL-like interface for querying data stored in HDFS?

A company needs to import data from a legacy on-premises Oracle database into BigQuery on a daily basis. The database is accessible over VPN. They want a fully managed solution that requires minimal coding. What should they use?

A dataset has a column with missing values. Which data cleansing technique is specifically used to replace missing values with a calculated estimate?

Which open-source framework is designed for large-scale data processing using in-memory computing and provides APIs for batch and streaming?

A gaming company wants to process player activity events in real time to update leaderboards. Events are generated by millions of devices. They need a scalable ingestion service that can handle bursts and decouple producers from consumers. What should they use for ingestion?

Keep studying — Ingesting and processing the data