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 11–20 of 498

Q11

A company needs to analyze streaming data in real-time. What is the best choice?

  • A Cloud Pub/Sub
  • B Cloud Datastore
  • C Cloud Functions
  • D Cloud Filestore
Explanation Cloud Pub/Sub allows for real-time messaging and data analytics; the others do not focus on streaming data.
Q12

You are configuring a Cloud SQL instance. What happens if you set the backup retention period to zero?

  • A Backups will always be taken
  • B No automated backups will be created
  • C Backups will retain indefinitely
  • D Only manual backups will occur
Explanation Setting the retention to zero disables automatic backups, while others are inaccurate descriptions of backup behavior.
Q13

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

  • A BigQuery
  • B Cloud Functions
  • C Compute Engine
  • D Cloud Storage
Explanation BigQuery allows real-time analytics and can handle large datasets, while others serve different purposes.
Q14

A company needs to ensure its Cloud SQL instance has high availability. What should they configure?

  • A Single zone operation
  • B Read replicas only
  • C Regional configuration
  • D Manual backups only
Explanation Regional configuration provides high availability by deploying instances in multiple zones.
Q15

What happens when you delete a set of backup snapshots in Google Cloud Storage?

  • A They are permanently lost
  • B Restores become impossible
  • C They can be recovered
  • D Backup jobs will be paused
Explanation Deleted snapshots are not recoverable, permanently losing the data.
Q16

Which service automatically scales a database based on demand?

  • A Cloud SQL
  • B Cloud Spanner
  • C Firestore
  • D BigQuery
Explanation Cloud Spanner is designed for automatic scaling, while others require manual intervention or have predefined limits.
Q17

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

  • A Cloud Functions
  • B Dataflow
  • C Cloud Storage
  • D Bigtable
Explanation Dataflow is tailored for real-time data processing and analytics, while other options focus on different use cases.
Q18

You are configuring IAM roles for a Cloud SQL instance. What happens if you assign the 'Cloud SQL Client' role?

  • A Grants full database access
  • B Restricts access completely
  • C Enables read-only access
  • D Allows SQL instance management
Explanation The 'Cloud SQL Client' role provides read-only access to the Cloud SQL instance, whereas other options either provide too much or too little access.
Q19

Which Google Cloud service is best for large-scale relational databases?

  • A Cloud SQL
  • B Firebase Realtime Database
  • C Cloud Bigtable
  • D Cloud Firestore
Explanation Cloud SQL supports relational databases well, while others are designed for different use cases.
Q20

A company needs to process streaming data with low latency. Which service should they use?

  • A Cloud Pub/Sub
  • B Cloud Storage
  • C Cloud Functions
  • D Cloud Spanner
Explanation Cloud Pub/Sub is designed specifically for real-time streaming data, unlike the other options.