163 ) Tree of questions

------------------------------------------------------------------------------------------------

Tree of questions 

------------------------------------------------------------------------------------------------

1. Background  
1. Tell me about your background and exp
2.  Tell me about your Data modeling projects
1. Insurance project ✅
2. Banking project
3. Food delivery project 
4. Waste management project 
5. Hospital project 
6. pharma 
7. Sample - Data model Diagrams
2. Data modeling questions
1. Excel questions ✅
2. Normalization with eg (1nf, 2nf , 3nf ) 
3.  ( NOT IMP - JUST REF ) FAQ Questions only 
3. Dimensional modeling questions
1. Why do we need Data Warehouse
2. Enterprise data modeling - Insurance project OLTP
3. Types of data models 
4. star or snowflake schemas ( how to chose)
5. Types of facts and dimensions
6. OLTP & OLAP diff
7. SCD types and implementation
8. Experience in Metadata management MDM
9. Data dictionary✅
10. STTM 
    
    
4. SQL query qsns
1. All SQL queries ✅
2. SQL concept based FAQS 
1. Constraints in sql ( 8) ✅
3. 
   
5. Best practices  
1. Best practices of data modeling✅
2. Best practices of SQL query✅
   
   
6. Optimization of Data model and Query
1. DATA MODEL Optimization : Heavy data type column [ Varchar( Max) ] problem 
2. SQL query optimization steps 
   
   
7. Performance tuning qsns
1. SQL : Reasons for slow running query 
2. SQL how to tune slow query - Performance tuning questions ..
1. sql server✅
2. oracle ✅
3. mysql✅
   
   
8. Challenges you faced in DM projects
1. List of challenges 
2. Banking DM project Challenges : ✅
3. insurance DM project Challenges  ✅
4. food delivery DM project Challenges ✅
5. pharma DM project Challenges 
   
   
9. Warehouse concepts
1. 133 ) Compare DWH tools - Snowflake, synapse , bigquery, Redshift
2. 134 ) when should customer prefer  -  dwh tools 
1. snowflake ,
2.  Azure synapse ,
3.  GCP bigquery, 
4. aws redshift
3. Data mesh✅
4. Data vault
1. did you work on Data vault project  ✅
2. How did you handle the changes in data model  ✅
3. Datavault faqs
5. Data pipeline✅
1. data pipeline is a set of automated scripts,   that move data from one or more source systems, transform it   and load it into a destination target (such as a data warehouse, or lake house)
6. Data lineage✅ 
1. (tracking data from source to destination in diagram )
7. Data lake    ✅
1. Data Lake is a centralized, highly scalable storage repository that holds a vast amount of raw, unprocessed data in its native format (structured, semi-structured, and unstructured) until it is needed for analytics
8. Data lakehouse and how to design ( DATA BRICKS )✅
   
   
9. Diff between Datalake and Data lakehouse


10. Data warehouse✅
11. Data governance  ✅

1. Data governance is a collection of policies, procedures, standards, roles, and responsibilities that collectively ensure an organization's data is accurate, secure, compliant, and effectively managed throughout its entire lifecycle.

2. Data Governance FAQS
3. HIPAA , GDPR 
12. How to do Data profiling✅
13. ETL FAQ questions
14. ETL & ELT ( when to suggest )
15. Did you work on NO SQL databased AND Cassandra DB
    
    
10. Data modeling toos qsns
1. Erwin features
2. er studio features
   
   
11. SNOWFLAKE  DATABASE features 
1. FAQS on SNOWFLAKE DB
2. Snowflake Admin position interview qsns
3. 
   
   
12. AWS qsns
1. Aws solution architect project qsns✅
2. AWS interview qsns✅
3.  ) AWS : which features did you work 
   
   
13. Azure qsns
1. Azure solution architect project qsns✅
2. Which Azure features and project did you work on 
3. Azure data bricks 
4. Azure qsn flow 
   
   
14. MS fabric qsns
    
    
15. Data architect 
1. FAQ questions
2. DA training topics 

=================================================Company interview qsns
================================================

1. Infosys 23ju26
1. what is grain of fact table  that weekly ,monthly yearly 
   
   
2. Cognizant - 21jul26 qsns 
1. 
   
1. 
   
3. KPMG ( 28JUL26) AI qsns 
   
   
4. KP  & RACKSPACE