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 91–100 of 498

Q91

Which service manages SQL databases in Google Cloud?

  • A Cloud SQL
  • B BigQuery
  • C Firestore
  • D Cloud Spanner
Explanation Cloud SQL is specifically for managing SQL databases, while others serve different purposes.
Q92

A company needs to optimize their data analytics workload. Which service is most suitable for large-scale analytics?

  • A Cloud Spanner
  • B Firestore
  • C BigQuery
  • D Cloud SQL
Explanation BigQuery is designed for large-scale analytics, unlike the other choices.
Q93

You are configuring IAM roles for a Cloud Storage bucket. What happens when you assign a 'roles/storage.objectViewer' role?

  • A View objects only
  • B Edit objects
  • C Delete objects
  • D Create objects
Explanation This role allows users to view objects, but not modify or delete them.
Q94

Which service is best for managing relational databases in Google Cloud?

  • A Cloud SQL
  • B Cloud Spanner
  • C Bigtable
  • D Firestore
Explanation Cloud SQL is designed for managed relational databases, while others cater to different data models.
Q95

A company needs to analyze large datasets with SQL-like queries on a serverless platform. Which service should they choose?

  • A BigQuery
  • B Cloud SQL
  • C Dataproc
  • D Cloud Dataflow
Explanation BigQuery is designed for serverless SQL analytics on large datasets.
Q96

You are configuring high availability for a Cloud Spanner instance. What configuration is required?

  • A Single region configuration
  • B Regional multi-instance
  • C Multi-region configuration
  • D Single instance configuration
Explanation Multi-region configurations ensure high availability through data redundancy.
Q97

Which service focuses on managing NoSQL databases in Google Cloud?

  • A Cloud Spanner
  • B Bigtable
  • C Firestore
  • D Cloud SQL
Explanation Firestore is designed for NoSQL data, while others focus on SQL or other database types.
Q98

A company needs to combine data from multiple sources in real-time. Which Google Cloud service should they use?

  • A Cloud Function
  • B Datastream
  • C Dataflow
  • D Cloud Pub/Sub
Explanation Dataflow is optimized for real-time data processing and transformation, unlike the other options.
Q99

What happens when you enable the Active Location feature in Cloud Spanner?

  • A Increases leader replica counts
  • B Replicates data across all regions
  • C Optimizes for low-latency reads
  • D Disables read-write capabilities
Explanation Active Location minimizes latency by optimizing data locations for reads and writes, while other options are incorrect actions related to Spanner capabilities.
Q100

Which service allows you to analyze big data on Google Cloud?

  • A BigQuery
  • B Cloud SQL
  • C Cloud Spanner
  • D Firebase
Explanation BigQuery is designed for analytics on big data; the others focus on different use cases.