🔒 Guided

Pre-launch preview. Authorised access only.

Incorrect code

Guided by A Guide to Cloud
Explore AB-900 AI-901
Guided DP-900 Domain 3
Domain 3 — Module 2 of 5 40%
16 of 27 overall

DP-900 Study Guide

Domain 1: Core Data Concepts

  • Your First Look at Data Free
  • Data File Formats: CSV, JSON, Parquet & More Free
  • Databases: Relational vs Non-Relational Free
  • Transactional Workloads: Keeping Data Consistent Free
  • Analytical Workloads: Finding the Insights Free
  • Data Roles: DBA, Engineer & Analyst Free
  • The Azure Data Landscape Free

Domain 2: Relational Data on Azure

  • Relational Data: Tables, Keys & Relationships
  • Normalization: Why Duplicate Data is Bad
  • SQL Basics: SELECT, INSERT, UPDATE, DELETE
  • Database Objects: Views, Indexes & More
  • Azure SQL: Your Database in the Cloud
  • Open-Source Databases on Azure
  • Choosing the Right Azure Database

Domain 3: Non-Relational Data on Azure

  • Azure Blob Storage: Files in the Cloud
  • Azure Files & Table Storage
  • Azure Cosmos DB: The Global Database
  • Cosmos DB APIs: SQL, MongoDB & More
  • Choosing Non-Relational Storage

Domain 4: Analytics on Azure

  • Data Ingestion & Processing
  • Analytical Data Stores: Data Lakes, Warehouses & Lakehouses
  • Microsoft Fabric & Azure Databricks
  • Batch vs Streaming: Two Speeds of Data
  • Real-Time Analytics on Azure
  • Power BI: See Your Data
  • Data Models in Power BI
  • Choosing the Right Visualization

DP-900 Study Guide

Domain 1: Core Data Concepts

  • Your First Look at Data Free
  • Data File Formats: CSV, JSON, Parquet & More Free
  • Databases: Relational vs Non-Relational Free
  • Transactional Workloads: Keeping Data Consistent Free
  • Analytical Workloads: Finding the Insights Free
  • Data Roles: DBA, Engineer & Analyst Free
  • The Azure Data Landscape Free

Domain 2: Relational Data on Azure

  • Relational Data: Tables, Keys & Relationships
  • Normalization: Why Duplicate Data is Bad
  • SQL Basics: SELECT, INSERT, UPDATE, DELETE
  • Database Objects: Views, Indexes & More
  • Azure SQL: Your Database in the Cloud
  • Open-Source Databases on Azure
  • Choosing the Right Azure Database

Domain 3: Non-Relational Data on Azure

  • Azure Blob Storage: Files in the Cloud
  • Azure Files & Table Storage
  • Azure Cosmos DB: The Global Database
  • Cosmos DB APIs: SQL, MongoDB & More
  • Choosing Non-Relational Storage

Domain 4: Analytics on Azure

  • Data Ingestion & Processing
  • Analytical Data Stores: Data Lakes, Warehouses & Lakehouses
  • Microsoft Fabric & Azure Databricks
  • Batch vs Streaming: Two Speeds of Data
  • Real-Time Analytics on Azure
  • Power BI: See Your Data
  • Data Models in Power BI
  • Choosing the Right Visualization
Domain 3: Non-Relational Data on Azure Premium ⏱ ~10 min read

Azure Files & Table Storage

Azure Files replaces your traditional file server. Azure Table Storage gives you a simple key-value store. Both live inside a storage account alongside Blob Storage.

Two more storage services

☕ Simple explanation

Azure Files is a shared network drive in the cloud. Azure Table Storage is a giant lookup table.

Think of Azure Files as the shared drive your team maps to their computers — everyone can read and write files. Azure Table Storage is more like a phone book — you look up a name (key) and get back their details (value). Both live in the same Azure storage account as Blob Storage.

Azure Files provides fully managed file shares accessible via SMB (Server Message Block) and NFS (Network File System) protocols — drop-in replacements for on-premises file servers. Azure Table Storage is a NoSQL key-value store for semi-structured data that doesn’t require complex queries or relationships. Both services exist within an Azure Storage account alongside Blob Storage.

Azure Files

Azure Files provides managed file shares that can be mounted on Windows, macOS, and Linux — just like mapping a network drive.

Tom’s scenario: Pacific Freight has an on-premises file server where drivers upload delivery photos and dispatchers access route documents. Azure Files replaces it:

  • Drivers upload photos from their tablets via SMB
  • Dispatchers access the same files from their desktops
  • The file share is backed up automatically
  • No physical server to maintain

Key features:

FeatureDescription
ProtocolsSMB 3.0 (Windows, macOS, Linux) and NFS (Linux)
MountingMap as a network drive on any OS
IdentitySupports Entra ID (Azure AD) authentication
TiersPremium (SSD), Transaction optimised, Hot, Cool
BackupAzure Backup integration for snapshot-based recovery
SyncAzure File Sync caches files on local servers for hybrid scenarios

When to use Azure Files:

  • Replace on-premises file servers
  • Share configuration files across multiple VMs
  • Lift-and-shift applications that expect file system access (SMB)
  • Shared storage for containerised applications

Azure Table Storage

Azure Table Storage is a simple NoSQL key-value store for semi-structured data. Each row (entity) has a partition key, row key, and a set of properties that can vary between entities.

Aisha’s example: Her food app stores device settings for each user:

PartitionKeyRowKeyThemeNotificationsLastOrder
auckland-uniaisha-001darktrue2026-04-20
auckland-uniliam-002lightfalse—

Different entities can have different properties — Liam doesn’t have a LastOrder value. The combination of PartitionKey + RowKey uniquely identifies each entity.

Key features:

FeatureDescription
Data modelKey-value with flexible properties per entity
AccessOData protocol and REST API
SchemaSchemaless — each entity can have different properties
ScalePetabytes of data, billions of entities
CostVery low — fraction of a cent per GB per month

When to use Table Storage:

  • Device or user configuration data
  • Simple metadata lookups (not complex queries)
  • High-volume, low-complexity data (IoT device registry)
Azure Files vs Table Storage vs Blob Storage
FeatureAzure FilesAzure Table StorageAzure Blob Storage
What it storesFiles in a shared folderKey-value entities (NoSQL)Any file (objects/blobs)
Access methodSMB/NFS mountREST API, ODataREST API, SDKs, URLs
Best forReplacing file servers, shared drivesSimple lookups, device configMassive unstructured data, data lakes
SchemaFile system (folders, files)Flexible (key + properties)None (binary objects)
Query capabilityBrowse folders, file namesFilter by partition/row keyMetadata only (not content)
ℹ️ Table Storage vs Cosmos DB Table API

Azure Table Storage and Azure Cosmos DB both offer a Table API. The key differences:

  • Table Storage: Simple, very cheap, limited query capabilities, single-region
  • Cosmos DB Table API: More features (global distribution, guaranteed latency, automatic indexing), higher cost

If your app starts with Table Storage and needs more capabilities later, you can migrate to Cosmos DB Table API with minimal code changes.

💡 Exam tip: picking the right storage service

The exam gives you storage scenarios. Quick decision guide:

  • “Applications need to mount a shared drive” → Azure Files
  • “Simple key-value lookups for configuration” → Azure Table Storage
  • “Store images, videos, or large binary files” → Azure Blob Storage
  • “Replace an on-premises file server” → Azure Files
  • “IoT device registry with flexible properties” → Azure Table Storage

Flashcards

Question

What is Azure Files?

Click or press Enter to reveal answer

Answer

A fully managed file share service accessible via SMB and NFS protocols. It replaces on-premises file servers — mount it as a network drive on Windows, macOS, or Linux.

Click to flip back

Question

What is Azure Table Storage?

Click or press Enter to reveal answer

Answer

A NoSQL key-value store for semi-structured data. Each entity has a PartitionKey, RowKey, and flexible properties. Cheap, simple, and scalable — best for configuration data and simple lookups.

Click to flip back

Question

How do Azure Blob Storage, Azure Files, and Azure Table Storage differ?

Click or press Enter to reveal answer

Answer

Blob Storage: massive object storage for any file. Azure Files: managed file shares (mount as a drive). Table Storage: NoSQL key-value store for simple structured lookups. All three live in the same storage account.

Click to flip back

Knowledge check

Knowledge Check

Pacific Freight needs drivers to upload delivery photos from tablets and dispatchers to access the same files from desktop computers. The current on-premises file server is being retired. Which Azure service replaces it?

Knowledge Check

Aisha's app needs to store per-user settings (theme preference, notification toggle, language). Each user may have different settings. Reads are simple lookups by user ID. Which service is MOST cost-effective?

🎬 Video coming soon

Next up: Azure Cosmos DB: The Global Database — the multi-model, globally distributed NoSQL database.

← Previous

Azure Blob Storage: Files in the Cloud

Next →

Azure Cosmos DB: The Global Database

Guided

I learn, I simplify, I share.

A Guide to Cloud YouTube Feedback

© 2026 Sutheesh. All rights reserved.

Guided is an independent study resource and is not affiliated with, endorsed by, or officially connected to Microsoft. Microsoft, Azure, and related trademarks are property of Microsoft Corporation. Always verify information against Microsoft Learn.