Microsoft DP-900 Exam Syllabus
Topic Details Describe core data concepts (15-20%)
Describe types of core data workloads - describe batch data
- describe streaming data
- describe the difference between batch and streaming data
- describe the characteristics of relational dataDescribe data analytics core concepts - describe data visualization (e.g., visualization, reporting, business intelligence (BI))
- describe basic chart types such as bar charts and pie charts
- describe analytics techniques (e.g., descriptive, diagnostic, predictive, prescriptive, cognitive)
- describe ELT and ETL processing
- describe the concepts of data processingDescribe how to work with relational data on Azure (25-30%)
Describe relational data workloads - identify the right data offering for a relational workload
- describe relational data structures (e.g., tables, index, views)Describe relational Azure data services - describe and compare PaaS, IaaS, and SaaS solutions
- describe Azure SQL family of products including Azure SQL Database, Azure SQL Managed Instance, and SQL Server on Azure Virtual Machines
- describe Azure Synapse Analytics
- describe Azure Database for PostgreSQL, Azure Database for MariaDB, and Azure Database for MySQLIdentify basic management tasks for relational data - describe provisioning and deployment of relational data services
- describe method for deployment including the Azure portal, Azure Resource Manager templates, Azure PowerShell, and the Azure command-line interface (CLI)
- identify data security components (e.g., firewall, authentication)
- identify basic connectivity issues (e.g., accessing from on-premises, access from Azure VNets, access from Internet, authentication, firewalls)
- identify query tools (e.g., Azure Data Studio, SQL Server Management Studio, sqlcmd utility, etc.)Describe query techniques for data using SQL language - compare Data Definition Language (DDL) versus Data Manipulation Language (DML)
- query relational data in Azure SQL Database, Azure Database for PostgreSQL, and Azure Database for MySQLDescribe how to work with non-relational data on Azure (25-30%)
Describe non-relational data workloads - describe the characteristics of non-relational data
- describe the types of non-relational data
- recommend the correct data store
- determine when to use non-relational dataDescribe non-relational data offerings on Azure - identify Azure data services for non-relational workloads
- describe Azure Cosmos DB APIs
- describe Azure Table storage
- describe Azure Blob storage
- describe Azure File storageIdentify basic management tasks for non-relational data -describe provisioning and deployment of non-relational data services
- describe method for deployment including the Azure portal, Azure Resource Manager templates, Azure PowerShell, and the Azure command-line interface (CLI)
- identify data security components (e.g., firewall, authentication, encryption)
- identify basic connectivity issues (e.g., accessing from on-premises, access from Azure VNets, access from Internet, authentication, firewalls)
- identify management tools for non-relational dataDescribe an analytics workload on Azure (25-30%)
Describe analytics workloads - describe transactional workloads
- describe the difference between a transactional and an analytics workload
- describe the difference between batch and real time
- describe data warehousing workloads
- determine when a data warehouse solution is neededDescribe the components of a modern data warehouse - describe Azure data services for modern data warehousing such as Azure Data Lake Storage Gen2, Azure Synapse Analytics, Azure Databricks, and Azure HDInsight
- describe modern data warehousing architecture and workloadDescribe data ingestion and processing on Azure - describe common practices for data loading
- describe the components of Azure Data Factory (e.g., pipeline, activities, etc.)
- describe data processing options (e.g., Azure HDInsight, Azure Databricks, Azure Synapse Analytics, Azure Data Factory)Describe data visualization in Microsoft Power BI - describe the role of paginated reporting
- describe the role of interactive reports
- describe the role of dashboards
- describe the workflow in Power BI