Which architectural characteristic is most indicative of a flexible data processing system?

The use of a single vendor's proprietary APIs throughout the system

The use of a fixed schema that cannot be changed

The ability to process data only in batch mode

The ability to swap out a data source or processing engine with minimal impact on other components

A retail company is building a data pipeline to ingest sales data from multiple stores. They expect the number of stores to grow significantly over the next year, and they want to avoid rearchitecting the pipeline as data volumes increase. They also need to stage raw data before processing to handle late-arriving data. Which design best meets these needs?

Use a single large VM running a custom ingestion script that writes to Cloud SQL.

Use Cloud Storage for ingestion, then run batch jobs on Dataproc to process data directly from storage.

Use Cloud Functions to ingest data directly into BigQuery, with no staging area.

Use Cloud Pub/Sub for ingestion, Cloud Storage as a staging area, and Dataflow for processing, with autoscaling enabled.

Which information is typically included in a data catalog entry?

The physical location of the data and its lineage

The list of all users who have ever accessed the data

The exact query results from the data

A multinational corporation wants to run data analytics on Google Cloud but also wants to keep the option to move to another cloud provider. They have strict data residency requirements that vary by country. They plan to use BigQuery for analytics. What is the best way to ensure portability while meeting residency?

Use Cloud Storage only and avoid any processing in the cloud.

Store data in open formats like Parquet in Cloud Storage, and use portable processing frameworks like Apache Spark.

Use BigQuery as the primary storage and processing engine, and export data to Parquet periodically.

Use BigQuery Omni to query data in other clouds, avoiding data movement.

A logistics company is integrating data from multiple suppliers. They suspect some suppliers send data with inconsistent formats and missing values. Before loading into their data warehouse, they want to understand the structure and quality of the incoming data. What should they do?

Create a data catalog entry for each supplier's data.

Run data profiling on the incoming data to assess completeness, uniqueness, and data types.

Use Dataflow to transform all data into a common schema without prior analysis.

Load the data directly into BigQuery and rely on schema auto-detection.

Google CloudProfessional Data Engineer

Domain 1Objective 3

1.3 Designing for Flexibility and Portability PROFESSIONAL-DATA-ENGINEER Practice Questions (Page 4)

Part of the Designing data processing systems domain, which accounts for ~22% of the PROFESSIONAL-DATA-ENGINEER exam. Google Cloud does not publish an official question count, but from its 120-minute exam (~50–80 total, ~11–18 in this domain), expect 3–5 from this objective — we provide 30 practice questions to prepare you well beyond it. (estimate)

30questions here

6free pages

8concepts

~22%of the exam

Questions 16–20

16foundation · easy
Which architectural characteristic is most indicative of a flexible data processing system?
Select an answer first
17application · medium
A retail company is building a data pipeline to ingest sales data from multiple stores. They expect the number of stores to grow significantly over the next year, and they want to avoid rearchitecting the pipeline as data volumes increase. They also need to stage raw data before processing to handle late-arriving data. Which design best meets these needs?
Select an answer first
18foundation · easy
Which information is typically included in a data catalog entry?
Select an answer first
19expert · hard
A multinational corporation wants to run data analytics on Google Cloud but also wants to keep the option to move to another cloud provider. They have strict data residency requirements that vary by country. They plan to use BigQuery for analytics. What is the best way to ensure portability while meeting residency?
Select an answer first
20application · medium
A logistics company is integrating data from multiple suppliers. They suspect some suppliers send data with inconsistent formats and missing values. Before loading into their data warehouse, they want to understand the structure and quality of the incoming data. What should they do?
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.

1.3 Designing for Flexibility and Portability PROFESSIONAL-DATA-ENGINEER Practice Questions (Page 4)

Questions 16–20

Which architectural characteristic is most indicative of a flexible data processing system?

Which information is typically included in a data catalog entry?

A logistics company is integrating data from multiple suppliers. They suspect some suppliers send data with inconsistent formats and missing values. Before loading into their data warehouse, they want to understand the structure and quality of the incoming data. What should they do?

Keep studying — Designing data processing systems