Practice Professional-Data-Engineer Exam Online

Question 1

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 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 : Use 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 : Use 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 : Specify 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 : Specify 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

You work for a bank. You have a labelled dataset that contains information on already granted loan application and whether these applications have been defaulted. You have been asked to train a model to predict default rates for credit applicants. What should you do?

A : Increase the size of the dataset by collecting additional data.

B : Train a linear regression to predict a credit default risk score.

C : Remove the bias from the data and collect applications that have been declined loans.

D : Match loan applicants with their social profiles to enable feature engineering.

Answer: B

Question 4

Which of these statements about exporting data from BigQuery is false?

A : To export more than 1 GB of data, you need to put a wildcard in the destination filename.

B : The only supported export destination is Google Cloud Storage.

C : Data can only be exported in JSON or Avro format.

D : The only compression option available is GZIP.

Answer: C

Question 5

You receive data files in CSV format monthly from a third party. You need to cleanse this data, but every third

month the schema of the files changes. Your requirements for implementing these transformations include:

Executing the transformations on a schedule

Enabling non-developer analysts to modify transformations

Providing a graphical tool for designing transformations

What should you do?

A : Use Cloud Dataprep to build and maintain the transformation recipes, and execute them on a scheduled basis

B : Load each month’s CSV data into BigQuery, and write a SQL query to transform the data to a standard schema. Merge the transformed tables together with a SQL query

C : Help the analysts write a Cloud Dataflow pipeline in Python to perform the transformation. The Python code should be stored in a revision control system and modified as the incoming data’s schema changes

D : Use Apache Spark on Cloud Dataproc to infer the schema of the CSV file before creating a Dataframe. Then implement the transformations in Spark SQL before writing the data out to Cloud Storage and loading into BigQuery

Answer: D

Name:	Cloud Certified Professional Data Engineer
Exam Code:	Professional-Data-Engineer
Certification:	Google Cloud Certified
Vendor:	Google
Total Questions:	433
Last Updated:	Apr 23, 2024

Google Professional-Data-Engineer