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 451–460 of 498

Q451

Which service is best for large OLAP workloads?

  • A BigQuery
  • B Cloud SQL
  • C Cloud Spanner
  • D Firestore
Explanation BigQuery is optimized for OLAP queries and large datasets, unlike the other options.
Q452

A company needs to ensure high availability for their Cloud SQL instance. What should they enable?

  • A Read replicas
  • B IPv6
  • C Patch management
  • D VPC peering
Explanation Read replicas help to distribute load and enhance availability, while other options do not directly achieve high availability.
Q453

You are configuring IAM roles for a service account. What happens if multiple roles with different permissions are assigned?

  • A All permissions are combined
  • B Only the highest role applies
  • C Permissions are ignored
  • D Roles conflict and fail
Explanation All permissions from different roles are effectively combined for the service account.
Q454

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

  • A BigQuery
  • B Cloud Dataflow
  • C Cloud SQL
  • D Cloud Spanner
Explanation Cloud Dataflow is designed for processing real-time data streams, while the others focus on batch processing or SQL databases.
Q455

A company needs a database that can scale horizontally and provide strong consistency. Which should they choose?

  • A Cloud SQL
  • B Cloud Spanner
  • C Firestore
  • D Bigtable
Explanation Cloud Spanner offers horizontal scaling and strong ACID guarantees, unlike the other options which do not meet both criteria.
Q456

What happens when you increase the number of replicas in Cloud SQL?

  • A Decreased latency for read operations
  • B Increased cost only
  • C More write capacity available
  • D Increased backup duration
Explanation Increasing replicas improves read performance and reduces latency, unlike the other options which are either incorrect or misleading.
Q457

Which service is best for real-time data processing?

  • A Cloud Dataflow
  • B Cloud Storage
  • C Cloud SQL
  • D BigQuery
Explanation Cloud Dataflow is designed for real-time data processing, while the others focus on storage or batch processing.
Q458

A company needs to replicate data across regions for disaster recovery. Which Google Cloud service is best suited?

  • A Cloud Pub/Sub
  • B Cloud Storage Transfer Service
  • C Cloud Spanner
  • D Firebase Realtime Database
Explanation Cloud Spanner provides multi-region replication for disaster recovery, unlike the other options which don't specialize in this area.
Q459

What happens when a Cloud SQL instance is stopped?

  • A All data is deleted
  • B No billing occurs
  • C Backups are automatically created
  • D Instance configuration is reset
Explanation Billing stops only when a Cloud SQL instance is stopped but the data remains intact unlike option A, C, and D.
Q460

Which service allows real-time data processing in Google Cloud?

  • A Cloud Pub/Sub
  • B Cloud Functions
  • C Cloud SQL
  • D BigQuery
Explanation Cloud Pub/Sub enables real-time messaging, while the others serve different functions.