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 321–330 of 498

Q321

You are configuring a VPC peering connection. What happens if overlapping subnet ranges exist?

  • A Peering will succeed, but routes will conflict.
  • B Peering will succeed with multiple routes.
  • C Peering will fail to establish.
  • D Virtual networks will merge successfully.
Explanation Overlapping subnet ranges prevent VPC peering from being established.
Q322

Which service is best for NoSQL document storage?

  • A Firestore
  • B Cloud SQL
  • C Cloud Spanner
  • D BigQuery
Explanation Firestore is designed specifically for document storage; others focus on relational SQL or analytics.
Q323

A company needs to enforce security policies on their Cloud SQL instances. Which feature is essential?

  • A VPC Peering
  • B IAM Database Authentication
  • C Load Balancing
  • D Cloud Functions
Explanation IAM Database Authentication allows user identity verification; the others do not enforce access directly.
Q324

What happens when you enable automatic backups for Cloud Spanner?

  • A Destroys all existing data
  • B Triggers data compression
  • C Creates backups daily
  • D Removes all user permissions
Explanation Automatic backups are scheduled daily, the other options are inaccurate representations of cloud service behavior.
Q325

Which service is best for real-time data processing?

  • A Cloud Dataflow
  • B Cloud SQL
  • C Cloud Storage
  • D Cloud Spanner
Explanation Cloud Dataflow is designed for real-time data processing, unlike the other options which serve different purposes.
Q326

A company needs to manage large amounts of relational data. Which Google Cloud service is most appropriate?

  • A Cloud Firestore
  • B Cloud Spanner
  • C BigQuery
  • D Cloud Pub/Sub
Explanation Cloud Spanner is built for relational data at scale, whereas the others serve different data types or purposes.
Q327

What happens when you set a Cloud SQL instance to the highest tier?

  • A Limits access to SQL databases
  • B Increases connection count limit
  • C Reduces backup frequency
  • D Enables Cloud SQL for NoSQL
Explanation The highest tier increases the connection limits, while other options do not accurately reflect changes from tier upgrades.
Q328

Which Google Cloud service is designed for serverless event-driven execution?

  • A Cloud Functions
  • B Cloud Run
  • C App Engine
  • D Compute Engine
Explanation Cloud Functions is specifically for serverless event-driven executions, while others serve different purposes.
Q329

You are configuring Firestore in your application. What happens if you do not set up Firestore security rules?

  • A All data is accessible.
  • B No data can be deleted.
  • C Data encryption is disabled.
  • D Read access is automatically restricted.
Explanation Without security rules, Firestore defaults to allowing read and write access to all data.
Q330

A company needs to store structured and time-series data efficiently. Which database should they consider using?

  • A BigQuery
  • B Cloud Spanner
  • C Cloud Storage
  • D Cloud SQL
Explanation Cloud Spanner is ideal for structured and time-series data due to its scalability and SQL support.