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 41–50 of 498

Q41

A company needs low-latency access to large datasets while maintaining strong consistency. Which database service would you choose?

  • A Cloud Firestore
  • B Cloud Spanner
  • C Bigtable
  • D Cloud SQL
Explanation Cloud Spanner provides low-latency access with strong consistency for large datasets compared to the other choices.
Q42

What happens when a Cloud SQL instance reaches its maximum storage quota?

  • A Instance automatically expands storage
  • B Instance goes down temporarily
  • C Instance becomes read-only
  • D No effect on instance operation
Explanation When the maximum storage quota is reached, the instance becomes read-only until storage is freed or expanded.
Q43

Which service is best for managing relational databases in GCP?

  • A Cloud SQL
  • B Bigtable
  • C Firestore
  • D Cloud Spanner
Explanation Cloud SQL is designed specifically for relational databases, while Bigtable and Firestore are NoSQL solutions and Cloud Spanner is for horizontal scaling but not just relational.
Q44

A company needs to store many unstructured data artifacts. Which GCP service should they use for this purpose?

  • A Cloud Firestore
  • B Cloud Storage
  • C Cloud SQL
  • D Cloud Bigtable
Explanation Cloud Storage is optimized for storing unstructured data, unlike Firestore and Cloud SQL which are for structured data.
Q45

What happens when you scale a Cloud Spanner instance up within GCP?

  • A Charges decrease
  • B Downtime occurs
  • C More processing capacity is available
  • D Data becomes read-only
Explanation Scaling up increases processing capacity without downtime, while charges generally increase and no restrictions on data occur.
Q46

Which service allows automatic database scaling in Google Cloud?

  • A Cloud SQL
  • B Firestore
  • C Bigtable
  • D Spanner
Explanation Spanner supports automatic scaling, while the others require manual management.
Q47

A company needs to enforce encryption for data at rest in Cloud Storage. What should they do?

  • A Use customer-managed encryption keys
  • B Enable public access controls
  • C Use the default Google keys
  • D Turn off versioning
Explanation Customer-managed encryption keys provide encryption control over data at rest, unlike the other options.
Q48

What happens when a Cloud SQL instance surpasses its IOPS limit?

  • A Instance crashes immediately
  • B Queries may experience latency
  • C Backup fails only
  • D Performance remains unaffected
Explanation Exceeding IOPS results in query latency, not immediate crash or backup failure.
Q49

Which service should you use for analytical SQL queries in Google Cloud?

  • A BigQuery
  • B Cloud SQL
  • C Firestore
  • D Spanner
Explanation BigQuery is designed for analytical queries, while the others are transactional or NoSQL databases.
Q50

A company needs a relational database that scales horizontally. Which option should they choose?

  • A Cloud SQL
  • B Spanner
  • C Firestore
  • D Bigtable
Explanation Spanner provides horizontal scalability with relational features, while the others do not support it effectively.