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 361–370 of 498

Q361

Which service automatically scales database instances?

  • A Cloud SQL
  • B Firestore
  • C Cloud Spanner
  • D Bigtable
Explanation Cloud Spanner automatically scales instances based on demand, while others require manual scaling.
Q362

A company needs low-latency reads for a global application. Which database should they choose?

  • A Cloud SQL
  • B Firestore
  • C Cloud Memorystore
  • D BigQuery
Explanation Cloud Memorystore provides low-latency access through in-memory data storage, unlike others.
Q363

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

  • A Can publish messages to Pub/Sub
  • B Database instance can read from DB
  • C Access denied for Pub/Sub actions
  • D Can manage Cloud SQL settings
Explanation The instance can publish messages to Pub/Sub but cannot perform database actions or manage settings.
Q364

Which service allows you to manage and administer NoSQL databases in Google Cloud?

  • A Cloud Firestore
  • B Cloud Functions
  • C Cloud Source Repositories
  • D Cloud Pub/Sub
Explanation Cloud Firestore is designed specifically for NoSQL database management, while others serve different purposes.
Q365

A company needs to analyze large volumes of real-time data from various sources. Which Google Cloud service should they choose?

  • A Cloud Storage
  • B BigQuery
  • C Cloud Dataflow
  • D Cloud SQL
Explanation Cloud Dataflow is optimized for real-time analytics and data processing, while others are for storage or SQL databases.
Q366

You are configuring a Cloud SQL instance for high availability. What must you enable to achieve this?

  • A Read Replicas
  • B Regional Settings
  • C Failover Replicas
  • D Serverless Option
Explanation Failover Replicas provide high availability, while others do not directly contribute to high availability strategies.
Q367

Which service allows you to use SQL on unstructured data?

  • A BigQuery
  • B Cloud Storage
  • C Firestore
  • D Cloud SQL
Explanation BigQuery enables SQL queries on big data, while others do not have this capacity.
Q368

A company needs to process data streams with low latency. Which Google Cloud service is best suited for this task?

  • A Cloud Pub/Sub
  • B Cloud Storage
  • C Dataflow
  • D Cloud Functions
Explanation Cloud Pub/Sub is designed for real-time data streaming, unlike the others that focus on batch processing.
Q369

You are configuring Cloud Spanner for a multi-region deployment. What is a key consideration?

  • A Enable cross-region replication
  • B Use a single region only
  • C Limit to regional database
  • D Disable Strong Consistency
Explanation Cross-region replication is essential for availability, unlike other options which restrict functionality.
Q370

Which Google Cloud service is primarily used for relational database instances?

  • A Cloud SQL
  • B Cloud Firestore
  • C BigQuery
  • D Cloud Spanner
Explanation Cloud SQL manages relational databases, while others serve different data storage or querying needs.