Microsoft - DP-900 Certification Exam Details, Questions and Answers

Certification Provider

Microsoft

Exam

DP-900: Microsoft Azure Data Fundamentals

Number of questions (in our database)

233

Updated on

13 April 2024

Browse 233 Questions

Topics

Describe how to work with relational data on Azure Describe core data concepts in Azure Working with Data on Azure Core Data Concepts Introduction to Data Concepts Azure Data Services and Analytics Solutions Security, Privacy, Compliance, and Trust Describe how to work with non-relational data on Azure Describe an analytics workload on Azure

DP-900: Microsoft Azure Data Fundamentals Certification Exam Details

Introduction to DP-900: Microsoft Azure Data Fundamentals

The DP-900: Microsoft Azure Data Fundamentals is a foundational level examination offered by Microsoft. This certification is designed to validate your foundational knowledge of core data services and concepts in Microsoft Azure.

Importance of DP-900: Microsoft Azure Data Fundamentals Certification

Obtaining the DP-900 certification is an excellent way to begin your journey into a data-focused role. It lays the groundwork for other Azure role-based certifications and gives a broad overview of Azure data services.

Technical Details of the Exam

The exam covers various areas of Microsoft Azure fundamentals. It includes theoretical concepts as well as practical applications of Azure data services, requiring candidates to have a basic understanding of data-related implementation tasks.

Measured Skills in the Exam

Understanding core data concepts
Understanding how to work with relational data on Azure
Understanding how to work with non-relational data on Azure
Understanding an analytics workload on Azure

Preparation Advices for DP-900 Certification

Microsoft provides comprehensive learning paths for the DP-900 exam. It's recommended to start with the Microsoft Learn modules and then practice with hands-on labs. You can also consider instructor-led training.

Lastly, always review the exam skills outline to ensure you are studying all required topics.

Exam Topics

Describe how to work with relational data on Azure (20% - 30%)
- Describe relational Azure data services
- Describe relational data offerings in Azure
- Describe provisioning and deploying relational database offerings in Azure
- Describe Azure Synapse Analytics
- Describe Azure Databricks
Describe core data concepts in Azure (15% - 25%)
- Identify core data workloads
- Describe relational data workloads
- Describe non-relational data workloads
- Describe analytics workloads
Working with Data on Azure (25% - 35%)
- Data querying and manipulation with Azure SQL Database
- Building NoSQL solutions with Azure Cosmos DB
- Data exploration with Azure Synapse Analytics
- Data integration and orchestration with Azure Data Factory
- Introduction to Azure Databricks
- Data visualization and reporting with Power BI
Core Data Concepts (20% - 30%)
- Data storage options in Azure
- Understanding Azure Data Lake Storage
- Introduction to Azure SQL Database
- Exploring Azure Cosmos DB
- Overview of Azure Synapse Analytics
- Introduction to Azure Data Factory
Introduction to Data Concepts (15% - 25%)
- Understanding data types
- Exploring structured and unstructured data
- Introduction to relational and non-relational databases
- Data ingestion and processing
Azure Data Services and Analytics Solutions (15% - 25%)
- Azure HDInsight for big data processing
- Azure Machine Learning for advanced analytics
- Azure Cognitive Services for AI-powered solutions
- Azure Stream Analytics for real-time data processing
- Azure Data Lake Analytics for big data analytics
Security, Privacy, Compliance, and Trust (10% - 20%)
- Understanding data security in Azure
- Implementing data privacy and compliance in Azure
- Data governance and data sovereignty
- Monitoring and auditing data on Azure
Describe how to work with non-relational data on Azure (15% - 25%)
- Describe non-relational data offerings in Azure
- Describe provisioning and deploying non-relational data offerings on Azure
- Describe Azure Cosmos DB
- Describe Azure HDInsight
Describe an analytics workload on Azure (10% - 20%)
- Describe analytics workloads in Azure
- Describe Azure Synapse Analytics
- Describe Azure Databricks
- Describe Azure HDInsight