217 ) All questions post

 

1. Project based questions
1. Project explain
1. Insurance project qsns
2. Project challenges (4 )
1. 
   
2. SQL queries ( 14) 
3. Dimensional Modeling questions
1. Modeling qsns
2. Excel qsns 
3. Data modeling tools
4. Warehouse New  concepts
1. 33 )

   How to select which Data warehouse

   Database
1. - Snowflake / Azure  synapse / GCP  bigquery/ AWS Redshift
2.  
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
4. Data model implementation phase
1. Best practices
2. Optimisation
3. Perf tuning
5. Data bases 
1. snowflake features 
6. Cloud 
1. aws 
2. azure