Question 1

You want to migrate an on-premises 100 TB Microsoft SQL Server database to Google Cloud over a 1 Gbps

network link. You have 48 hours allowed downtime to migrate this database. What should you do? (Choose

two.)

Options :

A :

Use a change data capture (CDC) migration strategy.

B :

Move the physical database servers from on-premises to Google Cloud.

C : Keep the network bandwidth at 1 Gbps, and then perform an offline data migration.

D :

Increase the network bandwidth to 2 Gbps, and then perform an offline data migration.

E :

Increase the network bandwidth to 10 Gbps, and then perform an offline data migration.

Answer: A,E

Question 2

Options :

A :

B :

C :

D :

Answer: C

Question 3

Your company is migrating their MySQL database to Cloud SQL and cannot afford any planned downtime

during the month of December. The company is also concerned with cost, so you need the most cost-effective

solution. What should you do?

Options :

A :

Open a support ticket in Google Cloud to prevent any maintenance in that MySQL instance during the

month of December.

B :

Use Cloud SQL maintenance settings to prevent any maintenance during the month of December.

C :

Create MySQL read replicas in different zones so that, if any downtime occurs, the read replicas will act

as the primary instance during the month of December.

D :

Create a MySQL regional instance so that, if any downtime occurs, the standby instance will act as the

primary instance during the month of December.

Answer: B

Question 4

Your organization has a ticketing system that needs an online marketing analytics and reporting application.

You need to select a relational database that can manage hundreds of terabytes of data to support this new

application. Which database should you use?

Options :

A : Cloud SQL

B : BigQuery

C : Cloud Spanner

D : Bigtable

Answer: B

Question 5

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