GCP-ADP Data Management — 10 Questions

Question 1

You are configuring a Dataplex Data Quality task. You need to ensure the task runs on a schedule and produces a report in BigQuery. Which resource is required to execute this task?

Accepted Answer

Dataproc Serverless. A Spark-based environment or a serverless execution environment managed by Dataplex is used to run these tasks.

Answer

Dataflow template

Answer

BigQuery Data Transfer Service

Answer

Cloud Scheduler

Question 2

A team requires access to a specific Dataplex Zone. You want to grant them the ability to view metadata and query the data without granting them full owner permissions. Which role should you assign at the Lake level?

Accepted Answer

roles/dataplex.dataViewer. The Dataplex Data Viewer role allows viewing metadata and querying data within the lake assets.

Answer

roles/bigquery.dataViewer

Answer

roles/dataplex.viewer

Answer

roles/dataplex.admin

Question 3

You have sensitive data in Cloud Storage that needs to be deleted after 30 days to comply with regulatory requirements. What is the most efficient way to manage this?

Accepted Answer

Use Cloud Storage lifecycle management policies. Object lifecycle management rules in Cloud Storage are the standard way to automate data deletion based on age.

Answer

Run a manual BigQuery script

Answer

Write a Cloud Function to check dates and delete files

Answer

Create a Dataplex lifecycle task

Question 4

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 5

Which service should you use to search for and discover datasets across your entire Google Cloud organization?

Accepted Answer

Data Catalog. Data Catalog is the primary discovery tool for finding and understanding data assets in Google Cloud.

Answer

BigQuery Explorer

Answer

Cloud Storage Browser

Answer

Cloud Logging

Question 6

You need to control access to specific columns in a BigQuery table using Dataplex-integrated policy tags. What must you create before you can apply a policy tag to a column?

Accepted Answer

Policy Tag Taxonomy. A Policy Tag Taxonomy must be created in the Data Catalog / Dataplex taxonomy management before tags can be applied to columns.

Answer

Data Zone

Answer

IAM Condition

Answer

BigQuery Dataset permission

Question 7

You are migrating data into a Dataplex Lake. You need to ensure that the data is partitioned by date to improve query performance. Where do you define this partitioning?

Accepted Answer

At the Asset level. In Dataplex, partitioning is defined at the asset level when linking the BigQuery table or Cloud Storage files.

Answer

At the Zone level

Answer

At the Lake level

Answer

In the IAM policy

Question 8

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 9

What is the purpose of a 'Data Zone' in Dataplex?

Accepted Answer

To provide a logical grouping for governance and policies. Zones are used to group data assets within a lake for common governance, security, and lifecycle policies.

Answer

To execute Spark jobs

Answer

To store query results

Answer

To act as a physical storage location

Question 10

What happens if you delete a Dataplex Lake?

Accepted Answer

The lake is deleted, but the underlying assets remain. Deleting a Lake removes the logical grouping but does not delete the underlying data assets (like BigQuery datasets or GCS buckets).

Answer

The data is moved to a 'trash' bucket

Answer

Access to the assets is granted to all users

Answer

All underlying data assets are deleted