A company stores raw data in Cloud Storage and wants to use BigQuery for analytics. The data is append-only and the team wants to minimize query costs for large scans. What is the most effective way to reduce query costs?

Load all data into a single BigQuery table without partitioning.

Use BigQuery BI Engine to accelerate queries.

Partition the BigQuery table by date and use clustering on frequently filtered columns.

Use external tables to avoid BigQuery storage costs.

A large organization wants to let each business unit manage its own data assets while ensuring that all data meets company-wide security and compliance standards. Which governance model best supports this requirement?

Decentralized governance without standards

A global bank is implementing a federated governance model. Each country's data team owns its data in separate projects. Central compliance requires that all data be tagged with a `data_classification` tag, and that access to `confidential` data be restricted to a central group. However, each country team must be able to grant access to their own data for local analysts. What is the most effective way to enforce this?

Create a central Dataplex lake with zones for each country, apply the tag template centrally, and delegate zone-level IAM to country teams.

Use BigQuery column-level security with policy tags in each project.

Create a Dataplex lake in each country project and apply the tag template and IAM policy in each lake.

Use Organization Policy to enforce the tag and IAM on all projects.

A data platform team needs to provide a complete audit trail of data changes for regulatory compliance. The data flows from Cloud Storage through Dataflow into BigQuery. The team must be able to answer: 'Which pipeline version produced this specific row in BigQuery?' What is the most reliable way to capture this?

Use Cloud Data Fusion to track the pipeline version.

Add a `pipeline_version` column to the BigQuery table and populate it in the Dataflow job.

Use BigQuery audit logs to find the job that loaded the data.

Enable Dataplex lineage and rely on the automatically captured pipeline version.

A media company stores raw video metadata in Cloud Storage and wants to run interactive SQL queries on it without loading the data into BigQuery. The data is rarely updated, and the team wants to minimize storage costs. What is the most cost-effective approach?

Copy the data to a different Cloud Storage bucket with a colder storage class.

Use Dataplex to create a data lake and query it with Spark on Dataproc.

Create a BigQuery external table that references the Cloud Storage files.

Load the data into a BigQuery table and set a table expiration.

Google CloudProfessional Data Engineer

Domain 3Objective 4

3.4 Designing for a Data Platform PROFESSIONAL-DATA-ENGINEER Practice Questions (Page 2)

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

23questions here

5free pages

6concepts

~20%of the exam

Questions 6–10

6application · medium
A company stores raw data in Cloud Storage and wants to use BigQuery for analytics. The data is append-only and the team wants to minimize query costs for large scans. What is the most effective way to reduce query costs?
Select an answer first
7foundation · easy
A large organization wants to let each business unit manage its own data assets while ensuring that all data meets company-wide security and compliance standards. Which governance model best supports this requirement?
Select an answer first
8expert · hard
A global bank is implementing a federated governance model. Each country's data team owns its data in separate projects. Central compliance requires that all data be tagged with a `data_classification` tag, and that access to `confidential` data be restricted to a central group. However, each country team must be able to grant access to their own data for local analysts. What is the most effective way to enforce this?
Select an answer first
9expert · hard
A data platform team needs to provide a complete audit trail of data changes for regulatory compliance. The data flows from Cloud Storage through Dataflow into BigQuery. The team must be able to answer: 'Which pipeline version produced this specific row in BigQuery?' What is the most reliable way to capture this?
Select an answer first
10application · medium
A media company stores raw video metadata in Cloud Storage and wants to run interactive SQL queries on it without loading the data into BigQuery. The data is rarely updated, and the team wants to minimize storage costs. What is the most cost-effective approach?
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.

3.4 Designing for a Data Platform PROFESSIONAL-DATA-ENGINEER Practice Questions (Page 2)

Questions 6–10

A company stores raw data in Cloud Storage and wants to use BigQuery for analytics. The data is append-only and the team wants to minimize query costs for large scans. What is the most effective way to reduce query costs?

A large organization wants to let each business unit manage its own data assets while ensuring that all data meets company-wide security and compliance standards. Which governance model best supports this requirement?

A media company stores raw video metadata in Cloud Storage and wants to run interactive SQL queries on it without loading the data into BigQuery. The data is rarely updated, and the team wants to minimize storage costs. What is the most cost-effective approach?

Keep studying — Storing the data