Designing data processing systems
Practise only this domain. 97 questions with explanations, 20 at a time.
Start this domainSample questions
- A healthcare insurer runs claims, membership, and provider network teams that each generate large datasets. Leadership wants each team to control its own data, while other teams can find and consume those datasets across the company. Which operating model fits this goal best?Medium
- A global insurer holds policyholder records for customers in Germany, Brazil and Canada. Local regulators forbid moving identifiable records outside each country. The actuarial team still wants a consolidated view of claims trends across all three. What should the data engineer do?Medium
- A retailer curates a sales feed in BigQuery and wants several outside partners to query it. The retailer must be able to cut off any partner immediately and see which partner ran which queries. Which approach satisfies both requirements?Medium
- A company adopts a data mesh model. The marketing domain's customer engagement data is to be published as a reusable data product. Who should be accountable for its quality, documentation and service levels?Easy
- A bank wants one set of completeness and validity checks applied to customer tables in several BigQuery datasets, with the results reported to a central place where data stewards can review them. Which Dataplex capability fits?Easy
- A payments platform needs a single SQL database that accepts writes in several continents at once. Every transaction must be atomic and strongly consistent, and the system must keep serving if an entire region fails. Which option should you choose?Medium
- A mobile game needs a live ranking of millions of players that updates as scores change. Players must see their rank with low-millisecond latency, and the ranking must stay correct after each atomic score update. Which design is most appropriate?Hard
- A logistics firm wants three carriers to read a curated subset of its shipment tables. Each carrier should see only its own shipments, the firm must be able to revoke a carrier's access immediately, and no data should be copied into the carriers' environments. Which solution should the firm use?Medium
- A ride-hailing company's reporting pipeline must survive the complete loss of a region. Acceptable data loss is at most one hour, and service must be restored within four hours. Which design meets both targets?Medium
- A company runs a dozen event-driven applications on Apache Kafka in its own data center and wants them on Google Cloud as a managed service. Teams want to keep their existing Kafka client libraries, topic configuration and consumer groups, with the smallest possible code change. Which service fits?Medium
- An insurer keeps a 40 TB BigQuery dataset. It must be able to restore the data as it stood no more than an hour before an accidental delete, keep those recovery points for 90 days, and minimize storage cost. Which approach is most cost-effective?Medium
- A media company wants its clickstream history to stay readable by Spark on another cloud if it ever leaves Google Cloud. Which storage design best keeps the data portable?Medium
- A ride-sharing platform streams trip events into BigQuery. Events with missing driver IDs, wrong timestamp types, or fares outside a plausible range must never reach the reporting tables. Which pipeline design handles this?Medium
- A bank's ingestion team wants partner files to land in an unvalidated area, move to a validated area only after quality rules pass, and then feed a consumer layer. Which Google Cloud construct organizes this with governed zones?Medium
- A payments-ingestion service must keep running if an entire Google Cloud zone fails, must not lose acknowledged data, and must recover within 30 minutes. Which deployment best fits?Medium
- A fintech's data team needs development, test, and production environments with identical table definitions, and production data must never be reachable from development. Which setup is recommended?Medium
- A mobile app emits event records whose optional attributes change frequently. Which format and load approach lets the warehouse absorb new optional attributes without breaking the pipeline?Medium
- A ticketing company's Cloud Spanner database must lose no committed transactions, even if an entire region becomes unavailable. Which configuration delivers a zero recovery point objective?Hard