GCP-ADP Timed Practice Test 2 — 10 Questions

Question 1

Which console menu would you navigate to in order to access Dataplex?

Accepted Answer

Analytics. Dataplex is found under the 'Analytics' section in the Google Cloud console.

Answer

Compute Engine

Answer

Operations

Answer

Storage

Question 2

Which component of Cloud Composer acts as the primary interface for managing and triggering DAGs manually?

Accepted Answer

Airflow Web Interface. The Airflow Web Interface is the primary UI for managing DAGs and viewing execution history.

Answer

Cloud Storage Browser

Answer

Cloud Shell

Answer

BigQuery Console

Question 3

You need to set up an alert when a GCS bucket exceeds a certain size. Which tool do you use?

Accepted Answer

Cloud Monitoring. Cloud Monitoring allows you to set up alerts based on GCS bucket metrics like byte count.

Answer

Cloud Build

Answer

IAM

Answer

Cloud Logging

Question 4

You are using Dataflow to read from Pub/Sub. The pipeline is failing due to malformed messages. How can you handle these without crashing?

Accepted Answer

Use a Dead Letter Queue (DLQ). Using a Dead Letter Queue (DLQ) pattern allows you to route unprocessable messages to a separate destination for inspection.

Answer

Ignore errors

Answer

Increase memory

Answer

Restart the pipeline

Question 5

You want to automate the export of a BigQuery table to Cloud Storage on a daily basis. What should you use?

Accepted Answer

BigQuery Data Transfer Service.. BigQuery Data Transfer Service allows for scheduled exports and imports.

Answer

Cloud Monitoring alerts.

Answer

Looker studio refresh.

Answer

A manual SQL query.

Question 6

You need to run a task in Cloud Composer only if the previous task failed. Which Trigger Rule should you use?

Accepted Answer

one_failed. The 'one_failed' trigger rule allows a task to execute if at least one parent task has failed.

Answer

none_failed

Answer

always

Answer

all_success

Question 7

A user is running a query on a BigQuery table with nested data (JSON). How do you access a field named 'city' inside a record field named 'address'?

Accepted Answer

address.city. Standard SQL uses the dot notation (dot-walk) to access fields within a STRUCT.

Answer

address->city

Answer

address[city]

Answer

JSON_EXTRACT(address, '$.city')

Question 8

When setting up a Dataplex Lake, you chose the 'Multi-region' location type. What is the implication of this choice?

Accepted Answer

It improves data availability and durability. Multi-region deployment increases availability and ensures data is replicated across multiple regions within the same geography.

Answer

It restricts access to users in a single region

Answer

It prevents the use of BigQuery datasets

Answer

It reduces the cost of storing data

Question 9

You have a Looker dashboard that loads slowly. What is the first thing you should check in the 'Looker System Activity' or 'Query History'?

Accepted Answer

Check the Query History to see execution time and SQL complexity.. Checking the query history helps identify if the underlying database is slow or if the Looker model is generating inefficient SQL.

Answer

Restart the Looker instance.

Answer

Delete all existing users.

Answer

Change the Looker instance color theme.

Question 10

A team is migrating to Dataplex. Which TWO of the following are prerequisites for adding a BigQuery dataset as an asset to a Lake? (Choose two)

Accepted Answer

The user needs BigQuery permissions on the dataset. The user needs proper IAM permissions on the project and the dataset to register it as an asset.

Answer

The dataset must be public

Answer

The dataset must exist in the same project as the Lake

Answer

The dataset must contain at least one table