Courseiva
Back to Google Professional Data Engineer questions

Scenario-based practice

Refer to the Exhibit Practice Questions

Practise Google Professional Data Engineer practice questions — original exam-style scenarios covering every exam domain, with detailed explanations, wrong-answer analysis, and common exam traps.

12
scenario questions
PDE
exam code
Google Cloud
vendor

Scenario guide

How to approach refer to the exhibit practice questions

Practise exhibit-style questions that ask you to read a topology, table, command output or diagram before choosing the best answer.

Quick answer

Exhibit-style questions test whether you can read a topology, command output, diagram or table before choosing the best answer.

How to extract the relevant detail from an exhibit.

How topology, command output or routing information affects the answer.

How to avoid answering from memory before reading the evidence.

How to map the exhibit back to the exam objective.

Related practice questions

Related PDE topic practice pages

Scenario questions usually connect to one or more exam topics. Use these links to review the underlying concepts behind the scenario.

Practice set

Practice scenarios

Question 1hardmultiple choice
Full question →

Refer to the exhibit. A team is trying to run a custom prediction container on Vertex AI Endpoint. They get this error when the container starts. What is the most likely cause?

Exhibit

Log: "Container failed with error: exec format error. Ensure the container has an entry point."
Question 2mediummultiple choice
Full question →

A BigQuery query fails with the error shown in the exhibit. What is the most likely cause?

Exhibit

Refer to the exhibit.

Exhibit:
Error: Resources exceeded during query execution.
Query statement: SELECT * 
FROM `project.dataset.table` 
WHERE date >= '2023-01-01'
Question 3mediummultiple choice
Full question →

Refer to the exhibit. A data scientist deploys a model using this configuration. Users report that after a few hours of inactivity, the first prediction request takes over 30 seconds. What is the most likely cause?

Network Topology
gcloud ai models describeregion=us-central1model=123456789Output:"deployedModels": ["id": "12345","model": "projects/my-project/locations/us-central1/models/123456789","displayName": "my_model","createTime": "2023-08-01T12:00:00Z","privateEndpoints": {"predictHttpUri": "https://us-central1-aiplatform.googleapis.com/v1/projects/my-project/locations/us-central1/endpoints/67890:predict"},"trafficSplit": {"12345": 100"disableContainerLogging": true,"automaticResources": {"minReplicaCount": 0,"maxReplicaCount": 5
Question 4hardmultiple choice
Full question →

Based on the exhibit, what is the most likely cause of duplicate rows despite using the same event_id as insertId?

Exhibit

Refer to the exhibit.

```
# BigQuery table schema and sample data
Table: mydataset.events
Columns:
  event_id: STRING (REQUIRED)
  event_timestamp: TIMESTAMP (REQUIRED)
  event_data: STRING (NULLABLE)
  user_id: STRING (REQUIRED)
Partitioned by: event_timestamp (daily)
Clustered by: user_id

Job: Dataflow pipeline writing 1000 events/second to this table using streaming inserts with insertId = event_id.

Monitoring shows intermittent 'duplicate rows' in queries that count distinct event_ids.
```
Question 5hardmultiple choice
Full question →

A Dataflow pipeline as described in the exhibit has increasing lag. Which optimization is most likely to reduce the lag?

Exhibit

Refer to the exhibit.

Exhibit:
Pipeline description:
- Source: PubSubIO.read()
- Transform: ParDo(Process)
- Window: Window.into(FixedWindows of 1 minute)
- Transform: GroupByKey
- Sink: Write to BigQuery using StreamingInserts
- Estimated throughput: 10MB/s
- Observed lag: increasing
Question 6hardmultiple choice
Full question →

A company runs a Cloud Dataflow streaming pipeline that reads from Cloud Pub/Sub, performs a fixed window of 10 seconds, joins with a slowly-changing dimension table stored in Cloud Bigtable, and writes results to BigQuery. The pipeline has been running for months but recently started exhibiting increasing latency and occasional data loss. The pipeline uses default settings with autoscaling enabled (min 2, max 20 workers). The Bigtable cluster has 3 nodes. The dimensions are updated infrequently. The latency has grown from seconds to minutes. Examining the Dataflow monitoring UI, you see that the 'System Lag' metric is increasing, and some windows are not being emitted. The CPU utilization on Bigtable nodes is below 50%. There are no errors in the logs. Which action is most likely to resolve the issue?

Question 7mediummultiple choice
Full question →

Refer to the exhibit. What is the most likely cause of the error?

Exhibit

Error: Vertex AI.Exception: 400 Failed to deploy model to endpoint projects/.../endpoints/1234. Details: The resource 'projects/.../models/5678' is missing an artifact URI. Please upload the model artifact to Cloud Storage and create a new model version.
Question 8mediummultiple choice
Full question →

Refer to the exhibit. A developer sees this log entry when trying to get a prediction. What is the most likely cause?

Exhibit

{
 "severity": "ERROR",
 "message": "Prediction failed: Model 'projects/my-project/models/12345/versions/v1' not found.",
 "timestamp": "2024-01-20T10:00:00Z",
 "request": "POST /v1/projects/my-project/models/12345:predict"
}
Question 9easymultiple choice
Full question →

Refer to the exhibit. A Cloud Build step fails when pushing a Docker image to Artifact Registry. What is the missing IAM role for the Cloud Build service account?

Exhibit

Refer to the exhibit.
```json
{
  "error": "denied: permission denied for us-central1-docker.pkg.dev/my-project/my-repo/my-model:latest"
}
```
Question 10hardmultiple choice
Full question →

Refer to the exhibit. A data engineer sees these metrics from Cloud Monitoring for a deployed Vertex AI Endpoint. What is the most effective action to reduce latency?

Exhibit

Metric: CPU Utilization (Model Endpoint)
Current: 90%
Threshold: 80%
Trend: Increasing

Metric: Prediction Latency (p95)
Current: 1500ms
Threshold: 1000ms
Trend: Increasing
Question 11hardmultiple choice
Full question →

Refer to the exhibit. The feature store 'my_fs' responds to offline queries but online serving requests fail. What is the most likely cause?

Exhibit

gcloud ai featurestores describe projects/.../locations/us-central1/featurestores/my_fs
Output:
online_serving_config:
  fixed_node_count: 0
  scaling:
    min_node_count: 1
    max_node_count: 10
    cpu_utilization_target: 80
state: STABLE
Question 12easymultiple choice
Full question →

Refer to the exhibit. An auditor sees the following output from `gcloud ai models list`. What can they conclude about versioning?

Exhibit

MODEL_ID: my_model
VERSION_ID: v1
DISPLAY_NAME: my_model_v1
STATE: READY
VERSION_UPDATE_TIME: 2023-01-10T12:00:00

MODEL_ID: my_model
VERSION_ID: v2
DISPLAY_NAME: my_model_v2
STATE: READY
VERSION_UPDATE_TIME: 2023-01-15T12:00:00

These PDE practice questions are part of Courseiva's free Google Cloud certification practice question bank. Courseiva provides original exam-style PDE questions with detailed explanations, topic-based practice, mock exams, readiness tracking, and study analytics.