You are working on a sensitive project involving private user dat
a. You have set up a project on Google Cloud Platform to house your work internally. An external consultant is going to assist with coding a complex transformation in a Google Cloud Dataflow pipeline for your project. How should you maintain users' privacy?

• A.Grant the consultant the Cloud Dataflow Developer role on the project.
• B.Create a service account and allow the consultant to log on with it.
• C.Grant the consultant the Viewer role on the project.
• D.Create an anonymized sample of the data for the consultant to work with in a different project.

Comment: *

Name: *

Email: *

Verification: *

Which is the preferred method to use to avoid hotspotting in time series data in Bigtable?

• A.Field promotion
• B.Randomization
• C.Salting
• D.Hashing

Comment: *

Name: *

Email: *

Verification: *

You are designing storage for two relational tables that are part of a 10-TB database on Google Cloud. You want to support transactions that scale horizontally. You also want to optimize data for range queries on nonkey columns. What should you do?

• A.Use Cloud SQL for storage. Use Cloud Dataflow to transform data to support query patterns.
• B.Use Cloud Spanner for storage. Use Cloud Dataflow to transform data to support query patterns.
• C.Use Cloud Spanner for storage. Add secondary indexes to support query patterns.
• D.Use Cloud SQL for storage. Add secondary indexes to support query patterns.

Comment: *

Name: *

Email: *

Verification: *

Which of these is not a supported method of putting data into a partitioned table?

• A.If you have existing data in a separate file for each day, then create a partitioned table and upload each file into the appropriate partition.
• B.Run a query to get the records for a specific day from an existing table and for the destination table, specify a partitioned table ending with the day in the format "$YYYYMMDD".
• C.Create a partitioned table and stream new records to it every day.
• D.Use ORDER BY to put a table's rows into chronological order and then change the table's type to "Partitioned".

Comment: *

Name: *

Email: *

Verification: *

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

• A.500 TB
• B.1 GB
• C.1 TB
• D.500 GB

Comment: *

Name: *

Email: *

Verification: *