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

Art

3 months ago

CMEK? I didn't even know that was a thing!

upvoted 0 times

...

Val

3 months ago

I agree, encryption details are super important!

upvoted 0 times

...

Owen

3 months ago

Wait, does it really matter if there are no foreign keys?

upvoted 0 times

...

Fabiola

4 months ago

Definitely need to know about the 512 tables limit.

upvoted 0 times

...

Glenna

4 months ago

Gotta check for tables without primary keys!

upvoted 0 times

...

Buffy

4 months 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

4 months 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

4 months 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

5 months ago

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

upvoted 0 times

...

Tricia

5 months 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

5 months 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

5 months 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

5 months 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

5 months 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

10 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