Google Professional Data Engineer Quiz 3 Topic 6 Questions 11-15

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 dat

a. What should you do?

AUse 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.

BUse 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.

CSpecify 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.

DSpecify 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.

Show Answer

Question: 2

Your companyâ€™s on-premises Apache Hadoop servers are approaching end-of-life, and IT has decided to migrate the cluster to Google Cloud Dataproc. A like-for-like migration of the cluster would require 50 TB of Google Persistent Disk per node. The CIO is concerned about the cost of using that much block storage. You want to minimize the storage cost of the migration. What should you do?

APut the data into Google Cloud Storage.

BUse preemptible virtual machines (VMs) for the Cloud Dataproc cluster.

CTune the Cloud Dataproc cluster so that there is just enough disk for all data.

DMigrate some of the cold data into Google Cloud Storage, and keep only the hot data in Persistent Disk.
References:

Show Answer

Question: 3

Your company is using WHILECARD tables to query data across multiple tables with similar names. The SQL statement is currently failing with the following error:

# Syntax error : Expected end of statement but got â€œ-â€œ at [4:11]

SELECT age

FROM

bigquery-public-data.noaa_gsod.gsod

WHERE

age != 99

AND_TABLE_SUFFIX = â€˜1929â€™

ORDER BY

age DESC

Which table name will make the SQL statement work correctly?

A'bigquery-public-data.noaa_gsod.gsod'

Bbigquery-public-data.noaa_gsod.gsod*

C'bigquery-public-data.noaa_gsod.gsod'*

D'bigquery-public-data.noaa_gsod.gsod*`
References:

Show Answer

Question: 4

You are integrating one of your internal IT applications and Google BigQuery, so users can query BigQuery from the applicationâ€™s interface. You do not want individual users to authenticate to BigQuery and you do not want to give them access to the dataset. You need to securely access BigQuery from your IT application.

What should you do?

ACreate groups for your users and give those groups access to the dataset

BIntegrate with a single sign-on (SSO) platform, and pass each user's credentials along with the query
request

CCreate a service account and grant dataset access to that account. Use the service account's private key to access the dataset

DCreate a dummy user and grant dataset access to that user. Store the username and password for that user in a file on the files system, and use those credentials to access the BigQuery dataset

Show Answer

Question: 5

You are designing the database schema for a machine learning-based food ordering service that will predict what users want to eat. Here is some of the information you need to store:

The user profile: What the user likes and doesnâ€™t like to eat

The user account information: Name, address, preferred meal times

The order information: When orders are made, from where, to whom

The database will be used to store all the transactional data of the product. You want to optimize the data schem

a. Which Google Cloud Platform product should you use?

ABigQuery

BCloud SQL

CCloud Bigtable

DCloud Datastore

Show Answer

Google Professional Data Engineer Quiz:3 Topic:6 Questions:11-15