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 281–290 of 498

Q281

A company needs to analyze streaming data in real-time. Which service should they use?

  • A Cloud Pub/Sub
  • B Cloud Functions
  • C Cloud Dataflow
  • D BigQuery
Explanation Cloud Dataflow is specifically built for real-time data processing, unlike the other options.
Q282

You are configuring a Cloud SQL instance and must ensure it scales automatically. What feature should you enable?

  • A Read Replicas
  • B Storage Autoscaling
  • C High Availability
  • D Regional Resilience
Explanation Storage Autoscaling allows automatic scaling, unlike the others which serve different purposes.
Q283

Which service is used for managed NoSQL databases in GCP?

  • A Firestore
  • B Cloud SQL
  • C Bigtable
  • D Cloud Spanner
Explanation Firestore is designed for NoSQL data models; Cloud SQL is for SQL databases.
Q284

A company needs to store and query large volumes of time-series data. What GCP service should they choose?

  • A BigQuery
  • B Memorystore
  • C Cloud SQL
  • D Cloud Datastore
Explanation BigQuery is optimized for large analytics queries, including time-series data.
Q285

What happens when you set an instance's 'Automatic Backups' to 'off'?

  • A Backups are stored in Cloud Storage
  • B No backups will be created
  • C Only manual backups are possible
  • D Backups become less frequent
Explanation Setting 'Automatic Backups' to 'off' disables all automatic backups.
Q286

Which service provides managed data warehousing in Google Cloud?

  • A BigQuery
  • B Cloud SQL
  • C Firestore
  • D Cloud Spanner
Explanation BigQuery is specifically designed for scalable analytics and data warehousing needs, unlike other options which serve different purposes.
Q287

A company needs to achieve low-latency reads for session data in a multi-region setup. What should they use?

  • A Cloud Bigtable
  • B Cloud SQL
  • C FireStore
  • D Cloud Spanner
Explanation Cloud Bigtable is optimized for low-latency, high-throughput workloads, making it suitable for session data.
Q288

You are configuring a database with automatic failover. What happens in case of failure?

  • A Database restarts in the same zone
  • B Service interrupts until resolved
  • C Requests are rerouted to standby
  • D User must manually restart
Explanation With automatic failover, traffic is automatically redirected to a standby instance, ensuring continuity.
Q289

A company requires a fully managed database with automatic scaling. Which service should they use?

  • A Cloud Firestore
  • B Cloud Spanner
  • C Bigtable
  • D Cloud SQL
Explanation Cloud Spanner offers automatic scaling, while others do not.
Q290

What happens when you set a Cloud SQL instance to use Private IP only?

  • A Accessible only via VPN
  • B No external access available
  • C Allows public IP access
  • D No access control applied
Explanation Private IP settings block external access completely.