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 171–180 of 498

Q171

What happens when you set a Cloud Storage bucket's uniform access control to 'Uniform'?

  • A All objects inherit bucket permissions
  • B Objects maintain individual permissions
  • C Only project owners can access it
  • D Bucket cannot store public objects
Explanation Uniform access means all objects share the same permissions; individual permissions are removed.
Q172

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

  • A Firestore
  • B Cloud SQL
  • C BigQuery
  • D Cloud Spanner
Explanation Firestore is designed specifically for NoSQL databases, while the others are different database types.
Q173

A company needs real-time analytics for streaming data. Which Google Cloud service should they use?

  • A BigQuery
  • B Dataflow
  • C Cloud Storage
  • D Pub/Sub
Explanation Dataflow is designed for stream processing, while the others are not specialized for real-time analytics.
Q174

You are configuring backups for a Cloud SQL instance. What happens if the daily backup fails?

  • A Backup retries automatically
  • B Instance shuts down
  • C Backup is skipped for the day
  • D You receive an alert only
Explanation If a daily backup fails, it is skipped, whereas B and D do not accurately describe the behavior.
Q175

Which Google Cloud service is best for real-time analytics?

  • A BigQuery
  • B Cloud SQL
  • C Pub/Sub
  • D Firestore
Explanation BigQuery is designed for real-time analytics on large datasets, while others serve different purposes.
Q176

A company needs to store sensitive data with access controls. Which GCP feature should they prioritize?

  • A IAM Policies
  • B Cloud Storage Buckets
  • C Firewalls
  • D Logs Routing
Explanation IAM Policies provide fine-grained access control, unlike the other options.
Q177

What happens if you exceed your Cloud SQL instance storage limits?

  • A Instance automatically upgrades
  • B Database becomes read-only
  • C Instance crashes immediately
  • D Storage is deleted immediately
Explanation Exceeding storage limits causes Cloud SQL to become read-only until resolved, while others are incorrect scenarios.
Q178

Which Google Cloud service offers fully managed NoSQL databases?

  • A Cloud Firestore
  • B Cloud SQL
  • C BigQuery
  • D Cloud Spanner
Explanation Cloud Firestore is a serverless NoSQL database, while the others serve different database models.
Q179

A company needs high availability and automatic scaling for its relational database. Which service should they use?

  • A Cloud SQL
  • B Bigtable
  • C Cloud Spanner
  • D Memorystore
Explanation Cloud Spanner is specifically designed for high availability and scalability in relational databases.
Q180

What happens when you enable IAM policies on a Cloud SQL instance?

  • A User access is completely denied.
  • B Data encryption is disabled.
  • C Access is controlled by defined roles.
  • D Backups become automatic.
Explanation IAM policies control access based on roles, while the other options are incorrect effects of IAM on Cloud SQL.