Instiq

1Data preparation and ingestion

Practice questions →Glossary →
  • 1.1Data processing methodologies and quality

    Understand the difference and selection among ETL, ELT, and ETLT data-manipulation methodologies, assessing data quality, data cleaning with Cloud Data Fusion, BigQuery, and Dataflow, and choosing the right data transfer tool (Storage Transfer Service, Transfer Appliance).

  • 1.2Data formats and extract/load

    Understand data formats (CSV, JSON, Apache Parquet, Apache Avro, structured tables), choosing extraction tools (Dataflow, BigQuery Data Transfer Service, Database Migration Service, Cloud Data Fusion), and loading into Google Cloud storage with the gcloud / bq CLI, Storage Transfer Service, and client libraries.

  • 1.3Choosing storage and data location

    Understand choosing among storage destinations (Cloud Storage, BigQuery, Cloud SQL, Firestore, Bigtable, Spanner, AlloyDB), classifying data requirements as structured, semi-structured, or unstructured, and selecting data location types: regional, dual-regional, multi-regional, and zonal.