Free Google Professional-Data-Engineer Exam Questions

Become Google Certified with updated Professional-Data-Engineer exam questions and correct answers

Page: 1 / 95

Total 472 Questions | Updated On: Aug 21, 2019

Add To Cart

Question 1

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 : rtition by transaction time; cluster by state first, then city then store ID

B : rtition by transaction tome cluster by store ID first, then city, then stale

C : p-level cluster by stale first, then city then store

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

Answer: C

Question 2

You create a new report for your large team in Google Data Studio 360. The report uses Google BigQuery as

its data source. It is company policy to ensure employees can view only the data associated with their region,

so you create and populate a table for each region. You need to enforce the regional access policy to the data.

Which two actions should you take? (Choose two.)

A : ure all the tables are included in global dataset.

B : ure each table is included in a dataset for a region.

C : just the settings for each table to allow a related region-based security group view access.

D : just the settings for each view to allow a related region-based security group view access.

E : just the settings for each dataset to allow a related region-based security group view access.

Answer: A,D

Question 3

Your company's customer_order table in BigOuery stores the order history for 10 million customers, with a

table size of 10 PB. You need to create a dashboard for the support team to view the order history. The

dashboard has two filters, countryname and username. Both are string data types in the BigQuery table. When

a filter is applied, the dashboard fetches the order history from the table and displays the query results.

However, the dashboard is slow to show the results when applying the filters to the following query:

How should you redesign the BigQuery table to support faster access?

A : Cluster the table by country field, and partition by username field.

B : Partition the table by country and username fields.

C : Cluster the table by country and username fields

D : Partition the table by _PARTITIONTIME.

Answer: C

Question 4

When using Cloud Data Fusion you receive an error that a Dataproc operation failed and the user is not authorized to act as a service account. What would you do to correct this problem?

A : Create a Cloud Dataproc cluster before starting Cloud Data Fusion.

B : Grant the Service Account User role to Cloud Data Fusion.

C : Grant the Service Account User role to Cloud Dataproc.

D : Ensure both Cloud Data Fusion and Cloud Dataproc are running in the same zone.

Answer: B

Question 5

What are the minimum permissions needed for a service account used with Google Dataproc?

A : ecute to Google Cloud Storage; write to Google Cloud Logging

B : ite to Google Cloud Storage; read to Google Cloud Logging

C : ecute to Google Cloud Storage; execute to Google Cloud Logging

D : ad and write to Google Cloud Storage; write to Google Cloud Logging

Answer: D

Page: 1 / 95

Total 472 Questions | Updated On: Aug 21, 2019

Add To Cart