Data 231-240

You need to assign access rights to these two groups. What should you do?

• 
• 
• 
• 

You need to resolve the concurrency issue. What should you do?

• Increase the slot capacity of the project with baseline as 0 and maximum reservation size as 3000.

• Update SQL pipelines to run as a batch query, and run ad-hoc queries as interactive query jobs.

• Increase the slot capacity of the project with baseline as 2000 and maximum reservation size as 3000.

• Update SQL pipelines and ad-hoc queries to run as interactive query jobs.

You want to encrypt the customer data stored in BigQuery. You need to implement per-user crypto-deletion on data stored in your tables. You want to adopt native features in Google Cloud to avoid custom solutions. What should you do?

• Implement Authenticated Encryption with Associated Data (AEAD) BigQuery functions while storing your data in BigQuery.

• Create a customer-managed encryption key (CMEK) in Cloud KMS. Associate the key to the table while creating the table.

• Create a customer-managed encryption key (CMEK) in Cloud KMS. Use the key to encrypt data before storing in BigQuery.

• Encrypt your data during ingestion by using a cryptographic library supported by your ETL pipeline.

What should you do?

• 
• 
• 
• 

What should you do?

• 
• 
• 
• 

What should you do?

• 
• 
• 
• 

What should you do?

• 
• 
• 
• 

What should you do?

• 
• 
• 
• 

You are on the data governance team and are implementing security requirements to deploy resources. You need to ensure that resources are limited to only the europe-west3 region. You want to follow Google-recommended practices.

• 
• 
• 
• 

You recently deployed several data processing jobs into your Cloud Composer 2 environment. You notice that some tasks are failing in Apache Airflow. On the monitoring dashboard, you see an increase in the total workers memory usage, and there were worker pod evictions. You need to resolve these errors. What should you do? (Choose two.)

• Increase the directed acyclic graph (DAG) file parsing interval.

• Increase the Cloud Composer 2 environment size from medium to large.

• Increase the maximum number of workers and reduce worker concurrency.

• Increase the memory available to the Airflow workers.

• Increase the memory available to the Airflow triggerer.