OpenExam.
THE RESOURCE LIBRARY

Azure Data Fundamentals: Knowledge Library & Illustrated Guides

Find a lesson, explanation or study reference within this exam.

Search covers this exam’s lessons, illustrated guides and published study references.

Three original responsibility cards: SQL Database provides database-oriented PaaS; Managed Instance adds instance-scoped capabilities as PaaS; SQL Server on an Azure VM supplies guest OS control with additional management responsibility. ORIGINAL GUIDE
OpenExam original · 14 min read

Azure SQL Database vs Managed Instance: Start With the Required Control

Separate a database feature, an instance feature and a host requirement before choosing a service.

Read the illustrated guide
Original decision ledger separates representation,required read/write task and transaction boundary;none implies a universal product winner. ORIGINAL GUIDE
OpenExam original · 13 min read

Relational or Non-relational? Start With the Access Task

A document shape,an entity relationship and a transaction scope answer different questions.

Read the illustrated guide
Original pipeline distinguishes shared source capture from an ongoing processing/result path and a bounded reconciliation/report path. ORIGINAL GUIDE
OpenExam original · 13 min read

Batch or Streaming? Write the Output Deadline First

Separate when data arrives from when the required answer must exist.

Read the illustrated guide
Approved donation rows are filtered first, grouped into A=11, B=10 and C=0, then HAVING total greater than 10 retains A only. ORIGINAL GUIDE
OpenExam original · 12 min read

WHERE vs HAVING: Decide Which Data Belongs in the Total

Trace row eligibility, grouping and aggregate thresholds with a complete fictional dataset.

Read the illustrated guide

Original guides explain selected concepts using retained source references, new examples and original diagrams. They are teaching resources, not video transcripts or official exam papers.