GCP-ADP Data Management — Timed 15 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. roles/dataplex.dataViewer is the Dataplex role designed to grant read access to data within a lake/zone, including the ability to view metadata and query the underlying data, without granting administrative or owner permissions. It is the least-privilege role that satisfies the requirement of viewing metadata and querying data at the lake level.

Answer

roles/bigquery.dataViewer

Answer

roles/dataplex.viewer

Answer

roles/dataplex.admin

Question 3

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 because an asset represents the actual data resource (such as a BigQuery table or Cloud Storage bucket) that is being cataloged and governed. Partitioning is a property of the underlying data storage, so it is configured where the asset is defined, not at the lake or zone level. This allows different assets within the same zone to have different partitioning schemes.

Answer

At the Zone level

Answer

At the Lake level

Answer

In the IAM policy

Question 4

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. The correct resource is a Lake. In Dataplex, a lake is a logical container that groups together zones and assets, providing a single logical entity for governance across multiple projects. It allows you to organize and manage data from various sources like BigQuery datasets and Cloud Storage buckets.

Answer

Asset

Answer

Taxonomy

Answer

Data Zone

Question 5

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 Lakes and Zones are created within a specific Google Cloud region, and the regionalized Lake/Zone definition enforces that data assets reside in that region, supporting data residency compliance. By defining lakes and zones in the required geography, you constrain where data is stored and processed.

Answer

Location-based IAM policies

Answer

Data residency tags

Answer

VPC Service Controls

Question 6

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 are sub-divisions within a Lake that let you group assets by department, data classification, or processing stage (raw vs. curated). By creating separate Zones for each department and attaching the appropriate assets, you can apply IAM policies at the Zone level so each department only sees and accesses its own data. This provides the isolation required without creating separate Lakes.

Answer

Data tags on the assets

Answer

IAM roles on the bucket only

Answer

Separate Lakes for each department

Question 7

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. The minimal configuration is to remove the Storage Object Viewer role from the user. Dataplex relies on the underlying storage permissions to control access to data. If a user does not have Storage Object Viewer on the bucket, they cannot view the file contents, even if they have Dataplex permissions.

Answer

Remove the user from the Dataplex Lake Viewer role

Answer

Create a Dataplex deny-policy

Answer

Delete the asset from Dataplex

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. Choosing a multi-region location for a Dataplex Lake replicates metadata and data across multiple geographic regions, which improves availability (survives a single-region outage) and durability (redundant copies reduce data loss risk). This is the same trade-off as multi-region BigQuery datasets or multi-region Cloud Storage buckets: higher resilience at the cost of slightly higher latency and cost.

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 need to share a BigQuery dataset across multiple organizations. What is the recommended approach using Dataplex?

Accepted Answer

Use Dataplex to aggregate the datasets in one Lake. Dataplex Lakes can attach assets from multiple projects and even multiple organizations, allowing a single logical Lake to aggregate datasets that live in different projects. This provides centralized governance, discovery, and metadata management without copying or exposing data publicly. It is the recommended pattern for cross-organization data sharing because it preserves ownership and security boundaries while enabling unified access.

Answer

Grant public access to the dataset

Answer

Copy all data to a single project

Answer

Export the data to CSV files

Question 10

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

Accepted Answer

BigQuery. BigQuery is the correct answer because it provides a serverless, highly scalable data warehouse that can query data across multiple storage systems using standard SQL. Through features like BigQuery Omni and external tables, it can directly query data in Cloud Storage, Amazon S3, Azure Blob Storage, and other sources without data movement. Dataplex itself integrates with BigQuery to provide a unified analytics interface, but the actual query engine that enables cross-storage SQL is BigQuery. Thus, BigQuery is the Dataplex component that allows querying data across different storage systems with a single SQL interface.

Answer

Dataproc

Answer

Data Catalog

Answer

Cloud Storage

Question 11

You are troubleshooting lineage issues. Which THREE of the following factors could prevent lineage from being captured? (Choose three)

Accepted Answer

The service account lacks 'lineage.events.create' permission. Option A is correct because lineage capture depends on the identity performing the operation holding the 'lineage.events.create' permission; without it, the lineage event cannot be written and lineage will not be recorded. Option C is correct because lineage is emitted through specific API endpoints, so if the pipeline calls the wrong or legacy endpoints, no lineage events are generated. Option D is correct because only supported services integrate with the lineage system; jobs running on an unsupported service will not produce lineage events. Option B is incorrect because lake administrator privileges are not required for lineage capture, only the appropriate lineage permission. Option E is incorrect because a multi-region bucket affects data location and access, not whether lineage events are emitted.

Answer

The user is not an administrator of the lake

Answer

The data files are in a multi-region bucket

Question 12

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. Option A is correct because Dataplex relies on Data Catalog as its underlying metadata repository: when Dataplex discovers, profiles, or manages assets across lakes, zones, and assets, the resulting technical and business metadata is stored in and served through Data Catalog. Option B is correct because Data Catalog has been folded into Dataplex as a sub-feature, so the Data Catalog capabilities (search, tagging, metadata management) are now delivered as part of the Dataplex product rather than as a standalone service. Option C is incorrect because they are not billed as two separate products; Data Catalog functionality is included within Dataplex, so there is no separate Data Catalog charge. Option D is incorrect because they do not maintain separate IAM systems; access is governed through unified Google Cloud IAM roles and permissions that apply across Dataplex and its Data Catalog metadata. Option E is incorrect because they are not completely separate products — Data Catalog is integrated into and subsumed by Dataplex.

Answer

You must pay for them separately

Answer

They have separate IAM systems

Answer

They are completely separate products

Question 13

You are using Dataplex Data Quality tasks to validate a BigQuery table that receives daily incremental loads. The table is partitioned by ingestion date and contains a column named customer_id that must never be null. You need the task to run every night, scan only the most recently loaded partition, and write the results to a BigQuery table so that your operations team can query failures. What should you do?

Accepted Answer

Create a Dataplex Data Quality task, define a rule that checks customer_id for null values, configure a schedule, set the task's scope to the target BigQuery partition, and specify a BigQuery destination table for the results.. A Dataplex Data Quality task can enforce a non-null rule on customer_id, run on a schedule, limit its scan to a specific BigQuery partition, and export results to a BigQuery table. That directly satisfies the nightly cadence, the incremental partition scope, and the queryable result destination. The other approaches either add unnecessary services, use a non-queryable destination, or scan more data than required.

Answer

Create a Dataplex Data Quality task with a null rule on customer_id and configure it to write results to a Cloud Storage bucket as JSON files, then load those files into BigQuery with a scheduled query.

Answer

Create a Dataplex Data Quality task with a null rule on customer_id, then use a Cloud Scheduler job to invoke the Dataplex API nightly and configure the task to publish results to a Pub/Sub topic.

Answer

Create a Dataplex Data Quality task with a null rule on customer_id and set the task to run on a schedule, but leave the scope at the table level so that all partitions are scanned each night to ensure completeness.

Question 14

A data engineer needs to copy a 500 GB dataset from an on-premises data center to Cloud Storage. The data center has a reliable 1 Gbps internet connection, and the transfer must complete within two days. Which Google Cloud service should they use?

Accepted Answer

Storage Transfer Service. Storage Transfer Service is the managed online transfer solution for moving large datasets from on-premises or other cloud sources into Cloud Storage. It supports scheduling, retries, and incremental transfers, which suits a 500 GB move over a reliable 1 Gbps link within two days. Physical appliances and network-only options do not fit the requirements.

Answer

Transfer Appliance

Answer

Cloud Interconnect with a Partner Interconnect attachment

Answer

Cloud VPN with gsutil parallel composite uploads

Question 15

You are a data practitioner at a retail company. Your team has a BigQuery dataset that contains customer transaction records spanning 5 years. Analysts frequently run queries filtered by transaction_date, but most queries only look at the last 30 days. Query costs are high because BigQuery scans the entire table for each query. You want to reduce cost and improve performance with minimal changes to existing queries. What should you do?

Accepted Answer

Partition the table by transaction_date using day partitioning.. Partitioning the table by transaction_date allows BigQuery to scan only the partitions that match the query filter. Since most queries target the last 30 days, daily partitioning will prune the older partitions, significantly reducing bytes processed and cost. Existing queries that filter on transaction_date will automatically benefit without modification, making this the most efficient and least disruptive solution.

Answer

Create a clustered table on the transaction_date column.

Answer

Create a view that filters the last 30 days and have analysts query the view.

Answer

Export the last 30 days of data to a new table and have analysts query that table.