Instiq

1Designing data processing systems

Practice questions →Glossary →
  • 1.1Designing for security and compliance

    Understand IAM and organization policies for data platforms, encryption at rest/in transit and key management, handling PII, data residency (sovereignty), governance via project/dataset/table architecture, and multi-environment (dev/prod) design.

  • 1.2Designing for reliability, migration, and data methods

    Understand data preparation/cleaning (Dataform, Dataflow, Cloud Data Fusion), pipeline monitoring/orchestration, disaster recovery and fault tolerance, ACID vs availability decisions, data validation, and choosing migration tools (BigQuery Data Transfer Service, Database Migration Service, Datastream, Transfer Appliance).