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 251–260 of 498

Q251

A company needs to ensure data is encrypted at rest and in transit. Which combination should they use?

  • A IAM roles
  • B Cloud KMS and SSL/TLS
  • C VPC Service Controls
  • D Cloud SQL only
Explanation Cloud KMS supports encryption at rest, and SSL/TLS secures data in transit.
Q252

What happens when you encounter a retention policy violation in Cloud Storage?

  • A Objects are deleted immediately
  • B Logs are generated for audit
  • C Notification sent to admin
  • D Policy is ignored by default
Explanation Retention policies enforce deletion of objects once their retention period expires.
Q253

Which Google Cloud service offers a serverless way to run databases?

  • A Cloud Firestore
  • B Cloud Spanner
  • C Cloud SQL
  • D BigQuery
Explanation Cloud Firestore is serverless; others require management.
Q254

A company needs to seamlessly scale its database backend during peak season. Which Google Cloud service should they use?

  • A Cloud SQL
  • B Cloud Firestore
  • C Cloud Spanner
  • D Bigtable
Explanation Cloud Spanner is designed for horizontal scaling.
Q255

You are configuring IAM policies for a Cloud SQL database. What happens if you attach a role that doesn't include 'cloudsql.instances.get'?

  • A Access denied for instance details.
  • B User can still access instance.
  • C Role will not apply.
  • D Access granted automatically.
Explanation Access to instance details requires specific roles.
Q256

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

  • A Cloud Pub/Sub
  • B BigQuery
  • C Cloud Functions
  • D Cloud SQL
Explanation Cloud Pub/Sub is designed for real-time messaging.
Q257

A company needs a highly available database for e-commerce. Which Google Cloud service should they choose?

  • A Cloud Firestore
  • B Cloud Datastore
  • C Cloud Spanner
  • D Cloud Bigtable
Explanation Cloud Spanner offers global availability and consistency.
Q258

What happens when you exceed the quota on Cloud SQL instances?

  • A Instances shut down immediately
  • B No additional connections are accepted
  • C Billing for overtime usage occurs
  • D Data gets deleted automatically
Explanation Exceeding the quota prevents new connections but does not shut down existing instances.
Q259

Which Google Cloud service is best for real-time data processing?

  • A Dataflow
  • B Cloud Storage
  • C BigQuery
  • D Cloud SQL
Explanation Dataflow is designed for real-time processing, while others are not focused on real-time tasks.
Q260

A company needs to migrate a legacy database to Google Cloud with minimal downtime. Which service should they use?

  • A Cloud Spanner
  • B Cloud SQL Database Migration Service
  • C BigQuery
  • D Firestore
Explanation Cloud SQL Database Migration Service facilitates minimal downtime migration, whereas others do not specialize in migration.