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 431–440 of 498

Q431

A company needs to ensure that their Cloud SQL instance can recover from accidental data loss. What should they implement?

  • A Automatic backups
  • B Strong IAM policies
  • C Compute Engine snapshots
  • D HTTP(S) Load Balancer
Explanation Automatic backups allow recovery from data loss, while other options serve different purposes.
Q432

You are configuring a Cloud Spanner instance with 10 nodes. What happens if you reduce it to 5 nodes?

  • A Performance improves immediately
  • B Instance scales down and may impact performance
  • C Node reduction requires a complete restart
  • D Billing will double for unused nodes
Explanation Reducing nodes can lower compute capacity, affecting performance, while other options are incorrect.
Q433

Which Google Cloud service is primarily used for relational database management?

  • A Cloud SQL
  • B Cloud Firestore
  • C Cloud Bigtable
  • D Cloud Spanner
Explanation Cloud SQL is designed for relational databases, while others serve NoSQL or analytical purposes.
Q434

A company needs to analyze streaming data in real-time. Which Google Cloud service should they use?

  • A Cloud Datastore
  • B Cloud Pub/Sub
  • C BigQuery
  • D Dataflow
Explanation Dataflow is optimized for processing streaming data, unlike others that serve different functions.
Q435

You are configuring a database for multiple transactions per second. What setting would most improve performance?

  • A Increase replication latency
  • B Use read replicas
  • C Disable indexing
  • D Limit connection pooling
Explanation Read replicas reduce load by handling read requests, while others either hurt performance or do not enhance it.
Q436

Which service is optimal for managing relational databases on Google Cloud?

  • A Cloud SQL
  • B Cloud Firestore
  • C BigQuery
  • D Cloud Spanner
Explanation Cloud SQL is specifically designed for relational databases, while the others serve different purposes.
Q437

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

  • A Single zone
  • B Read replicas
  • C Regional configuration
  • D Standard storage
Explanation Regional configurations automatically replicate data for high availability, unlike the other options.
Q438

What happens when a Cloud Firestore database exceeds its quota for document writes?

  • A Writes will fail temporarily
  • B Writes are throttled until limits reset
  • C All operations are disabled
  • D Data is automatically archived
Explanation Writes will fail until the quota is reset, unlike throttling or other measures suggested in the other options.
Q439

Which service offers fully managed NoSQL databases in Google Cloud?

  • A Cloud Firestore
  • B Cloud Functions
  • C Cloud Pub/Sub
  • D BigQuery
Explanation Cloud Firestore is a fully managed NoSQL service; others serve different purposes.
Q440

A company needs consistent data transactions across its applications. What should they use?

  • A Cloud Spanner
  • B Bigtable
  • C Datastore
  • D Cloud Storage
Explanation Cloud Spanner offers global consistency and transactions; others do not guarantee strong consistency.