Welcome to ExamTopics
ExamTopics Logo
- Expert Verified, Online, Free.
exam questions

Exam Professional Cloud Database Engineer All Questions

View all questions & answers for the Professional Cloud Database Engineer exam

Exam Professional Cloud Database Engineer topic 1 question 95 discussion

Actual exam question from Google's Professional Cloud Database Engineer
Question #: 95
Topic #: 1
[All Professional Cloud Database Engineer Questions]

You are migrating a telehealth care company's on-premises data center to Google Cloud. The migration plan specifies:
PostgreSQL databases must be migrated to a multi-region backup configuration with cross-region replicas to allow restore and failover in multiple scenarios.
MySQL databases handle personally identifiable information (PII) and require data residency compliance at the regional level.
You want to set up the environment with minimal administrative effort. What should you do?

  • A. Set up Cloud Logging and Cloud Monitoring with Cloud Functions to send an alert every time a new database instance is created, and manually validate the region.
  • B. Set up different organizations for each database type, and apply policy constraints at the organization level.
  • C. Set up Pub/Sub to ingest data from Cloud Logging, send an alert every time a new database instance is created, and manually validate the region.
  • D. Set up different projects for PostgreSQL and MySQL databases, and apply organizational policy constraints at a project level.
Show Suggested Answer Hide Answer
Suggested Answer: D 🗳️

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
chelbsik
Highly Voted 1 year, 11 months ago
Selected Answer: D
A and C don't prevent anything, and between B and D I choose D because there is no sense to maintain a separate org just because of the compliance - a separate project is more than enough.
upvoted 5 times
...
Zek
Most Recent 5 days, 12 hours ago
D. No need to setup different organizations, isolating the databases at the project level and applying the constraints will be require less administrative effort than setting different organizations
upvoted 1 times
...
dynamic_dba
1 year, 8 months ago
D. A doesn’t make sense. B is complete overkill. C does something manually and is convoluted. That leaves D. Managing policy at the project level is cleaner than having separate Organizations.
upvoted 4 times
...
SVGoogle89
1 year, 11 months ago
one Org with multiple folders and projects under folders
upvoted 1 times
...
pk349
1 year, 11 months ago
B: Set up different organizations for each *** database type, and apply policy constraints at the organization level.
upvoted 1 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...