GCP-ADP Practice Test 12 — 15 Questions

Question 1

A data scientist is using Vertex AI Workbench and needs to share a notebook with a team member who only needs read access. What is the most secure way to do this?

Accepted Answer

Grant the user 'Storage Object Viewer' role on the Cloud Storage bucket containing the .ipynb file.. Storing the notebook in Cloud Storage and using IAM permissions is the standard way to share notebook artifacts.

Answer

Add the user as a 'Vertex AI User' on your project.

Answer

Copy the notebook code into an email.

Answer

Change the instance permissions to 'Public'.

Question 2

You are configuring a Dataplex asset that points to a GCS bucket. You want to ensure that only files in a specific folder are included in the asset. How do you specify this?

Accepted Answer

Specify a path filter in the asset definition. When adding a GCS bucket as an asset, you can provide a filter or prefix to limit the scope to a specific path.

Answer

Define a SQL view on the folder

Answer

Use an IAM condition on the bucket

Answer

Move the files to a separate bucket

Question 3

You are writing a complex BigQuery query and need to define a temporary table to use later in the same query. What is the most efficient syntax?

Accepted Answer

WITH clause (CTE).. Common Table Expressions (CTEs) defined with the WITH clause are the cleanest, most readable way to handle temporary logic.

Answer

Nested subqueries.

Answer

Variable declaration.

Answer

CREATE TABLE AS SELECT.

Question 4

Which TWO of the following are benefits of using Cloud Storage?

Accepted Answer

Global availability. GCS offers high durability and global accessibility.

Answer

Automatic virus scanning

Answer

Automatic data compression

Answer

Auto-scaling SQL queries

Question 5

You want to enforce that all data in a specific Dataplex Zone must be encrypted with a Customer-Managed Encryption Key (CMEK). How do you enforce this?

Accepted Answer

Configure CMEK at the Lake/Zone creation level. When creating a Dataplex Lake or Zone, you can configure CMEK settings that apply to the underlying resources.

Answer

There is no way to enforce CMEK in Dataplex

Answer

Use a Dataflow job to re-encrypt

Answer

Apply it via an IAM policy

Question 6

In BigQuery, you want to improve query performance for a table that is frequently filtered by a `customer_id` column. What is the recommended strategy?

Accepted Answer

Cluster the table by 'customer_id'.. Clustering by `customer_id` organizes the data physically to optimize queries that filter by that specific column.

Answer

Add a primary key constraint.

Answer

Convert the table to a View.

Answer

Increase the number of slots in the reservation.

Question 7

You are working in a Vertex AI Workbench notebook and want to list the files in your current working directory. What command should you run?

Accepted Answer

!ls. In a Jupyter-based environment, the `ls` command (prefix with % or ! if in a cell) lists files in the current folder.

Answer

find .

Answer

dir

Answer

list_files()

Question 8

Which of the following is NOT a benefit of using Dataplex?

Accepted Answer

High-frequency OLTP transaction support. Dataplex is for data governance and management, not for high-frequency low-latency transaction processing (OLTP).

Answer

Automated data discovery

Answer

Improved data compliance

Answer

Unified data management

Question 9

A BigQuery table has 10 billion rows. You notice a query performing a cross-join is timing out. What should you do?

Accepted Answer

Replace the cross-join with a specific JOIN condition.. Cross-joins on massive datasets are the leading cause of query failure; they should be avoided in favor of JOIN ON or other set-based operations.

Answer

Use a wildcard table.

Answer

Cache the results in BigQuery.

Answer

Increase the number of slots.

Question 10

You have a Dataplex Lake containing data from two different regions. How does this affect data access?

Accepted Answer

Users must have access to both regional storage resources. You must ensure that users have the necessary IAM permissions to access the data in both regions; the lake acts as a logical container but does not override regional access restrictions.

Answer

Users cannot access data across regions

Answer

Data access is automatically merged

Answer

The Lake automatically replicates data

Question 11

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 12

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 13

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 14

What does 'Data Lineage' show you in Dataplex?

Accepted Answer

The path the data took through the system. Data lineage tracks the origin, movement, and transformations of data as it moves through the pipeline.

Answer

The number of users accessing the data

Answer

The cost of storing data

Answer

The database schema version

Question 15

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