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 101–110 of 498

Q101

A company needs to migrate a large volume of data with minimal downtime. Which approach should they use?

  • A Scheduled downtime migration
  • B Cold migration
  • C Online migration using Database Migration Service
  • D Manual data transfer
Explanation Online migration using Database Migration Service minimizes downtime; others can lead to significant outages.
Q102

You are configuring a Cloud SQL instance with automatic backups. What happens if a backup fails?

  • A All backups will fail subsequently
  • B Only the failed backup is retried
  • C The backup process stops forever
  • D The next backup will still occur
Explanation If a backup fails, the next scheduled backup will still proceed without interruption; other options incorrectly imply a complete failure of the service or process.
Q103

Which Google Cloud service provides fully managed NoSQL databases?

  • A Cloud Firestore
  • B Cloud Spanner
  • C Cloud SQL
  • D BigQuery
Explanation Cloud Firestore is designed for NoSQL, unlike others.
Q104

A company needs consistent and scalable relational database. Which option should they choose?

  • A Cloud SQL
  • B Cloud Datastore
  • C Cloud Memorystore
  • D Cloud Storage
Explanation Cloud SQL offers relational databases with scalability.
Q105

What happens when you exceed Cloud Firestore's write rate limits?

  • A Transactions are automatically retried.
  • B Writes will succeed instantly.
  • C The database will reset.
  • D Writes are rejected temporarily.
Explanation Exceeding limits results in temporary write rejections, unlike automatic retries.
Q106

Which service provides a fully managed NoSQL document database?

  • A Cloud Firestore
  • B Cloud SQL
  • C Cloud Bigtable
  • D Cloud Spanner
Explanation Cloud Firestore is designed for NoSQL document storage; Cloud SQL, Bigtable, and Spanner are not NoSQL document databases.
Q107

A company needs to analyze large datasets quickly without upfront costs. Which GCP service should they use?

  • A BigQuery
  • B Cloud Storage
  • C Dataproc
  • D Cloud Functions
Explanation BigQuery allows for on-demand analysis of large datasets without upfront costs; the others don't meet this need effectively.
Q108

What happens when you set up a replica with Cloud Spanner and one region goes down?

  • A Database becomes read-only
  • B Automatic failover to another region
  • C Data loss occurs
  • D Transaction errors cannot be resolved
Explanation Cloud Spanner supports automatic failover, ensuring availability; the other options do not reflect the service's capabilities.
Q109

Which service provides a fully managed NoSQL database for application development?

  • A Cloud Firestore
  • B Cloud SQL
  • C Google Sheets
  • D Cloud Bigtable
Explanation Cloud Firestore is a NoSQL document database, whereas Cloud SQL is relational, Google Sheets is for spreadsheets, and Cloud Bigtable is designed for analytics and key-value workloads.
Q110

A company needs to restore a Cloud SQL instance to a specific point in time. What feature should they use?

  • A Read replicas
  • B Point-in-time recovery
  • C Backup export
  • D Automatic failover
Explanation Point-in-time recovery allows restoration from specific timestamps, while read replicas are for scaling and backups are for static retrieval of data.