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: Jan 10, 2025

Add To Cart

Question 1

You want to use a BigQuery table as a data sink. In which writing mode(s) can you use BigQuery as a sink?

A : th batch and streaming

B : gQuery cannot be used as a sink

C : ly batch

D : ly streaming

Answer: A

Question 2

You want to archive data in Cloud Storage. Because some data is very sensitive, you want to use the “Trust No One” (TNO) approach to encrypt your data to prevent the cloud provider staff from decrypting your data. What should you do?

A : gcloud kms keys create to create a symmetric key. Then use gcloud kms encrypt to encrypt each archival file with the key and unique additional authenticated data (AAD). Use gsutil cp to upload each encrypted file to the Cloud Storage bucket, and keep the AAD outside of Google Cloud.

B : gcloud kms keys create to create a symmetric key. Then use gcloud kms encrypt to encrypt each archival file with the key. Use gsutil cp to upload each encrypted file to the Cloud Storage bucket. Manually destroy the key previously used for encryption, and rotate the key once and rotate the key once.

C : ecify customer-supplied encryption key (CSEK) in the .boto configuration file. Use gsutil cp to upload each archival file to the Cloud Storage bucket. Save the CSEK in Cloud Memorystore as permanent storage of the secret.

D : ecify customer-supplied encryption key (CSEK) in the .boto configuration file. Use gsutil cp to upload each archival file to the Cloud Storage bucket. Save the CSEK in a different project that only the security team can access.

Answer: B

Question 3

Which of these are examples of a value in a sparse vector? (Select 2 answers.)

A : [0, 5, 0, 0, 0, 0]

B : [0, 0, 0, 1, 0, 0, 1]

C : [0, 1]

D : [1, 0, 0, 0, 0, 0, 0]

Answer: C,D

Question 4

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?

A : oud Spanner

B : oud Bigtable

C : oud Firestore

D : oud SQL

Answer: D

Question 5

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

Page: 1 / 95

Total 472 Questions | Updated On: Jan 10, 2025

Add To Cart