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 471–480 of 498

Q471

You are configuring a Cloud SQL instance. What happens if you set the database to auto-backup enabled but with an incorrect scheduling frequency?

  • A Backups will be created on schedule
  • B No backups will be created
  • C Backups get delayed until corrected
  • D Manual backups become mandatory
Explanation If the scheduling frequency is incorrect, no backups will occur until it is fixed.
Q472

Which Cloud SQL option allows for automatic failover?

  • A High Availability (HA)
  • B Standard Instance
  • C Read Replica
  • D On-Demand Instance
Explanation High Availability (HA) ensures automatic failover, while others do not.
Q473

A company needs to store sensitive data securely in BigQuery. Which option should they use?

  • A Standard tables
  • B Encrypted tables
  • C Partitioned tables
  • D Unauthenticated access
Explanation Encrypted tables protect sensitive data, while others lack this feature.
Q474

You are configuring IAM roles for a Cloud Spanner database. What do you need to consider?

  • A Roles determine access levels
  • B Only project owners can access
  • C Spanner only requires default roles
  • D IAM roles are irrelevant to Spanner
Explanation Roles define granular access; others misrepresent access control.
Q475

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

  • A BigQuery
  • B Cloud Pub/Sub
  • C Cloud SQL
  • D Firestore
Explanation BigQuery is designed for real-time analytics; others are not optimized for this use case.
Q476

A company needs to ensure that its Cloud SQL instance is automatically backed up. What should they enable?

  • A Read Replicas
  • B Automatic Backups
  • C High Availability
  • D Query Insights
Explanation Automatic Backups ensure data is backed up; others offer different features.
Q477

You are configuring Redis on Google Cloud. What happens if you exceed the memory limit?

  • A New data will be rejected
  • B Data will be automatically purged
  • C Application will crash
  • D Memory will allocate more space
Explanation Exceeding memory limits leads to data eviction policies; other options are incorrect outcomes.
Q478

Which Google Cloud service can automatically scale databases?

  • A Cloud SQL
  • B BigQuery
  • C Cloud Firestore
  • D Cloud Spanner
Explanation Cloud Spanner automatically scales horizontally; others do not provide this feature.
Q479

A company needs to analyze streaming data from IoT devices. Which service is most suitable?

  • A Cloud Dataflow
  • B Cloud Storage
  • C Firestore
  • D Cloud Pub/Sub
Explanation Cloud Dataflow is designed for processing streaming data; others focus on storage or messaging.
Q480

You are configuring a backup plan for Cloud SQL. What happens when the backup window overlaps with peak usage?

  • A Backup will pause during peak.
  • B Backup will fail.
  • C Backup will continue but may impact performance.
  • D Backup will occur without any issues.
Explanation Backups can affect performance if run during peak times; they do not automatically pause or fail.