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 221–230 of 498

Q221

A company needs to ensure automatic backups of their Cloud SQL instance. What should they configure?

  • A High Availability
  • B Automated Backups
  • C Read Replicas
  • D Instance Failover
Explanation Automated Backups are specifically designed to perform regular backups, unlike High Availability, Read Replicas, or Instance Failover.
Q222

You are configuring a Firestore database. What happens when you set rules allowing 'read' access to 'if request.time < timestamp'?

  • A Prevents all reads after timestamp.
  • B Grants all read access always.
  • C Grants read access until timestamp.
  • D Denies all access permanently.
Explanation This rule allows read access only until the specified timestamp, while other options misinterpret the conditional logic.
Q223

Which service is best for real-time data streaming?

  • A Cloud Pub/Sub
  • B Cloud Firestore
  • C Cloud SQL
  • D Cloud Storage
Explanation Cloud Pub/Sub is specifically designed for real-time streaming, whereas others are not intended for that use-case.
Q224

A company needs to run complex SQL queries on a large dataset. Which Google Cloud solution should they choose?

  • A BigQuery
  • B Cloud Spanner
  • C Cloud SQL
  • D Datastore
Explanation BigQuery is optimized for running complex SQL queries on large datasets, while others may not be as efficient for this purpose.
Q225

What happens when you exceed the read bandwidth of a Cloud Bigtable instance?

  • A Writes are queued until bandwidth frees up.
  • B No additional reads can occur.
  • C Read requests are throttled.
  • D All reads are rejected automatically.
Explanation When bandwidth is exceeded, read requests are throttled to ensure stability, instead of rejecting them or queuing writes.
Q226

Which Google Cloud service is best for managing large NoSQL datasets?

  • A Firestore
  • B Cloud SQL
  • C Cloud Memorystore
  • D Cloud Spanner
Explanation Firestore is optimized for NoSQL workloads, while others serve different data models.
Q227

A company needs a scalable SQL database with global distribution. Which Google Cloud option should they choose?

  • A Cloud Spanner
  • B Cloud SQL
  • C Bigtable
  • D Firestore
Explanation Cloud Spanner is designed for distributed SQL databases with scalability.
Q228

What happens when you try to back up a Cloud Spanner instance while it is undergoing maintenance?

  • A Back up fails immediately.
  • B Back up queues until maintenance is complete.
  • C Back up completes with partial data.
  • D Back up is processed normally.
Explanation Backups will be queued and processed after maintenance for data consistency.
Q229

Which Google Cloud service is best for batch processing data?

  • A Cloud Dataflow
  • B Cloud Functions
  • C Cloud Run
  • D BigQuery
Explanation Cloud Dataflow is designed for batch processing, while the others are for event-driven or interactive processing.
Q230

A company needs to perform real-time analytics on streaming data. Which combination of services should they use?

  • A Pub/Sub and BigQuery
  • B Firestore and Dataflow
  • C Cloud SQL and Cloud Run
  • D Cloud Storage and Compute Engine
Explanation Pub/Sub for data ingestion and BigQuery for real-time analytics is a suitable choice.