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 491–498 of 498

Q491

A company needs high availability for its Cloud SQL instance. What should they implement?

  • A Single zone deployment
  • B Read replicas
  • C High availability configuration
  • D Backup and restore
Explanation High availability configuration ensures failover capabilities, unlike the other options.
Q492

What happens when you set `automatic_restart` to false in a Cloud SQL instance?

  • A Instance will restart on failure
  • B Instance will not restart automatically
  • C Instance becomes unresponsive
  • D Instance is deleted immediately
Explanation Setting `automatic_restart` to false prevents automatic restart on failure, while the others imply incorrect behavior.
Q493

Which service manages SQL databases in Google Cloud?

  • A Cloud SQL
  • B Firestore
  • C BigQuery
  • D Cloud Spanner
Explanation Cloud SQL is specifically designed for managing SQL databases, while the others serve different database types or analytical purposes.
Q494

A company needs to implement a high-availability database for global applications. Which Google Cloud solution should they choose?

  • A Cloud Bigtable
  • B Cloud Datastore
  • C Cloud Spanner
  • D Cloud Firestore
Explanation Cloud Spanner is designed for high availability and horizontal scaling across regions, which suits global applications best.
Q495

What happens when you scale down a Cloud SQL instance?

  • A Downtime is guaranteed
  • B Data is permanently lost
  • C Performance might temporarily degrade
  • D Connection limits increase automatically
Explanation Scaling down can lead to temporary performance degradation as resources adjust, but data is retained and downtime is not guaranteed.
Q496

Which Google Cloud service is best for batch processing jobs?

  • A Cloud Dataflow
  • B Cloud Functions
  • C Cloud Run
  • D Cloud Pub/Sub
Explanation Cloud Dataflow is designed specifically for batch processing, while the others serve different use cases.
Q497

A company needs to ensure changes to the production database are logged and can be reverted. Which option is best?

  • A Enable Audit Logs
  • B Use Backup and Restore
  • C Use Change Data Capture
  • D Implement Cloud Functions
Explanation Change Data Capture is ideal for tracking changes, while other options address different needs.
Q498

What happens when you set a Cloud SQL instance to 'read-only'?

  • A No connections allowed
  • B Can only read data
  • C No changes to database allowed
  • D Backup operations are disabled
Explanation In 'read-only' mode, only data retrieval is permitted, preventing modifications.