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 51–60 of 498

Q51

You are configuring a Cloud Firestore database's indexing strategy. What happens when you create a compound index?

  • A Queries run faster
  • B Only single-field indexes are used
  • C No additional billing occurs
  • D It reduces read performance
Explanation A compound index optimizes queries involving multiple fields, thus enhancing performance while others are misleading or incorrect.
Q52

Which service is best for real-time data processing?

  • A Cloud Pub/Sub
  • B Cloud Storage
  • C Cloud SQL
  • D Cloud Dataflow
Explanation Cloud Dataflow is designed for real-time processing, while the others serve different purposes.
Q53

A company needs a highly available database solution. Which feature should they prioritize?

  • A Backups
  • B Auto-scaling
  • C Multi-regional replication
  • D Cost-effectiveness
Explanation Multi-regional replication provides durability and availability, crucial for high availability.
Q54

What happens when you disable a Cloud Firestore index?

  • A All queries fail
  • B Queries are slower
  • C Data becomes inaccessible
  • D It's permanently deleted
Explanation Disabling an index does not delete it; queries may run slower without it.
Q55

Which Google Cloud service is best for serverless SQL databases?

  • A Cloud SQL
  • B Datastore
  • C Bigtable
  • D Cloud Spanner
Explanation Cloud SQL provides a fully managed serverless SQL database, while others are not SQL databases or serverless.
Q56

A company needs to migrate their on-premises databases to Google Cloud. What should they prioritize in their migration planning?

  • A Reducing storage costs only
  • B Minimizing downtime
  • C Using legacy software
  • D Choosing the cheapest service
Explanation Minimizing downtime is crucial for successful database migrations, unlike the other options.
Q57

You are configuring Auto ML for dataset predictions. What is a critical requirement?

  • A Data must be highly balanced
  • B Use only structured data
  • C All labels must be unique
  • D Data should be correctly labeled
Explanation Correct labeling of data is crucial for training models effectively, while other options are not universally required.
Q58

Which service is best for NoSQL document storage?

  • A Firestore
  • B Cloud Spanner
  • C BigQuery
  • D Cloud SQL
Explanation Firestore is optimized for NoSQL document storage, while the others serve different database models.
Q59

A company needs low-latency transactions for their e-commerce platform. Which database should they choose?

  • A Cloud Spanner
  • B Firestore
  • C Bigtable
  • D Cloud SQL
Explanation Cloud Spanner provides strong consistency and low-latency transactions across global instances, making it ideal for e-commerce.
Q60

You are configuring a Cloud SQL instance. What happens if you disable automatic storage increase?

  • A Increases storage on demand
  • B Stops storage from being expanded
  • C Nullifies your instance
  • D Enables dynamic scaling
Explanation Disabling automatic storage increase prevents storage from automatically expanding, potentially leading to out-of-space errors if capacity is reached.