PDE sample questions

Question 1

Your company is using WILDCARD tables to query data across multiple tables with similar names. The SQL statement is currently failing with the following error:

Syntax error: Expected end of statement but got at [4:11]

SELECT age
FROM
bigquery-public-data.noaa_gsod.gsod
WHERE
age != 99 AND_TABLE_SUFFIX = ‘1929’
ORDER BY
age DESC

Which table name will make the SQL statement work correctly?

Accepted Answer

‘bigquery-public-data.noaa_gsod.gsod*'

Answer

‘bigquery-public-data.noaa_gsod.gsod’*

Answer

‘bigquery-public-data.noaa_gsod.gsod‘

Answer

bigquery-public-data.noaa_gsod.gsod*

Question 2

You work on a regression problem in a natural language processing domain, and you have 100M labeled exmaples in your dataset. You have randomly shuffled your data and split your dataset into train and test samples (in a 90/10 ratio). After you trained the neural network and evaluated your model on a test set, you discover that the root-mean-squared error (RMSE) of your model is twice as high on the train set as on the test set. How should you improve the performance of your model?

Accepted Answer

Increase the complexity of your model by, e.g., introducing an additional layer or increase sizing the size of vocabularies or n-grams used.

Answer

Try to collect more data and increase the size of your dataset.

Answer

Increase the share of the test sample in the train-test split.

Answer

Try out regularization techniques (e.g., dropout of batch normalization) to avoid overfitting.

Question 3

You need to create a new transaction table in Cloud Spanner that stores product sales data. You are deciding what to use as a primary key. From a performance perspective, which strategy should you choose?

Accepted Answer

A random universally unique identifier number (version 4 UUID)

Answer

The current epoch time

Answer

The original order identification number from the sales system, which is a monotonically increasing integer

Answer

A concatenation of the product name and the current epoch time

Question 4

You need to copy millions of sensitive patient records from a relational database to BigQuery. The total size of the database is 10 TB. You need to design a solution that is secure and time-efficient.
What should you do?

Accepted Answer

Export the records from the database as an Avro file. Upload the file to GCS using gsutil, and then load the Avro file into BigQuery using the BigQuery web Ul in the GCP Console.

Answer

Export the records from the database as an Avro file. Copy the file onto a Transfer Appliance and send it to Google, and then load the Avro file into BigQuery using the BigQuery web Ul in the GCP Console.

Answer

Export the records from the database as an Avro file. Create a public URL for the Avro file, and then use Storage Transfer Service to move the file to Cloud Storage. Load the Avro file into BigQuery using the BigQuery web Ul in the GCP Console.

Answer

Export the records from the database into a CSV file. Create a public URL for the CSV file, and then use Storage Transfer Service to move the file to Cloud Storage. Load the CSV file into BigQuery using the BigQuery web Ul in the GCP Console.

Question 5

An e-commerce platform uses Cloud Composer to orchestrate a complex daily data processing workflow. The workflow involves several Dataproc jobs, BigQuery queries, and data validation checks. The platform team wants to implement a CI/CD process to automatically deploy changes to their Airflow DAGs from a GitHub repository to the Composer environment. Which of the following approaches is the recommended best practice for achieving this?

graph TD A[Developer pushes to main branch] --> B{GitHub Actions}; B --> C[Sync DAGs to Composer GCS Bucket]; C --> D[Cloud Composer picks up new DAG];

Accepted Answer

Use a CI/CD tool like GitHub Actions or Cloud Build to sync the DAGs folder from the repository to the environment's GCS bucket.

Answer

Configure the Cloud Composer environment to pull DAGs directly from the GitHub repository via an SSH key.

Answer

Write a startup script for the Composer workers that performs a `git pull` on the repository every time a worker starts.

Answer

Manually upload the DAG files using `gcloud composer environments storage dags import` command after each change.

Question 6

You need to migrate a 2TB relational database to Google Cloud Platform. You do not have the resources to significantly refactor the application that uses this database and cost to operate is of primary concern.
Which service do you select for storing and serving your data?

Accepted Answer

Cloud SQL

Answer

Cloud Firestore

Answer

Cloud Bigtable

Answer

Cloud Spanner

Question 7

You are migrating your data warehouse to BigQuery. You have migrated all of your data into tables in a dataset. Multiple users from your organization will be using the data. They should only see certain tables based on their team membership. How should you set user permissions?

Accepted Answer

Create authorized views for each team in the same dataset in which the data resides, and assign the users/groups data viewer access to the authorized views

Answer

Assign the users/groups data viewer access at the table level for each table

Answer

Create authorized views for each team in datasets created for each team. Assign the authorized views data viewer access to the dataset in which the data resides. Assign the users/groups data viewer access to the datasets in which the authorized views reside

Answer

Create SQL views for each team in the same dataset in which the data resides, and assign the users/groups data viewer access to the SQL views

Question 8

You are managing a Cloud Dataproc cluster. You need to make a job run faster while minimizing costs, without losing work in progress on your clusters. What should you do?

Accepted Answer

Increase the cluster size with preemptible worker nodes, and configure them to use graceful decommissioning.

Answer

Increase the cluster size with preemptible worker nodes, and configure them to forcefully decommission.

Answer

Increase the cluster size with more non-preemptible workers.

Answer

Increase the cluster size with preemptible worker nodes, and use Cloud Stackdriver to trigger a script to preserve work.

Question 9

You have a data stored in BigQuery. The data in the BigQuery dataset must be highly available. You need to define a storage, backup, and recovery strategy of this data that minimizes cost. How should you configure the BigQuery table?

Accepted Answer

Set the BigQuery dataset to be regional. Create a scheduled query to make copies of the data to tables suffixed with the time of the backup. In the event of an emergency, use the backup copy of the table.

Answer

Set the BigQuery dataset to be multi-regional. Create a scheduled query to make copies of the data to tables suffixed with the time of the backup. In the event of an emergency, use the backup copy of the table.

Answer

set the BigQuery dataset to be multi-regional. In the event of an emergency, use a point-in-time snapshot to recover the data.

Answer

Set the BigQuery dataset to be regional. In the event of an emergency, use a point-in-time snapshot to recover the data.

Question 10

You work for an economic consulting firm that helps companies identify economic trends as they happen. As part of your analysis, you use Google BigQuery to correlate customer data with the average prices of the 100 most common goods sold, including bread, gasoline, milk, and others. The average prices of these goods are updated every 30 minutes. You want to make sure this data stays up to date so you can combine it with other data in BigQuery as cheaply as possible. What should you do?

Accepted Answer

Store the data in Google Cloud Datastore. Use Google Cloud Dataflow to query BigQuery and combine the data programmatically with the data stored in Cloud Datastore

Answer

Store the data in a file in a regional Google Cloud Storage bucket. Use Cloud Dataflow to query BigQuery and combine the data programmatically with the data stored in Google Cloud Storage.

Answer

Load the data every 30 minutes into a new partitioned table in BigQuery.

Answer

Store and update the data in a regional Google Cloud Storage bucket and create a federated data source in BigQuery

PDE Practice Questions

Unlock the full exam and previous versions

Syntax error: Expected end of statement but got at [4:11]

Create an account to continue.

Syntax error: Expected end of statement but got at [4:11]

Create an account to continue.

Related exams