nerdexam
GoogleGoogle

PROFESSIONAL-CLOUD-DATABASE-ENGINEER · Question #43

PROFESSIONAL-CLOUD-DATABASE-ENGINEER Question #43: Real Exam Question with Answer & Explanation

Sign in or unlock PROFESSIONAL-CLOUD-DATABASE-ENGINEER to reveal the answer and full explanation for question #43. The question stem and answer options stay visible for context.

Managing Database Operations

Question

Your organization has a busy transactional Cloud SQL for MySQL instance. Your analytics team needs access to the data so they can build monthly sales reports. You need to provide data access to the analytics team without adversely affecting performance. What should you do?

Options

  • ACreate a read replica of the database, provide the database IP address, username, and password
  • BCreate a read replica of the database, enable the cloudsql.iam_authentication flag on the replica,
  • CEnable the cloudsql.iam_authentication flag on the primary database instance, and grant read
  • DProvide the database IP address, username, and password of the primary database instance to

Unlock PROFESSIONAL-CLOUD-DATABASE-ENGINEER to see the answer

You've previewed enough free PROFESSIONAL-CLOUD-DATABASE-ENGINEER questions. Unlock PROFESSIONAL-CLOUD-DATABASE-ENGINEER for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.

Topics

#Cloud SQL#Read Replicas#IAM Authentication#Performance Optimization
Full PROFESSIONAL-CLOUD-DATABASE-ENGINEER PracticeBrowse All PROFESSIONAL-CLOUD-DATABASE-ENGINEER Questions