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 141–150 of 498

Q141

What happens when a Cloud Bigtable column family is deleted?

  • A Data remains accessible
  • B All data is permanently deleted
  • C Storage is automatically reduced
  • D Data is archived for 30 days
Explanation Deleting a column family in Bigtable permanently deletes all data within that family.
Q142

Which service allows you to manage NoSQL databases in Google Cloud?

  • A Firestore
  • B Cloud SQL
  • C BigQuery
  • D Cloud Spanner
Explanation Firestore is specifically designed for NoSQL data, unlike the others which cater to SQL or analytics.
Q143

A company needs automated backups for their Cloud SQL instance. What is the best configuration?

  • A Enable automated backups in instance settings
  • B Manually back up every week
  • C Use Cloud Storage for backups
  • D Disable backups for cost savings
Explanation Automated backups in instance settings ensure consistent data recovery without manual intervention.
Q144

What happens when you exceed the storage quota on a Google Cloud Datastore?

  • A Data deletion occurs automatically
  • B New writes are rejected until reduced
  • C Performance improves temporarily
  • D No impact on existing data
Explanation Exceeding the storage quota results in rejection of new writes while existing data remains intact.
Q145

Which Google Cloud service is best for managed NoSQL databases?

  • A Cloud Firestore
  • B Cloud Spanner
  • C Cloud SQL
  • D BigQuery
Explanation Cloud Firestore is designed for NoSQL; others serve different use cases.
Q146

A company needs a highly available relational database. Which service should they choose?

  • A Cloud SQL with read replicas
  • B Cloud Storage
  • C Cloud Datastore
  • D Pub/Sub
Explanation Cloud SQL with read replicas ensures high availability; others do not provide relational capabilities.
Q147

You are configuring a database backup strategy. What happens if you set too short of a backup interval?

  • A Wasted storage space
  • B Increased recovery time
  • C Higher cost due to frequency
  • D Faster data retrieval
Explanation Short backup intervals lead to higher costs; others are misleading scenarios.
Q148

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

  • A BigQuery
  • B Cloud SQL
  • C Cloud Spanner
  • D Firestore
Explanation BigQuery is optimized for real-time analytics, while the others serve different purposes.
Q149

A company needs a highly available relational database solution. Which Google Cloud service should they use?

  • A Cloud Functions
  • B Cloud SQL
  • C BigTable
  • D Datastore
Explanation Cloud SQL offers high availability features for relational databases, unlike the other options.
Q150

What happens when you set a Cloud Spanner database to read-only mode?

  • A Write operations succeed
  • B Only read operations succeed
  • C All operations are blocked
  • D Data replication stops
Explanation In read-only mode, only read operations can be performed while writes are disallowed.