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 201–210 of 498

Q201

What happens when you exceed your Cloud Firestore quota on writes?

  • A Writes are automatically throttled
  • B No writes will be accepted
  • C Writes will return an error
  • D Responses will be delayed
Explanation Exceeding the quota means additional writes are rejected until the next quota cycle.
Q202

Which service is best for data warehouse analytics?

  • A BigQuery
  • B Cloud Storage
  • C Cloud SQL
  • D Firestore
Explanation BigQuery is designed for data warehouse analytics, while others serve different purposes.
Q203

A company needs to ensure high availability for their database. What is a recommended approach?

  • A Use a single regional instance
  • B Implement read replicas
  • C Enable automatic back-ups only
  • D Choose a low-traffic region
Explanation Implementing read replicas distributes traffic and increases availability, unlike single instances or only backups.
Q204

You are configuring Cloud SQL for a production environment. What happens when you enable the 'automatic failover' feature?

  • A Data will be deleted
  • B Service will become slower
  • C Spooling transaction logs begin
  • D Promotes the standby instance immediately
Explanation Enabling 'automatic failover' allows spooling of transaction logs for recovery, unlike other options which are irrelevant or misleading.
Q205

Which service is best for managing NoSQL databases on Google Cloud?

  • A Cloud Firestore
  • B Cloud SQL
  • C Cloud Spanner
  • D BigQuery
Explanation Cloud Firestore is specifically designed for NoSQL databases, while others serve different purposes.
Q206

A company needs to process real-time data streams. Which Google Cloud product is most suitable?

  • A BigQuery
  • B Pub/Sub
  • C Cloud Functions
  • D Cloud Storage
Explanation Pub/Sub is designed for real-time messaging and stream processing, unlike the other options.
Q207

What happens when a Cloud SQL instance exceeds its maximum storage limit?

  • A Instance is automatically deleted
  • B Write operations fail
  • C Additional storage is purchased
  • D Instance performance is throttled
Explanation Write operations will fail once the storage limit is exceeded, preventing data loss.
Q208

Which Google Cloud service is best for handling large-scale SQL workloads?

  • A Cloud SQL
  • B Bigtable
  • C Cloud Firestore
  • D Datastore
Explanation Cloud SQL is designed for relational databases, while the others handle different data models.
Q209

A company needs to tremendously increase read and write throughput for a NoSQL database. Which option should they consider?

  • A Use Cloud Firestore
  • B Use Cloud Spanner
  • C Use Datastore
  • D Use Cloud SQL
Explanation Cloud Spanner scales seamlessly for large workloads, while the others do not support high throughput effectively.
Q210

You are configuring backup tables in BigQuery. What happens when you attempt to create a backup of a table marked 'Native table'?

  • A Backup is created successfully.
  • B Backup process fails.
  • C Only partial data is backed up.
  • D Backup cannot maintain time partitioning.
Explanation BigQuery does not support direct backups for native tables without alternative methods.