Normalization
Normalization is the process of organizing relational data to reduce redundancy by splitting it into related tables. DP-900 expects you to describe why normalization is used within the relational-data domain.
All DP-900 Terms
Structured data
Structured data is data that conforms to a fixed schema of rows and columns, such as tables in a relational database.
Semi-structured data
Semi-structured data is data that has some organizational structure, such as tags or keys, but does not fit a rigid relational schema — for example JSON or XML documents.
Relational database
A relational database is a database that stores data in tables of rows and columns with defined relationships and is queried using SQL.
Normalization
Normalization is the process of organizing relational data to reduce redundancy by splitting it into related tables.
Azure SQL Database
Azure SQL Database is a fully managed platform-as-a-service relational database in the Azure SQL family.
Azure SQL Managed Instance
Azure SQL Managed Instance is a managed deployment option in the Azure SQL family that offers near-complete SQL Server compatibility.
Azure Blob Storage
Azure Blob Storage is an object-storage service for storing large amounts of unstructured data such as files, images, and backups.
Azure Files
Azure Files is a managed file-share service that exposes fully managed file shares accessible over the SMB and NFS protocols.
Azure Table storage
Azure Table storage is a NoSQL key-value store for large amounts of structured, non-relational data.
Azure Cosmos DB
Azure Cosmos DB is a globally distributed, multi-model NoSQL database service with several APIs and low-latency access.
Transactional workload
A transactional workload (OLTP) is a workload characterized by many small, fast read and write operations, such as recording orders or payments.
Analytical workload
An analytical workload (OLAP) is a workload optimized for reading and aggregating large volumes of data to support reporting and decision-making.
Microsoft Fabric
Microsoft Fabric is an end-to-end analytics platform that unifies data engineering, warehousing, and business intelligence.
Power BI
Power BI is Microsoft's business-analytics service for building interactive reports and dashboards from data models.