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 241–250 of 498

Q241

Which service facilitates real-time data processing in Google Cloud?

  • A Cloud Dataflow
  • B Cloud Functions
  • C Cloud Datastore
  • D BigQuery
Explanation Cloud Dataflow is designed for real-time data processing, while the others serve different purposes like serverless functions or analytics.
Q242

A company needs to ensure that its Cloud SQL databases remain highly available. What should it configure?

  • A Read replicas
  • B Cloud Spanner
  • C High availability configuration
  • D Scheduled backups
Explanation High availability configuration ensures failover and uptime, while the others do not provide such guarantees.
Q243

What happens when you set backup retention to 0 days in Google Cloud SQL?

  • A Backups will not be created
  • B All backups are kept indefinitely
  • C Backups will be deleted immediately
  • D Backups are created normally
Explanation Setting the retention to 0 prevents any backups from being created, while the others imply different backup behaviors.
Q244

Which service provides automatic scaling for databases?

  • A Cloud SQL
  • B Cloud Spanner
  • C BigQuery
  • D Firestore
Explanation Cloud Spanner is designed for automatic scaling, while the others have fixed resources.
Q245

A company needs a non-relational database for flexible schema. Which option is best?

  • A BigQuery
  • B Cloud SQL
  • C Firestore
  • D Cloud Memorystore
Explanation Firestore offers a flexible schema suited for non-relational data, unlike the other options.
Q246

What happens when you enable Cloud SQL's automatic backups?

  • A Instance upgrades automatically
  • B Data is encrypted at rest
  • C Backups occur regularly without manual intervention
  • D Database performance decreases significantly
Explanation Automatic backups run regularly without manual intervention, while others are incorrect actions or effects.
Q247

Which service is best for managing NoSQL data in GCP?

  • A Cloud Bigtable
  • B Cloud SQL
  • C Cloud Datastore
  • D Firestore
Explanation Cloud Datastore is optimized for NoSQL data, while others have different primary focuses.
Q248

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

  • A Backup with 7-day retention
  • B Read replicas in multiple zones
  • C Standard storage type
  • D One regional instance
Explanation Read replicas in multiple zones provide high availability, unlike the other options.
Q249

You are configuring table sharding in BigQuery. What happens if you include too many shards?

  • A Improved query performance
  • B No effect on performance
  • C Increased costs due to complexity
  • D Automatic optimization by BigQuery
Explanation Too many shards can lead to increased costs and complexity without performance improvement.
Q250

Which service is best for NoSQL database management?

  • A Google Firestore
  • B Google Cloud SQL
  • C Google BigQuery
  • D Google Cloud Spanner
Explanation Google Firestore is specifically designed for NoSQL applications, while others are SQL-based.