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. DP-900 covers it as one of the three ways to represent 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 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.
A relational database is a database that stores data in tables of rows and columns with defined relationships and is queried using SQL.
Normalization is the process of organizing relational data to reduce redundancy by splitting it into related tables.
Azure SQL Database is a fully managed platform-as-a-service relational database in the Azure SQL family.
Azure SQL Managed Instance is a managed deployment option in the Azure SQL family that offers near-complete SQL Server compatibility.
Azure Blob Storage is an object-storage service for storing large amounts of unstructured data such as files, images, and backups.
Azure Files is a managed file-share service that exposes fully managed file shares accessible over the SMB and NFS protocols.
Azure Table storage is a NoSQL key-value store for large amounts of structured, non-relational data.
Azure Cosmos DB is a globally distributed, multi-model NoSQL database service with several APIs and low-latency access.
A transactional workload (OLTP) is a workload characterized by many small, fast read and write operations, such as recording orders or payments.
An analytical workload (OLAP) is a workload optimized for reading and aggregating large volumes of data to support reporting and decision-making.
Microsoft Fabric is an end-to-end analytics platform that unifies data engineering, warehousing, and business intelligence.
Power BI is Microsoft's business-analytics service for building interactive reports and dashboards from data models.