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 381–390 of 498

Q381

What happens when you use a Firestore instance in an offline mode?

  • A Data losses occur during sync
  • B Local data is cached
  • C Indexed data is deleted
  • D Only reads are allowed
Explanation Firestore allows local caching of data for offline access, unlike other options which are incorrect.
Q382

Which service is best for NoSQL document storage?

  • A Firestore
  • B Cloud Spanner
  • C BigQuery
  • D Cloud SQL
Explanation Firestore is designed for NoSQL document storage; Cloud Spanner is for SQL, BigQuery for analytics, and Cloud SQL for relational data.
Q383

A company needs to migrate data from on-premise MySQL to GCP without downtime. What should they use?

  • A Database Migration Service
  • B Cloud Storage Transfer Service
  • C Dataflow
  • D gsutil
Explanation Database Migration Service allows for minimal downtime when migrating databases; the others do not support this specific use case.
Q384

You are configuring Cloud SQL replicas. What happens when a master instance is deleted?

  • A Replicas become standalone instances
  • B Replicas remain active but unusable
  • C Replicas are automatically deleted
  • D Replicas migrate to another region
Explanation If the master is deleted, all replicas are also deleted as they depend on the master instance.
Q385

Which service allows managed serverless Postgres databases?

  • A Cloud SQL
  • B BigQuery
  • C Cloud Spanner
  • D Firestore
Explanation Cloud SQL provides serverless managed databases for Postgres; others serve different purposes.
Q386

A company needs to maintain data consistency during multi-region writes. What should they use?

  • A Cloud Bigtable
  • B Cloud Spanner
  • C Firestore
  • D Cloud SQL
Explanation Cloud Spanner offers strong consistency and horizontal scalability across regions; others do not handle this well.
Q387

You are configuring a backup policy in Cloud SQL. What happens when you set the backup to 'enabled' but 'no retention'?

  • A Backups will not be taken.
  • B All backups are kept indefinitely.
  • C Backups will be deleted immediately.
  • D Backups will be expired automatically.
Explanation Setting 'no retention' means backups will be automatically deleted when new backups are taken; others are incorrect regarding backup management.
Q388

Which service is best for NoSQL databases in GCP?

  • A Firestore
  • B Cloud SQL
  • C BigQuery
  • D Cloud Spanner
Explanation Firestore is tailored for NoSQL document storage, unlike the others that serve different database models.
Q389

A company needs to set up a relational database with automated backups. What should they choose?

  • A Cloud Bigtable
  • B Cloud SQL
  • C Firestore
  • D Memorystore
Explanation Cloud SQL supports automated backups for relational databases, while others do not have this feature.
Q390

What happens when an instance exceeds its allocated CPU quota on GCP?

  • A Instance is automatically suspended
  • B Additional charges are applied
  • C Instance performance degrades
  • D Instance is recreated with higher quota
Explanation Performance degrades when CPU quota is exceeded; it does not auto-suspend or elevate the quota automatically.