Microsoft Azure DP-900 Practice Test 2026 – Complete Exam Prep

The choice of SQL Server is accurate as it is a relational database management system (RDBMS) that uses structured query language (SQL) for defining and manipulating data. It organizes data into tables with rows and columns, adhering to a schema, which is a characteristic of relational databases.

In contrast, Cosmos DB, Blob Storage, and File Storage are all considered non-relational database options. Cosmos DB is a globally distributed, multi-model database service that supports document, key-value, graph, and column-family data models, making it highly flexible for various workloads. Blob Storage is designed for storing massive amounts of unstructured data, such as documents and media files, while File Storage provides a managed file share in the cloud, focused on simplicity and ease of use for applications that require shared access to files.

This clear distinction between relational and non-relational databases is fundamental in understanding the varied offerings of Azure in terms of data storage solutions.