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 questionsCloud 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.
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.
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).
Keep practicing
Take the free CLOUD-DIGITAL-LEADER practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other CLOUD-DIGITAL-LEADER practice questions
- Question 1Your organization needs to ensure that the Google Cloud resources of each of your departm…
- Question 2A vacation home rental organization wants to predict the popularity of properties in thei…
- Question 3You are consulting for a client who is migrating to Google Cloud. They presently have a m…
- Question 4Which of the following is/are true about Anthos?
- Question 5What are the network requirements for Private Google Access?
- Question 6Your company security team manages access control to production systems using an LDAP dir…
