DP-900 Exam Study Guide (Microsoft Azure Data Fundamentals)
You can access DP-900 Exam Microsoft official page here
Preparing for the DP-900 Microsoft Azure Data Fundamentals Certificate exam? Don’t know where to start? This post is the DP-900 Certificate Study Guide (with links to each exam objective).
I have curated a list of articles from Microsoft documentation for each objective of the DP-900 exam. I hope this article will help you to achieve the DP-900 Microsoft Certified Azure Data Fundamentals Certification. Also, please share the post within your circles so it helps them to prepare for the exam.
Skills Measured
- Describe Core Data Concepts (15-20%)
- Describe How to Work with Relational Data on Azure (25-30%)
- Describe How to Work with Non-relational Data on Azure (25-30%)
- Describe an Analytics Workload on Azure (25-30%)
DP-900 Exam Free Study Guide
For each test objective, I’ve compiled a thorough collection of articles from Microsoft documentation. Please feel free to forward this page to your friends and coworkers in order to assist them in preparing for the test .
Describe Core Data Concepts (15-20%)
Describe Types of Core Data Workloads
- Describe batch data
- Batch vs. Real time data processing
- Describe streaming data
- Streaming data
- Describe the difference between batch and streaming data
- Difference between Batch & Streaming processing
- Describe the characteristics of relational data
- Properties of RDBMSs and NoSQL databases
Describe Data Analytics Core Concepts
- Describe data visualization (e.g., visualization, reporting, business intelligence)
- Data visualization beginner’s guide
- Business reporting or enterprise reporting
- Business intelligence: Transforming data into business insights
- Describe basic chart types such as bar charts and pie charts
- Bar Graph: graphical display of data
- A complete guide to Pie Charts
- Describe analytics techniques (e.g., descriptive, diagnostic, predictive, prescriptive, cognitive)
- Comparing Descriptive, Predictive, Prescriptive & Diagnostic Analytics
- What is cognitive analytics?
- Describe ELT and ETL processing
- ETL and ELT processing
- Describe the concepts of data processing
- What is Data Processing?
Describe How to Work with Relational Data on Azure (25-30%)
Describe Relational Data Workloads
- Identify the right data offering for a relational workload
- Databases
- Describe relational data structures (e.g., tables, index, views)
- Properties of Relational Tables
- Fully managed, intelligent & flexible cloud database services
- SQL: Views
Describe Relational Azure Data Services
- Describe and compare PaaS, IaaS, and SaaS solutions
- Types of cloud services
- Describe Azure SQL family of products including Azure SQL Database, Azure SQL Managed Instance, and SQL Server on Azure Virtual Machines
- What is Azure SQL Database?
- What is Azure SQL Managed Instance?
- What is SQL Server on Azure Virtual Machines?
- Describe Azure Synapse Analytics
- What is Azure Synapse Analytics?
- Describe Azure Database for PostgreSQL, Azure Database for MariaDB, and Azure
Database for MySQL - What is Azure Database for PostgreSQL?
- What is Azure Database for MariaDB?
- What is Azure Database for MySQL?
Identify Basic Management Tasks for Relational Data
- Describe provisioning and deployment of relational data services
- Provision an Azure SQL database to store application data
- Describe the method for deployment including the Azure portal, Azure Resource Manager templates, Azure PowerShell, and the Azure command-line interface (CLI)
- Creating a single database in Azure SQL Database using an ARM template
- Create an Azure SQL Database single database
- Use PowerShell to create a database & configure a firewall rule
- Use Azure CLI to create a database & configure a firewall rule
- Identify data security components (e.g., firewall, authentication)
- Azure SQL Database firewall
- Azure Azure AD authentication
- Information protection and encryption
- Identify basic connectivity issues (e.g., accessing from on-premises, access with Azure VNets, access from Internet, authentication, firewalls)
- Troubleshooting connectivity issues & other errors
- Azure SQL DB Connectivity Troubleshooting
- Troubleshoot connection issues to Azure SQL Database
- Identify query tools (e.g., Azure Data Studio, SQL Server Management Studio, sqlcmd utility, etc.)
- What is Azure Data Studio?
- Connect to & query a SQL Server instance by using SSMS
- sqlcmd – Use the utility
Describe Query Techniques for Data Using SQL Language
- Compare Data Definition Language (DDL) versus Data Manipulation Language (DML)
- Difference between DDL and DML in DBMS
- Query relational data in Azure SQL Database, Azure Database for PostgreSQL, and Azure Database for MySQL
- Use Azure Data Studio to connect & query PostgreSQL
- Use MySQL Workbench to connect & query data in Azure Database for MySQL
- Azure portal’s query editor to query an Azure SQL Database
Describe How to Work with Non-relational Data on Azure (25-30%)
Describe Non-relational Data Workloads
- Describe the characteristics of non-relational data
- Properties of NoSQL databases
- Describe the types of non-relational and NoSQL data
- Non-relational data and NoSQL
- Recommend the correct datastore
- Non-relational data: Typical requirements
- Determine when to use non-relational data
- Relational vs. Non-relational databases
Describe Non-relational Data Offerings on Azure
- Identify Azure data services for non-relational workloads
- What are NoSQL databases?
- Describe Azure Cosmos DB APIs
- Identify the technology options
- Describe Azure Table storage
- What is Azure Table storage?
- Describe Azure Blob storage
- What is Azure Blob storage?
- Describe Azure File storage
- What are the Azure Files?
Identify Basic Management Tasks for Non-relational Data
- Describe provisioning and deployment of non-relational data services
- Azure Cosmos account, database, container & items from the Azure portal
- Create Apache HBase cluster in Azure HDInsight using ARM template
- Describe the method for deployment including the Azure portal, Azure Resource Manager templates, Azure PowerShell, and the Azure command-line interface (CLI)
- Azure Cosmos account, database from the Azure portal
- Create an Azure Cosmos DB by using an ARM template
- Create an Azure Cosmos DB database with PowerShell
- Create an Azure Cosmos account, database using Azure CLI
- Identify data security components (e.g., firewall, authentication, encryption)
- Configure IP firewall in Azure Cosmos DB
- Security in Azure Cosmos DB: Overview
- Secure access to data in Azure Cosmos DB
- Data encryption in Azure Cosmos DB
- Identify basic connectivity issues (e.g., accessing from on-premises, access with Azure VNets, access from Internet, authentication, firewalls)
- Diagnose & troubleshoot issues when using Azure Cosmos DB .NET SDK
- Troubleshoot issues with an IP access control policy
- Authorization fails for CosmosDB created over portal #662
- Identify management tools for non-relational data
- Work with data using Azure Cosmos explorer
Describe an Analytics Workload on Azure (25-30%)
Describe Analytics Workloads
- Describe transactional workloads
- Online transaction processing (OLTP)
- Describe the difference between a transactional and an analytics workload
- Transactional vs. Analytical: How does OLTP differ from OLAP?
- Describe the difference between batch and real time
- Batch vs. Real time data processing
- Describe data warehousing workloads
- Data warehouse workloads and use cases
- Determine when a data warehouse solution is needed
- Why You Need a Data Warehouse?
Describe 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
- Introduction to Azure Data Lake Storage Gen2
- What is Azure Synapse Analytics?
- What is Azure Databricks?
- What is Azure HDInsight?
- Describe modern data warehousing architecture and workload
- Modern data warehouse architecture
Describe Data Ingestion and Processing on Azure
- Describe common practices for data loading
- Data loading strategies for Synapse SQL pool
- Describe the components of Azure Data Factory (e.g., pipeline, activities, etc.)
- Pipelines and activities in Azure Data Factory
- Describe data processing options (e.g., Azure HDInsight, Azure Databricks, Azure Synapse Analytics, Azure Data Factory)
- What is Azure HDInsight?
- What is Azure Databricks?
- What is Azure Synapse Analytics?
- What is Azure Data Factory?
Describe Data Visualization in Microsoft Power BI
- Describe the role of paginated reporting
- What are paginated reports in Power BI Premium?
- Describe the role of interactive reports
- Go from data to insight to action with Power BI Desktop
- Describe the role of dashboards
- Dashboards for business users of the Power BI service
- Describe the workflow in Power BI
- Power BI Workflow
This brings us to the end of the DP-900 Microsoft Azure Data Fundamentals Study Guide.
Follow Me to Receive Updates on DP-900 Exam
Share the DP-900 Study Guide in Your Network
Share on facebook
Share on twitter
Share on linkedin
