176 ) Warehouse concepts ( pipeline , lakehouse , vault , governance, mesh)

 

1. 133 )

   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