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 411–420 of 498

Q411

What happens when you exceed the read limits in Firestore?

  • A Temporary throttling occurs
  • B All reads are blocked permanently
  • C Reads are processed without limits
  • D Data is corrupted
Explanation Temporary throttling occurs to manage excess reads, preventing overload, unlike permanent blocking or data corruption.
Q412

Which service allows automatic scaling based on demand in Google Cloud?

  • A Google Kubernetes Engine
  • B Cloud SQL
  • C BigQuery
  • D Cloud Functions
Explanation Cloud Functions scales automatically to meet demand, while others require manual intervention.
Q413

A company needs to migrate a relational database to Google Cloud. Which service best supports high availability?

  • A Cloud Firestore
  • B Cloud Spanner
  • C Cloud Storage
  • D Bigtable
Explanation Cloud Spanner is designed for high availability and scalability in relational databases.
Q414

What happens when you set a Cloud SQL instance to 'private IP' only?

  • A Public access is allowed.
  • B Instance cannot be accessed externally.
  • C Instance performs faster.
  • D Data backup is not available.
Explanation Setting 'private IP' restricts access to internal networks only, preventing external access.
Q415

Which Google Cloud service offers fully-managed NoSQL database solutions?

  • A Cloud Firestore
  • B Cloud SQL
  • C Cloud Spanner
  • D Cloud Datastore
Explanation Cloud Firestore is designed for NoSQL; the others are SQL-based or not NoSQL-oriented.
Q416

A company needs to ensure that their Cloud SQL instances are encrypted. What setting should they enable?

  • A Data In Transit Encryption
  • B Integrity Enforcement
  • C Full Disk Encryption
  • D Network Security Rules
Explanation Full Disk Encryption secures stored data; options A and D don’t encrypt at rest.
Q417

You are configuring rights management for BigQuery. What happens if you grant a user 'roles/bigquery.dataViewer'?

  • A User can create datasets
  • B User can delete tables
  • C User can read table data
  • D User can export data only
Explanation 'roles/bigquery.dataViewer' allows read access only; others allow actions the role does not permit.
Q418

Which Google Cloud service would you use for fully managed NoSQL document databases?

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

A company needs to optimize costs for frequently accessed data; which should they use?

  • A Coldline Storage
  • B Standard Storage
  • C Archive Storage
  • D Regional Storage
Explanation Standard Storage is the most cost-effective for frequently accessed data compared to Coldline or Archive Storage.
Q420

What happens when you delete a project in Google Cloud?

  • A All data is permanently lost.
  • B Data is retained for 30 days.
  • C Project settings are saved.
  • D Usage history is archived.
Explanation Deleting a project results in permanent deletion of all resources and data within that project, not retained.