Professional-Data-Engineer Google Exam Questions and Free Practice Test

Question 25

- (Exam Topic 6)
You are a head of BI at a large enterprise company with multiple business units that each have different priorities and budgets. You use on-demand pricing for BigQuery with a quota of 2K concurrent on-demand slots per project. Users at your organization sometimes don’t get slots to execute their query and you need to correct this. You’d like to avoid introducing new projects to your account.
What should you do?

A. Convert your batch BQ queries into interactive BQ queries.

B. Create an additional project to overcome the 2K on-demand per-project quota.

C. Switch to flat-rate pricing and establish a hierarchical priority model for your projects.

D. Increase the amount of concurrent slots per project at the Quotas page at the Cloud Console.

Correct Answer:C
Reference https://cloud.google.com/blog/products/gcp/busting-12-myths-about-bigquery

Question 26

- (Exam Topic 6)
You are designing storage for very large text files for a data pipeline on Google Cloud. You want to support ANSI SQL queries. You also want to support compression and parallel load from the input locations using Google recommended practices. What should you do?

A. Transform text files to compressed Avro using Cloud Dataflo

B. Use BigQuery for storage and query.

C. Transform text files to compressed Avro using Cloud Dataflo

D. Use Cloud Storage and BigQuery permanent linked tables for query.

E. Compress text files to gzip using the Grid Computing Tool

F. Use BigQuery for storage and query.

G. Compress text files to gzip using the Grid Computing Tool

H. Use Cloud Storage, and then import into Cloud Bigtable for query.

Correct Answer:D

Question 27

- (Exam Topic 6)
Your globally distributed auction application allows users to bid on items. Occasionally, users place identical bids at nearly identical times, and different application servers process those bids. Each bid event contains the item, amount, user, and timestamp. You want to collate those bid events into a single location in real time to determine which user bid first. What should you do?

A. Create a file on a shared file and have the application servers write all bid events to that fil

B. Process the file with Apache Hadoop to identify which user bid first.

C. Have each application server write the bid events to Cloud Pub/Sub as they occu

D. Push the events from Cloud Pub/Sub to a custom endpoint that writes the bid event information into Cloud SQL.

E. Set up a MySQL database for each application server to write bid events int

F. Periodically query each of those distributed MySQL databases and update a master MySQL database with bid event information.

G. Have each application server write the bid events to Google Cloud Pub/Sub as they occu

H. Use a pull subscription to pull the bid events using Google Cloud Dataflo

I. Give the bid for each item to the userin the bid event that is processed first.

Correct Answer:C

Question 28

- (Exam Topic 6)
You are migrating a table to BigQuery and are deeding on the data model. Your table stores information related to purchases made across several store locations and includes information like the time of the transaction, items purchased, the store ID and the city and state in which the store is located You frequently query this table to see how many of each item were sold over the past 30 days and to look at purchasing trends by state city and individual store. You want to model this table to minimize query time and cost. What should you do?

A. Partition by transaction time; cluster by state first, then city then store ID

B. Partition by transaction tome cluster by store ID first, then city, then stale

C. Top-level cluster by stale first, then city then store

D. Top-level cluster by store ID first, then city then state.

Correct Answer:C

Question 29

- (Exam Topic 5)
Which of these sources can you not load data into BigQuery from?

A. File upload

B. Google Drive

C. Google Cloud Storage

D. Google Cloud SQL

Correct Answer:D
You can load data into BigQuery from a file upload, Google Cloud Storage, Google Drive, or Google Cloud Bigtable. It is not possible to load data into BigQuery directly from Google Cloud SQL. One way to get data from Cloud SQL to BigQuery would be to export data from Cloud SQL to Cloud Storage and then load it from there.
Reference: https://cloud.google.com/bigquery/loading-data

Question 30

- (Exam Topic 6)
You are operating a streaming Cloud Dataflow pipeline. Your engineers have a new version of the pipeline with a different windowing algorithm and triggering strategy. You want to update the running pipeline with the new version. You want to ensure that no data is lost during the update. What should you do?

A. Update the Cloud Dataflow pipeline inflight by passing the --update option with the --jobName set to the existing job name

B. Update the Cloud Dataflow pipeline inflight by passing the --update option with the --jobName set to a new unique job name

C. Stop the Cloud Dataflow pipeline with the Cancel optio

D. Create a new Cloud Dataflow job with the updated code

E. Stop the Cloud Dataflow pipeline with the Drain optio

F. Create a new Cloud Dataflow job with the updated code

Correct Answer:A

START Professional-Data-Engineer EXAM