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 191–200 of 498

Q191

A company needs a scalable NoSQL database with global distribution. Which should they choose?

  • A Cloud SQL
  • B Bigtable
  • C Datastore
  • D Firestore
Explanation Bigtable offers global scalability and is designed for high-throughput data access.
Q192

What happens when you overwrite an existing BigQuery table?

  • A Data is permanently deleted.
  • B Only schema is updated.
  • C Table is duplicated.
  • D Data is appended.
Explanation Overwriting replaces the table's data, losing the previous contents.
Q193

Which service allows automatic scaling of NoSQL databases?

  • A Cloud Spanner
  • B Cloud SQL
  • C Firestore
  • D BigQuery
Explanation Firestore automatically scales based on demand; others require manual scaling or are more suited for structured data.
Q194

A company needs to ensure strict data access controls for its databases. What feature should they implement?

  • A IAM roles and permissions
  • B Database replicas
  • C Backup and restore
  • D Data encryption at rest
Explanation IAM roles and permissions manage data access; the others focus on data protection, not access control.
Q195

You are configuring a scheduled export of your Cloud SQL database. What happens during the export?

  • A Database is locked temporarily
  • B All pending transactions are processed
  • C Export occurs without data modifications
  • D Export fails if no backup exists
Explanation The export process is non-intrusive; options A and B imply interruptions that do not occur, and D is incorrect as exports don't require existing backups.
Q196

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

  • A Cloud Firestore
  • B Cloud SQL
  • C Cloud Spanner
  • D BigQuery
Explanation Cloud Firestore is designed specifically for NoSQL needs, while others serve SQL or analytical purposes.
Q197

A company needs to ensure their Cloud SQL instance is fault-tolerant. What should they configure?

  • A Standard Environment
  • B High Availability
  • C Automatic Backups
  • D Read Replicas
Explanation High Availability uses a primary-replica setup for fault tolerance, unlike the others which do not provide this level of redundancy.
Q198

You are configuring a Cloud Bigtable instance. What happens if you set the cluster replication to zero?

  • A No data will be stored
  • B Data will be replicated once
  • C Only a single cluster will exist
  • D Data will be lost immediately
Explanation Setting replication to zero means no additional replicas are created, maintaining only the initial cluster.
Q199

Which service is best for real-time analytics on streaming data in Google Cloud?

  • A BigQuery
  • B Cloud Pub/Sub
  • C Dataflow
  • D Cloud Storage
Explanation Dataflow handles real-time streaming analytics, while others are not designed for this purpose.
Q200

A company needs to ensure that their Cloud SQL database is highly available. What should they configure?

  • A Read replicas
  • B Cloud Functions
  • C Failover replicas
  • D Backup schedules
Explanation Failover replicas provide high availability by taking over if the primary instance fails.