1. Home
  2. Microsoft
  3. DP-900 Exam Syllabus

Microsoft DP-900 Exam Syllabus

Microsoft DP-900 Exam

Microsoft Azure Data Fundamentals

Total Questions: 292

What is Included in the Microsoft DP-900 Exam?

Authentic information about the syllabus and an effective study guide is essential to go through the Microsoft DP-900 exam in the first attempt. The study guide of Study4Exam provides you with comprehensive information about the syllabus of the Microsoft DP-900 exam. You should get this information at the start of your preparation because it helps you make an effective study plan. We have designed this Microsoft Azure Data Fundamentals certification exam preparation guide to give the exam overview, practice questions, practice test, prerequisites, and information about exam topics that help to go through the Microsoft Azure Data Fundamentals exam. We recommend you to the preparation material mentioned in this study guide to cover the entire Microsoft DP-900 syllabus. Study4Exam offers 3 formats of Microsoft DP-900 exam preparation material. Each format provides new practice questions in PDF format, web-based and desktop practice exams to get passing marks in the first attempt.

Microsoft DP-900 Exam Overview :

Exam Name Microsoft Azure Data Fundamentals
Exam Code DP-900
Actual Exam Duration 60 minutes
Expected no. of Questions in Actual Exam 60
Exam Registration Price $99
Official Information https://docs.microsoft.com/en-us/learn/certifications/exams/dp-900
See Expected Questions Microsoft DP-900 Expected Questions in Actual Exam
Take Self-Assessment Use Microsoft DP-900 Practice Test to Assess your preparation - Save Time and Reduce Chances of Failure

Microsoft DP-900 Exam Topics :

Section Weight Objectives
Describe data ingestion and processing on Azure 25-30% - 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 25-30% - describe the role of paginated reporting
- describe the role of interactive reports
- describe the role of dashboards
- describe the workflow in Power BI
Describe the components of a modern data warehouse 25-30% - 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 workload
Describe analytics workloads 25-30% - 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 needed
Identify basic management tasks for non-relational data 25-30% - 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 with Azure VNets, access from Internet, authentication, firewalls)
- identify management tools for non-relational data
Describe non-relational data workloads 25-30% - describe the characteristics of non-relational data
- describe the types of non-relational and NoSQL data
- recommend the correct data store
- determine when to use non-relational data
Describe non-relational data offerings on Azure 25-30% - identify Azure data services for non-relational workloads
- describe Azure Cosmos DB APIs
- describe Azure Table storage
- describe Azure Blob storage
- describe Azure File storage
Describe query techniques for data using SQL language 25-30% - 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 MySQL
Identify basic management tasks for relational data 25-30% - 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 with Azure VNets, access from Internet, authentication, firewalls)
- identify query tools (e.g., Azure Data Studio, SQL Server Management Studio, sqlcmd utility, etc.)
Describe relational Azure data services 15-20% - 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 MySQL
Describe relational data workloads 25-30% - identify the right data offering for a relational workload
- describe relational data structures (e.g., tables, index, views)
Describe types of core data workloads 15-20% - describe batch data
- describe streaming data
- describe the difference between batch and streaming data
- describe the characteristics of relational data
Describe data analytics core concepts 15-20% - 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 processing

Updates in the Microsoft DP-900 Exam Syllabus:

Microsoft DP-900 exam questions and practice test are the best ways to get fully prepared. Study4exam's trusted preparation material consists of both practice questions and practice test. To pass the actual Azure Data Fundamentals DP-900 exam on the first attempt, you need to put in hard work on these Microsoft DP-900 questions that provide updated information about the entire exam syllabus. Besides studying actual questions, you should take the Microsoft DP-900 practice test for self-assessment and actual exam simulation. Revise actual exam questions and remove your mistakes with the Microsoft Azure Data Fundamentals DP-900 exam practice test. Online and windows-based formats of the DP-900 exam practice test are available for self-assessment.