Exam Professional Cloud Database Engineer topic 1 question 146 discussion

Actual exam question from Google's Professional Cloud Database Engineer

Question #: 146
Topic #: 1

[All Professional Cloud Database Engineer Questions]

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?

A. Take a back up of the production database, and restore it to another Cloud SQL for PostgreSQL instance. Provide access to the new instance to the developers.
B. Check for missing roles and privileges in the cloned Cloud SQL instance. Grant missing privileges to the developers.
C. Clone the current production database, and restore it to an earlier point-in-time (PITR). Provide access to the cloned instance to the developers.
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.

Show Suggested Answer

Suggested Answer: D 🗳️

by WOOJONE at May 29, 2025, 1:19 a.m.

Comments

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!