GCP-ADP Practice Test 2 — 25 Questions

Question 1

You are using BigQuery and need to load data from an external file that is not in GCS. Which method is recommended?

Accepted Answer

Upload to GCS then BigQuery. The recommended method to load external data into BigQuery is to first upload the file to Google Cloud Storage, then use BigQuery's native load job to ingest it. This approach is reliable, scalable, and leverages BigQuery's optimized loading pipeline. It also allows for better error handling and supports various file formats.

Answer

Use Cloud Functions

Answer

Stream directly from the local machine

Answer

Use an external API

Question 2

You are ingesting CSV files into BigQuery using the bq load command. The CSV files have a header row, and you want BigQuery to automatically detect the schema and skip the header. Which flags should you include?

Accepted Answer

--autodetect --skip_leading_rows=1. To load CSV files with a header row and let BigQuery infer the schema, use bq load with --autodetect and --skip_leading_rows=1. The --autodetect flag enables schema inference, and --skip_leading_rows=1 skips the header. The other flag combinations either use invalid flags or require manual schema definition, which is not what the scenario asks for.

Answer

--autodetect --header=true

Answer

--infer_schema --skip_rows=1

Answer

--schema --header

Question 3

You have noticed that your data quality tasks are failing. Which THREE of the following are potential causes for failure? (Choose three)

Accepted Answer

The YAML rule configuration is malformed. Option A is correct because data quality tasks in tools like Cloud Dataplex/DQ rely on YAML rule specifications, and malformed YAML (bad indentation, invalid keys, syntax errors) will cause the task to fail during parsing before execution. Option B is correct because the service account executing the data quality job must have the required IAM permissions (e.g., BigQuery Data Viewer, Storage Object Viewer) on the underlying data; missing permissions cause authorization errors and task failure. Option D is correct because data quality tasks often run on a Dataproc cluster or serverless Dataproc environment, so if that environment is unavailable (deleted, misconfigured, or out of quota), the job cannot execute and fails. Option C is not a valid cause because a slow internet connection on the user's side does not affect server-side data quality task execution. Option E is not a valid cause because moving data files to another lake would typically result in a 'not found' or empty-scan condition rather than being a general failure cause, and it is not one of the marked correct answers.

Answer

The user has a slow internet connection

Answer

The data files were moved to another lake

Question 4

You have a BigQuery table that is partitioned by ingestion time. You need to reduce storage costs by automatically deleting data older than 90 days. You want to ensure that the deletion happens without manual intervention and that the partitions are completely removed. What should you do?

Accepted Answer

Set a partition expiration on the table for 90 days.. Partition expiration is a table setting that automatically deletes partitions after a specified number of days. For ingestion-time partitioned tables, this is the simplest and most efficient way to remove old data and reduce storage costs. It requires no manual intervention and ensures partitions are dropped entirely.

Answer

Configure a Cloud Scheduler job that calls the BigQuery API to drop partitions older than 90 days.

Answer

Create a scheduled query that runs daily to delete rows older than 90 days using a DELETE statement.

Answer

Use a lifecycle rule on the BigQuery dataset to delete tables older than 90 days.

Question 5

A retail analytics team runs a Looker Explore against a BigQuery table containing order line items. Analysts need a single visual that shows the average order value per country, but the underlying table stores one row per line item, so multiple rows share the same order_id. Which approach produces a correct average order value per country?

Accepted Answer

Create a measure that divides total revenue by the count of distinct order_id values, then group by the country dimension in the Explore.. The table's grain is one row per line item, so any row-level average reports line-item value rather than order value. The reliable pattern is a ratio measure: summed revenue divided by the distinct count of order identifiers. Grouping that measure by the country dimension gives a defensible average order value per country, and using a distinct count in the denominator neutralizes the fan-out that multi-item orders introduce.

Answer

Apply a SUM aggregation to the order_total dimension and rely on Looker's default symmetric aggregates to return the per-country average.

Answer

Enable the Symmetric Aggregates setting on the country dimension and select Average as the measure type for order_total.

Answer

Add the order_total column as a dimension, use the Average aggregation type, and group by country to obtain the mean order value.

Question 6

You are using Vertex AI Workbench. You want to install a new Python library, `seaborn`, for visualization. What is the correct way to install it in the notebook instance?

Accepted Answer

!pip install seaborn. In a Vertex AI Workbench notebook (JupyterLab-based), the correct way to install a Python package is to run a shell command from a notebook cell using the `!` prefix, so `!pip install seaborn` executes pip in the notebook's kernel environment. This installs the library into the instance's Python environment so it can be imported in subsequent cells.

Answer

Use the Google Cloud Console library menu.

Answer

import seaborn

Answer

apt-get install seaborn

Question 7

You need to store sensitive data in GCS. Which feature ensures data is encrypted at rest?

Accepted Answer

Default Encryption. Google Cloud Storage automatically encrypts all data at rest using AES-256 encryption before it is written to disk, with no configuration required. This default encryption ensures that sensitive data is protected without any additional action from the user. While CMEK and Cloud DLP offer additional control or inspection, the fundamental guarantee of encryption at rest is provided by default encryption.

Answer

Identity and Access Management

Answer

Cloud DLP

Answer

Customer-Managed Encryption Keys (CMEK)

Question 8

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. Automatic data discovery in Dataplex scans data in a Lake and automatically identifies and tags sensitive information such as PII using built-in or custom data classifiers. It profiles data assets and applies metadata tags, which is exactly what's needed to detect and tag PII across an organization.

Answer

Data quality task

Answer

Lifecycle management policy

Answer

IAM policy inheritance

Question 9

You have a BigQuery table containing millions of rows of web server logs. You need to run a query that filters on a timestamp column and returns only the last 24 hours of data. The table is not partitioned. What should you do to improve query performance and reduce cost for this and future similar queries?

Accepted Answer

Create a partitioned table on the timestamp column and copy the data into it.. Partitioning a large table by a timestamp column enables partition pruning, so queries that filter on that column only scan relevant partitions. This reduces both cost and query time. Without partitioning, even with a WHERE clause, BigQuery scans the entire table. Clustering alone is less effective without partitioning, and materialized views are not ideal for dynamic time windows.

Answer

Create a clustered table on the timestamp column.

Answer

Add a WHERE clause that uses the timestamp column with a specific date range.

Answer

Create a materialized view that selects the last 24 hours of data and refresh it every hour.

Question 10

You need to perform data cleansing on a large dataset in Dataprep. Which execution engine should you choose for scalability?

Accepted Answer

Dataflow. Dataflow is the correct execution engine for Dataprep because Dataprep is built on top of Cloud Dataflow, which provides distributed, autoscaling processing for large datasets. Dataflow handles the parallel execution of Dataprep recipes across many workers, so cleansing operations scale horizontally without manual cluster management. Choosing Dataflow ensures the job can handle terabyte-scale data efficiently.

Answer

Local Desktop

Answer

BigQuery

Answer

Cloud Run

Question 11

You are a data engineer at a healthcare company. You need to create a Dataflow pipeline that reads from a Pub/Sub subscription and writes to BigQuery. The pipeline must handle late-arriving data and ensure exactly-once processing. You also need to minimize cost. Which of the following should you use?

Accepted Answer

Use Dataflow with Apache Beam's PubSubIO and BigQueryIO, enabling windowing and triggers for late data, and use BigQueryIO.Write with exactly-once semantics.. Dataflow with Apache Beam provides the necessary constructs for exactly-once processing and late data handling. PubSubIO and BigQueryIO support windowing and triggers, and BigQueryIO.Write can be configured for exactly-once semantics. Other options either lack these features or are not cost-effective for this use case. Therefore, using Dataflow with these configurations is the correct approach.

Answer

Use Dataflow with the Pub/Sub to BigQuery template and set the --discardUnknownFields option.

Answer

Use BigQuery's streaming ingestion with a Pub/Sub subscription directly.

Answer

Use Cloud Data Fusion with a Realtime pipeline that writes to BigQuery.

Question 12

A marketing analyst needs to run a one-time SQL query that joins a BigQuery table containing campaign performance data with a small CSV file stored in a Cloud Storage bucket. The CSV is updated weekly by an external partner. The analyst wants the query to always reflect the latest CSV without loading it into BigQuery each week. What should the analyst do?

Accepted Answer

Create a BigQuery external table over the CSV file in Cloud Storage and join it with the campaign table in the query.. A BigQuery external table over the Cloud Storage CSV lets queries read the file directly, so the join always sees the latest partner data without any load or refresh job. This is the standard pattern when small reference files change frequently and you want to avoid maintaining a native copy.

Answer

Export the campaign table to Cloud Storage, then run the join in Cloud Shell using a local SQL engine.

Answer

Import the CSV into BigQuery as a native table and set up a scheduled query to re-import it weekly.

Answer

Use the bq load command to append the CSV into a partitioned table each week.

Question 13

You are using Cloud Scheduler to trigger a Workflows execution every hour. The Workflows definition expects an argument 'projectId' to be passed at runtime. You need to ensure the argument is provided correctly. What should you include in the Cloud Scheduler job configuration?

Accepted Answer

In the 'Body' field, provide a JSON payload with the argument, e.g., {"projectId": "my-project"}.. When Cloud Scheduler triggers a Workflows execution, it sends an HTTP POST request to the Workflows API endpoint. Runtime arguments must be included in the request body as a JSON object. The 'Body' field in Cloud Scheduler allows you to specify this JSON payload, ensuring the workflow receives the 'projectId' argument. Other fields like URL, headers, or non-existent attributes do not serve this purpose.

Answer

In the 'URL' field, append the argument as a query parameter, e.g., ?projectId=my-project.

Answer

In the 'Attributes' field, define a key-value pair with 'projectId' as the key and 'my-project' as the value.

Answer

In the 'Headers' field, add a custom header like 'X-Project-Id: my-project'.

Question 14

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. In Dataplex, when defining a zone or asset that points to a Cloud Storage bucket, you can specify a path filter (a prefix or folder path) in the asset definition to limit discovery and inclusion to only files under that folder. This is the native mechanism for scoping a Dataplex asset to a subset of a bucket.

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 15

You need to set up an alert when a GCS bucket exceeds a certain size. Which tool do you use?

Accepted Answer

Cloud Monitoring. Cloud Monitoring is the GCP service responsible for collecting metrics, creating alerting policies, and notifying on threshold breaches. GCS automatically exports storage metrics (such as storage.googleapis.com/storage/total_bytes) to Cloud Monitoring, so you can build an alerting policy on bucket size and route it to email, Pub/Sub, or PagerDuty. This is the canonical way to alert on resource metrics in GCP.

Answer

Cloud Build

Answer

IAM

Answer

Cloud Logging

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. Data Catalog taxonomies are project-scoped resources, so to share one across multiple projects you define it once in a central (host) project and grant other projects' users or service accounts the appropriate Data Catalog IAM roles (e.g., Data Catalog Viewer/Editor) on that taxonomy. This avoids duplication and keeps policy definitions consistent. Cross-project sharing is achieved through IAM bindings, not by relocating the resource.

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 role of the 'Dataplex Data Steward'?

Accepted Answer

To manage metadata, quality rules, and compliance. A Dataplex Data Steward is responsible for managing metadata, defining and enforcing data quality rules, and ensuring compliance with governance policies across data assets. This role uses Dataplex features like Business Glossary, Data Quality tasks, and Data Catalog to curate and govern data. It is a governance-focused role, not an engineering or analytics role.

Answer

To write SQL queries for the business

Answer

To develop ETL pipelines

Answer

To manage the underlying infrastructure

Question 18

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. Dataplex Data Quality tasks are defined using a YAML specification that describes the rules, including non-null constraints on columns. The YAML file is uploaded to a Cloud Storage bucket and referenced when creating the Data Quality task. This approach allows for flexible, version-controlled rule definitions that are decoupled from the underlying data schema.

Answer

In the Cloud Storage metadata

Answer

In the BigQuery table schema

Answer

In the Dataplex Asset definition

Question 19

A data analyst is working in a Vertex AI Workbench notebook. They want to connect to a private BigQuery dataset. How should they authenticate?

Accepted Answer

The instance's attached service account will handle authentication automatically.. Vertex AI Workbench instances are associated with a service account that provides credentials to Google Cloud APIs. When the notebook calls BigQuery, the client library uses the instance's attached service account automatically via the metadata server, so no manual credentials are needed. This is the secure and recommended authentication method.

Answer

Enter your username and password in every query.

Answer

Hardcode the service account key in the notebook.

Answer

Use the 'gcloud auth login' command in every cell.

Question 20

Which component of Cloud Composer acts as the primary interface for managing and triggering DAGs manually?

Accepted Answer

Airflow Web Interface. The Airflow Web Interface (the Airflow UI) is the primary interface in Cloud Composer for viewing, triggering, and managing DAGs manually. It provides DAG views, task logs, graph view, and manual trigger buttons.

Answer

Cloud Storage Browser

Answer

Cloud Shell

Answer

BigQuery Console