Question 1

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?

Options :

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 2

A team of data scientists has been using an on-premises cluster running Hadoop and HBase. They want to migrate to a managed service in Google Cloud. They also want to minimize changes to programs that make extensive use of the HBase API. What GCP service would you recommend?

Options :

A : Bigtable

B : BigQuery

C : Cloud Spanner

D : Cloud Dataflow

Answer: A

Question 3

You are designing a data warehouse in BigQuery to analyze sales data for a telecommunication serviceprovider. You need to create a data model for customers, products, and subscriptions All customers, products,and subscriptions can be updated monthly, but you must maintain a historical record of all data. You plan touse the visualization layer for current and historical reporting. You need to ensure that the data model issimple, easy-to-use. and cost-effective. What should you do?

Options :

A : Create a normalized model with tables for each entity. Use snapshots before updates to track historical data

B : Create a normalized model with tables for each entity. Keep all input files in a Cloud Storage bucket to track historical data

C : Create a denormalized model with nested and repeated fields Update the table and use snapshots to track historical data

D : Create a denormalized, append-only model with nested and repeated fields Use the ingestion timestamp to track historical data.

Answer: D

Question 4

When you store data in Cloud Bigtable, what is the recommended minimum amount of stored data?

Options :

A : 500 TB

B : 1 GB

C : 1 TB

D : 500 GB

Answer: C

Question 5

You receive data files in CSV format monthly from a third party. You need to cleanse this data, but every thirdmonth the schema of the files changes. Your requirements for implementing these transformations include:Executing the transformations on a scheduleEnabling non-developer analysts to modify transformationsProviding a graphical tool for designing transformationsWhat should you do?

Options :

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

Free Professional-Data-Engineer Mock Exam – Practice Online Confidently

Buying Options: