Your organization uses a BigQuery table that is partitioned by ingestion time. You need to remove
data that is older than one year to reduce your organizations storage costs. You want to use the most
efficient approach while minimizing cost. What should you do?
You are migrating data from a legacy on-premises MySQL database to Google Cloud. The database
contains various tables with different data types and sizes, including large tables with millions of
rows and transactional dat
a. You need to migrate this data while maintaining data integrity, and minimizing downtime and cost.
What should you do?
Your retail organization stores sensitive application usage data in Cloud Storage. You need to encrypt
the data without the operational overhead of managing encryption keys. What should you do?
Your organization sends IoT event data to a Pub/Sub topic. Subscriber applications read and perform
transformations on the messages before storing them in the data warehouse. During particularly
busy times when more data is being written to the topic, you notice that the subscriber applications
are not acknowledging messages within the deadline. You need to modify your pipeline to handle
these activity spikes and continue to process the messages. What should you do?
You work for an ecommerce company that has a BigQuery dataset that contains customer purchase
history, demographics, and website interactions. You need to build a machine learning (ML) model to
predict which customers are most likely to make a purchase in the next month. You have limited
engineering resources and need to minimize the ML expertise required for the solution. What should
you do?