DP-900 / Fundamentals

DP-900: Microsoft Azure Data Fundamentals

Prepare for DP-900 with a guide to the current objectives and 200 original questions in Spanish and English, with explanations checked against Microsoft Learn.

Duration
45 minutes
Passing score
700/1000
Official exam price
76 EUR · 99 USD

Spain: EUR 76 · United States: USD 99. Indicative prices before applicable taxes and discounts. Confirm pricing on Microsoft Learn. The LarrúaTech practice test is free.

Documentation review: 22 October 2026 · Objectives: 21 July 2026 · ES / EN

A solid foundation for working with data

DP-900 validates data concepts and the purpose of Azure data services. It is intended for people starting with cloud data and requires no prior certification. Learn to justify which option meets each scenario before memorizing product names.

The reviewed English study guide publishes objectives effective from 21 July 2026. Microsoft translations may be updated later: this bilingual material follows that English scope. Fabric and Databricks are part of the analytics domain.

The four exam domains

Core data concepts

25–30 %
  • Structured, semi-structured and unstructured data. CSV, JSON, XML, Parquet, Avro and Delta Lake.
  • Transactional and analytical workloads, CRUD and ACID properties. Responsibilities of database administrators, data engineers and data analysts.

56 questions in this bank

Relational data on Azure

20–25 %
  • Tables, rows, columns, keys and referential integrity. Normalization, SQL queries, views, procedures and indexes.
  • Choose between Azure SQL Database, Managed Instance and SQL Server on a VM. Managed PostgreSQL and MySQL services.

48 questions in this bank

Non-relational data on Azure

15–20 %
  • Object storage, file shares and key/attribute entities: Blob Storage, Azure Files and Table Storage.
  • Cosmos DB use cases and API selection: NoSQL, MongoDB, Cassandra, Gremlin and Table.

40 questions in this bank

Analytics on Azure

25–30 %
  • Ingestion, ETL and ELT; data lakes, warehouses and lakehouses. Microsoft Fabric, OneLake and Azure Databricks.
  • Batch and streaming; Stream Analytics and Real-Time Intelligence. Power BI, facts, dimensions, grain and visualizations.

56 questions in this bank

Comparisons to master

RequirementOption to evaluateWhy
PaaS relational database for an applicationAzure SQL DatabaseEngine and operating system management are delegated to the service.
SQL Server instance feature compatibility without VM administrationAzure SQL Managed InstancePaaS aimed at instance compatibility; check the specific features.
Operating system control and custom software installationSQL Server on Azure Virtual MachinesIaaS control with machine management responsibilities.
Images as objects / SMB share / NoSQL entitiesBlob / Files / TableThese are different access models; file size alone does not determine the choice.
Integrated analytics / Spark notebooks and lakehouseMicrosoft Fabric / Azure DatabricksCapabilities overlap; pay attention to explicit scenario requirements.

Study through practice and review

  1. Work through all four Microsoft Learn domains and summarize each concept using your own example.
  2. Start with 10- or 20-question practice sessions. Read the explanation and open the reference whenever unsure, even after a correct answer.
  3. Review errors by domain and then try a timed session. The simulator uses 45 minutes for practice; the real exam question count can vary.
  4. Use the ES / EN selector to practice terminology in both languages. Question identifiers and answer keys remain the same.

Interpreting your result: 70% is a local learning target. It is not equivalent to Microsoft’s scaled score of 700 and does not guarantee a pass. These are original, independent questions rather than official or leaked exam items.

Researched sources, forums and practice resources

This bank contains 200 questions in both languages, supported by 29 official sources. The research covers 20 resources and communities, including ExamTopics, ITExams and other practice banks. Each entry distinguishes what was accessible from what the provider advertises.

LarrúaTech questions use original wording. External banks and experiences help broaden scenarios and identify difficulties; answers are checked against official documentation. Paid content has not been purchased or imported.

Microsoft Learn · DP-900Official

Official objectives and domain weights. The reviewed English version publishes the 21 July 2026 objectives.

Microsoft Practice AssessmentOfficial

Free official self-assessment linked from Learn. The offering and link were verified; its interactive bank was not extracted.

ExamTopicsCommunity

Indexed bank excerpts and storage and SQL discussions were reviewed. Community corrections include official links and posts from different years. Direct bank access was blocked; a complete audit and authenticity as actual official exam items are not claimed.

ITExamsIndependent practice

The public page advertises 323 questions; several are image-based. Its own footer says it does not offer real Microsoft exam questions. The advertised count does not establish currency or correctness.

CertsHeroIndependent practice

The public page showed 319 questions and the search index another version with 341. One sample labels reporting over a dimensional model as OLTP: this is checked against analytics documentation rather than accepted automatically.

TheExamsLabIndependent practice

The indexed sample advertises 332 questions and identifies topics such as rehydration and visualizations. Some image-dependent items are incomplete in text; the entire bank was not validated.

WhizlabsIndependent practice

Public question and explanation samples. Some references and names are old; its paid bank was neither purchased nor audited.

MeasureUpIndependent practice

The reviewed product page advertises 118 questions and a 03/2024 update. Check alignment with the July 2026 scope before buying; the product page does not validate the bank's answers.

SkillCertProIndependent practice

The indexed page advertises 640 questions and 13 mocks, presented as coming from previous exams. These are commercial claims; authenticity and paid content were not verified.

ExampracticeIndependent practice

Open samples and pages with differing counts and dates were located. Some scenarios are too generic; the site's practice timer must not be confused with the official exam duration.

AzurePrepIndependent practice

The page advertises 288 questions and a 10-question preview. Its offering and comparison were reviewed without verifying every answer or treating its competitor comparisons as independent evidence.

ciply.ioIndependent practice

Advertises 131 original questions, four formats and official references. The page provides readable samples and claims July 2026 alignment; the complete paid bank was not accessed.

FirstTryIndependent practice

A 10-question sample with scenarios and explanations. Useful for comparing style and reasoning; its readiness claims do not replace the official objectives.

TechclickIndependent practice

The indexed sample advertises 120 original questions and its own 180-minute timer. Its practice certificate is not a Microsoft certification.

Pass HarborIndependent practice

Advertises 601 original questions and July 2026 alignment. The page and public samples were read; the advertised quantity does not mean 601 questions verified by LarrúaTech.

DataStudyGuidesIndependent practice

The catalog advertises 192 DP-900 questions, cards and Learn sources. Its methodology page describes assisted authoring and a second review; this is recorded as the site's claim rather than external certification.

Packt Publishing · GitHubRepository

Public repository with question bank, two tests and explanation PDFs. The material was located; PDFs were not imported and GitHub availability does not establish alignment with 2026.

Cloud2BR · DP-900StudyGuideRepository

Community guide with references and questions. The relational sample includes a problematic explanation about DELETE without WHERE; operations are therefore checked against SQL documentation and answers are not imported automatically.

ckoliveiraa · Curso DP-900Repository

Portuguese community course with modules, cards and an advertised 60-question mock. Recorded as a multilingual study resource rather than a technically audited bank.

Reddit · r/AzureCertificationCommunity

Experiences and questions about Fabric, Cosmos DB, resources and difficulty. Testimonials identify common difficulties; exam scope is determined by Learn rather than one person's recollection.

Always check the current official objectives. The review is documentation-based and dated as indicated; it does not imply Microsoft certification or automatic future maintenance.