GCP-ADP Data Management — 25 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

Question 11

You need to restrict data access to specific geographic regions for compliance. Which Dataplex feature supports this?

Accepted Answer

Regionalized Lake and Zone definition. Dataplex allows you to restrict the location of data assets when creating a lake or zone.

Answer

Location-based IAM policies

Answer

Data residency tags

Answer

VPC Service Controls

Question 12

You are configuring a Dataplex Data Quality task. You want to validate that a 'user_id' column has no NULL values. Where do you define this rule?

Accepted Answer

In a YAML configuration file. Data quality rules are defined in a YAML configuration file that Dataplex uses to run the quality check task.

Answer

In the Cloud Storage metadata

Answer

In the BigQuery table schema

Answer

In the Dataplex Asset definition

Question 13

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 14

Which role is required to manage Dataplex assets within a Zone?

Accepted Answer

roles/dataplex.admin. The Dataplex Data Steward or Dataplex Admin role is required to manage assets, but specifically 'roles/dataplex.admin' or 'roles/dataplex.dataSteward' are used.

Answer

roles/storage.admin

Answer

roles/bigquery.admin

Answer

roles/viewer

Question 15

You have multiple departments using the same Dataplex Lake. You need to ensure that each department can only see data belonging to their own projects. What should you configure?

Accepted Answer

Separate Zones within the Lake. Dataplex Zones allow for logical separation within a Lake, where permissions can be scoped to the zone level.

Answer

Data tags on the assets

Answer

IAM roles on the bucket only

Answer

Separate Lakes for each department

Question 16

You have a Data Catalog taxonomy that you want to share across multiple projects. How do you achieve this?

Accepted Answer

Define it in a central project and share access. You create the taxonomy in a central host project and grant permissions to other projects to use it.

Answer

Move the taxonomy to the Organization node

Answer

Duplicate the taxonomy in each project

Answer

Use Cloud Resource Manager to link them

Question 17

What is the primary function of the 'Dataplex Discovery' process?

Accepted Answer

To automatically catalog and profile data. Discovery automatically scans and catalogs data assets in your storage to make them discoverable.

Answer

To manage VPC firewall rules

Answer

To run SQL queries

Answer

To migrate data to the cloud

Question 18

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 19

You need to track lineage for a BigQuery table populated by a Dataflow pipeline. How does Dataplex help?

Accepted Answer

Dataplex captures it automatically for supported services. Dataplex and Data Catalog integrate with BigQuery and Dataflow to capture lineage automatically when pipelines are correctly instrumented.

Answer

Lineage is not supported in Dataplex

Answer

You must use a third-party tool

Answer

You must manually enter the lineage in the Data Catalog UI

Question 20

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