Bash, the Crucial Exams Chat Bot
AI Bot
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 |
Front
ETL
Click the card to flip
Back
Extract, Transform, Load process for transferring and transforming data
Front
ELT
Back
Extract, Load, Transform process that leverages database engine for transformations
Front
Foreign Key
Back
Column that creates a relationship between two tables
Front
Schema
Back
Blueprint of how database tables are organized and their relationships
Front
Primary Key
Back
Unique identifier for a record in a database table
Front
Denormalization
Back
Technique where normalized data is combined for improved query performance
Front
Star Schema
Back
Simplified database schema with fact table at the center and dimension tables connected
Front
Normalization
Back
Process of organizing data to reduce redundancy and improve integrity
Front
Aggregation
Back
Technique to summarize data by grouping and calculating metrics
Front
Data Transformation
Back
Process of converting data from one format to another
Front
Data Types
Back
Categories that define the kind of data stored in database columns
Front
Joins
Back
SQL operations used to combine data from two or more tables
Front
Snowflake Schema
Back
Normalized version of star schema with dimensions further expanded
Front
Dimension Table
Back
Table containing descriptive attributes related to measurements in fact tables
Front
Fact Table
Back
Table containing measures or metrics in a star or snowflake schema
1/15
This deck includes techniques for designing data models and performing transformations within Microsoft Fabric to support business needs efficiently.