Microsoft Azure Data Fundamentals (DP-900) Preparation

Microsoft Azure Data Fundamentals (DP-900) Preparation is a free program on ARPS, the Arab Platform for Professional Studies. Independent DP-900 preparation covering core data concepts, Azure relational and non-relational services, and analytics. Four modules and twenty-four lessons connect data concepts with Azure relational, non-relational and analytical services. Retained sound examples are extended through practical outputs that can be checked.

Important notice: Independent preparation. Arab Platform for Professional Studies (ARPS) does not administer the Microsoft exam, award Microsoft Azure Data Fundamentals certification, or claim Microsoft endorsement.

Study desk with a figurine, a model of paper data cylinders and tables in a tray, a cloud above them: cover of the ARPS program Microsoft Azure Data Fundamentals (DP-900) Preparation Studying is completely free
Estimated time
56.5 hours
subjects
4
lessons
24
Study language
Arabic and English

Certificate issuance fee

$90

331 AED or 338 SAR

After you pay the certificate fee, you can print the certificate and transcript in both Arabic and English, or in English only.

Start the first subject now Fees by route

What you will learn in the first 10 minutes

The opening lessons of the first subject, with the reading time set for each. Approximate total time in minutes: 8

  1. Representing data: structure is not a file extension 8 min read
    • Classify a record by its actual structure and identify what is needed to extract its fields without confusing file type and data store

From lesson 1, readable now without an account: Representing data: structure is not a file extension

The core data concepts domain asks you to distinguish structured, semi-structured, and unstructured data. Start with the record the application must process, rather than the name of a cloud service. Structured data follows a relatively stable schema: known fields, a type for each value, and rows whose constraints can be checked. Appointment records with appointment_id, patient_id, slot, and status fit that description if every row follows those fields, even when they arrive as a CSV file. A comma does not make content structured by itself. A CSV cell can contain free text or nested JSON, and files in one feed can have different columns. Ask which fields software may rely on and which constraints can be enforced before selecting a database.

Read the full lesson free
Start free

A free account saves your progress and takes you straight to lesson 1.

Program facts

Study fee
Free
subjects
4
lessons
24
Estimated time
56.5 hours
Content last reviewed
Access period
30 days
Study language
Arabic and English

About the program

Four modules and twenty-four lessons connect data concepts with Azure relational, non-relational and analytical services. Retained sound examples are extended through practical outputs that can be checked. Every lesson has three exercises with separate feedback. Two timed internal mocks each contain forty original questions in sixty minutes. Microsoft’s blueprint defines certification scope; these training forms remain independent of the official examination.

Practical relevance

Exercises classify records, map relationships, examine partition choices and reconcile pipeline counts.

Why this program

It connects data storage and processing choices to verifiable cases instead of memorizing service names alone.

Career relevance

Useful to beginning data practitioners discussing Azure choices with database and analytics teams.

Career paths this program serves

This program is a step on the paths of the following occupations. Open a path to see its other programs in study order.

What you will learn

  • Core data concepts
  • Relational data on Azure
  • Non-relational data on Azure
  • Analytics on Azure
Learning outcomes (24)
  1. Classify a record by its actual structure and identify what is needed to extract its fields without confusing file type and data store
  2. Compare file, object and database storage from reading, update and query patterns
  3. Separate event recording from aggregation by counting unit and freshness requirement
  4. Assign a data incident among database administrator, data engineer and analyst with escalation boundaries
  5. Compare CSV, JSON and column-oriented files by structure, validation and read pattern
  6. Trace a record from source to report and assign quality checks to the responsible roles
  7. Decompose a repeating order table into related entities and prevent update and deletion anomalies
  8. Interpret SELECT, JOIN, GROUP BY and row changes, and distinguish tables, views and indexes
  9. Compare Azure SQL Database, Managed Instance and SQL Server on an Azure VM by compatibility, control and operations
  10. Match a PostgreSQL or MySQL requirement to its managed Azure service without assuming SQL Server compatibility
  11. Design a junction table with composite key and constraints, then check join effects on counts and sums
  12. Interpret filtered aggregation and distinguish the roles of table, view, index and procedure
  13. Choose object storage or a managed file share from access pattern and bound a raw-size calculation
  14. Choose PartitionKey and RowKey for non-relational metadata and explain query limits
  15. Assess a distributed document store and choose a partition key aligned with customer queries
  16. Match a data model or existing client to a Cosmos DB API without treating APIs as interchangeable
  17. Balance access frequency, retrieval delay and retention policy when selecting a Blob tier
  18. Design a document and partition key for a read pattern, separating API compatibility from identical behavior
  19. Trace ingestion, transformation, storage and analysis while preserving grain and source quality
  20. Distinguish the platforms' capabilities and match processing and BI layers to real needs without exclusivity claims
  21. Choose batch or stream from decision latency and place ingestion, processing and alerting services
  22. Set model grain and measure, then choose a comparison or trend visual without misleading denominators
  23. Define fact and dimension grains and reconcile counts and values from ingestion to report
  24. Design a model relationship and a measure with the right denominator, then choose a visual that preserves context

Who it is for

  • DP-900 candidates seeking structured coverage of current Microsoft domains with original cases and questions.
  • New analysts and application developers connecting business questions to storage and processing choices.
  • Team members considering Azure migration who need to distinguish file, object, relational and document workloads, discuss report freshness, and challenge a dashboard denominator before any production deployment decision.

Prerequisites

  • Basic familiarity with files, tables, rows, columns and simple percentages. The first lesson reviews these before service selection.
  • Azure administration, advanced SQL and a paid subscription are not required for these reading and decision cases.
  • If these terms are new, first calculate one numerator-over-denominator rate and read a small CSV row and JSON document. Use each exercise feedback block to check your interpretation before moving on.

What it does not offer

  • General Azure administration or AZ-900 preparation.
  • Advanced PL-300 implementation or awarding a Microsoft credential.

Curriculum

  1. Subject 1 Open for free

    Core data concepts

    Start with the question the data must answer, not a file extension. Compare regular CSV columns with JSON documents whose keys may vary, and with images or audio that require extraction before their content can be counted. Separate interchange formats from object storage and an operational database: retaining proof images differs from updating an order state or preventing a double sale. Concurrent state changes indicate a transactional workload; grouping history by month or category indicates analytical work. In the extended case, trace record counts from source to pipeline, model and visual. The first count divergence identifies where to investigate; blaming the chart alone is insufficient. Distinguish the roles that verify source data, repair transformations and agree on metric meaning. Exercises classify records, calculate a rate and reconcile a pipeline, while explicitly marking what cannot be inferred from unindexed scans or incomplete fields.

    6 lessons · 13 hours
    1. Representing data: structure is not a file extension 2 hours
    2. From files to a store that fits the query 2 hours
    3. Distinguishing transactions from analysis 2 hours
    4. Who owns which decision in the data chain? 2 hours
    5. Read file formats before choosing a store 2 hours
    6. Data quality and lineage across roles 2 hours
  2. Subject 2

    Relational data on Azure

    Build a small relational model from customer orders. Repeating a customer's current address on every order causes update anomalies; separating Customer from Order with stable keys reduces that risk while the policy for a historical delivery address remains a separate decision. In SQL, read SELECT, JOIN and GROUP BY, distinguishing order rows from distinct customers after a join. Work a two-row result and see how a separate INSERT would change one city's total. Compare Azure SQL Database for a new app seeking less server management, Managed Instance for a demonstrated instance-level compatibility need, and SQL Server on a virtual machine when broader control justifies more operations. The word SQL does not make PostgreSQL and MySQL interchangeable with SQL Server; engine behavior and migration dependencies still need checking. Exercises produce a key map, a query with expected rows, and a service-choice matrix with its assumptions.

    6 lessons · 13 hours
    1. Keys, relationships and normalization 2 hours
    2. Reading SQL and basic database objects 2 hours
    3. Choosing among Azure SQL options 2 hours
    4. Open-source relational engines on Azure 2 hours
    5. Resolve many-to-many relationships without multiplying measures 2 hours
    6. Choose SQL objects for the question and update pattern 2 hours
  3. Subject 3

    Non-relational data on Azure

    Compare non-relational options by access interface rather than a NoSQL label. Invoice images retrieved as whole objects suggest Blob, whereas a legacy app requiring a shared file path across servers suggests Azure Files. Table Storage entities use partition and row keys; known-key retrieval fits, but this is not a promise of relational joins. For Cosmos DB documents, inspect the partition key against traffic: uniqueness alone does not prevent a hotspot when one value receives most requests. Finally, distinguish Cosmos DB APIs by the existing application's data model; a MongoDB-like interface does not guarantee identical queries or migration behavior. Worked cases state the read and write unit, then test traffic distribution, consistency and query form rather than selecting storage from JSON syntax or a file extension. Exercises produce an access matrix, a key design and a migration boundary note.

    6 lessons · 13 hours
    1. Blob and Files: same content, different access pattern 2 hours
    2. Azure Table: designing keys from query patterns 2 hours
    3. Cosmos DB: workload fit and partition key 2 hours
    4. Cosmos DB APIs and the meaning of compatibility 2 hours
    5. Blob tiers and the lifecycle of retrievable copies 2 hours
    6. From document query to Cosmos partition and API choice 2 hours
  4. Subject 4

    Analytics on Azure

    Trace a reporting question from source to presentation. Identify ingestion, transformations that clean or derive fields, analytical storage, then model and visual. Reconcile row counts between stages: filling a missing value does not insert a row, and a report filter can reduce what is displayed without changing the model. Distinguish batch work that tolerates stated delay from a streaming requirement that receives and processes events continuously, assigning Event Hubs and Stream Analytics roles only where needed. Compare Fabric and Azure Databricks by workload, tooling and integration rather than claiming either universally replaces the other. In Power BI, choose trend, comparison or composition views from the question and show denominators beside rates. Exercises deliver a pipeline map, count reconciliation, freshness decision and a verifiable visual specification.

    6 lessons · 13 hours
    1. From source to analytical store 2 hours
    2. Fabric and Databricks in a large analytics workload 2 hours
    3. Batch or stream: time is part of the decision 2 hours
    4. Power BI: model, measure and fitting visual 2 hours
    5. From source batch to a reconcilable analytical model 2 hours
    6. Interpret a Power BI measure under filters 2 hours

Subjects unlock in sequence as you progress.

Strengths

  • DP-900 blueprint coverage through specific data cases
  • Worked applications with checked results
  • Original questions with reasons for each option

Evidence basis

Scope follows Microsoft’s study guide effective 21 July 2026; service explanations use current documentation and an independent normalization source.

Reference organizations

  • Microsoft

Frameworks used

  • DP-900 study guide — Skills measured as of 2026-07-21
Methodology

Mapped blueprint skills to original lessons, cases and questions while checking each service boundary.

How the route works

Professional Certification Preparation programs help learners prepare for a recognized external certification through structured knowledge, review, practice questions, and readiness assessments. Arab Platform for Professional Studies (ARPS) does not administer the certification owner's official exam.

Structured self-paced study aligned to the current external certification scope, with knowledge review, practice questions, readiness checks, and internal mock assessments.

  • Focused preparation for a specific external certification.
  • Content aligned to the current official exam scope when available.
  • Practice questions and internal readiness assessments.
  • Clear separation between Arab Platform for Professional Studies (ARPS) preparation and the official external exam.

Assessment

The route includes an internal assessment for Arab Platform for Professional Studies (ARPS) completion eligibility and separate mock/readiness assessments that are not the external official exam.

Assessment attempts: 2 per assessment, 7 days apart

The pass mark is announced before the program is published.

Certificate

The Arab Platform for Professional Studies (ARPS) credential confirms completion of the preparation program only; the target professional certification requires passing the external issuer's examination under its rules.

Every certificate has a public verification code. Verify a certificate

A sample from a real program in this track: Project Management Professional (PMP) Preparation. The learner, scores and dates are fictional; opens in a new window.

Verification example: a real issued certificate

Disclaimer: Any platform completion credential is separate from Microsoft certification.

Program questions

Is this the official Microsoft certification?

No. This is independent preparation; Microsoft controls its official exam and certification.

Which blueprint does this cover?

The DP-900 skills measured from 21 July 2026, subject to source review when revised.

Do I need an Azure subscription?

No, not for the reading, decision exercises or assessments in this material.

Are official exam items copied?

No. Practice and mock questions are original, and their result is not a Microsoft exam result.

How do I choose a service for a case?

State read, update, consistency and freshness needs first, then compare the relevant service behavior.

Show all (8)
Are there worked examples?

Yes. Each lesson includes a worked example and three exercises with separate feedback, followed by explanatory questions.

Is Microsoft Azure Data Fundamentals (DP-900) Preparation free, and do I get a certificate?

Yes. Microsoft Azure Data Fundamentals (DP-900) Preparation is free on ARPS: every lesson, exercise and assessment is free, the first subject is open to read without an account, and the program is available in Arabic and English. Issuing a certificate is optional and has a published fee; it is a training completion certificate showing you passed the program's assessments, recognised by most private-sector organisations in the Gulf states and most Arab countries, and it strengthens your CV; confirming that a specific organisation accepts it remains your responsibility.

What other names is Microsoft Azure Data Fundamentals (DP-900) Preparation known by?

The subject of this program is also known as: DP-900, Azure Data Fundamentals, Microsoft Azure Data Fundamentals. Learners usually find it by searching for: DP-900 exam prep, microsoft azure data fundamentals dp 900 exam prep, DP-900 practice test prep, DP-900 study guide, free DP-900 exam prep, what is DP-900 certification, DP-900 exam requirements, DP-900 course in Arabic.

Professionals in this domain

Connect with certified consultants, trainers, coaches and specialists in the same domain across the ARPS communities.