GCP-ADP Practice Test 2 — 30 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.

Question 11

Which TWO of the following are best practices for managing Cloud Composer DAG dependencies?

Accepted Answer

Use plugins for shared code. Best practices include keeping DAGs small and using modular code for shared tasks.

Answer

Store DAGs in a database

Answer

Hardcode all configurations

Answer

Run all tasks in a single DAG file

Question 12

Which THREE of these are valid ways to monitor or analyze BigQuery performance?

Accepted Answer

Query Plan explanation. Performance analysis is done via metadata views, query plans, and monitoring dashboards.

Answer

Editing the table schema

Answer

Changing the project billing currency

Question 13

When creating a dashboard in Looker Studio, which connector type allows you to connect to an arbitrary SQL query?

Accepted Answer

Custom query.. The 'Custom Query' option in the BigQuery connector allows users to enter raw SQL.

Answer

Direct table link.

Answer

LookML model connector.

Answer

Spreadsheet connector.

Question 14

Your organization uses Workflows to orchestrate multi-step API calls. You need to handle transient failures in a specific HTTP request by retrying it up to 5 times with exponential backoff. Which block should you use?

Accepted Answer

A 'try' block with a 'retry' policy.. The 'try/retry' block in Workflows syntax allows for configuring custom backoff and max attempts for specific steps.

Answer

A 'loop' block with a counter increment.

Answer

An 'if' statement checking for 500 status codes.

Answer

A global 'exception' handler at the end of the workflow.

Question 15

You want to perform data quality checks on a BigQuery table that is updated daily. How should you schedule the Dataplex task?

Accepted Answer

Configure a CRON schedule on the task. Dataplex tasks can be triggered on a schedule using cron syntax, allowing for daily alignment with data updates.

Answer

Manually trigger via the UI

Answer

Wait for discovery to trigger it

Answer

Use Cloud Run to trigger the task

Question 16

Which of the following describes the purpose of 'BigQuery ML'?

Accepted Answer

To run machine learning models using SQL.. BQML allows users to build and run machine learning models using standard SQL within BigQuery.

Answer

To create dashboard charts.

Answer

To compress table data.

Answer

To manage IAM permissions.

Question 17

Which THREE of the following are components of a Workflows definition?

Accepted Answer

main. Workflows consist of steps, main entry points, and can include variable assignments.

Answer

dag_schedule

Answer

worker_config

Question 18

You need to anonymize PII (Personally Identifiable Information) before loading data into BigQuery. Which tool is best?

Accepted Answer

Cloud DLP. Cloud Data Loss Prevention (DLP) API provides automated de-identification and masking.

Answer

Dataflow

Answer

BigQuery

Answer

Cloud Storage

Question 19

You notice your Looker dashboard is showing duplicate data. What is the most likely cause?

Accepted Answer

Fan-out due to a join without correctly defined primary keys.. Fan-outs occur when joining a one-to-many relationship without correctly defining the primary key or using the correct aggregate type.

Answer

The data is cached in the browser.

Answer

The user is logged in twice.

Answer

The BigQuery table is corrupted.

Question 20

In a Cloud Composer DAG, you need to trigger a BigQuery job that runs as a service account other than the one assigned to the GKE nodes. How should you implement this?

Accepted Answer

Use the 'impersonation_chain' parameter in the BigQueryInsertJobOperator.. Using the 'impersonation_chain' parameter in the BigQueryInsertJobOperator allows the service account running the task to impersonate a different service account.

Answer

Hardcode the credentials in a JSON file inside the DAG folder.

Answer

Change the worker node's identity in the Cloud Console.

Answer

Configure a connection with the 'Service Account Key' type in Airflow UI.