You set up a streaming data insert into a Redis cluster via a Kafka cluster. Both clusters are running on Compute Engine instances. You need to encrypt data at rest with encryption keys that you can create, rotate, and destroy as needed. What should you do?

• A.Create encryption keys in Cloud Key Management Service. Use those keys to encrypt your data in all of the Compute Engine cluster instances.
• B.Create encryption keys in Cloud Key Management Service. Reference those keys in your API service calls when accessing the data in your Compute Engine cluster instances.
• C.Create a dedicated service account, and use encryption at rest to reference your data stored in your Compute Engine cluster instances as part of your API service calls.
• D.Create encryption keys locally. Upload your encryption keys to Cloud Key Management Service. Use those keys to encrypt your data in all of the Compute Engine cluster instances.

Comment: *

Name: *

Email: *

Verification: *

The _________ for Cloud Bigtable makes it possible to use Cloud Bigtable in a Cloud Dataflow pipeline.

• A.Cloud Dataflow connector
• B.DataFlow SDK
• C.BiqQuery API
• D.BigQuery Data Transfer Service

Comment: *

Name: *

Email: *

Verification: *

Your company is in a highly regulated industry. One of your requirements is to ensure individual users have access only to the minimum amount of information required to do their jobs. You want to enforce this requirement with Google BigQuery. Which three approaches can you take? (Choose three.)

• A.Disable writes to certain tables.
• B.Restrict access to tables by role.
• C.Ensure that the data is encrypted at all times.
• D.Restrict BigQuery API access to approved users.
• E.Segregate data across multiple tables or databases.
• F.Use Google Stackdriver Audit Logging to determine policy violations.

Comment: *

Name: *

Email: *

Verification: *

You need to set access to BigQuery for different departments within your company. Your solution should comply with the following requirements:
* Each department should have access only to their data.
* Each department will have one or more leads who need to be able to create and update tables and provide them to their team.
* Each department has data analysts who need to be able to query but not modify data.
How should you set access to the data in BigQuery?

• A.Create a table for each department. Assign the department leads the role of Owner, and assign the data analysts the role of Editor on the project the table is in.
• B.Create a table for each department. Assign the department leads the role of Editor, and assign the data analysts the role of Viewer on the project the table is in.
• C.Create a dataset for each department. Assign the department leads the role of WRITER, and assign the data analysts the role of READER on their dataset.
• D.Create a dataset for each department. Assign the department leads the role of OWNER, and assign the data analysts the role of WRITER on their dataset.

Comment: *

Name: *

Email: *

Verification: *

What are two methods that can be used to denormalize tables in BigQuery?

• A.1) Split table into multiple tables; 2) Use a partitioned table
• B.1) Join tables into one table; 2) Use nested repeated fields
• C.1) Use a partitioned table; 2) Join tables into one table
• D.1) Use nested repeated fields; 2) Use a partitioned table

Comment: *

Name: *

Email: *

Verification: *