Welcome to ExamTopics
ExamTopics Logo
- Expert Verified, Online, Free.
Mail Us[email protected]
Menu
Google Discussions
exam questions

Exam Professional Cloud Database Engineer All Questions

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

Exam Professional Cloud Database Engineer topic 1 question 118 discussion

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

You are managing two different applications: Order Management and Sales Reporting. Both applications interact with the same Cloud SQL for MySQL database. The Order Management application reads and writes to the database 24/7, but the Sales Reporting application is read-only. Both applications need the latest data. You need to ensure that the Performance of the Order Management application is not affected by the Sales Reporting application. What should you do?

  • A. Create a read replica for the Sales Reporting application.
  • B. Create two separate databases in the instance, and perform dual writes from the Order Management application.
  • C. Use a Cloud SQL federated query for the Sales Reporting application.
  • D. Queue up all the requested reports in PubSub, and execute the reports at night.
Show Suggested Answer Hide Answer
Suggested Answer: A 🗳️
by pk349 at Dec. 24, 2022, 10:18 p.m.

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
Submit Cancel
chelbsik
Highly Voted 1 year, 11 months ago
Selected Answer: A
Read replica is more than enough
upvoted 7 times
...
dynamic_dba
Highly Voted 1 year, 8 months ago
A. B could be done, but would need some application work to make it happen. Eliminate B. Federated queries are queries sent from BigQuery to Cloud SQL or Cloud Spanner with the results returned to BigQuery as a temporary table. So C is wrong. Even if D made sense, running all the reports at night would still impact the Order Management application since it accesses the database 24x7. That leaves A which is the classic solution to offload reads from the primary instance.
upvoted 5 times
...
Zek
Most Recent 3 days, 6 hours ago
A Create a Read Replica to serve the Sales Reporting application while the Order Management continues to write to the Primary instance
upvoted 1 times
...
pk349
1 year, 11 months ago
A: Create a read replica for the ***** Sales Reporting application.
upvoted 3 times
...

Get IT Certification

Unlock free, top-quality video courses on ExamTopics with a simple registration. Elevate your learning journey with our expertly curated content. Register now to access a diverse range of educational resources designed for your success. Start learning today with ExamTopics!

Start Learning for free
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