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 121–130 of 498

Q121

Which service is best for NoSQL document storage?

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

A company needs scalable storage for time-series data. What should they choose?

  • A Cloud Spanner
  • B Bigtable
  • C Cloud SQL
  • D FireStore
Explanation Bigtable is optimized for time-series data, while the others do not provide the same scalability for this specific use case.
Q123

You are configuring Cloud SQL backups. What happens when backups exceed the retention limit?

  • A Old backups are deleted
  • B All backups are retained
  • C New backups stop being created
  • D Retention limit increases automatically
Explanation Old backups are deleted when the retention limit is exceeded, while the other options are incorrect actions.
Q124

Which service is best for real-time data analysis?

  • A Cloud Spanner
  • B Cloud Bigtable
  • C BigQuery
  • D Cloud SQL
Explanation BigQuery is optimized for real-time analytics, while others are less suited for this purpose.
Q125

A company needs to securely store passwords. What service should they use?

  • A Cloud Storage
  • B Secret Manager
  • C Cloud Firestore
  • D Cloud Datastore
Explanation Secret Manager securely manages sensitive information like passwords, unlike the others.
Q126

What happens when using multi-region Cloud Storage without versioning?

  • A Faster data retrieval
  • B Higher costs for writes
  • C Data may be stored in one region
  • D Previous versions are retained
Explanation Without versioning, data may only be stored in the selected region, leading to potential data-loss risks during overwrites.
Q127

Which service is optimized for real-time analytics in Google Cloud?

  • A BigQuery
  • B Cloud Spanner
  • C Cloud SQL
  • D Firestore
Explanation BigQuery is specifically designed for real-time analytics, while others cater to transactional workloads or document storage.
Q128

A company needs to migrate legacy databases to Cloud SQL. What is a key requirement?

  • A Enable virtual machines
  • B Choose a compatible database engine
  • C Create a local database
  • D Ensure no data loss
Explanation Choosing a compatible database engine is crucial for successful migration, while others are not specific to the requirements.
Q129

What happens when you disable automatic backups in Cloud SQL?

  • A Backups continue to occur weekly
  • B Instant recovery point is preserved
  • C Manual backups become mandatory
  • D Database performance will be degraded
Explanation Disabling automatic backups requires you to create backups manually, while other options misrepresent backup functionalities or impacts on performance.
Q130

Which Google Cloud service provides managed NoSQL databases?

  • A Cloud SQL
  • B Cloud Firestore
  • C Cloud Spanner
  • D BigQuery
Explanation Cloud Firestore is designed for NoSQL databases, unlike the others which serve different purposes.