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 111–120 of 498

Q111

You are configuring Cloud Spanner. What happens if you set a database's consistency level to 'Strong'?

  • A Faster response times
  • B Lower availability
  • C Eventual consistency applied
  • D Read-only access only
Explanation Strong consistency ensures all replicas give the same result, potentially reducing availability to maintain data integrity, unlike eventual consistency which allows lower latency and higher availability.
Q112

Which service is best for real-time data processing?

  • A BigQuery
  • B Cloud Pub/Sub
  • C Cloud Storage
  • D Cloud SQL
Explanation Cloud Pub/Sub is designed for real-time messaging, unlike the other options, which serve different purposes.
Q113

A company needs a highly scalable NoSQL database. Which should they use?

  • A Cloud SQL
  • B Firestore
  • C Cloud Storage
  • D Bigtable
Explanation Bigtable is designed for high scalability in NoSQL databases, unlike the other options focused on SQL or object storage.
Q114

You are configuring a Cloud SQL instance. What happens if you set a lower max_connections than your application needs?

  • A Connections will be allowed once established.
  • B New connections will be denied.
  • C Connections will automatically scale.
  • D The instance will crash.
Explanation New connections cannot be established if the max_connections limit is reached, contrary to other options, which misrepresent the behavior.
Q115

A company needs to store large volumes of analytics data. Which Google Cloud service should they use?

  • A BigQuery
  • B Cloud Storage
  • C Cloud SQL
  • D Firestore
Explanation BigQuery is designed for large-scale analytics, while the others are not optimized for this purpose.
Q116

What happens when you enable automatic replication in Cloud Spanner?

  • A Reduces latency across regions
  • B Increases storage costs
  • C Creates multiple data copies
  • D Eliminates failover time
Explanation Automatic replication ensures multiple data copies for reliability, while the others are misleading.
Q117

You are configuring IAM roles for a Cloud SQL instance. What is the effect of granting the 'roles/cloudsql.viewer' role?

  • A Full access to manage databases
  • B Read-only access to databases
  • C No access to Cloud SQL
  • D Ability to delete instances
Explanation The 'roles/cloudsql.viewer' role allows read-only access, while the other options provide incorrect permissions.
Q118

Which Google Cloud service is best for managing large scale NoSQL databases?

  • A Firestore
  • B Cloud SQL
  • C BigQuery
  • D Cloud Spanner
Explanation Cloud Spanner is designed for large scale NoSQL databases, while Firestore is more suited for document storage, Cloud SQL for relational databases, and BigQuery for analytics.
Q119

A company needs to provide managed MySQL instances for multi-regional access; what should they use?

  • A Cloud SQL
  • B Cloud Functions
  • C Firestore
  • D App Engine
Explanation Cloud SQL supports managed MySQL instances suited for multi-regional access, whereas the others do not provide managed relational databases.
Q120

What happens when a Cloud Firestore document exceeds 1 MB in size?

  • A Document is stored as usual
  • B Document is split into smaller parts
  • C An error is thrown
  • D Document is served without changes
Explanation When a Cloud Firestore document exceeds 1 MB, an error is thrown as it violates the maximum size limit for documents.