Search the practice set

275 questions, 991 terms and 600 topics in 30 areas.

53 results for “Regulatory Reporting Pipelines”

Terminology · 18
term

Submission Deadline Architecture

Designing a reporting pipeline around a fixed external deadline, where late is a breach and the recovery window is part of the schedule rather than a contingency.

Regulatory Reporting Pipelines
term

Regulatory Constraint

A legal requirement that removes design options — and one that must be established early, because it is not negotiable and is expensive to retrofit.

Business Architecture
term

Admission Policy

A rule evaluated at the moment a resource is created or changed, which rejects the request rather than reporting on it afterwards.

Policy as Code
term

Backfill

Re-running a pipeline over historical periods to populate new data or correct a past error, and the operation that proves whether a pipeline is well designed.

ETL & ELT
term

Budget Guardrail

An automated control that constrains or alerts on spend before an invoice arrives, rather than reporting overspend after the fact.

Cost Governance
term

Cloud Exit Plan

A documented, costed assessment of what leaving a provider or service would require — increasingly a regulatory expectation and a better lock-in control than portability itself.

Multi-Cloud
term

Compliance Obligation Mapping

Translating regulatory text into specific, testable technical requirements attached to the systems they apply to.

Regulatory Constraints
term

Data Minimisation

Collecting and retaining only what a stated purpose requires, which reduces both regulatory exposure and breach impact at the same time.

Privacy by Design
term

Dropbox's Move Off S3

Dropbox moved the majority of its file storage off Amazon S3 onto custom infrastructure, reporting savings that its S-1 filing put at roughly $75 million over two years.

Cost & FinOps
term

ETL vs ELT

Whether data is transformed before loading into the target or after it, which decides where the compute happens and how much raw history you keep.

Data Architecture
term

Idempotent Pipeline

A pipeline whose task can be re-run for the same input window any number of times and produce the same result.

ETL & ELT
term

Material Outsourcing Notification

The regulatory obligation to inform a supervisor before placing a critical function with a third party, which puts cloud adoption on a timeline architecture must respect.

Sector Cloud Rules
term

Obligation Mapping

Translating each legal or regulatory requirement into the specific design constraints it imposes, so that compliance becomes a set of testable properties rather than a document.

Regulatory & Data Protection Architecture
term

Operational vs Analytical Store

The separation between the store serving the application's transactions and the one serving reporting and analysis, and the mechanism connecting them.

Polyglot Persistence
term

Personally Identifiable Information

Data relating to an identifiable person — a category far broader than name and address, and the trigger for most regulatory obligation.

Security Architecture
term

Pipeline Anomaly Detection

Monitoring row counts, distributions, freshness and schema for unexplained change, because data pipelines fail silently far more often than they error.

Data Observability
term

Pipeline Orchestration

Coordinating the execution of data tasks by dependency rather than by clock, with retries, backfill and observability built in.

ETL & ELT
term

Showback

Reporting each team's share of platform and infrastructure cost without actually charging it, to change behaviour without creating a market.

Platform Funding
Questions · 5
quiz

A business sponsor asks for a real-time data platform because "the competition has one". Reporting is currently a nightly batch that lands at 06:00 and nobody has complained. How do you handle this?

Do not answer the technology question "Real time platform" is a solution, and it has arrived without a problem attached. Answering it directly leads either to a

Streaming vs Batch
quiz

Your internal platform has been live for a year. Six of twenty teams use it; the rest built their own pipelines. The CTO proposes mandating it. What is your advice?

Advise against the mandate, and say why in terms of evidence A mandate converts a usability problem into a compliance problem. It will produce adoption numbers

Platform Adoption
quiz

A nightly pipeline failed halfway and the retry produced duplicate rows. Walk me through fixing this properly.

The immediate problem The task appends rather than replacing its window , so a partial run followed by a retry writes some rows twice. The data is now wrong in

ETL & ELT
quiz

A regulator asks for evidence that your exit plan from your primary cloud provider is credible. The plan is a twelve-page document. What will they find, and what should you do?

What they will find A document describing an intention. Supervisors have moved from accepting exit plans to asking what has been tested, precisely because most

Exit & Concentration Risk
quiz

Six weeks before launch, legal confirms that customer data for one market must be processed and stored in-country. The architecture is single-region in another jurisdiction. What do you do?

Establish exactly what the requirement covers Before designing anything, get three things in writing from legal: which data is in scope — usually a defined cate

Data Residency
Topics · 29
topic

Regulatory Reporting Pipelines

Submissions with fixed deadlines, fixed formats, and a regulator who audits the lineage.

2 items
topic

Regulatory & Data Protection Architecture

General material on designing under legal and regulatory obligation.

2 items
topic

Regulatory Constraints

Non-negotiable requirements that remove design options entirely.

2 items
topic

Consent Architecture

Capturing, versioning and propagating consent to every system that acts on the data.

3 items
topic

Cross-Border Transfer

The legal mechanism that permits data to leave, and the architecture that respects it.

2 items
topic

Data Observability

Freshness, volume, schema and distribution monitoring for pipelines that fail silently.

4 items
topic

Data Residency

Keeping data within a jurisdiction, including backups, logs and support access.

3 items
topic

Data Subject Rights

Access, correction, portability and erasure across systems that never planned for them.

3 items
topic

Digital Sovereignty

Control over data, operations and the operator, beyond where the bytes physically sit.

2 items
topic

Erasure vs Immutability

Deletion obligations against event logs, backups and ledgers designed never to forget.

2 items
topic

Exit & Concentration Risk

Being able to leave a provider, and what the regulator asks when you cannot.

3 items
topic

Failure Modes

Slow rather than down, partial, grey, and failing while reporting success.

9 items
topic

Financial Services Regulation

Operational resilience, payment rules and supervisory expectations as design inputs.

2 items
topic

Geo-Restriction & Sanctions

Blocking access by jurisdiction, and the accuracy and evasion problems that come with it.

2 items
topic

Healthcare Data Protection

PHI handling, minimum necessary access, and audit expectations in clinical systems.

2 items
topic

Kappa vs Lambda

One pipeline replayed versus two pipelines reconciled, and the maintenance each carries.

2 items
topic

Lawful Basis & Purpose Limitation

Why you may hold the data, and why that forbids the second use somebody proposed.

2 items
topic

ML Platform

Feature stores, training pipelines, registries and deployment.

2 items
topic

Migration Risk

Bounding blast radius, staging by cohort, and honest readiness reporting.

3 items
topic

PCI-DSS Scoping

Segmentation and tokenisation to shrink what is in scope, because scope is the cost.

3 items
topic

Privacy by Design

Data minimisation, default protection and purpose binding as structural decisions.

3 items
topic

Privacy-Enhancing Technologies

Differential privacy, secure enclaves and federated computation, and what each buys.

2 items
topic

Pseudonymisation

Separating identity from record, and the re-identification risk that remains.

2 items
topic

Records Retention & Legal Hold

Keeping what must be kept, deleting what must go, and freezing both on demand.

2 items
topic

Sector Cloud Rules

Regulator expectations for cloud use, exit plans and material outsourcing notification.

2 items
topic

Self-Service vs Governed

Letting analysts move fast without four teams reporting four different revenues.

2 items
topic

Slowly Changing Dimensions

Overwriting, versioning or timestamping attribute history, and the reporting each enables.

2 items
topic

Technical Leadership

Setting direction and carrying accountability without a team reporting to you.

3 items
topic

Third-Party Risk

Assessing, contracting and monitoring the vendors your architecture now depends on.

2 items