You want to ensure Dress4Win's sales and tax records remain available for infrequent viewing by auditors
for at least 10 years.
Cost optimization is your top priority.
Which cloud services should you choose?

• A.Google Cloud Storage Coldline to store the data, and gsutil to access the data.
• B.Google Cloud Storage Nearline to store the data, and gsutil to access the data.
• C.Google Bigtabte with US or EU as location to store the data, and gcloud to access the data.
• D.BigQuery to store the data, and a web server cluster in a managed instance group to access the data.
  Google Cloud SQL mirrored across two distinct regions to store the data, and a Redis cluster in a
  managed instance group to access the data.

Comment: *

Name: *

Email: *

Verification: *

For this question, refer to the TerramEarth case study.
TerramEarth plans to connect all 20 million vehicles in the field to the cloud. This increases the volume to 20 million 600 byte records a second for 40 TB an hour. How should you design the data ingestion?

• A.Vehicles write data directly to GCS.
• B.Vehicles write data directly to Google Cloud Pub/Sub.
• C.Vehicles stream data directly to Google BigQuery.
• D.Vehicles continue to write data using the existing system (FTP).

Comment: *

Name: *

Email: *

Verification: *

The database administration team has asked you to help them improve the performance of their new
database server running on Google Compute Engine. The database is for importing and normalizing their
performance statistics and is built with MySQL running on Debian Linux. They have an n1-standard-8
virtual machine with 80 GB of SSD persistent disk.
What should they change to get better performance from this system?

• A.Create a new virtual machine running PostgreSQL
• B.Increase the virtual machine's memory to 64 GB
• C.Dynamically resize the SSD persistent disk to 500 GB
• D.Modify all of their batch jobs to use bulk inserts into the database
• E.Migrate their performance metrics warehouse to BigQuery

Comment: *

Name: *

Email: *

Verification: *

You are working at a sports association whose members range in age from 8 to 30. The association collects a large amount of health data, such as sustained injuries. You are storing this data in BigQuery. Current legislation requires you to delete such information upon request of the subject. You want to design a solution that can accommodate such a request. What should you do?

• A.Create a BigQuery view over the table that contains all data. Upon a deletion request, exclude the rows that affect the subject's data from this view. Use this view instead of the source table for all analysis tasks.
• B.Use a unique identifier for each individual. Upon a deletion request, delete all rows from BigQuery with this identifier.
• C.Use a unique identifier for each individual. Upon a deletion request, overwrite the column with the unique identifier with a salted SHA256 of its value.
• D.When ingesting new data in BigQuery, run the data through the Data Loss Prevention (DLP) API to identify any personal information. As part of the DLP scan, save the result to Data Catalog. Upon a deletion request, query Data Catalog to find the column with personal information.

Comment: *

Name: *

Email: *

Verification: *

Your BigQuery project has several users. For audit purposes, you need to see how many queries each user ran in the last month.

• A.Connect Google Data Studio to BigQuery. Create a dimension for the users and a metric for the amount of queries per user.
• B.In the BigQuery interface, execute a query on the JOBS table to get the required information.
• C.Use 'bq show' to list all jobs. Per job, use 'bq Is' to list job information and get the required information.
• D.Use Cloud Audit Logging to view Cloud Audit Logs, and create a filter on the query operation to get the

Comment: *

Name: *

Email: *

Verification: *