Google Cloud Professional Cloud Database Engineer PCDBE — Topic 1 Question 145

Question

You are the DBA of your organization. You provided a cloned instance from the production Cloud SQL for PostgreSQL database to the developers for testing purposes. After the creation of the clone, your developers notice missing data in one of the recently altered tables. What should you do to ensure that all data is included?

Accepted Answer

Correct answer: D. The correct answer is D. Option D: Dump the production database to a file. Modify the dumped file to ALTER TABLE to SET LOGGED on tables that were unlogged in production. Reload the data in the new Cloud SQL for PostgreSQL instance. Cloud SQL is a managed relational database (MySQL/PostgreSQL/SQL Server) that handles patching, backups, and failover.

Google Cloud Professional Cloud Database Engineer PCDBE — Question 145