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 291–300 of 498

Q291

You are configuring a Firestore database for your app. How should you structure your data for optimal performance?

  • A Use large collections only
  • B Design with smaller, nested documents
  • C Mix all data in one document
  • D Use global indexes for all queries
Explanation Smaller, nested documents allow better performance and scalability.
Q292

Which service provides managed NoSQL databases on GCP?

  • A Firestore
  • B Cloud SQL
  • C BigQuery
  • D Cloud Bigtable
Explanation Firestore is specifically designed for NoSQL workloads, while the others serve different purposes.
Q293

A company needs to ensure their Cloud SQL instances have high availability. What should they enable?

  • A Read replicas
  • B Automatic backups
  • C Cloud Spanner
  • D Regional failover
Explanation Regional failover ensures high availability, unlike the other options which provide different functionalities.
Q294

You are configuring a Google Cloud BigQuery dataset. What happens when you set up a dataset expiration time?

  • A Data auto-deletes after expiration
  • B Dataset cannot be queried
  • C Expiration time is just a reminder
  • D Expiration is ignored if accessed
Explanation Setting an expiration time results in automatic deletion of the dataset after the time elapses.
Q295

Which service helps with relational database management?

  • A Cloud SQL
  • B Bigtable
  • C Firestore
  • D Cloud Spanner
Explanation Cloud SQL specifically supports relational databases; others serve different database types.
Q296

A company needs to ensure their backups are point-in-time and require minimal downtime. Which GCP service should they choose?

  • A Dataflow
  • B Cloud Storage
  • C Cloud Spanner
  • D Cloud Firestore
Explanation Cloud Spanner provides point-in-time recovery with minimal downtime; the others don’t have this specific feature.
Q297

What happens when you configure a Cloud SQL instance as read-only?

  • A Only read queries are allowed
  • B All queries are blocked
  • C Write operations are allowed
  • D Replication is disabled
Explanation Read-only mode allows only read queries, blocking write operations; the other options are incorrect interpretations.
Q298

Which service can replicate data across multiple regions?

  • A Cloud SQL
  • B Cloud Spanner
  • C Firebase Realtime Database
  • D Bigtable
Explanation Cloud Spanner is designed for global transaction consistency and replication, while others do not support cross-region replication as robustly.
Q299

A company needs a database that scales both horizontally and vertically with strong consistency. Which service should they choose?

  • A Cloud SQL
  • B Bigtable
  • C Cloud Spanner
  • D Firestore
Explanation Cloud Spanner offers both horizontal and vertical scaling with strong consistency, unlike the other options.
Q300

You are configuring IAM roles for a database service. What happens when two conflicting roles are assigned to a user?

  • A Conflicting permissions cancel out
  • B The most permissive role is applied
  • C Access is denied entirely
  • D Roles are merged without conflicts
Explanation The most permissive access applies, as IAM combines roles without cancelling permissions.