CLOUD-DIGITAL-LEADER practice question 29 of 35

Cloud SQL is a fully-managed relational database service for MySQL, PostgreSQL and SQL serv-ers, keeping Cloud SQL Google Cloud Service in mind, which of the following statements is/are correct?

Full set: 411 questions
Answer options
A: Data inside cloud SQL is automatically Encrypted.
B: Cloud SQL automatically ensures your databases are reliable, secure, and scala-ble so that your business continues to run without disruption.
C: With DMS (Database Migration Service) it becomes very easy to Migration of Pro-duction Database.
D: All of the above Correct answer
Correct Answer:
D. All of the above
Explanation

Cloud SQL encrypts all data at rest with AES-256 and uses TLS for data in transit. Because the service is fully managed, Google automates backups, patching, high-availability failover, read-scaling, and IAM-based security, thereby providing reliability, security, and scalability without manual administration. Google’s Database Migration Service (DMS) performs continuous, minimal-downtime replication from on-premises or other cloud MySQL and PostgreSQL sources into Cloud SQL, making production migrations straightforward. Since statements A, B, and C are each correct, option D (“All of the above”) is the most complete and therefore the single best choice.

Why Incorrect

A. Correct but covers only encryption; omits reliability and migration, so not the most comprehensive answer.
B. Correct but omits encryption at rest/in transit and migration ease; therefore incomplete.
C. Correct yet mentions only migration; does not include encryption and managed reliability; thus incomplete.

References

1. Google Cloud documentation – “Cloud SQL”: Overview page, paragraph 2 (“Cloud SQL automatically ensures your databases are reliable, secure, and scalable…”) https://cloud.google.com/sql

2. Google Cloud documentation – “Data encryption in Cloud SQL”: Section “Encryption at rest” (all data is automatically encrypted with AES-256).

3. Google Cloud documentation – “Database Migration Service Overview”: First paragraph (“makes it easier to migrate production MySQL and PostgreSQL databases to Cloud SQL with minimal downtime”).

4. Google Cloud Security Whitepaper – “Encryption at rest,” p. 7 (describes default AES-256 encryption for managed storage services including Cloud SQL).

Scroll to Top