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 61–70 of 498

Q61

Which service allows creation of relational databases in Google Cloud?

  • A Cloud SQL
  • B Cloud Firestore
  • C BigQuery
  • D Cloud Spanner
Explanation Cloud SQL is designed for relational database management, while others serve different purposes.
Q62

A company needs a fully managed, horizontal database scalability. Which service should they choose?

  • A Cloud Firestore
  • B Cloud Storage
  • C Cloud SQL
  • D Cloud Datastore
Explanation Cloud Firestore offers automatic scaling and real-time syncing, unlike SQL and Cloud Storage which don't inherently support horizontal scaling.
Q63

What happens when using a multi-region Cloud Spanner instance in a region-specific operation?

  • A Increased latency
  • B Lower costs
  • C Improved reliability
  • D No change in performance
Explanation Using multi-region instances can introduce latency due to inter-region communication, while others are misleading.
Q64

Which service enables automatic backup of Cloud SQL instances?

  • A Cloud Storage
  • B Cloud Firestore
  • C Cloud SQL Automated Backups
  • D BigQuery
Explanation Cloud SQL Automated Backups provides built-in backup features, unlike the other services listed.
Q65

A company needs a solution for storing unstructured data with high retrieval rates. Which Google service should they use?

  • A BigQuery
  • B Cloud Pub/Sub
  • C Cloud Storage
  • D Cloud SQL
Explanation Cloud Storage is optimized for unstructured data and high-frequency access, unlike the other options.
Q66

You are configuring a Cloud Spanner database. What happens if you leave the 'average row size' configuration empty?

  • A Defaults to an estimated value
  • B Database creation fails
  • C Uses maximum possible size
  • D Requires manual input only
Explanation Leaving the configuration empty defaults to a system-estimated value, contrary to other options.
Q67

Which service is best for simultaneously processing data streams and batch data in real time?

  • A Cloud Dataflow
  • B Cloud Dataproc
  • C BigQuery
  • D Cloud SQL
Explanation Cloud Dataflow is designed specifically for this dual processing capability, while the others serve different use cases.
Q68

You are configuring IAM roles for a new Cloud SQL instance. What is the correct minimum role needed to enable backups?

  • A Cloud SQL Admin
  • B Editor
  • C Viewer
  • D Cloud SQL Backup Operator
Explanation The Cloud SQL Backup Operator has permissions specifically for backup management, unlike the other roles.
Q69

A company needs to migrate its on-premises SQL database to Google Cloud SQL. What is the recommended initial step?

  • A Perform data backup
  • B Use Database Migration Service
  • C Export data to CSV
  • D Create a new Cloud SQL instance
Explanation Using Database Migration Service is the most efficient method for direct migration, while the other options are not required initially.
Q70

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

  • A Bigtable
  • B Cloud SQL
  • C Firestore
  • D Memorystore
Explanation Bigtable is designed for NoSQL workloads, while others focus on SQL or caching.