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 351–360 of 498

Q351

You are configuring a Cloud SQL instance. What happens if you choose the 'High Availability' option?

  • A Data is replicated to multiple regions
  • B Automatic backups are disabled
  • C A standby instance is created
  • D Performance is reduced by half
Explanation High Availability creates a standby instance for failover, ensuring continuity.
Q352

Which Google Cloud service automates database backups?

  • A Cloud SQL
  • B Dataflow
  • C Cloud Storage
  • D Firestore
Explanation Cloud SQL offers automated backups; the others do not specifically provide this service.
Q353

A company needs to analyze big data with minimal operational overhead. Which service should they use?

  • A BigQuery
  • B Spanner
  • C Cloud SQL
  • D Datastore
Explanation BigQuery is designed for big data analytics; Spanner and Cloud SQL are for transactional workloads.
Q354

What happens when you configure a Cloud Memorystore instance with a 0% eviction policy?

  • A Cache is not stored
  • B Old data gets deleted
  • C New data cannot be added
  • D Instance will crash
Explanation A 0% eviction policy prevents old data eviction, thus disallowing new writes if the memory limit is reached; the others are incorrect about storage behavior.
Q355

Which service is best for managed NoSQL database solutions?

  • A Google Cloud Bigtable
  • B Google Cloud SQL
  • C Google Cloud Datastore
  • D Google Cloud Spanner
Explanation Cloud Datastore is optimized for NoSQL data.
Q356

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

  • A Google Cloud Pub/Sub
  • B Google Cloud Storage
  • C Google Cloud BigQuery
  • D Google Cloud Functions
Explanation Cloud Pub/Sub is designed for real-time data streaming.
Q357

You are configuring IAM roles for a service account. What is the least privilege principle?

  • A Assign maximum permissions possible
  • B Assign only necessary permissions
  • C Assign default project permissions
  • D Ignore permission assignment
Explanation Least privilege means minimal necessary permissions.
Q358

Which Google Cloud service is designed for interactive analytics?

  • A BigQuery
  • B Cloud SQL
  • C Datastore
  • D Cloud Spanner
Explanation BigQuery is specifically optimized for interactive analytics, while the others serve different database purposes.
Q359

A company needs a scalable solution for NoSQL data. Which product should they choose?

  • A Cloud SQL
  • B Redis on Cloud Memorystore
  • C Cloud Firestore
  • D Cloud Bigtable
Explanation Cloud Bigtable is designed for large-scale NoSQL data, unlike the other options which focus on different paradigms.
Q360

You are configuring high availability for your Cloud SQL instance. What happens when one zone becomes unavailable?

  • A The instance is deleted automatically.
  • B Automatic failover occurs.
  • C You lose all data immediately.
  • D No change; it remains unavailable.
Explanation Automatic failover helps maintain availability in case of zone failure, unlike the other options which are incorrect scenarios.