DP-900 Azure Data Fundamentals Exam Preparation

Explore common data workloads: OLTP for day-to-day transactions, OLAP for analytical processing, and data warehouses for reporting.

Identify the database administrator's role in design, security, backups, and disaster recovery; the data engineer's data movement, cleaning, governance, and pipelines; and the data analyst's insight generation.

Explore core data concepts including structured, unstructured, and semi-structured data, storage options, common workloads like oltp and olap, and the roles of database administrators, data engineers, and data analysts.

Explore normalization and the first three normal forms, learning how primary keys and atomic columns reduce data redundancy in relational databases.

Watch a live demo of a sample database dp900demo, explore tables and constraints, and learn how SQL selects, filters, and updates data in Azure SQL Server.

Learn how indexes improve query speed by sorting data, using a primary key and a first name index, and weigh the trade-offs on inserts and updates.

Provision an Azure SQL database in the portal, choose server and database options, select a pricing model, configure access with firewall rules, and load sample data for testing.

Explore Azure resource manager ARM templates for automating SQL database deployments beyond portal. Download templates, script repeated deployments, and see resources, storage accounts, and dependencies, with Bicep as an abstraction.

Explore networking security with private links and firewall controls, identity security with Microsoft Entra, encryption with Azure Key Vault, and logging and auditing for SQL database.

Learn relational query tools for Azure data, including the Azure portal query editor, Azure Data Studio, SQL Server Management Studio, and the SQL command line utility.

Explore azure blob storage via containers, create and manage containers, upload diverse files, and switch access tiers from hot to cool to archive, with virtual folders and programmatic access.

Explore Azure Table storage as a non-relational, semi-structured data store with entities identified by partition key and row key, offering flexible properties and no foreign keys.

Explore non-relational data types, from JSON document storage and column family structures to key-value table APIs, graph databases, and time series data, plus blob storage and Azure search options.

Compare relational and non-relational databases in azure, and learn how to select cosmos db, data warehouse, and storage for IoT and analytics, guided by normalization and data integrity concepts.

Explore Azure Cosmos DB, which provides six APIs for non-relational data, stores JSON documents, supports provisioned and serverless throughput, multi-region writes, backups, and private networking with key management.

Explore how ARM templates automate Cosmos DB deployments using Azure Resource Manager. Download, export, or view templates, apply parameterized settings, and deploy from the portal, CLI, or REST APIs.

Cosmos DB can be moved from public internet to a private network using firewalls and allowlists. Access relies on primary, secondary, or read-only keys.

Consolidate data from OLTP sources into a data warehouse to support reporting and archiving. Enable scalable analytics with Azure Synapse Analytics for end-of-day and end-of-month reports using massively parallel processing.

Explore the modern data warehouse architecture, from diverse data sources and ingestion with Azure Data Factory to data lake, Azure Databricks, Synapse Analytics, Analysis Services, and Power BI.

Explore Microsoft Fabric, an all-in-one unification platform that integrates data tools like Power BI, Synapse, and Data Factory on OneLake, with built-in Purview protection and an AI assistant Co-Pilot.