Skip to content

Data Architect interview questions

Data modelling, warehouse and lakehouse design, pipelines and integration, governance and quality, and platform scalability and cost.

71 questions · 5 topics · 10 free answers

Data Engineer roadmap4 stages from basics to interview-ready. Learn the gaps, then come back and practise.

0 of 71 practised · 0 bookmarked · saved on this device

71 questions

  1. #1What does a data architect do?EasyConceptData modelling Pro answer

    This answer is part of Pro

    10 of 71 Data Architect answers are free. A Pro pass opens the rest, including hands-on task steps.

  2. #2What is normalisation?EasyConceptData modelling Pro answer

    This answer is part of Pro

    10 of 71 Data Architect answers are free. A Pro pass opens the rest, including hands-on task steps.

  3. #3What is a star schema?EasyConceptData modelling Pro answer

    This answer is part of Pro

    10 of 71 Data Architect answers are free. A Pro pass opens the rest, including hands-on task steps.

  4. #4What are primary and foreign keys?EasyConceptData modelling Pro answer

    This answer is part of Pro

    10 of 71 Data Architect answers are free. A Pro pass opens the rest, including hands-on task steps.

  5. #5Star versus snowflake schema?MediumConceptData modelling Pro answer

    This answer is part of Pro

    10 of 71 Data Architect answers are free. A Pro pass opens the rest, including hands-on task steps.

  6. #6What are slowly changing dimensions?MediumConceptData modelling Pro answer

    This answer is part of Pro

    10 of 71 Data Architect answers are free. A Pro pass opens the rest, including hands-on task steps.

  7. #7What is a surrogate key and why use one?MediumConceptData modelling Pro answer

    This answer is part of Pro

    10 of 71 Data Architect answers are free. A Pro pass opens the rest, including hands-on task steps.

  8. #8What is Data Vault modelling?MediumConceptData modelling Pro answer

    This answer is part of Pro

    10 of 71 Data Architect answers are free. A Pro pass opens the rest, including hands-on task steps.

  9. #9What is the grain of a fact table?MediumConceptData modelling Pro answer

    This answer is part of Pro

    10 of 71 Data Architect answers are free. A Pro pass opens the rest, including hands-on task steps.

  10. #10Conceptual, logical and physical models?MediumConceptData modelling Pro answer

    This answer is part of Pro

    10 of 71 Data Architect answers are free. A Pro pass opens the rest, including hands-on task steps.

Hunting for a Data Architect role too? See open Data Architect jobs.