DP-900 practice questionsMicrosoft certification practice
← Interview & exam prep
Microsoft certification practice

DP-900 practice questions

12 exam-style questions for DP-900 — Azure Data Fundamentals, each with the correct answer and why. Then take a timed practice test that also draws on the related skill banks.

12 questionsBeginner 6 · Intermediate 6Answers + explanations
Take it as a timed test
Free PDF
All 389 questions & answers, in one file

DAX, Excel, Power BI, Fabric, certification practice and analyst interviews — every answer with the reason behind it. Print it, study it offline.

Instant download, plus the free Tuesday briefing. Unsubscribe in one click.

Skills measured

  • Core data concepts
  • Relational data on Azure
  • Non-relational data on Azure
  • Analytics workloads
Official DP-900 exam page ↗

Beginner 6 questions

1Structured data is best described as…

  1. Audio files
  2. Free-form text only
  3. Data in a fixed schema of rows and columns (e.g., a relational table)
  4. Application logs
  5. Images and video
Show answerHide answer

C · Data in a fixed schema of rows and columns (e.g., a relational table) Structured data fits a predefined schema of rows/columns.

2A relational database organizes data into…

  1. A single flat file
  2. Folders of files
  3. Key-value pairs only
  4. Tables with rows, columns and defined relationships
  5. Graphs only
Show answerHide answer

D · Tables with rows, columns and defined relationships Relational databases use related tables with keys.

3OLTP systems are optimized for…

  1. Heavy analytical queries
  2. File archiving
  3. Streaming video
  4. Report caching
  5. Many small transactional reads and writes
Show answerHide answer

E · Many small transactional reads and writes OLTP handles high volumes of short transactions (inserts/updates).

4OLAP systems are optimized for…

  1. Object storage
  2. Complex analytical queries over large volumes of data
  3. Transaction processing
  4. Message queuing
  5. App hosting
Show answerHide answer

B · Complex analytical queries over large volumes of data OLAP serves aggregations and analysis over large datasets.

5Non-relational (NoSQL) data stores include…

  1. Only Excel sheets
  2. Key-value, document, column-family and graph stores
  3. Only images
  4. Only CSV files
  5. Only relational tables
Show answerHide answer

B · Key-value, document, column-family and graph stores NoSQL covers several models beyond the relational table.

6A data warehouse is primarily used for…

  1. Real-time chat
  2. Running a website
  3. Email delivery
  4. Storing app code
  5. Centralized analytical reporting over integrated data
Show answerHide answer

E · Centralized analytical reporting over integrated data Warehouses consolidate data for analytics and BI.

Intermediate 6 questions

7Azure SQL Database is…

  1. A dashboard tool
  2. A NoSQL graph store
  3. A file share
  4. A message bus
  5. A managed relational (PaaS) database service
Show answerHide answer

E · A managed relational (PaaS) database service It's a fully-managed relational database in Azure.

8Azure Blob Storage is best suited for…

  1. Real-time streaming only
  2. Storing large amounts of unstructured object data
  3. Hosting semantic models
  4. Running T-SQL joins
  5. Relational transactions
Show answerHide answer

B · Storing large amounts of unstructured object data Blob storage holds unstructured objects (files, images, backups) at scale.

9In analytics, ETL/ELT pipelines are used to…

  1. Move and transform data into an analytical store
  2. Send notifications
  3. Manage user logins
  4. Compress images
  5. Render visuals
Show answerHide answer

A · Move and transform data into an analytical store Pipelines ingest and shape data for the analytics layer.

10Azure Synapse and Microsoft Fabric provide…

  1. Email hosting
  2. Only spreadsheets
  3. VM management only
  4. A CRM
  5. Integrated analytics platforms (warehousing plus big data)
Show answerHide answer

E · Integrated analytics platforms (warehousing plus big data) They unify data warehousing and big-data analytics.

11A key benefit of a managed (PaaS) database is that…

  1. It can't scale
  2. The provider handles patching, backups and high availability
  3. You manage the hardware
  4. It only runs on-prem
  5. There is no security
Show answerHide answer

B · The provider handles patching, backups and high availability PaaS offloads infrastructure and maintenance to the cloud provider.

12Stream processing (vs batch) handles…

  1. Only relational tables
  2. Continuous, low-latency event data
  3. Only files
  4. Only historical data
  5. Large periodic chunks
Show answerHide answer

B · Continuous, low-latency event data Streaming processes events continuously with low latency.

What changed lately? Latest Microsoft Fabric news, releases & questions →

Coming soon $19 one-time · early-access price
Prep Pro: full mock exams
  • Full-length, timed mock exams in the real PL-300, DP-600 and MO-201 format
  • Score breakdown by skill, with a study plan for your weak spots
  • New questions every month, written against the current exam outline

No payment now. We'll email you once, when it opens.

More microsoft certification practice