Question 1

Your company has PostgreSQL databases on-premises and on Amazon Web Services (AWS). You are

planning multiple database migrations to Cloud SQL in an effort to reduce costs and downtime. You want to

follow Google-recommended practices and use Google native data migration tools. You also want to closely

monitor the migrations as part of the cutover strategy. What should you do?

Options :

A : Use Database Migration Service to migrate all databases to Cloud SQL.

B :

Use Database Migration Service for one-time migrations, and use third-party or partner tools for change

data capture (CDC) style migrations.

C :

Use data replication tools and CDC tools to enable migration.

D :

Use a combination of Database Migration Service and partner tools to support the data migration

strategy.

Answer: A

Question 2

Options :

A :

B :

C :

D :

Answer: C

Question 3

Your company wants you to migrate their Oracle, MySQL, Microsoft SQL Server, and PostgreSQL relational databases to Google Cloud. You need a fully managed, flexible database solution when possible. What should you do?

Options :

A : Migrate all the databases to Cloud SQL.

B :

Migrate the Oracle, MySQL, and Microsoft SQL Server databases to Cloud SQL, and migrate the PostgreSQL databases to Compute Engine.

C :

Migrate the MySQL, Microsoft SQL Server, and PostgreSQL databases to Compute Engine, and migrate the Oracle databases to Bare Metal Solution for Oracle.

D :

Migrate the MySQL, Microsoft SQL Server, and PostgreSQL databases to Cloud SQL, and migrate the Oracle databases to Bare Metal Solution for Oracle.

Answer: D

Question 4

You want to migrate your on-premises PostgreSQL database to Compute Engine. You need to migrate this database with the minimum downtime possible. What should you do?

Options :

A :

Perform a full backup of your on-premises PostgreSQL, and then, in the migration window, perform an incremental backup.

B : Create a read replica on Cloud SQL, and then promote it to a read/write standalone instance.

C : Use Database Migration Service to migrate your database.

D : Create a hot standby on Compute Engine, and use PgBouncer to switch over the connections.

Answer: D

Question 5

You are a DBA of Cloud SQL for PostgreSQL. You want the applications to have password-less authentication for read and write access to the database. Which authentication mechanism should you use?

Options :

A : Use Identity and Access Management (IAM) authentication.

B : Use Managed Active Directory authentication.

C : Use Cloud SQL federated queries.

D : Use PostgreSQL database-s built-in authentication.

Answer: A