Google Professional Cloud Database Engineer Exam - Topic 7 Question 50 Discussion

Actual exam question for Google's Professional Cloud Database Engineer exam

Question #: 50
Topic #: 7

[All Professional Cloud Database Engineer Questions]

You want to migrate your PostgreSQL database from another cloud provider to Cloud SQL. You plan on using Database Migration Service and need to assess the impact of any known limitations. What should you do? (Choose two.)

AIdentify whether the database has over 512 tables.

BIdentify all tables that do not have a primary key.

CIdentity all tables that do not have at least one foreign key.

DIdentify whether the source database is encrypted using pgcrypto extension.

EIdentify whether the source database uses customer-managed encryption keys (CMEK).

Show Suggested Answer

Suggested Answer: D

by Carey at Jan 14, 2025, 07:02 AM

Limited Time Offer

25%

Off

Get Premium Professional Cloud Database Engineer Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Fabiola

6 days ago

Definitely need to know about the 512 tables limit.

upvoted 0 times

...

Glenna

12 days ago

Gotta check for tables without primary keys!

upvoted 0 times

...

Buffy

17 days ago

I vaguely recall that foreign keys might not be as critical, but I’m not confident about option C being necessary for migration.

upvoted 0 times

...

Dianne

23 days ago

I practiced a similar question where we had to identify limitations, and I think having too many tables could be an issue, so option A could be right.

upvoted 0 times

...

Clarinda

28 days ago

I’m not entirely sure, but I feel like checking for encryption methods like CMEK could be crucial, so maybe option E?

upvoted 0 times

...

Jacki

1 month ago

I remember something about primary keys being important for migration, so I think option B might be relevant.

upvoted 0 times

...

Tricia

1 month ago

I feel pretty confident about this one. Identifying the table count, missing primary keys, and missing foreign keys are all important steps to assess the migration impact. I'll make sure to cover those bases.

upvoted 0 times

...

Denny

1 month ago

This seems straightforward enough. I'll focus on the key things to check - table count, primary keys, and foreign keys. That should give me a good idea of any potential issues before the migration.

upvoted 0 times

...

Ernestine

1 month ago

I'm a bit confused on the encryption part. Do I need to identify if the source database is using pgcrypto or customer-managed encryption keys? I'll have to research that more.

upvoted 0 times

...

Candra

1 month ago

Okay, let's think this through step-by-step. First, I'll need to check if the database has over 512 tables, as that's a known limitation. Then I'll look for any tables without primary keys or foreign keys.

upvoted 0 times

...

Valentin

1 month ago

Hmm, this looks like a tricky one. I'll need to carefully review the limitations of the Database Migration Service to see what potential issues I might encounter.

upvoted 0 times

...

Evan

6 months ago

Wait, did they say 'Database Migration Service'? I thought we were moving to Cloud SQL, not the cloud migration service. Guess I need to brush up on my cloud skills!

upvoted 0 times