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 271–280 of 498

Q271

Which service allows you to manage databases at scale?

  • A Cloud SQL
  • B Cloud Storage
  • C Cloud Functions
  • D Cloud Run
Explanation Cloud SQL is designed for managing relational databases, while the others serve different purposes.
Q272

A company needs to ensure their Cloud Spanner instance provides high availability. What should they configure?

  • A Single-region deployment
  • B Multi-region deployment
  • C Replication only
  • D Backup schedules
Explanation Multi-region deployment ensures high availability through redundancy, unlike single-region deployments.
Q273

You are configuring a Firestore database. What happens when you set the security rules to allow read access to all users?

  • A Only authenticated users can read
  • B All users can read data
  • C No data can be read
  • D Read access is denied by default
Explanation Setting read access to all users permits any user to access the data, contrary to the other options.
Q274

Which service is best for real-time analytics on streaming data?

  • A Cloud Pub/Sub
  • B BigQuery
  • C Cloud Storage
  • D Cloud Firestore
Explanation Cloud Pub/Sub allows ingestion of streaming data for real-time analytics, while the others are not designed for immediate streaming data processing.
Q275

A company needs to manage version control for its Cloud SQL database. What is the best approach?

  • A Enable automatic backups
  • B Use binary logs
  • C Create read replicas
  • D Instant recovery snapshots
Explanation Using binary logs in Cloud SQL supports version control by allowing recovery and point-in-time restoration, while other options serve different purposes.
Q276

What happens when you disable the Auto-Suspend feature of a Google Cloud SQL instance?

  • A Instance will never go idle
  • B Costs will decrease significantly
  • C Data loss may occur
  • D Performance metrics will improve
Explanation Disabling Auto-Suspend means the instance remains active at all times, potentially leading to increased costs, while others are incorrect based on instance behavior.
Q277

Which Google Cloud service is best for data stream processing?

  • A Dataflow
  • B Cloud Storage
  • C BigQuery
  • D Cloud SQL
Explanation Dataflow provides capabilities for stream processing, while others serve different purposes.
Q278

A company needs to manage large volumes of unstructured data. What is the most suitable database solution?

  • A Cloud Spanner
  • B Cloud Firestore
  • C Bigtable
  • D Cloud SQL
Explanation Bigtable is designed specifically for unstructured data, unlike the other options which cater to structured data.
Q279

What happens if a Cloud SQL instance exceeds its allocated storage limit?

  • A Instance stops accepting writes
  • B Data is automatically deleted
  • C Service continues as normal
  • D Instance shuts down automatically
Explanation The instance will stop accepting writes but remains available for reads until storage is managed.
Q280

Which service is best for managing non-relational data?

  • A Cloud Firestore
  • B Cloud SQL
  • C BigQuery
  • D Cloud Storage
Explanation Cloud Firestore is designed for non-relational data, while the others focus on relational or data storage.