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 211–220 of 498

Q211

Which service would best handle dynamic web application data?

  • A Cloud SQL
  • B Cloud Storage
  • C BigQuery
  • D Firestore
Explanation Firestore is optimized for real-time synchronization, making it ideal for dynamic data, whereas Cloud SQL is relational and BigQuery is designed for analytics.
Q212

A company needs to ensure high availability for its Cloud SQL instances. What should they do?

  • A Enable read replicas
  • B Deploy to one zone
  • C Use standard storage
  • D Set backup window
Explanation Enabling read replicas can improve availability and load balancing, while deploying to one zone risks downtime.
Q213

What happens when you deploy a Cloud Function in a non-default region?

  • A Increased latency only
  • B Reduced billing costs
  • C Limited region availability
  • D Regional resources are used
Explanation Deploying in a non-default region uses regional resources and might offer proximity benefits, while other options are misleading.
Q214

Which Google Cloud service is best for processing large-scale streaming data?

  • A Dataflow
  • B Cloud SQL
  • C BigQuery
  • D Cloud Storage
Explanation Dataflow is designed for real-time stream processing, while the others serve different data handling purposes.
Q215

A startup needs to manage a temporary workload for a product launch. Which storage option maintains low cost while being accessible?

  • A Persistent Disk
  • B Cloud Storage Nearline
  • C Bigtable
  • D Cloud SQL
Explanation Cloud Storage Nearline is low-cost and suitable for infrequently accessed data, ideal for temporary workloads.
Q216

You are configuring IAM roles for developers. What would happen if you assign 'roles/editor' instead of 'roles/viewer'?

  • A Read-only access
  • B Full project permissions
  • C No access at all
  • D Service accounts only
Explanation The 'roles/editor' allows full permissions, which exceeds the intended viewer access.
Q217

Which service offers fully managed NoSQL databases in Google Cloud?

  • A Firestore
  • B Cloud SQL
  • C BigQuery
  • D Cloud Spanner
Explanation Firestore is designed for NoSQL, while others are SQL-based.
Q218

A company needs a global distribution for its database. Which Google Cloud product should they use?

  • A Cloud Firestore
  • B Cloud SQL
  • C Bigtable
  • D Cloud Spanner
Explanation Cloud Spanner is designed for global distribution; others aren't.
Q219

You are configuring backups for a Cloud SQL instance. What happens if you choose point-in-time recovery?

  • A You can restore to any timestamp.
  • B Backups are deleted immediately.
  • C Restoration takes 24 hours.
  • D Backing up halts database operations.
Explanation Point-in-time recovery allows restoring to any timestamp; others are incorrect.
Q220

Which service is best for migrating databases to Google Cloud?

  • A Database Migration Service
  • B Cloud Pub/Sub
  • C BigQuery
  • D Cloud Dataflow
Explanation Database Migration Service is designed specifically for seamless database migration, while the others serve different purposes.