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 371–380 of 498

Q371

A company needs to ensure minimal downtime during maintenance of a Cloud Spanner instance. What approach should they use?

  • A Use read replicas
  • B Enable multi-region configuration
  • C Use Sharded Clusters
  • D Implement Transactional Jobs
Explanation Multi-region configuration allows automatic failover and higher availability.
Q372

What happens when a Cloud Firestore instance reaches its maximum write throughput?

  • A Writes queue up automatically
  • B Writes are throttled
  • C Database is corrupted
  • D All writes fail instantly
Explanation Writes are throttled to limit overflow and maintain service reliability without corruption.
Q373

Which service is best for real-time data processing in Google Cloud?

  • A Cloud Pub/Sub
  • B Cloud Functions
  • C Cloud Storage
  • D Cloud SQL
Explanation Cloud Pub/Sub is designed for real-time data streaming, whereas the others focus on functions, storage, or SQL management.
Q374

A company needs to run a MySQL database without managing instances. Which Google Cloud service should they choose?

  • A Cloud SQL
  • B Spanner
  • C Firebase Realtime Database
  • D Bigtable
Explanation Cloud SQL offers managed MySQL services, while the others either serve different database types or are not SQL-based.
Q375

What happens when you exceed the maximum storage limit of a Google Cloud Firestore database?

  • A Writes are automatically denied
  • B Firestore upgrades to a paid tier
  • C Data is deleted automatically
  • D You cannot perform more writes
Explanation Exceeding the storage limit will prevent further writes, while the other statements are inaccurate regarding Firestore behavior.
Q376

Which service is primarily used for scalable relational databases in Google Cloud?

  • A Cloud SQL
  • B Bigtable
  • C Firestore
  • D Cloud Spanner
Explanation Cloud SQL is for relational databases; others are not.
Q377

A company needs to migrate its NoSQL database to Google Cloud while ensuring minimal downtime. Which strategy should they use?

  • A Cold migration
  • B Online migration
  • C Hybrid migration
  • D Lift and shift
Explanation Online migration allows for minimal downtime during transfer.
Q378

You are configuring the failover for your Cloud Spanner instance. What happens if the primary node fails?

  • A Automatic switching to standby node occurs
  • B Service will remain unavailable
  • C Data loss is expected
  • D Permissions will reset on recovery
Explanation Failover to standby node ensures availability; others are misconceptions.
Q379

Which service is used for managed data warehouse on GCP?

  • A BigQuery
  • B Firestore
  • C Cloud SQL
  • D Spanner
Explanation BigQuery is designed for analytics, while others serve different purposes.
Q380

A company needs to store structured data with high availability. What should they use?

  • A Cloud Storage
  • B Cloud Firestore
  • C Cloud SQL
  • D Bigtable
Explanation Cloud SQL offers structured data storage with high availability features, unlike the other options.