Prepstellar
Get the app

DP-900 · Mock exam · 25 questions

DP-900 mock exam: 25 free practice questions

Untimed here · timed and scored in the app

A free DP-900 practice test with 25 exam-style questions drawn from the whole course and weighted by domain like the exam guide. Answer at your pace and read why each option is right or wrong.

  • 700 or greaterPassing score
  • Describe core data concepts 25–30%
  • Identify considerations for relational data on Azure 20–25%
  • Describe considerations for working with non-relational data on Azure 15–20%
  • Describe an analytics workload on Azure 25–30%

Exam details from the vendor’s exam guide, captured 2026-08-30.

Swipe, scroll or use ← →

  1. Q1 / 25

    A report must show each product category's proportion of total sales. Which visual fits the analytical goal?

    1. AA line chart showing the ordering of sales over time
    2. BA map positioning sales values across geographic locations
    3. CA pie chart showing each category as part of the total
    4. DA scatter plot comparing sales with another numeric measure
    Show the answer

    The required message is part-to-whole composition, which is the documented use of a pie chart; time, correlation, and geography are separate selection criteria.

    Next → 1 / 25

  2. Q2 / 25

    A sales director defines a business question and provides raw order data. Which action best fulfills the data analyst responsibility?

    1. AOptimize the database for consistent operational performance
    2. BProcess the data into relevant insights for the stated question
    3. CGrant sales users privileges over the operational database
    4. DCreate recovery processes for accidental order deletion
    Show the answer

    The analyst uses identified business requirements to turn raw data into relevant insight; database access, performance, and recovery solve operational needs.

    Next → 2 / 25

  3. Q3 / 25

    What can an analyst configure in Power BI Desktop Model view?

    1. ACloud publication, app distribution, and workspace membership
    2. BReport consumption, browser access, and mobile notifications
    3. CPhone-app navigation, dashboard sharing, and scheduled refreshes
    4. DTable relationships, hierarchies, data types, and display formats
    Show the answer

    Model view shapes the semantic model by configuring relationships and analytical properties; service publication and consumption tasks occur elsewhere in the workflow.

    Next → 3 / 25

  4. Q4 / 25

    Which compatibility statement describes Azure SQL Managed Instance?

    1. AIt offers full compatibility by exposing the guest operating system to customers
    2. BIt offers near-100 percent compatibility with on-premises SQL Server instances
    3. CIt implements MySQL Community Edition with managed scaling and backups
    4. DIt provides core database-level capabilities but omits instance-oriented architecture
    Show the answer

    Managed Instance is positioned between database-level PaaS and customer-managed virtual machines by retaining near-complete SQL Server instance compatibility while Azure manages the platform.

    Next → 4 / 25

  5. Q5 / 25

    Which capability combination defines a data lakehouse?

    1. AFlexible data lake storage with relational warehouse-style querying
    2. BRelational warehouse storage with processing limited to transactional writes
    3. COperational database storage with create-only record access
    4. DPreaggregated semantic storage with no file-based foundation
    Show the answer

    A lakehouse unifies the scalable file-oriented foundation of a data lake with the relational query semantics associated with a warehouse.

    Next → 5 / 25

  6. Q6 / 25

    How do the typical data scopes differ?

    1. ABatch and streaming both require the full historical dataset
    2. BBatch uses recent data only; streaming requires the full dataset
    3. CBatch and streaming both exclude data outside a rolling window
    4. DBatch can use all data; streaming uses recent data or a window
    Show the answer

    Scope follows the processing model: batch can inspect the complete dataset, while streaming usually sees the newest events or a temporal window.

    Next → 6 / 25

  7. Q7 / 25

    Which combination describes Azure Cosmos DB for MongoDB?

    1. AMongoDB drivers, BSON data, and MQL
    2. BTable Storage clients, key-value rows, and CQL
    3. CCassandra clients, column families, and MQL
    4. DNative clients, JSON documents, and Gremlin
    Show the answer

    MongoDB compatibility spans the client libraries, BSON representation, and MQL query language, so all three interface elements must align.

    Next → 7 / 25

  8. Q8 / 25

    Which workload profile favors Azure SQL Database?

    1. AA server migration requiring full control of SQL Server configuration
    2. BA new cloud application with minimal instance-level dependencies
    3. CA legacy application requiring unsupported operating-system features
    4. DAn existing instance requiring advanced features and near-complete compatibility
    Show the answer

    Azure SQL Database targets cloud-designed or lightly dependent applications that can use managed database-level capabilities.

    Next → 8 / 25

  9. Q9 / 25

    An analytics project must ingest data from relational databases, nonrelational databases, file stores, and streams, then prepare it for an analytical store. Which responsibility is most relevant?

    1. ACreating charts directly from each unprepared source
    2. BDesigning data engineering workloads across varied platform technologies
    3. CManaging database privileges across all source applications before building the integration workload
    4. DWriting recovery policies for each source database
    Show the answer

    The scenario combines the documented technology range with ingestion, cleansing, transformation, and analytical storage, making it an end-to-end data engineering workload.

    Next → 9 / 25

  10. Q10 / 25

    An organization wants ingestion, warehousing, real-time analytics, data science, and Power BI in one browser-based SaaS workspace without managing clusters. Which platform fits?

    1. ADelta Lake alone
    2. BDatabricks SQL alone
    3. CAzure Databricks
    4. DMicrosoft Fabric
    Show the answer

    The requirement matches Fabric's unified workload set, OneLake foundation, Power BI integration, and vendor-operated SaaS infrastructure.

    Next → 10 / 25

  11. Halfway, at your pace

    In the app the mock exam is timed and scored like the real thing.

    Get the app

  12. Q11 / 25

    Which schema behavior is valid for rows in one Azure Table Storage table?

    1. ARows must reference related tables through declared foreign keys
    2. BRows may omit row keys when their partition keys are unique
    3. CRows must contain identical columns and share one composite key
    4. DRows may contain different columns while retaining unique composite keys
    Show the answer

    Table Storage permits flexible columns, but every row still needs the partition-key and row-key combination that uniquely identifies it.

    Next → 11 / 25

  13. Q12 / 25

    What does an index contain for its specified table column?

    1. AA sorted copy of column data with pointers to corresponding rows
    2. BA duplicate table whose rows require no further maintenance
    3. CA virtual SELECT result with no relationship to table rows
    4. DA set of procedure parameters that update corresponding rows
    Show the answer

    The sorted values and row pointers let the database system navigate to matches more directly than a full row-by-row scan.

    Next → 12 / 25

  14. Q13 / 25

    An archive must retain native images, audio recordings, videos, and application-specific binary documents. The files do not share a schema of recurring fields or properties. Which classification fits the archived content?

    1. AStructured, because each document supplies the same entity attributes
    2. BUnstructured, because the native files have no shared specific structure
    3. CSemi-structured, because all media files contain varying address sections
    4. DStructured, because every binary file follows one common table schema
    Show the answer

    Native documents, images, audio, video, and binary files with no specific shared structure match the unstructured category.

    Next → 13 / 25

  15. Q14 / 25

    Which description best identifies Microsoft Fabric?

    1. AA unified SaaS analytics platform built over shared OneLake storage
    2. BA standalone file format that adds transactions to Parquet
    3. CA code-first Spark service deployed inside an Azure subscription
    4. DA dedicated notebook language used for SQL analytics
    Show the answer

    Fabric integrates multiple analytics workloads in one browser-based SaaS workspace and uses OneLake as their common storage layer.

    Next → 14 / 25

  16. Q15 / 25

    What does the API selected for a Cosmos DB account determine?

    1. AData format, query language, and client-library compatibility
    2. BAzure region, historical archive, and server patch schedule
    3. CTable joins, backup ownership, and relational schema enforcement
    4. DDevice frequency, player latency, and shopping-cart volume
    Show the answer

    The API is the application-facing abstraction, so it governs how data is represented, queried, and accessed through libraries rather than choosing business workload characteristics.

    Next → 15 / 25

  17. Q16 / 25

    Which Azure SQL family product uses the IaaS service model?

    1. AAzure SQL Database on a managed logical server
    2. BAzure SQL Database using a shared elastic pool
    3. CAzure SQL Managed Instance with automated recovery
    4. DSQL Server on Azure Virtual Machines
    Show the answer

    The virtual-machine product provides virtualized infrastructure and customer control; Azure SQL Database and Managed Instance abstract the server as PaaS.

    Next → 16 / 25

  18. Q17 / 25

    During stakeholder collaboration, what does a data engineer design and implement?

    1. AReports and visualizations that present identified business insights
    2. BDatabase privileges and user access decisions for operational records
    3. CData-related workloads for ingestion, preparation, and analytical storage
    4. DBackup and recovery plans that restore failed database systems
    Show the answer

    Stakeholder collaboration informs data-related workloads spanning ingestion pipelines, cleansing, transformation, and analytical stores.

    Next → 17 / 25

  19. Q18 / 25

    Which technology is the foundation of Azure Databricks large-scale processing?

    1. AApache Spark
    2. BPower BI
    3. COneLake
    4. DPower Query transformations
    Show the answer

    Azure Databricks is built on Apache Spark and is optimized for distributed engineering, data science, and SQL analytics.

    Next → 18 / 25

  20. Q19 / 25

    A team must expose an Azure Files share through NFS to supported Linux hosts and control access through a private network boundary. Which configuration meets the documented requirements?

    1. AAn HDD-tier storage account with SMB enabled for macOS clients
    2. BAn HDD-tier storage account with public access and no virtual network
    3. CAn SSD-tier storage account with NFS enabled for Windows clients
    4. DAn SSD-tier storage account with a configured virtual network
    Show the answer

    NFS Azure file shares require SSD-backed storage and a configured virtual network; the protocol is supported for qualifying Linux kernels.

    Next → 19 / 25

  21. Q20 / 25

    A team is building a new cloud application with no significant instance-level dependencies. It wants automated updates, backups, and recovery. Which service best fits?

    1. AAzure SQL Database with its managed database-level capabilities
    2. BAzure Database for PostgreSQL for a SQL Server-based application
    3. CAzure SQL Managed Instance for advanced instance-level compatibility
    4. DSQL Server on Azure Virtual Machines with customer-managed maintenance
    Show the answer

    Azure SQL Database is designed for new cloud solutions and minimizes administration when the application can work with core database-level SQL Server capabilities.

    Next → 20 / 25

  22. Q21 / 25

    What does Delta Lake add to Parquet files?

    1. AA transaction log supporting ACID transactions, versioning, and reliable updates
    2. BAn XML tag hierarchy that defines elements and attributes for every record
    3. CA graph model that stores entities as nodes connected by relationship links
    4. DA fixed-width text layout that allocates equal characters to each field
    Show the answer

    Delta Lake extends the Parquet storage format with a transaction log, enabling transactional reliability and data versioning on data-lake files.

    Next → 21 / 25

  23. Q22 / 25

    Why might a solution persist stream-processing results in an analytical store?

    1. ATo prevent current events from appearing in real-time dashboards
    2. BTo support later historical analysis beside batch-processed data
    3. CTo remove the need for current filtering and aggregation
    4. DTo force every incoming record through a scheduled monthly job
    Show the answer

    Persisting streamed results preserves them for retrospective work and lets historical analysis combine them with batch-produced results.

    Next → 22 / 25

  24. Q23 / 25

    Which data format and query style belong to Azure Cosmos DB for NoSQL?

    1. AGraph vertices with Gremlin traversals
    2. BColumn families with CQL queries
    3. CJSON documents with SQL-like queries
    4. DBSON documents with MQL queries
    Show the answer

    The native NoSQL API pairs JSON documents with SQL-like syntax, unlike the BSON, graph, and column-family interfaces.

    Next → 23 / 25

  25. Q24 / 25

    Which key uniquely identifies an entity instance?

    1. AA primary key
    2. BA nullable column
    3. CA foreign key
    4. DA discrete attribute
    Show the answer

    The primary key supplies the unique identity of a row; a foreign key stores the primary-key value of a related entity.

    Next → 24 / 25

  26. Q25 / 25

    How should a task be classified when one employee performs multiple data roles?

    1. AUse the responsibility being performed in that task
    2. BUse the location of the on-premises or cloud system
    3. CUse the employee's first assigned data responsibility
    4. DUse the database platform hosting the organization's data
    Show the answer

    Roles divide responsibilities even when one person carries several roles, so the current task determines whether the work is administration or analysis.

    Next → 25 / 25

  27. That’s the whole mock exam

    Every question you miss comes back exactly when you’re about to forget it.

    Back to the course Get the app

How to use this mock exam

Sit all 25 questions in one go: the mix covers every domain in the same proportion as the exam, so a low score points at the domain you skipped rather than at bad luck.

Read the explanation under every question, including the ones you got right — the reason an option is wrong is usually the thing being tested.

Then retake it in the app, where the mock exam is timed and scored and the questions you miss come back on a schedule.

Keep your progress · Get the app

The whole course, on your phone

Lessons you can read, audio you can listen to on the way to work, and practice that remembers what you got wrong.

Get the app