Home Microsoft Exams Google Cloud Exams

Loading page

Curious about new developments and updates? Follow our social media.

Get a free certification question every week.

Microsoft Exams

AZ-104 Administrator
AZ-204 Developer
AZ-900 Fundamentals
All Microsoft Exams

Google Cloud Exams

Associate Data Practitioner
All Google Cloud Exams

Terms Privacy Cookies About

© 2026 StudyCerts. All rights reserved.

Loading page

Home
Google Cloud Exams
Professional Cloud Data Engineer
Making decisions related to ACID (atomicity, consistency, isolation, and durability) compliance and availability
A global financial enterprise is re-architecting its core pa…

Professional Cloud Data Engineer

professional-cloud-data-engineer

Advanced

Prepare and test your skills

Track Readiness

Description
Sample Question
Free Trial
Practice Test

Advanced

Prepare and test your skills

Track Readiness

Description
Sample Question
Free Trial
Practice Test

Acid Compliance Global Spanner Database Selection

Section: Making decisions related to ACID (atomicity, consistency, isolation, and durability) compliance and availability

Worked example. The correct answer is already marked and every option is explained below, so there is nothing to select here. To answer questions yourself, start the free trial.

A global financial enterprise is re-architecting its core payment processing platform on Google Cloud. The system has the following requirements:

Execute distributed multi-table, multi-row financial ledger transactions across multiple cloud regions
Provide strict serializable isolation and external consistency (linearizability) to eliminate stale reads and race conditions
Provide automatic horizontal scaling for relational data with high write throughput

Which Google Cloud database service natively satisfies these requirements?

Cloud Spanner

Firestore in Datastore mode

Cloud SQL for PostgreSQL

Cloud Bigtable

Explanations

What Cloud Spanner is

Cloud Spanner is a fully managed, mission-critical, enterprise-grade relational database service designed for global scale. It uniquely combines the structure and ACID compliance of traditional relational databases with the horizontal scalability and high availability of NoSQL systems.

How it meets the requirements

Distributed multi-row/multi-table transactions: Cloud Spanner natively supports distributed transactions across multiple tables, splits, and geographic regions using two-phase commit and Paxos consensus.
Strict serializable isolation and linearizability: Spanner utilizes Google's TrueTime API to generate monotonically increasing timestamps, enabling external consistency (strict serializability) globally.
Horizontal scaling: It automatically shards and balances relational data across compute nodes without sacrificing transactional guarantees.

Key advantages

Guarantees ACID consistency across multi-region configurations.
Provides up to 99.999% availability SLAs for multi-region instances.
Eliminates the need for application-managed distributed transaction coordination or manual sharding.
Supports standard SQL querying alongside strong referential integrity.

Why this is optimal

None of the other Google Cloud managed database engines provide both multi-region distributed relational ACID transactions with external consistency and horizontal write scalability.

View source documentation

Related questions

Keep the momentum going with these hand-picked practice scenarios

AdvancedProfessional Cloud Data Engineer

An enterprise is architecting a globally distributed mobile platform deployed across the United States, Europe, and Asia. The application encompasses two distinct operational data paths: Social Activity Stream: Tracks user interactions, presence state, and social reaction counters (such as post likes and upvotes). This workload requires ultra-low latency, multi-continent write accessibility, and maximum availability ($A$) even during cross-continent network partitions ($P$), where temporary stale reads are acceptable. Billing and Wallet Ledger: Processes financial token top-ups, checkout payments, and user balances. This workload strictly mandates ACID compliance, global transactional integrity, and strong consistency ($C$) to prevent double-spending, even if network partitions introduce latency or reject writes to maintain consistency ($CP$). According to CAP theorem principles and Google Cloud database characteristics, which architectural design correctly implements these requirements?

Making decisions related to ACID (atomicity, consistency, isolation, and durability) compliance and availability

AdvancedProfessional Cloud Data Engineer

An e-commerce company is designing an event-driven inventory management pipeline on Google Cloud. The system ingests high-volume inventory mutation events from physical stores and online checkouts through Pub/Sub and processes them using Cloud Dataflow before updating product inventory levels in BigQuery and downstream datastores. The system must meet the following reliability and data integrity requirements: Guarantee inventory count accuracy and consistency despite potential out-of-order and duplicate message delivery caused by transient network retries and at-least-once Pub/Sub delivery. Prevent invalid or malformed messages from stalling the streaming pipeline while preserving them for debugging and compensating corrections. Allow safe recovery and message reprocessing in the event of subscriber-side processing bugs. Which architectural pattern should the data engineering team implement?

AdvancedProfessional Cloud Data Engineer

An enterprise is designing a centralized data preparation and cleaning architecture using Cloud Data Fusion. Data files from multiple external partners are uploaded to separate Cloud Storage buckets, and each dataset requires distinct data quality validation rules, formatting directives, and output destinations. Creating and maintaining individual static pipelines for dozens of source feeds has caused significant operational overhead and deployment delays. The data engineering team requires a single, maintainable pipeline structure that dynamically determines its input source, validation checks, and output target during each scheduled execution. How should you configure the Cloud Data Fusion pipeline to support these dynamic validation and cleaning requirements?

AdvancedProfessional Cloud Data Engineer

A financial SaaS enterprise is designing a multi-tenant data access architecture in BigQuery to serve both internal analytics teams and external client organizations. The data architecture must satisfy the following technical and compliance requirements: Tenant Scaling & Regionalization: Support scaling from 500 to over 5,000 distinct tenant organizations located across multiple global Google Cloud regions. Performance Optimization: Enable each tenant to apply independent table partitioning and clustering schemes tailored to their specific querying workloads. Column Governance: Dynamically obscure sensitive payment card data for general data analysts while providing plaintext access to authorized compliance auditors with the Fine-Grained Reader role. Which architecture should the data engineering team implement to satisfy these requirements?

AdvancedProfessional Cloud Data Engineer

Your organization uses a custom on-premises visualization tool to generate business intelligence reports. The tool currently connects to relational databases using standard SQL protocols and does not natively support the BigQuery API. You need to integrate this tool with BigQuery to analyze large datasets. Security policies mandate that the connection must not traverse the public internet, and BigQuery resources must be protected from data exfiltration by restricting access strictly to your hybrid network environment. How should you securely integrate the on-premises tool with BigQuery?

AdvancedProfessional Cloud DevOps Engineer

Your team is establishing a "shift-left" security practice for containerized applications built with Cloud Build and stored in Artifact Registry. You need to implement an automated policy gate within the continuous integration (CI) pipeline that satisfies the following requirements: Scans container images for OS and language package vulnerabilities prior to pushing them to Artifact Registry. Analyzes the effective severity of discovered vulnerabilities. Immediately fails the build and prevents upload to Artifact Registry if any vulnerability with a severity of CRITICAL or HIGH is detected. What should you do?

Want more questions like this?

Get a free certification question every week.

Are you ready for the Professional Cloud Data Engineer?

50 questions in the full practice test

No account required · Instant results

More Making decisions related to ACID (atomicity, consistency, isolation, and durability) compliance and availability practice questions

Get a free certification question with a full explanation every week.

Professional Cloud Data Engineer

Provider: Google Cloud
Passing score: 70%
Questions: 50
Duration: 90 minutes

Other sections in this exam

Designing data processing systems
Ingesting and processing the data
Storing the data
Preparing and using data for analysis
Maintaining and automating data workloads

Ask Scout

Still curious? Scout, our AI tutor, can explain this concept further and answer your follow-up questions.

Making decisions related to ACID (atomicity, consistency, isolation, and durability) compliance and availability

Preparing and cleaning data (e.g., Dataform, Dataflow, and Cloud Data Fusion, prompting LLMs for query generation)

Defining architecture to support data access patterns

Connecting to tools

Software supply chain security (e.g., Binary Authorization, Supply-chain Levels for Software Artifacts [SLSA] framework)