Please enable JavaScript.

Coggle requires JavaScript to display documents.

DP-203 - Chapter 2 -Designing a Data Storage Structure, Landing zone (raw…

- - - - Processing technology
      - compression
      - read/write performance
  - - - AVRO
      - Transactional workloads (ETL jobs) (write intensive)
    - - ORC
      - Parquet
      - fit for
        
        Analytical workloads (read intensive)
- - - - partitioning
      - pruning
      - eventual consistency
    - - Query
        
        indexing
        
        materialized views
      - tuning
        
        VM Size
        
        CPU
        
        memory
        
        disk
        
        scale out
      - caching
        
        external service
        
        Redis cache
        
        built-in
        Synapse
        
        Resultset cache