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 341–350 of 498

Q341

A company needs to ensure compliance with GDPR. What should they use?

  • A Data Loss Prevention API
  • B Cloud Spanner
  • C Cloud Functions
  • D BigQuery ML
Explanation The Data Loss Prevention API helps identify and protect sensitive data, aiding compliance with regulations like GDPR, unlike the other options.
Q342

You are configuring a Cloud SQL instance. What happens if you set the maximum storage as unlimited?

  • A Automatically deletes old data
  • B Can lead to increased costs
  • C Disables automatic backups
  • D Prevents database connection errors
Explanation Setting maximum storage to unlimited can lead to unexpected cost increases as the data grows, while the others are not directly impacted by this setting.
Q343

Which Google Cloud service is designed for serverless data processing?

  • A BigQuery
  • B Cloud Functions
  • C Cloud SQL
  • D Datastore
Explanation Cloud Functions enables serverless execution of code; the others are not serverless in this context.
Q344

A company needs to ensure high availability for their database. Which Cloud SQL feature should they implement?

  • A Read replicas
  • B Automatic backups
  • C Regional failover
  • D Cloud Functions trigger
Explanation Regional failover ensures high availability by switching database automatically in case of zone failure; the other options do not ensure full high availability.
Q345

What happens when a Bigtable instance is deleted?

  • A Data is stored for 30 days
  • B Data can be restored instantly
  • C Data is permanently lost
  • D Instance can be recreated without data
Explanation Deleting a Bigtable instance results in permanent data loss; data restoration is not possible.
Q346

Which Cloud SQL feature allows automatic backups?

  • A Automated Backups
  • B High Availability
  • C Read Replicas
  • D Query Insights
Explanation Automated Backups schedule restoration points, while others serve different purposes.
Q347

A company needs data analytics on large datasets without managing servers. Which Google Cloud service should they use?

  • A BigQuery
  • B Cloud Spanner
  • C Cloud SQL
  • D Dataproc
Explanation BigQuery is serverless and designed for large data analytics; others require more management or aren't optimized for large data processing.
Q348

What happens when you set a Cloud Firestore document to `update_time` in the future?

  • A The document is deleted
  • B The change is queued
  • C No change occurs until then
  • D Immediate update occurs
Explanation Future timestamps do not apply until the specified time, while other options misinterpret Firestore behaviors.
Q349

Which service offers managed NoSQL database solutions in GCP?

  • A Firestore
  • B Cloud Spanner
  • C BigQuery
  • D Cloud SQL
Explanation Firestore is specifically designed for NoSQL solutions; others serve different purposes.
Q350

A company needs to ensure compliance with GDPR while storing customer data on Google Cloud. What should they implement?

  • A Cloud Key Management Service
  • B VPC Service Controls
  • C Data Loss Prevention API
  • D Cloud Identity and Access Management
Explanation The Data Loss Prevention API helps automate data classification and privacy compliance.