GCP-ADP Practice Test 4 — 10 Questions

Question 1

Which THREE factors should you consider when choosing a partitioning strategy for a BigQuery table?

Accepted Answer

The query frequency for specific date ranges. Partitioning should be based on common filters, data size, and the query lifecycle.

Answer

The database name

Answer

The table color in the console

Question 2

In LookML, which parameter is used to define how a table should join to another?

Accepted Answer

relationship. The 'relationship' parameter is essential for Looker to join tables correctly without errors.

Answer

join_type

Answer

dimension_group

Answer

foreign_key

Question 3

A Cloud Composer DAG is failing because the Airflow database is locking up during high-concurrency periods. What is the most effective way to address this?

Accepted Answer

Scale up the Cloud Composer environment size to increase database resources.. Scaling the Composer environment or adjusting the database performance settings (or Airflow configuration) is the recommended path to resolve lock contention.

Answer

Delete all past DAG run logs.

Answer

Increase the number of DAGs in the repository.

Answer

Set the 'parallelism' parameter to a very high value.

Question 4

Which THREE of the following are common steps in a typical data pipeline orchestration pattern?

Accepted Answer

Validation. Common steps include data ingestion, transformation, and validation/export.

Answer

Network cable installation

Answer

Hardware provisioning

Question 5

You need to ingest data from an external API that requires an OAuth token. Which tool is best for executing this periodically?

Accepted Answer

Cloud Functions. Cloud Functions triggered by Cloud Scheduler can handle API requests with custom authentication logic.

Answer

Pub/Sub

Answer

BigQuery Data Transfer Service

Answer

Storage Transfer Service

Question 6

You are troubleshooting a Dataflow job that is running slower than expected when writing data to BigQuery. You suspect the issue is related to hot keys. What is the recommended strategy to mitigate this?

Accepted Answer

Add a random salt to the key before the shuffle operation. Keyed distribution issues can be solved by adding a random salt to keys to ensure better distribution across workers.

Answer

Change the Dataflow runner to a different region

Answer

Increase the number of worker machines

Answer

Use Cloud Storage as an intermediate sink

Question 7

What is the role of the 'Dataplex Data Steward'?

Accepted Answer

To manage metadata, quality rules, and compliance. The Data Steward is responsible for defining metadata, managing quality rules, and ensuring data policies are met.

Answer

To write SQL queries for the business

Answer

To develop ETL pipelines

Answer

To manage the underlying infrastructure

Question 8

Which TWO of the following are true about the relationship between Data Catalog and Dataplex? (Choose two)

Accepted Answer

Dataplex uses Data Catalog to store metadata. Dataplex integrates Data Catalog capabilities; they are tightly coupled.

Answer

You must pay for them separately

Answer

They have separate IAM systems

Answer

They are completely separate products

Question 9

Which TWO actions can help reduce the time it takes to build a Jupyter notebook in Vertex AI Workbench?

Accepted Answer

Scaling up the machine type for the instance. Optimizing compute and pre-installing environments can speed up development.

Answer

Change the project name

Answer

Disable the persistent disk

Answer

Using a single-core machine

Question 10

You have a large table in BigQuery that is updated constantly. You need to perform a query that is consistent. What should you use?

Accepted Answer

Time travel / Table snapshots.. Table snapshots allow you to query a consistent version of a table from a specific point in time.

Answer

A stored procedure.

Answer

An external table.

Answer

A materialized view.