GCP-ADP Practice Test 15 — 15 Questions

Question 1

You need to ensure that PII (Personally Identifiable Information) in BigQuery is automatically detected and tagged across your organization. Which Dataplex feature should you enable on your Lake?

Accepted Answer

Automatic data discovery. Dataplex discovery scans data assets and can automatically apply labels and tags based on system-defined taxonomies.

Answer

Data quality task

Answer

Lifecycle management policy

Answer

IAM policy inheritance

Question 2

You are identifying trends in a large dataset using BigQuery. Which SQL function is best suited to identify the top 5 products sold per region?

Accepted Answer

RANK() OVER (PARTITION BY region ORDER BY sales DESC).. Window functions, specifically RANK() or DENSE_RANK() combined with PARTITION BY, are designed for this exact use case.

Answer

GROUP BY region, product.

Answer

SELECT TOP 5 * FROM sales.

Answer

SUM(sales) OVER (ORDER BY region).

Question 3

You are troubleshooting a stuck task in Cloud Composer. You want to see the stdout/stderr logs for that specific task attempt. Where can you find them?

Accepted Answer

In the 'logs/' folder in the environment's GCS bucket.. Airflow task logs are stored in the GCS bucket associated with the environment, organized by DAG and task name.

Answer

In the Airflow metadata database directly.

Answer

In the Cloud Composer environment console logs.

Answer

Via the 'kubectl' logs command on the worker pod.

Question 4

You are migrating a legacy Airflow environment to Cloud Composer. You need to ensure that local Python packages used by custom operators are installed correctly. What is the recommended approach?

Accepted Answer

Upload the requirements.txt file to the environment bucket.. Define custom Python dependencies in the 'requirements.txt' file in the environment's bucket for Composer to install.

Answer

Create a custom Docker image for the Airflow environment.

Answer

Manually SSH into worker nodes and run 'pip install'.

Answer

Pre-install packages in the DAG file using 'os.system'.

Question 5

Which THREE of the following are valid methods for troubleshooting failed tasks in Cloud Composer?

Accepted Answer

Checking the Airflow web UI task state. Reviewing logs, checking task instance states in the UI, and examining scheduler logs are all standard troubleshooting steps.

Answer

Rebuilding the entire GKE cluster

Answer

Deleting the environment bucket

Question 6

Which THREE of the following are Dataflow windowing types?

Accepted Answer

Fixed. Fixed, Sliding, and Session are the standard windowing types in Beam/Dataflow.

Answer

Binary

Answer

Random

Question 7

When optimizing a Looker model, you want to prevent users from accidentally running very expensive queries. Which parameter should you use in LookML?

Accepted Answer

sql_always_where. The 'sql_always_where' parameter forces a filter on every query, which is an effective guardrail for cost and performance.

Answer

query_limit

Answer

access_filter

Answer

always_filter

Question 8

You need to ensure that a Dataplex user cannot view the contents of files in a GCS bucket registered as an asset. What is the minimal configuration?

Accepted Answer

Remove the Storage Object Viewer role from the user. You must remove the Storage Object Viewer role from the user for that specific bucket, even if they have Dataplex viewer roles.

Answer

Remove the user from the Dataplex Lake Viewer role

Answer

Create a Dataplex deny-policy

Answer

Delete the asset from Dataplex

Question 9

Which TWO of the following are true regarding Dataplex security? (Choose two)

Accepted Answer

IAM roles can be applied at the Lake, Zone, or Asset level. Dataplex uses IAM for access and integrates with GCP security features.

Answer

Users must provide a password for each asset

Answer

Dataplex ignores existing storage permissions

Answer

Dataplex provides its own authentication system

Question 10

In BigQuery, what does the 'Data Preview' tab show?

Accepted Answer

A sample of the table data.. The preview shows a sample of the rows in the table without consuming query quota or incurring costs.

Answer

The edit history of the table.

Answer

The billing usage for that table.

Answer

The full schema definition.

Question 11

You are using Dataplex to manage data across multiple projects. You need to organize your BigQuery datasets and Cloud Storage buckets into a single logical entity for governance. Which Dataplex resource should you create?

Accepted Answer

Lake. A Lake in Dataplex is a logical grouping of data assets that provides a boundary for governance and security.

Answer

Asset

Answer

Taxonomy

Answer

Data Zone

Question 12

You need to audit who accessed sensitive data in a Dataplex Lake. Which service should you monitor to see access logs for these data assets?

Accepted Answer

Cloud Audit Logs. Cloud Audit Logs records all access to data assets; Dataplex provides a unified view, but the logs reside in Cloud Audit Logs.

Answer

Dataplex Task Logs

Answer

BigQuery Query Logs

Answer

Data Catalog history

Question 13

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

Accepted Answer

Assets inherit the location of the zone. Assets point to existing storage and are managed within zones.

Answer

Assets can be created without a storage resource

Answer

Assets can only be BigQuery tables

Answer

Assets duplicate the physical data

Question 14

You need to perform a complex windowing operation on streaming data in Dataflow. Which windowing strategy is best for session-based activity?

Accepted Answer

Session windows. Session windows group events that happen close together in time, which is ideal for sessionizing user activity.

Answer

Fixed windows

Answer

Global windows

Answer

Sliding windows

Question 15

Which Dataplex component allows you to query data across different storage systems using a single SQL interface?

Accepted Answer

BigQuery. The Dataplex Lake provides a unified view, and BigQuery Omni or federated queries allow querying across different storage systems.

Answer

Dataproc

Answer

Data Catalog

Answer

Cloud Storage