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 131–140 of 498

Q131

A company needs to run a relational database with auto-scaling capabilities. Which service should they choose?

  • A Cloud SQL
  • B Cloud Spanner
  • C Firebase Realtime Database
  • D Bigtable
Explanation Cloud Spanner offers horizontal scaling for relational databases, suitable for high workloads.
Q132

What happens when you configure a database with a strong consistency model?

  • A Faster response times
  • B Data may be stale
  • C Always returns the latest data
  • D Reduced availability
Explanation Strong consistency ensures the latest data is always returned, reducing stale reads.
Q133

Which service is primarily used for big data analytics on Google Cloud?

  • A BigQuery
  • B Cloud SQL
  • C Cloud Storage
  • D Cloud Firestore
Explanation BigQuery is designed specifically for analyzing large datasets, while the other options serve different purposes.
Q134

A company needs to access Petabytes of historical data rapidly. Which storage solution should they use?

  • A Cloud SQL
  • B Cloud Datastore
  • C Bigtable
  • D Cloud Storage
Explanation Bigtable is optimized for large-scale data retrieval, unlike the other options which aren't designed for such scale.
Q135

What happens when you set a Cloud SQL instance to 'high availability'?

  • A Auto-scalable instance created
  • B Passive replica is created
  • C Multi-region deployment enabled
  • D Backup frequency increased
Explanation High availability creates a standby replica to ensure uptime, while the other options do not accurately describe this feature.
Q136

Which service is used for data analytics on petabytes of data in Google Cloud?

  • A BigQuery
  • B Cloud Spanner
  • C Cloud SQL
  • D Dataflow
Explanation BigQuery is optimized for handling large data analytics whereas others serve different purposes.
Q137

A company needs a fully managed NoSQL database for JSON data. Which Google Cloud service should they use?

  • A Cloud Firestore
  • B Cloud SQL
  • C Cloud Spanner
  • D Bigtable
Explanation Cloud Firestore is designed for scalable NoSQL databases, while others focus on SQL or wide-column storage.
Q138

What happens when a Cloud SQL instance is deleted?

  • A Data is retained permanently
  • B Data is archived automatically
  • C Data is permanently lost
  • D Data can be restored indefinitely
Explanation Deleting a Cloud SQL instance removes data permanently, unlike archiving or retention practices.
Q139

Which type of database scales horizontally without bound?

  • A NoSQL databases
  • B Relational databases
  • C In-memory databases
  • D Data warehouses
Explanation NoSQL databases easily scale horizontally, unlike relational databases that typically require vertical scaling.
Q140

A company needs to ensure their Cloud SQL instance is highly available. What should they implement?

  • A Read replicas
  • B Standard provisioning
  • C High availability (HA) mode
  • D Backup strategy
Explanation Implementing high availability (HA) mode provides automatic failover, ensuring minimized downtime.