Free Google Professional-Data-Engineer Exam Questions

Question 1

You are using Google BigQuery as your data warehouse. Your users report that the following simple query is running very slowly, no matter when they run the query: SELECT country, state, city FROM [myproject:mydataset.mytable] GROUP BY country You check the query plan for the query and see the following output in the Read section of Stage:1:

What is the most likely cause of the delay for this query?

A : ers are running too many concurrent queries in the system

B : [myproject:mydataset.mytable] table has too many partitions

C : ther the state or the city columns in the [myproject:mydataset.mytable] table have too many NULL values

D : t rows in the [myproject:mydataset.mytable] table have the same value in the country column, causing data skew

Answer: A

Question 2

You have a BigQuery dataset named "customers". All tables will be tagged by using a Data Catalog tag

template named "gdpr". The template contains one mandatory field, "has sensitive data~. with a boolean value.

All employees must be able to do a simple search and find tables in the dataset that have either true or false in

the "has sensitive data" field. However, only the Human Resources (HR) group should be able to see the data

inside the tables for which "hass-ensitive-data" is true. You give the all employees group the

bigquery.metadataViewer and bigquery.connectionUser roles on the dataset. You want to minimize

configuration overhead. What should you do next?

A : Create the "gdpr" tag template with private visibility. Assign the bigquery -dataViewer role to the HRgroup on the tables that contain sensitive data.

B : Create the ~gdpr" tag template with private visibility. Assign the datacatalog. tagTemplateViewer roleon this tag to the all employeesgroup, and assign the bigquery.dataViewer role to the HR group on the tables that contain sensitive data.

C : Create the "gdpr" tag template with public visibility. Assign the bigquery. dataViewer role to the HRgroup on the tables that containsensitive data.

D : Create the "gdpr" tag template with public visibility. Assign the datacatalog. tagTemplateViewer role onthis tag to the all employees.group, and assign the bijquery.dataViewer role to the HR group on the tables that contain sensitive data.

Answer: D

Question 3

You are building a model to make clothing recommendations. You know a user’s fashion preference is likely to change over time, so you build a data pipeline to stream new data back to the model as it becomes available. How should you use this data to train the model?

A : ntinuously retrain the model on just the new data.

B : ntinuously retrain the model on a combination of existing data and the new data.

C : ain on the existing data while using the new data as your test set.

D : ain on the new data while using the existing data as your test set.

Answer: C

Question 4

You are developing a data pipeline that will run several data transformation programs on Compute Engine virtual machines. You do not want to use your credentials for authenticating and authorizing these programs. You want to follow Google Cloud recommended practices, how would you authenticate and authorize the data transformation programs?

A : Create a Gmail account and use that account to create an IAM group. Store the password for the group in Secret Manager.

B : Create a service account and assign roles to the service account that are needed to execute the data transformation programs. Use Google managed keys to store both public and private portion of the service account keys.

C : Create a Gmail account and use that account to create an IAM user. Store the password for the account in Secret Manager.

D : Create a service account and assign roles to the service account that are needed to execute the data transformation programs. Use Secret Manager to store service account keys.

Answer: B

Question 5

You work for a large ecommerce company. You are using Pub/Sub to ingest the clickstream data to Google Cloud for analytics. You observe that when a new subscriber connects to an existing topic to analyze data, they are unable to subscribe to older data for an upcoming yearly sale event in two months, you need a solution that, once implemented, will enable any new subscriber to read the last 30 days of data. What should you do?

A : Create a new topic, and publish the last 30 days of data each time a new subscriber connects to an existing topic.

B : Set the topic retention policy to 30 days.

C : Set the subscriber retention policy to 30 days.

D : Ask the source system to re-push the data to Pub/Sub, and subscribe to it.

Answer: B