GCP-ADP Practice Test 2 — 25 Questions

Question 1

You are creating a Looker report with a 'measure' that calculates the total revenue. You notice it is summing correctly but the format is wrong. Where do you change the format?

Accepted Answer

In the LookML view file using 'value_format_name'.. The 'value_format_name' or 'value_format' parameter in the LookML view definition is where you control display formatting.

Answer

In the dashboard filter settings.

Answer

By editing the underlying SQL.

Answer

In the 'User' settings.

Question 2

Which TWO of the following statements about Dataplex discovery are true? (Choose two)

Accepted Answer

Discovery scans and infers schema from the data. Discovery is automatic for registered assets and generates metadata including schema.

Answer

Discovery must be manually triggered for every scan

Answer

Discovery works only for BigQuery tables

Answer

Discovery deletes duplicate files

Question 3

Which TWO of the following are valid ways to visualize BigQuery data within the Google Cloud ecosystem?

Accepted Answer

Looker Studio. Looker Studio and Looker are the primary visualization tools for BigQuery data.

Answer

Cloud Storage

Answer

Pub/Sub

Answer

Bigtable

Question 4

You have noticed that your data quality tasks are failing. Which THREE of the following are potential causes for failure? (Choose three)

Accepted Answer

The YAML rule configuration is malformed. Common failures include permission issues, invalid rule configurations, or missing execution environments.

Answer

The user has a slow internet connection

Answer

The data files were moved to another lake

Question 5

Which TWO of the following tools allow you to interact with Dataplex? (Choose two)

Accepted Answer

Google Cloud CLI (gcloud). Users interact with Dataplex via the Cloud Console and the Google Cloud CLI (gcloud).

Answer

A local database client like DBeaver

Answer

Text editor for configuration files

Answer

A standard SSH client

Question 6

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 7

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 8

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 9

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 10

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 11

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 12

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 13

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 14

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 15

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 16

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 17

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 18

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 19

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 20

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