Domain 4.4: Managing storage and database solutions

You want to automatically transition objects in a Cloud Storage bucket to Archive storage if they haven't been accessed in 365 days. What should you configure?

You are managing a Cloud SQL for PostgreSQL instance. You need to ensure you can recover the database to a specific point in time within the last 7 days in case of accidental data deletion. Which TWO features must be enabled? (Select TWO)

You have a Cloud Storage bucket containing millions of images. You want to automatically transition images older than 90 days to Nearline storage to save costs, and delete images older than 365 days. What is the MOST efficient way to implement this?

You are about to run a complex SQL query in BigQuery that joins several multi-terabyte tables. You are concerned about how much this single query will cost. How can you find out the exact amount of data the query will process BEFORE you run it?

Your application uploads daily reports to a Cloud Storage bucket. These reports are accessed frequently for the first 30 days, but rarely accessed after that. You want to automatically move objects older than 30 days to the Coldline storage class to save money. What is the MOST efficient way to achieve this?

You are about to run a complex SQL query on a multi-terabyte dataset in BigQuery. Because BigQuery charges per byte processed, you want to estimate the cost of the query BEFORE you actually run it. Which TWO methods can you use to find out how much data the query will process? (Select TWO)

You have a Cloud Storage bucket used for storing daily database backups. You want to automatically transition backups older than 30 days to Coldline storage, and delete backups older than 365 days. What is the MOST efficient way to implement this?

You are about to run a complex SQL query in BigQuery that joins several multi-terabyte tables. You are concerned about the potential cost of this query. Which TWO methods can you use to estimate the cost BEFORE executing the query? (Select TWO)

You have an object named `report.pdf` in a Cloud Storage bucket. It is currently stored in the Standard storage class. You want to change its storage class to Nearline using the command line. Which command should you use?

You need to optimize costs for a Cloud Storage bucket used for backups. You want objects to automatically transition to the Coldline storage class 30 days after they are created, and then be permanently deleted 365 days after creation. Which TWO Object Lifecycle Management rules should you configure? (Select TWO)

Your application generates daily log files that are stored in a Cloud Storage Standard bucket. These logs are frequently accessed for the first 30 days. After 30 days, they are rarely accessed but must be kept for 1 year for compliance, after which they can be deleted. What is the MOST automated and cost-effective way to manage these files?

You are about to run a complex SQL query in BigQuery that joins several multi-terabyte tables. You are concerned about how much this specific query will cost. How can you estimate the cost of this query BEFORE executing it?

You have a Cloud Storage bucket that receives thousands of image files daily. You want to automatically transition these files to Nearline storage after 30 days, and then delete them after 365 days. What is the most efficient way to implement this?

A data analyst is about to run a complex SQL query on a multi-terabyte BigQuery dataset. They are concerned about how much the query will cost and want to estimate the data processed before actually executing it. Which TWO methods can they use to estimate the cost? (Select TWO)