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 31–40 of 498

Q31

Which service is best suited for NoSQL databases on Google Cloud?

  • A Cloud Spanner
  • B Cloud SQL
  • C Firestore
  • D Bigtable
Explanation Firestore is specifically designed for NoSQL database applications, while other options are not primarily NoSQL.
Q32

A company needs to replicate their SQL database to another region for disaster recovery. Which Google Cloud service should they use?

  • A Cloud Functions
  • B Cloud SQL
  • C BigQuery
  • D Cloud Datastore
Explanation Cloud SQL includes built-in replication features suitable for disaster recovery, unlike the other services listed.
Q33

What happens when you disable billing for a Google Cloud project?

  • A Resources stop immediately
  • B Project remains active indefinitely
  • C All services continue without charges
  • D Resources are paused, not deleted
Explanation Disabling billing results in immediate resource suspension, while other options misrepresent the billing rules.
Q34

Which service is best for global application load balancing?

  • A Cloud Load Balancing
  • B Cloud Functions
  • C Cloud SQL
  • D Cloud Storage
Explanation Cloud Load Balancing distributes traffic globally, while others do not.
Q35

A company needs to ensure data in BigQuery is only accessible to specific users. What should be implemented?

  • A IAM Roles
  • B VPC Network
  • C Cloud CDN
  • D Dataflow
Explanation IAM Roles control user permissions effectively.
Q36

What happens when you set a Cloud Pub/Sub topic to retain messages for 3 days?

  • A Messages expire in 3 days.
  • B Messages are saved indefinitely.
  • C Messages are deleted after 1 day.
  • D Messages are sent to Cloud Storage.
Explanation Messages in Pub/Sub retain for the specified retention period.
Q37

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

  • A Dataflow
  • B Cloud Storage
  • C BigQuery
  • D Cloud Functions
Explanation Dataflow is designed for real-time data processing; the others are not specifically for that purpose.
Q38

A company needs to handle sudden spikes in web traffic without downtime. Which Google Cloud feature is most suitable?

  • A Load Balancing
  • B Compute Engine
  • C App Engine
  • D Persistent Disk
Explanation Load Balancing distributes traffic, preventing downtime, while others do not address traffic spikes directly.
Q39

What happens when you enable a database's automatic backup in Google Cloud SQL?

  • A Instantly backs up all data now
  • B Stores backup in Cloud Storage
  • C Backups occur at scheduled times
  • D Disables write operations during backup
Explanation Automatic backups occur according to a schedule rather than immediately; others misrepresent this function's behavior.
Q40

Which Google Cloud service is used for data warehousing?

  • A BigQuery
  • B Cloud SQL
  • C Cloud Spanner
  • D Datastore
Explanation BigQuery is specifically designed for data warehousing, whereas the others serve different database functionalities.