GCP-ADP Practice Test 5 — 10 Questions

Question 1

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 2

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 3

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 4

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 5

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 6

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 7

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 8

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 9

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 10

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.