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 21–30 of 498

Q21

What happens when you disable a service account in Google Cloud?

  • A All resources are deleted
  • B Access to resources is denied
  • C Billing is stopped immediately
  • D Service account can still access resources
Explanation Disabling a service account prevents it from accessing resources, while the other options incorrectly state its effects.
Q22

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

  • A BigQuery
  • B Cloud Storage
  • C Pub/Sub
  • D Cloud Functions
Explanation BigQuery is optimized for real-time analytics, while the others serve different functions.
Q23

A company needs to ensure that data workloads are automatically rescaled. What should they use?

  • A Cloud Spanner
  • B Cloud SQL
  • C Bigtable
  • D Cloud Storage
Explanation Cloud Spanner can automatically scale based on workloads, while the others don't offer this capability.
Q24

You are configuring Cloud Memorystore and must decide on an instance region. What happens if you select a region far from users?

  • A Increased latency
  • B Higher availability
  • C Reduced cost
  • D Better security
Explanation Selecting a distant region results in increased latency for users accessing the data.
Q25

Which service is ideal for real-time analytics on streaming data?

  • A BigQuery
  • B Cloud Pub/Sub
  • C Cloud SQL
  • D Cloud Datastore
Explanation Cloud Pub/Sub is designed specifically for real-time messaging, unlike the others.
Q26

A company needs to ensure their Cloud SQL instance is highly available. Which configuration should they choose?

  • A Single zone deployment
  • B Read replica
  • C Multi-region backup
  • D High availability configuration
Explanation High availability configuration lets Cloud SQL automatically switch to a standby instance.
Q27

What happens when you exceed the maximum number of connections in Cloud SQL?

  • A New connections are queued
  • B Applications get a connection error
  • C Old connections are closed
  • D Performance improves temporarily
Explanation Exceeding connection limits results in connection errors, affecting application functionality.
Q28

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

  • A Dataflow
  • B Firestore
  • C BigQuery
  • D Cloud Storage
Explanation Dataflow is designed for real-time data processing, whereas Firestore is for document storage, BigQuery for analytics, and Cloud Storage for blob storage.
Q29

A company needs to restrict database access after hours. What should you configure?

  • A IAM Roles
  • B VPC Peering
  • C Scheduled Queries
  • D Firewall Rules
Explanation IAM Roles can control access based on conditions, while VPC Peering connects networks, Scheduled Queries automate tasks, and Firewall Rules manage traffic.
Q30

What happens when you use an unsupported SQL feature in Cloud SQL?

  • A Feature execution fails
  • B Database ignores feature
  • C Server crashes
  • D Feature works partially
Explanation The execution of unsupported features fails outright; they are not ignored, do not cause crashes, and cannot work partially.