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 81–90 of 498

Q81

What happens when you exceed a Cloud SQL instance’s maximum connections?

  • A Requests are automatically retried
  • B New connections are denied
  • C Existing connections are dropped
  • D Instance shuts down
Explanation When maximum connections are exceeded, new connections are denied to maintain stability in the Cloud SQL instance.
Q82

Which service allows you to manage relational databases in Google Cloud?

  • A Cloud SQL
  • B Cloud Storage
  • C BigQuery
  • D Cloud Datastore
Explanation Cloud SQL is designed for relational databases, while the others serve different purposes.
Q83

A company needs to replicate their Cloud Spanner database across two regions for high availability. What must they do?

  • A Enable cross-region replication
  • B Use Cloud Storage buckets
  • C Set up a Cloud Function
  • D Migrate to BigQuery
Explanation Cross-region replication is explicitly supported in Cloud Spanner for high availability.
Q84

You are configuring a Cloud Firestore database with rules for access control. What happens when a document is targeted by a read rule that denies access?

  • A Access is granted with warnings
  • B Access is completely denied
  • C Access logs the attempt
  • D Access returns a default value
Explanation A deny rule in Firestore explicitly prevents access to the document.
Q85

Which service provides managed NoSQL database solutions?

  • A Firebase Realtime Database
  • B Cloud SQL
  • C Cloud Storage
  • D BigQuery
Explanation Firebase Realtime Database is designed for NoSQL data, while Cloud SQL and BigQuery cater to SQL database and analytics respectively, and Cloud Storage is for unstructured data.
Q86

A company needs to access data from an on-premises database rapidly without downtime. Which approach is best?

  • A Use Database Migration Service.
  • B Manually export and import data.
  • C Create a read replica.
  • D Use Static Data Transfer.
Explanation Database Migration Service allows for zero-downtime migrations, whereas manual transfer and static methods are slower or disruptive.
Q87

What happens when you disable a public IP on a Cloud SQL instance?

  • A Instance becomes inaccessible.
  • B Only private IP is accessible.
  • C Instance runs on a different node.
  • D Data is deleted immediately.
Explanation Disabling the public IP allows access only via the private IP, while options A, C, and D misrepresent the instance's operational changes.
Q88

Which service is used for managed NoSQL databases in Google Cloud?

  • A Cloud Bigtable
  • B Cloud SQL
  • C Cloud Functions
  • D Cloud Pub/Sub
Explanation Cloud Bigtable is specifically designed for NoSQL requirements while others serve different purposes or database types.
Q89

You are configuring IAM roles for a team using Cloud Storage. What is the least privilege principle?

  • A Grant all permissions
  • B Give minimal necessary access
  • C Use default presets only
  • D Assign one role per user
Explanation The least privilege principle ensures users have only the access needed to perform their tasks, which enhances security.
Q90

What happens when a Cloud SQL instance is stopped?

  • A Data is deleted
  • B Instance incurs charges
  • C Data storage is retained
  • D Automatic backups are disabled
Explanation Stopping a Cloud SQL instance retains data storage, unlike deletion where data is lost; charges can vary based on configuration.