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 261–270 of 498

Q261

You are configuring a Cloud SQL instance with very high read traffic. What happens if you use a single node configuration?

  • A High performance and zero latency
  • B Performance can degrade under load
  • C Automatic scaling occurs automatically
  • D Zero downtime during peak traffic
Explanation A single node can become a bottleneck under high load, leading to degraded performance.
Q262

Which Google Cloud service is best for managing relational databases at scale?

  • A Cloud SQL
  • B Cloud Storage
  • C BigQuery
  • D Cloud Functions
Explanation Cloud SQL is purpose-built for relational databases, while others serve different data needs, making this the best choice.
Q263

A company needs to analyze massive datasets with SQL queries. Which service should they use?

  • A Firestore
  • B BigQuery
  • C Cloud SQL
  • D Memorystore
Explanation BigQuery is optimized for analyzing large datasets using SQL, unlike the other options which serve different purposes.
Q264

What happens when you try to export a Firestore document that exceeds 1MB?

  • A Export succeeds with partial data
  • B Export fails with an error
  • C Data gets truncated to 1MB
  • D Data is compressed automatically
Explanation Firestore export fails if document size exceeds the limit, while other options inaccurately describe handling of size limit.
Q265

Which service is optimized for scalable NoSQL data storage?

  • A Firestore
  • B Cloud Storage
  • C Cloud SQL
  • D BigQuery
Explanation Firestore is designed for NoSQL data storage, while the others serve different purposes.
Q266

A company needs a managed PostgreSQL service without worrying about patching. Which solution should they choose?

  • A Cloud SQL for PostgreSQL
  • B Cloud Bigtable
  • C Google Sheets
  • D Spanner
Explanation Cloud SQL for PostgreSQL provides managed updates and maintenance, unlike the others.
Q267

What happens when a Write operation exceeds the throughput limits in Firestore?

  • A Write fails with an error
  • B Write is queued for retry
  • C Write occurs with latency
  • D Write operation is ignored
Explanation In Firestore, exceeding throughput causes the write to fail, rather than being queued or ignored.
Q268

Which service provides managed NoSQL databases in Google Cloud?

  • A Firestore
  • B Cloud Spanner
  • C Bigtable
  • D Cloud SQL
Explanation Firestore is designed for NoSQL database needs, while others serve different types of data.
Q269

A company needs to implement time-based access control for its database users. Which IAM feature should they consider?

  • A IAM Policies
  • B Cloud Functions
  • C Service Accounts
  • D Workload Identity
Explanation IAM Policies enable granular access control, whereas the others serve different roles.
Q270

What happens when you enable automatic storage increase on a Cloud SQL instance?

  • A Instance scales automatically further
  • B Storage grows as needed during usage
  • C Cost is fixed and does not increase
  • D Performance improves instantly
Explanation Automatic storage increase allows Cloud SQL to adjust storage based on usage, unlike fixed cost or performance changes.