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 461–470 of 498

Q461

A company needs to analyze structured data and run complex queries. Which database service should they use?

  • A Firebase Realtime Database
  • B Cloud Spanner
  • C Bigtable
  • D Cloud Datastore
Explanation Cloud Spanner is designed for SQL queries on structured data; the others mainly handle unstructured or non-structured data.
Q462

You are configuring Cloud SQL for high availability. What feature must you enable?

  • A Read replicas
  • B Zone redundancy
  • C Automatic backups
  • D Failover replicas
Explanation Failover replicas are essential for high availability, unlike the other options, which provide different functionalities.
Q463

Which service is designed for globally distributed, low-latency applications?

  • A Cloud Spanner
  • B Cloud SQL
  • C Bigtable
  • D Cloud Firestore
Explanation Cloud Spanner is designed for consistency and low-latency across global applications, while others serve different use cases.
Q464

A company needs to maintain data consistency during large-scale transactions. What should they consider?

  • A Eventual consistency
  • B Read replicas
  • C Strong consistency
  • D Partitioned tables
Explanation Strong consistency ensures all clients see the same data changes immediately, unlike eventual consistency.
Q465

You are configuring IAM roles for different database access. What happens if a user has conflicting roles?

  • A Access is denied
  • B Access is granted based on highest role
  • C Access is granted based on lowest role
  • D Conflicts need manual resolution
Explanation IAM resolves conflicting roles by allowing access based on the most permissive role, rather than denying it.
Q466

Which Google Cloud service offers NoSQL key-value storage?

  • A Cloud Datastore
  • B Cloud SQL
  • C Cloud Storage
  • D Cloud Bigtable
Explanation Cloud Datastore is designed for NoSQL, while Cloud SQL deals with relational databases.
Q467

A company needs to migrate a large MySQL database to Google Cloud. What is the recommended service for this?

  • A Cloud SQL
  • B Cloud Spanner
  • C Firestore
  • D Dataproc
Explanation Cloud SQL directly supports MySQL, making migration straightforward.
Q468

You are configuring a Cloud Bigtable instance. What happens when you set the garbage collection policy too aggressively?

  • A Data is deleted indefinitely
  • B Performance improves immediately
  • C Data may be unintentionally lost
  • D Costs will dramatically increase
Explanation Setting the policy too aggressively could lead to loss of necessary data.
Q469

Which service should you use for data warehousing in Google Cloud?

  • A BigQuery
  • B Firestore
  • C Cloud SQL
  • D Datastore
Explanation BigQuery is designed for large-scale data analytics, whereas others serve different database needs.
Q470

A company needs to implement database replication with minimal latency. Which service should they choose?

  • A Cloud Spanner
  • B Cloud SQL
  • C Bigtable
  • D Firestore
Explanation Cloud Spanner supports strong consistency and low-latency replication globally, unlike the others.