12 real DP-900 sample questions, each with a worked explanation and a rationale for every option, right and wrong. No account, no card. This is the reasoning the DP-900 tests: knowing why the tempting answer is wrong, not just spotting the right one.
The real DP-900 is Typically 40 to 60 questions questions in 45 minutes, pass mark 700 / 1000. For a domain-by-domain breakdown and a study plan, read the DP-900 study guide. The full bank has 262 questions.
lock_openFree sampleDescribe Core Data Conceptsmedium
Storing customer profiles as JSON documents whose fields vary between records is an example of semi-structured data. Is this statement correct?
- AYescheck_circle Correct
- BNo
JSON documents with fields that differ between records are semi-structured, not unstructured. JSON is named in the grounding as a common semi-structured format precisely because its documents can vary in their specific fields between instances.
Why A is correct: Correct. JSON is named in the grounding as a common semi-structured format precisely because its documents can vary in their specific fields between instances.
Why B is wrong: Answering No is wrong because semi-structured data is defined as having some structure while allowing variation between instances, and JSON with varying fields is the common example the grounding gives.
lock_openFree sampleDescribe Core Data Conceptsmedium
In which type of database is structured data held in tables, with each entity instance assigned a primary key that other tables reference to eliminate duplicate values?
- AGraph database
- BRelational databasecheck_circle Correct
- CKey-value database
- DDocument database
Relational databases use tables and primary keys to reference entities and normalise data, storing each value only once. Relational databases store structured data in tables representing entities, assign each instance a primary key, and reference those keys from other tables, which enables normalisation so details such as an individual customer are stored only once.
Why A is wrong: A graph database stores entities as nodes with links defining relationships, rather than normalised tables that reference each other through primary keys.
Why B is correct: Correct. Relational databases store structured data in tables representing entities, assign each instance a primary key, and reference those keys from other tables, which enables normalisation so details such as an individual customer are stored only once.
Why C is wrong: A key-value database pairs a unique key with a value in any format, so it does not model entities as related tables joined by primary keys.
Why D is wrong: A document database stores each value as a JSON document optimised for parsing, not as normalised tables linked by primary keys to remove duplication.
lock_openFree sampleDescribe Core Data Conceptsmedium
Which term do data professionals use for files that store unstructured data, such as images, video and audio, as raw binary that an application must interpret and render?
- ABinary Large Object (BLOB)check_circle Correct
- BTab-separated values (TSV)
- CAvro row-based file
- DExtensible Markup Language (XML)
Raw binary files for unstructured content like images, video and audio are called BLOBs, short for Binary Large Objects. Some formats store unstructured data as raw binary that applications must interpret and render, and data professionals refer to these files as BLOBs, short for Binary Large Objects, with common examples including images, video and audio.
Why A is correct: Correct. Some formats store unstructured data as raw binary that applications must interpret and render, and data professionals refer to these files as BLOBs, short for Binary Large Objects, with common examples including images, video and audio.
Why B is wrong: TSV is a delimited text format whose bytes map to printable characters, so it represents readable structured data rather than raw binary media.
Why C is wrong: Avro does store data as binary blocks, but it is an optimized format for structured records with a JSON header, not the general term for unstructured image or video files.
Why D is wrong: XML is a human-readable text format whose bytes map to printable characters, so it is not used to describe raw binary media that must be rendered.
lock_openFree sampleDescribe an Analytics Workload on Azureeasy
In a data warehouse that uses a star schema, what is the role of the central fact table relative to the surrounding dimension tables?
- AIt holds the numeric values that can be aggregated by the related dimensionscheck_circle Correct
- BIt holds the descriptive entities used to group and slice the numeric values
- CIt stores the raw files exactly as received before any schema is applied
- DIt records the read-time formula language used to compute query measures
Fact tables hold numbers; dimension tables hold the entities to aggregate by. In a star schema the central fact table contains the numeric values, related to dimension tables that represent the entities by which the data can be aggregated.
Why A is correct: Correct. In a star schema the central fact table contains the numeric values, related to dimension tables that represent the entities by which the data can be aggregated.
Why B is wrong: Describing entities such as customer, product and store is the role of the dimension tables.
Why C is wrong: Storing raw files with no schema describes a data lake, not a fact table in a star schema.
Why D is wrong: Formula-language measures belong to a semantic model, not to a warehouse fact table.
lock_openFree sampleDescribe an Analytics Workload on Azureeasy
Which open-source distributed processing engine is Azure Databricks built on?
- AApache Spark, used for large-scale engineering, data science, and SQL analyticscheck_circle Correct
- BApache Kafka, used as a streaming event source for real-time ingestion pipelines
- CSQL Server Analysis Services, used to build pre-aggregated multidimensional cube models
- DPower Query, used to author low-code reusable data transformation logic visually
Azure Databricks is built on Apache Spark for code-first large-scale analytics. The grounding states Azure Databricks is a cloud analytics platform built on Apache Spark, optimised for large-scale data engineering, data science, and SQL analytics.
Why A is correct: Correct. The grounding states Azure Databricks is a cloud analytics platform built on Apache Spark, optimised for large-scale data engineering, data science, and SQL analytics.
Why B is wrong: Apache Kafka is named only as an event source that streaming ingestion connects to, not the engine Databricks is built on.
Why C is wrong: SQL Server Analysis Services builds multidimensional cubes for analytical models, and is unrelated to the Databricks compute engine.
Why D is wrong: Power Query underpins low-code Dataflows Gen2 transformations, and is not the processing engine behind Azure Databricks.
lock_openFree sampleDescribe an Analytics Workload on Azuremedium
Fabric Mirroring can continuously replicate an external database such as Azure SQL Database into OneLake without any pipeline authoring. Is this statement correct?
- AYescheck_circle Correct
- BNo
Fabric Mirroring auto-replicates external databases into OneLake with no pipeline authoring. Fabric Mirroring continuously replicates external databases including Azure SQL Database, Snowflake, and Azure Cosmos DB into OneLake in near-real-time, with Fabric handling change tracking and replication automatically after a one-time source connection, requiring no pipeline authoring.
Why A is correct: Correct. Fabric Mirroring continuously replicates external databases including Azure SQL Database, Snowflake, and Azure Cosmos DB into OneLake in near-real-time, with Fabric handling change tracking and replication automatically after a one-time source connection, requiring no pipeline authoring.
Why B is wrong: Answering No would wrongly imply replication needs a hand-built pipeline, but Mirroring is configured once and then managed automatically by Fabric.
lock_openFree sampleIdentify Considerations for Relational Data on Azureeasy
In a relational database, how is a single instance of a real-world entity such as one customer represented?
- AAs one row within the table that models that entitycheck_circle Correct
- BAs one column within the table that models that entity
- CAs a separate table created for that individual instance
- DAs a datatype definition applied to the whole table
A row is one instance of an entity; the table is the whole collection of those instances. A relational table contains rows where each row represents a single instance of an entity, so one customer occupies one row in the customer table.
Why A is correct: Correct. A relational table contains rows where each row represents a single instance of an entity, so one customer occupies one row in the customer table.
Why B is wrong: A column stores one attribute (such as Email) across many entity instances, not a single instance.
Why C is wrong: A table models a whole collection of entities; one instance is a row inside it, not its own table.
Why D is wrong: A datatype constrains the values a column may hold; it does not represent an entity instance.
lock_openFree sampleIdentify Considerations for Relational Data on Azureeasy
Relational tables are a format for structured data in which each row in a table has the same columns, although some columns may hold no value (NULL) for a given row. Is this statement correct?
- AYescheck_circle Correct
- BNo
Every row in a relational table shares the same columns, but a cell may be empty (NULL). Relational tables store structured data where every row shares the same set of columns, and a column such as MiddleName can be empty or NULL for rows where no value applies.
Why A is correct: Correct. Relational tables store structured data where every row shares the same set of columns, and a column such as MiddleName can be empty or NULL for rows where no value applies.
Why B is wrong: Answering No would wrongly suggest rows can have differing columns; in a relational table the columns are fixed across all rows even though individual cells may be NULL.
lock_openFree sampleIdentify Considerations for Relational Data on Azureeasy
A database administrator needs to remove a previously granted permission so a user can no longer modify data in a table. Which category of SQL statement does this action belong to?
- AData Control Language (DCL), used to manage access by granting, denying, or revoking permissionscheck_circle Correct
- BData Manipulation Language (DML), used to retrieve, insert, modify, or delete rows in tables
- CData Definition Language (DDL), used to create, modify, and remove tables and other objects
- DTransact-SQL (T-SQL), the Microsoft dialect used by Azure SQL Database and SQL Server
DCL statements (GRANT, DENY, REVOKE) manage who is allowed to perform actions on database objects. Revoking a previously granted permission is a DCL action; database administrators use DCL statements such as GRANT, DENY, and REVOKE to manage access to objects in a database.
Why A is correct: Correct. Revoking a previously granted permission is a DCL action; database administrators use DCL statements such as GRANT, DENY, and REVOKE to manage access to objects in a database.
Why B is wrong: DML manipulates the data inside tables; it does not control which users hold permissions.
Why C is wrong: DDL changes the structure of objects, not the permissions assigned to users.
Why D is wrong: T-SQL is a SQL dialect, not one of the three logical statement categories that group statements by purpose.
lock_openFree sampleDescribe Considerations for Working with Non-Relational Data on Azureeasy
A team needs to store large numbers of images, video files, and backup archives so that applications can read and write them through a cloud storage API. Which Azure storage service is designed for this kind of unstructured data?
- AAzure Blob storagecheck_circle Correct
- BAzure Files
- CAzure Table storage
- DAzure Queue storage
Blob storage is Azure's object store for unstructured data such as images, video, and backups. Azure Blob storage stores massive amounts of unstructured data as binary large objects (blobs) that applications read and write through the Blob storage API, making it the fit for images, video, and archives.
Why A is correct: Correct. Azure Blob storage stores massive amounts of unstructured data as binary large objects (blobs) that applications read and write through the Blob storage API, making it the fit for images, video, and archives.
Why B is wrong: Azure Files provides cloud network file shares mounted over SMB or NFS, not an object store accessed through a Blob API.
Why C is wrong: Table storage holds semi-structured key/value rows, not arbitrary binary objects such as images or video.
Why D is wrong: Queue storage holds messages for asynchronous processing between application components, not large binary files.
lock_openFree sampleDescribe Considerations for Working with Non-Relational Data on Azuremedium
An organisation already has Azure file shares but wants to keep locally cached copies of those shared files on its on-premises servers synchronised with the data held in Azure. Which Azure Files capability provides this?
- AAzure File Synccheck_circle Correct
- BAzCopy
- CLifecycle management policy
- DGeo-redundant storage
Azure File Sync keeps locally cached copies of files in step with the share stored in Azure. Azure File Sync synchronises locally cached copies of shared files with the data in Azure File storage, giving on-premises servers an up-to-date local cache.
Why A is correct: Correct. Azure File Sync synchronises locally cached copies of shared files with the data in Azure File storage, giving on-premises servers an up-to-date local cache.
Why B is wrong: AzCopy is a utility for uploading and copying files to storage, not a service that keeps local caches continuously synchronised with the share.
Why C is wrong: Lifecycle management policies move or delete blobs across access tiers based on age; they apply to Blob storage, not file-share synchronisation.
Why D is wrong: Geo-redundant storage replicates data to a secondary region for resilience; it does not cache and sync files to on-premises servers.
lock_openFree sampleDescribe Considerations for Working with Non-Relational Data on Azureeasy
Which statement best describes what Azure Cosmos DB is?
- AA fully managed PaaS NoSQL database service for which Microsoft handles the infrastructure, patching, and backupscheck_circle Correct
- BA self-managed relational database engine that you install, patch, and back up on your own virtual machines
- CA managed relational database service built around fixed table schemas and SQL joins across related tables
- DA large-scale analytics warehouse designed for historical reporting over very large accumulated datasets
Cosmos DB is a fully managed PaaS NoSQL database; Microsoft runs the operational overhead for you. Azure Cosmos DB is a fully managed NoSQL database service, a platform-as-a-service offering in which Microsoft handles server provisioning, patching, updates, and backups.
Why A is correct: Correct. Azure Cosmos DB is a fully managed NoSQL database service, a platform-as-a-service offering in which Microsoft handles server provisioning, patching, updates, and backups.
Why B is wrong: Cosmos DB is a fully managed PaaS service for NoSQL data, not a self-managed relational engine that you patch yourself.
Why C is wrong: Cosmos DB is schema-agnostic NoSQL; workloads that depend on complex multi-table joins are better served by Azure SQL Database.
Why D is wrong: Large-scale historical analytics is a fit for Microsoft Fabric or Azure Synapse Analytics, not for Cosmos DB.
Examworthy is not affiliated with or endorsed by Microsoft. All questions are original, blueprint-aligned practice material. We never reproduce live exam items. DP-900 and related marks belong to their respective owners.
