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 1–10 of 498

Q1

Which Google Cloud service is designed for analytical workloads on large datasets?

  • A BigQuery
  • B Cloud SQL
  • C Firestore
  • D Cloud Spanner
Explanation BigQuery is optimized for analytics, while the others serve different database needs.
Q2

A company needs to store unstructured data that is frequently accessed and can grow rapidly. What should they use?

  • A Cloud Pub/Sub
  • B Cloud Storage
  • C Cloud SQL
  • D Cloud Firestore
Explanation Cloud Storage is ideal for unstructured data, while others serve different purposes.
Q3

You are configuring database replication. What happens when you set up a read replica in Google Cloud SQL?

  • A Data is synchronized instantly.
  • B Only SELECT queries are allowed.
  • C Replication lag may occur.
  • D Write operations are mirrored.
Explanation Replication lag can occur due to asynchronous replication, affecting data freshness.
Q4

Which Google Cloud service is best for modeling data relationships in a NoSQL database?

  • A Cloud Firestore
  • B Cloud Bigtable
  • C Cloud Spanner
  • D Cloud SQL
Explanation Cloud Spanner supports complex relationships in a distributed environment, unlike the others which focus on different data models.
Q5

A company needs to maintain high availability of its database across multiple regions. What should it implement?

  • A Multiple multi-region databases
  • B A read-replica in one region
  • C Automatic failover settings
  • D Database sharding across zones
Explanation Using multiple multi-region databases ensures redundancy and availability; the other options may not be enough alone for high availability.
Q6

You are configuring a Firestore database. What happens if you try to write data exceeding the maximum document size limit?

  • A Operation will return an error
  • B Data will be partially saved
  • C Limiting will be ignored
  • D Data is saved without limits
Explanation Attempting to exceed Firestore's document size limit causes an error, ensuring data integrity, while the other options inaccurately imply successful data writes.
Q7

Which service is best for serverless database interactions?

  • A Cloud Firestore
  • B Cloud SQL
  • C Cloud Spanner
  • D Bigtable
Explanation Cloud Firestore is optimized for serverless apps, unlike the others.
Q8

A company needs multi-regional database replication. Which Google Cloud database should they choose?

  • A Cloud SQL
  • B Firestore
  • C Cloud Spanner
  • D Datastore
Explanation Cloud Spanner supports multi-regional replication, while the others do not.
Q9

What happens when configuring auto-scaling for Cloud Bigtable?

  • A Nodes automatically decrease in number
  • B Read/write throughput changes affect node count
  • C Higher latency for read queries
  • D Data consistency is altered
Explanation Node count in Bigtable adjusts based on throughput demands, ensuring performance stability and availability.
Q10

Which service is best for managing NoSQL databases in Google Cloud?

  • A Cloud Firestore
  • B Cloud SQL
  • C BigQuery
  • D Cloud Spanner
Explanation Cloud Firestore is designed specifically for NoSQL storage, while others support SQL or analytics functionality.