You manage a meeting booking application that uses Cloud SQL. During an important launch, the Cloud SQL instance went through a maintenance event that resulted in a downtime of more than 5 minutes and adversely affected your production application. You need to immediately address the maintenance issue to prevent any unplanned events in the future. What should you do?
A. Set your production instance's maintenance window to non-business hours.
B. Migrate the Cloud SQL instance to Cloud Spanner to avoid any future disruptions due to maintenance.
C. Contact Support to understand why your Cloud SQL instance had a downtime of more than 5 minutes.
D. Use Cloud Scheduler to schedule a maintenance window of no longer than 5 minutes.
Your organization is running a low-latency reporting application on Microsoft SQL Server. In addition to the database engine, you are using SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), and SQL Server Integration Services (SSIS) in your on-premises environment. You want to migrate your Microsoft SQL Server database instances to Google Cloud. You need to ensure minimal disruption to the existing architecture during migration. What should you do?
A. Migrate to Cloud SQL for SQL Server.
B. Migrate to Cloud SQL for PostgreSQL.
C. Migrate to Compute Engine.
D. Migrate to Google Kubernetes Engine (GKE).
You are designing a database architecture for a global application that stores information about public parks worldwide. The application uses the database for read-only purposes, and a centralized batch job updates the database nightly. You want to select an open source, SQL-compliant database. What should you do?
A. Use Bigtable with multi-region clusters.
B. Use Memorystore for Redis with multi-zones within a region.
C. Use Cloud SQL for PostgreSQL with cross-region replicas.
D. Use Cloud Spanner with multi-region configuration.
Your customer is running a MySQL database on-premises with read replicas. The nightly incremental backups are expensive and add maintenance overhead. You want to follow Google-recommended practices to migrate the database to Google Cloud, and you need to ensure minimal downtime. What should you do?
A. Create a Google Kubernetes Engine (GKE) cluster, install MySQL on the cluster, and then import the dump file.
B. Use the mysqldump utility to take a backup of the existing on-premises database, and then import it into Cloud SQL.
C. Create a Compute Engine VM, install MySQL on the VM, and then import the dump file.
D. Create an external replica, and use Cloud SQL to synchronize the data to the replica.
Your organization operates in a highly regulated industry. Separation of concerns (SoC) and security principle of least privilege (PoLP) are critical. The operations team consists of:
Person A is a database administrator.
Person B is an analyst who generates metric reports.
Application C is responsible for automatic backups.
You need to assign roles to team members for Cloud Spanner. Which roles should you assign?
A. roles/spanner.databaseAdmin for Person A roles/spanner.databaseReader for Person B roles/spanner.backupWriter for Application C
B. roles/spanner.databaseAdmin for Person A roles/spanner.databaseReader for Person B roles/spanner.backupAdmin for Application C
C. roles/spanner.databaseAdmin for Person A roles/spanner.databaseUser for Person B roles/spanner databaseReader for Application C
D. roles/spanner.databaseAdmin for Person A roles/spanner.databaseUser for Person B roles/spanner.backupWriter for Application C
Your team is building an application that stores and analyzes streaming time series financial data. You need a database solution that can perform time series-based scans with sub-second latency. The solution must scale into the hundreds of terabytes and be able to write up to 10k records per second and read up to 200 MB per second. What should you do?
A. Use Firestore.
B. Use Bigtable
C. Use BigQuery.
D. Use Cloud Spanner.
Your company is developing a global ecommerce website on Google Cloud. Your development team is working on a shopping cart service that is durable and elastically scalable with live traffic. Business disruptions from unplanned downtime are expected to be less than 5 minutes per month. In addition, the application needs to have very low latency writes. You need a data storage solution that has high write throughput and provides 99.99% uptime. What should you do?
A. Use Cloud SQL for data storage.
B. Use Cloud Spanner for data storage.
C. Use Memorystore for data storage.
D. Use Bigtable for data storage.
You are managing a Cloud SQL for PostgreSQL instance in Google Cloud. You need to test the high availability of your Cloud SQL instance by performing a failover. You want to use the cloud command.
What should you do?
A. Use gcloud sql instances failover
B. Use gcloud sql instances failover
C. Use gcloud sql instances promote-replica
D. Use gcloud sql instances promote-replica
Your organization is running a MySQL workload in Cloud SQL. Suddenly you see a degradation in database performance. You need to identify the root cause of the performance degradation. What should you do?
A. Use Logs Explorer to analyze log data.
B. Use Cloud Monitoring to monitor CPU, memory, and storage utilization metrics.
C. Use Error Reporting to count, analyze, and aggregate the data.
D. Use Cloud Debugger to inspect the state of an application.
You are configuring a new application that has access to an existing Cloud Spanner database. The new application reads from this database to gather statistics for a dashboard. You want to follow Google-recommended practices when granting Identity and Access Management (IAM) permissions. What should you do?
A. Reuse the existing service account that populates this database.
B. Create a new service account, and grant it the Cloud Spanner Database Admin role.
C. Create a new service account, and grant it the Cloud Spanner Database Reader role.
D. Create a new service account, and grant it the spanner.databases.select permission.
