Question 111
You are the database administrator of a Cloud SQL for PostgreSQL instance that has pgaudit disabled. Users are complaining that their queries are taking longer to execute and performance has degraded over the past few months. You need to collect and analyze query performance data to help identity slow-running queries. What should you do?
Question 112
You have deployed a Cloud SQL for SQL Server instance. In addition, you created a cross-region read replica for disaster recovery (DR) purposes. Your company requires you to maintain and monitor a recovery point objective (RPO) of less than 5 minutes. You need to verify that your cross-region read replica meets the allowed RPO. What should you do?
Question 113
You are managing multiple applications connecting to a database on Cloud SQL for PostgreSQL.
You need to be able to monitor database performance to easily identify applications with long- running and resource-intensive queries. What should you do?
You need to be able to monitor database performance to easily identify applications with long- running and resource-intensive queries. What should you do?
Question 114
Your company is adopting AlloyDB for a business-critical application with the following requirements:
- RTO: Under 4 hours
- RPO: 6 hours (maximum data loss tolerance)
- Daily backups with a 7-day retention period
You need to design a solution to meet these requirements.
What should you do?
- RTO: Under 4 hours
- RPO: 6 hours (maximum data loss tolerance)
- Daily backups with a 7-day retention period
You need to design a solution to meet these requirements.
What should you do?
Question 115
An analytics team needs to read data out of Cloud SQL for SQL Server and update a table in Cloud Spanner.
You need to create a service account and grant least privilege access using predefined roles. What roles should you assign to the service account?
You need to create a service account and grant least privilege access using predefined roles. What roles should you assign to the service account?