Versions Compared

Version Old Version 1 New Version Current
Changes made by

thierry sinassamy

thierry sinassamy

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

  1. What’s the standard design for a relational data warehouse ?

    A common pattern is to use a denormalized, multidimensional schema.

  2. What’s unique about Fabric’s data warehouse ?

    IT’s built on the LakeHouse which is stored in Delta format and can be queried using SQL.

  3. What are the benefits of using Fabric’s data warehouse ?

    It enables data engineers, data scientists and business analysts to work together to create and query a data warehouse that is optimized for their specific needs.

  4. What are the steps involved in building a modern data warehouse ?

    Data ingestion, data storage, data processing, data analysis and insights delivery.

  5. What are dimension tables in a data warehouse ?

    Dimension table contain descriptive information about the data in fact tables.

  6. What’s the purpose of surrogate and alternate keys in a data warehouse ?

    Surrogate keys help maintain consistency and accuracy while alternate keys help maintain traceability between the data warehouse and the source system.