Why managed databases matter in GCP - Challenge Your Understanding

Challenge - 5 Problems

🧠 Conceptual

intermediate

Why choose a managed database service?

Which of the following is the main benefit of using a managed database service like Google Cloud SQL instead of managing your own database on a virtual machine?

A You can avoid paying for the database service and only pay for storage.

B You get automatic backups, patching, and scaling without manual intervention.

C You have full control over the operating system and database software versions.

D You must manually configure replication and failover for high availability.

💡 Hint

Think about what tasks a managed service automates for you.

Managed database services handle backups, updates, and scaling automatically, reducing operational work and risk.

❓ service_behavior

intermediate

Behavior of managed database backups

What happens when you enable automated backups on a managed database instance in Google Cloud SQL?

A The service automatically creates daily backups and retains them for a configured period.

B Backups are created only when you manually trigger them from the console.

C Backups are stored only on the same disk as the database instance.

D Backups cause the database to shut down temporarily during the process.

💡 Hint

Consider how managed services handle backups to avoid downtime.

Managed databases create daily backups automatically and keep them for a set retention period without downtime.

❓ Architecture

advanced

High availability with managed databases

You want to design a highly available database setup using Google Cloud SQL. Which configuration best achieves this?

A Use a single primary instance with no replicas and rely on backups.

B Create two independent primary instances in the same zone without replication.

C Create a primary instance with a failover replica in a different zone.

D Manually copy data between two instances every hour.

💡 Hint

Think about how managed services provide automatic failover.

A failover replica in a different zone allows automatic failover if the primary fails, ensuring high availability.

❓ security

advanced

Security features of managed databases

Which security feature is typically provided by managed database services like Google Cloud SQL to protect data at rest?

A Storing data unencrypted to improve performance.

B Disabling all network access by default without exceptions.

C Requiring manual installation of encryption software on the VM.

D Automatic encryption of stored data using Google-managed keys.

💡 Hint

Consider how cloud providers protect stored data without user setup.

Managed databases encrypt data at rest automatically using keys managed by the cloud provider, enhancing security without user effort.

✅ Best Practice

expert

Cost optimization with managed databases

You want to optimize costs for a managed database that has variable workloads with peak times and idle times. Which approach best balances cost and performance?

A Use a managed database with autoscaling enabled to adjust resources based on demand.

B Provision the largest instance size permanently to handle peak loads at all times.

C Manually stop the database instance during idle times to save costs.

D Use multiple small instances without load balancing to distribute workload.

💡 Hint

Think about how managed services can adjust resources automatically.

Autoscaling allows the database to increase resources during peak demand and reduce them when idle, saving costs while maintaining performance.