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 71–80 of 498

Q71

A company needs a global, low-latency RX database; which approach should they take?

  • A Single-region Cloud SQL
  • B Firestore multi-region
  • C BigQuery with regional storage
  • D Cloud Spanner without global instance
Explanation Firestore multi-region ensures high availability and low-latency globally.
Q72

What happens when you set a Cloud SQL instance's automated storage increase to 0?

  • A No increase occurs, manual only
  • B Instance will automatically delete
  • C Increased costs from unused space
  • D Storage is locked indefinitely
Explanation Setting it to 0 disables automatic increases, requiring manual management.
Q73

Which service is primarily designed for storing and querying large datasets at scale in Google Cloud?

  • A BigQuery
  • B Cloud SQL
  • C Firestore
  • D Datastore
Explanation BigQuery is tailored for handling large-scale data analytics, while the others are for smaller datasets or different use cases.
Q74

A company needs to ensure that their Cloud SQL instance can automatically switch to a standby replica in case of failure. Which feature should they enable?

  • A Read replicas
  • B High availability
  • C Standard tier
  • D Automatic backups
Explanation The High Availability feature automatically manages failover to standby replicas, whereas the other options do not provide this capability.
Q75

You are configuring IAM roles for a user who requires full access to Cloud Bigtable and minimal access to BigQuery. What happens if you assign both roles with conflicting permissions?

  • A Permission fails altogether
  • B User gets full permissions
  • C The more restricted role applies
  • D Permissions are averaged
Explanation In IAM, the most permissive role applies, hence the user would retain full access to Bigtable.
Q76

Which service should a developer use to automate database management tasks?

  • A Cloud SQL
  • B Datastream
  • C Cloud Functions
  • D Cloud MemoryStore
Explanation Cloud SQL automates maintenance tasks while other options don't focus on full database management.
Q77

A company needs real-time data replication for its Cloud SQL instance. What should they enable?

  • A Read Replicas
  • B Database Backup
  • C Data Warehousing
  • D Change Data Capture
Explanation Read Replicas provide real-time replication; the other options do not fulfill this requirement.
Q78

What happens when a Cloud Bigtable instance runs out of storage capacity?

  • A Instance shuts down automatically
  • B Writes are rejected until storage is freed
  • C Automatic migration to another region
  • D Data is deleted to free up space
Explanation When storage is full, new writes are rejected; the other choices do not accurately represent the behavior.
Q79

Which service is ideal for real-time event ingestion?

  • A Cloud Pub/Sub
  • B Cloud Storage
  • C BigQuery
  • D Cloud Functions
Explanation Cloud Pub/Sub is designed for real-time messaging and event ingestion, unlike the others which serve different purposes.
Q80

A company needs to analyze large datasets quickly. Which storage option is best?

  • A Cloud Firestore
  • B BigQuery
  • C Cloud RDBMS
  • D Cloud Storage
Explanation BigQuery is optimally designed for fast analytics on large datasets, while the others are less suited for this purpose.