Google Cloud

Google Cloud Certified – Professional Cloud Database Engineer

PR000256

Become a certified Professional Cloud Database Engineer with exam code PR000256 to validate your database skills in Google Cloud.

498 questions 0 views Free
Start Mock Test Timed · Full-length · Scored

Questions 161–170 of 498

Q161

A company needs to automate the provisioning of databases. Which service should they use?

  • A Google Cloud Functions
  • B Cloud Composer
  • C Cloud SQL
  • D Database Migration Service
Explanation Cloud Composer supports automation through workflow orchestration; others don't focus on provisioning.
Q162

What happens when you increase the instance class of a Cloud SQL database?

  • A Requires restarting the database
  • B Data is automatically expanded
  • C Performance is degraded temporarily
  • D Backup is triggered immediately
Explanation Increasing instance class requires a restart for changes; other options do not accurately reflect instance class changes.
Q163

Which Google Cloud service enables automated backups for databases?

  • A Cloud SQL
  • B Cloud Storage
  • C BigQuery
  • D Compute Engine
Explanation Cloud SQL provides automated backups; others do not primarily focus on databases.
Q164

A company needs to perform analytics on real-time streaming data. Which service is most appropriate?

  • A BigQuery
  • B Cloud Pub/Sub
  • C Cloud Dataflow
  • D Cloud Spanner
Explanation Cloud Dataflow is specifically designed for processing streaming data, while others serve different purposes.
Q165

You are configuring IAM roles for a service account and want to limit access to only necessary resources. What should you do?

  • A Assign predefined roles only
  • B Use basic roles such as Viewer
  • C Implement the principle of least privilege
  • D Grant roles broadly for ease
Explanation The principle of least privilege minimizes access rights; other options increase security risks.
Q166

Which Google Cloud service is typically used for managing large-scale NoSQL databases?

  • A Cloud Spanner
  • B BigQuery
  • C Cloud SQL
  • D Firestore
Explanation Cloud Spanner is designed for scalable NoSQL solutions, while others cater to SQL or analytics.
Q167

A company needs to migrate its on-premises MySQL database to Google Cloud while minimizing downtime as much as possible. Which approach should they use?

  • A Use Cloud Firebase
  • B Perform a one-time export/import
  • C Use Database Migration Service
  • D Use Cloud Functions
Explanation The Database Migration Service supports continuous migration with minimal downtime.
Q168

What happens when you exceed the maximum provisioned IOPS in a Cloud SQL instance?

  • A Performance is unaffected
  • B Instance automatically scales up
  • C Requests are throttled or queued
  • D Database is temporarily shut down
Explanation Exceeding IOPS leads to throttling or queuing of requests.
Q169

Which service provides managed NoSQL databases in Google Cloud?

  • A Cloud Firestore
  • B Bigtable
  • C Cloud Spanner
  • D Cloud SQL
Explanation Cloud Firestore is designed for NoSQL; others are either SQL or not specifically managed NoSQL.
Q170

A company needs to analyze large volumes of log data in real-time. Which Google Cloud service should they use?

  • A Cloud Pub/Sub
  • B Dataflow
  • C BigQuery
  • D Dataproc
Explanation Dataflow is optimized for real-time stream processing, while others serve different purposes.