Data Modeling and Transformation Techniques Flashcards

Microsoft Fabric Data Engineer Associate DP-700 Flashcards

Front	Back
Aggregation	Technique to summarize data by grouping and calculating metrics
Data Transformation	Process of converting data from one format to another
Data Types	Categories that define the kind of data stored in database columns
Denormalization	Technique where normalized data is combined for improved query performance
Dimension Table	Table containing descriptive attributes related to measurements in fact tables
ELT	Extract, Load, Transform process that leverages database engine for transformations
ETL	Extract, Transform, Load process for transferring and transforming data
Fact Table	Table containing measures or metrics in a star or snowflake schema
Foreign Key	Column that creates a relationship between two tables
Joins	SQL operations used to combine data from two or more tables
Normalization	Process of organizing data to reduce redundancy and improve integrity
Primary Key	Unique identifier for a record in a database table
Schema	Blueprint of how database tables are organized and their relationships
Snowflake Schema	Normalized version of star schema with dimensions further expanded
Star Schema	Simplified database schema with fact table at the center and dimension tables connected

This deck includes techniques for designing data models and performing transformations within Microsoft Fabric to support business needs efficiently.

Share on...