Tuesday, July 28, 2026

124 ) Data modeling excel questions

 

 

 Interview Questions and Answers: 

Fact Tables & Data Warehousing

  


  •  .

✅ Q8: .

Q10: 

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

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

 

-------- 




snoQuestionAnswerLinks
1

 
 

 

8 
23
24 


 

  
28 
 
 
 
 
  



49 
52 
54 

 

55

 
56 
 
 


 ..

 
64 
65

Ty 

  •  

    • 66 
    67




       =========================================================== 

      How do you calculate the size of each table 


      What are the datatypes and their Memory size calculation 

      https://data-modeling-made-easy.blogspot.com/2024/07/sql-data-types-and-sizes.html



      ============================================================= 
      What is Medallion architechture ?

      ===============================================================

        
      ===========================================================

      Data modeling tools list 

      •  ER/Studio
      • Erwin Data Modeler
      •  
      • SQL Server Management Studio
      •  MySQL Workbench
      •  Oracle SQL Developer Data Modeler
      • SAP PowerDesigner
      • IBM IDA 
      ===========================================================

      ==============================================================
       

       

      at
      Labels:

      No comments:

      Post a Comment

      Subscribe to: Post Comments (Atom)

      239 ) Metadata Management

      Metadata Management and Modern Data Governance Tools Metadata management forms the backbone of data governance, data lineage, and data quali...

      • CDM vs LDM vs PDM
          Conceptual vs logical vs physical data models by  Sonny Rivera , Senior Analytics Evangelist at ThoughtSpot Published Jun 2, 2023 Data mod...
      • 22JAN26 - Best practices for Data modeling 1
           --- ## Data Modeling Best Practices – Headings 1. Start with Business Requirements (Not Tables) 2. Define Grain First (Critical Rule) 3. ...
      • 13fe26 - RDS & REDSHIFT differences
          Key Differences: Amazon RDS vs. Amazon Redshift Feature   Amazon RDS (Relational Database Service) Amazon Redshift Primary Use Case Transa...