Data 241-250

What should you do?

• 
• 
• 
• 

What should you do to optimize for cost?

• 
• 
• 
• 

You need to exclude VM rows with fewer than 8 vCPU in your report. What should you do?

• Create a view with a filter to drop rows with fewer than 8 vCPU, and use the UNNEST operator.

• Create a materialized view with a filter to drop rows with fewer than 8 vCPU, and use the WITH common table expression.

• Create a view with a filter to drop rows with fewer than 8 vCPU, and use the WITH common table expression.

• Use Dataflow to batch process and write the result to another BigQuery table.

What should you do?

• 
• 
• 
• 

You have one BigQuery dataset which includes customers’ street addresses. You want to retrieve all occurrences of street addresses from the dataset. What should you do?

• 
• 
• 
• 

You are developing a model to identify the factors that lead to sales conversions for your customers. You have completed processing your data. You want to continue through the model development lifecycle. What should you do next?

• Use your model to run predictions on fresh customer input data.

• Monitor your model performance, and make any adjustments needed.

• Delineate what data will be used for testing and what will be used for training the model.

• Test and evaluate your model on your curated data to determine how well the model performs.

What should you do?

• Ask each team to create authorized views of their data. Grant the biquery.jobUser role to each team.

• Create a BigQuery scheduled query to replicate all customer data into team projects.

• Ask each team to publish their data in Analytics Hub. Direct the other teams to subscribe to them.

• Enable each team to create materialized views of the data they need to access in their projects.

Which query should you use?

• 
• 
• 
• 

You have designed an Apache Beam processing pipeline that reads from a Pub/Sub topic. The topic has a message retention duration of one day, and writes to a Cloud Storage bucket. You need to select a bucket location and processing strategy to prevent data loss in case of a regional outage with an RPO of 15 minutes. What should you do?

• 
• 
• 
• 

What should you do?

• Adopt multi-regional Cloud Storage buckets in your architecture.

• Adopt two regional Cloud Storage buckets, and update your application to write the output on both buckets.

• Adopt a dual-region Cloud Storage bucket, and enable turbo replication in your architecture.

• Adopt two regional Cloud Storage buckets, and create a daily task to copy from one bucket to the other.