Data 211-220

What should you do?

• 
• 
• 
• 

What should you do?

• 
• 
• 
• 

What should you do?

• Enable zonal high availability on the primary instance. Create a new read replica in a new region.

• Create a cascading read replica from the existing read replica in Region3.

• Create two new read replicas from the new primary instance, one in Region3 and one in a new region.

• Create a new read replica in Region1, promote the new read replica to be the primary instance, and enable zonal high availability.

What should you do? (Choose two.)

• Create two separate authorized datasets; one for the data analytics team and another for the consumer support team.

• Ensure that the data analytics team members do not have the Data Catalog Fine-Grained Reader role for the policy tags.

• Replace the authorized dataset with an authorized view. Use row-level security and apply filter_expression to limit data access.

• Remove the bigquery.dataViewer role from the data analytics team on the authorized datasets.

• Enforce access control in the policy tag taxonomy.

What should you do?

• 
• 
• 
• 

You are administering a BigQuery dataset that uses a customer-managed encryption key (CMEK). You need to share the dataset with a partner organization that does not have access to your CMEK. What should you do?

• Provide the partner organization a copy of your CMEKs to decrypt the data.

• Export the tables to parquet files to a Cloud Storage bucket and grant the storageinsights.viewer role on the bucket to the partner organization.

• Copy the tables you need to share to a dataset without CMEKs. Create an Analytics Hub listing for this dataset.

• Create an authorized view that contains the CMEK to decrypt the data when accessed.

You have a Standard Tier Memorystore for Redis instance deployed in a production environment. You need to simulate a Redis instance failover in the most accurate disaster recovery situation, and ensure that the failover has no impact on production data. What should you do?

• Create a Standard Tier Memorystore for Redis instance in the development environment. Initiate a manual failover by using the limited-data-loss data protection mode.

• Create a Standard Tier Memorystore for Redis instance in a development environment. Initiate a manual failover by using the force-data-loss data protection mode.

• Increase one replica to Redis instance in production environment. Initiate a manual failover by using the force-data-loss data protection mode.

• Initiate a manual failover by using the limited-data-loss data protection mode to the Memorystore for Redis instance in the production environment.

How should you redesign the BigQuery table to support faster access?

• Cluster the table by country and username fields.

• Cluster the table by country field, and partition by username field.

• Partition the table by country and username fields.

• Partition the table by _PARTITIONTIME.

What should you do?

• 
• 
• 
• 

You are using BigQuery with a multi-region dataset that includes a table with the daily sales volumes. This table is updated multiple times per day. You need to protect your sales table in case of regional failures with a recovery point objective (RPO) of less than 24 hours, while keeping costs to a minimum. What should you do?

• Schedule a daily export of the table to a Cloud Storage dual or multi-region bucket.

• Schedule a daily copy of the dataset to a backup region.

• Schedule a daily BigQuery snapshot of the table.

• Modify ETL job to load the data into both the current and another backup region.