PDF Version DemoMicrosoft DP-900: Microsoft Azure Data Fundamentals Exam Certified Professional salary
The average salary of a Microsoft DP-900: Microsoft Azure Data Fundamentals Exam Certified Expert in
- India - 12,10,327 INR
- United States - 80,000 USD
- England - 60,532 POUNDS
- Europe - 60,547 EURO
Microsoft DP-900 Exam Overview:
| Certification Vendor: | Microsoft |
|---|---|
| Exam Name: | Microsoft Azure Data Fundamentals |
| Exam Number: | DP-900 |
| Real Exam Qty: | 40-60 |
| Certificate Validity Period: | N/A |
| Exam Format: | Multiple-choice, Scenario-based |
| Exam Price: | USD 99 |
| Exam Duration: | 65 minutes |
| Related Certifications: | Microsoft Certified: Azure Data Fundamentals |
| Passing Score: | 700 / 1000 |
| Available Languages: | Indonesian (Indonesia), German, Korean, Chinese (Simplified), Italian, Portuguese (Brazil), English, Spanish, French, Chinese (Traditional), Russian, Arabic (Saudi Arabia), Japanese |
| Sample Questions: | Microsoft DP-900 Sample Questions |
| Exam Way: | Pearson VUE |
| Pre Condition: | There are no prerequisites for this exam. |
| Official Syllabus URL: | https://learn.microsoft.com/en-us/credentials/certifications/resources/study-guides/dp-900 |
What Are the Exam Topics?
Core data concepts
This topic majorly addresses the following skills:
- Various data workloads – this involves an overview of the features of relational data as well as the description, similarities and differences between streaming data and batch data as well as.
- Main concepts of data analytics – data visualization, business intelligence (BI), analytics techniques (diagnostic, predictive, descriptive, cognitive, prescriptive) and basic chart types such as pie charts and bar charts are the main concepts addressed in this category. Also, data processing techniques are covered along with ETL processing.
Microsoft DP-900 Exam Syllabus Topics:
| 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 data |
| Describe 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 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 - 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 MySQL |
| Identify 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 with 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 MySQL |
Describe 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 and NoSQL data - recommend the correct data store - determine when to use non-relational data |
| Describe 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 storage |
| Identify 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 with Azure VNets, access from Internet, authentication, firewalls) - identify management tools for non-relational data |
Describe 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 needed |
| 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 - describe modern data warehousing architecture and workload |
| Describe 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 |
What requirements should you fulfill before taking the Microsoft DP-900 exam?
The candidates for this certification exam are those individuals who want to validate their foundational-level experience in working with data within Cloud. They should possess the basic knowledge and skills in the domain of core data concepts. They also need to have an understanding of how these are implemented with the use of Microsoft Azure data services.
The applicants do not have to fulfill any requirements to take the Microsoft DP-900 test or get the associated certification. However, they must be familiar with different concepts of non-relational and relational data. They should also know various types of data workloads that are available, including analytical and transactional. Additionally, the students must develop mastery of the exam topics before sitting for this test.
Reference: https://docs.microsoft.com/en-us/learn/certifications/exams/dp-900
We are confident about the products and aim to help you pass with ease. In case of failure, we will provide a no hassle full money back guarantee for the purchasing fee.
985 Customer Reviews
Quality and ValueITbraindumps Practice Exams are written to the highest standards of technical accuracy, using only certified subject matter experts and published authors for development - no all study materials.
Tested and ApprovedWe are committed to the process of vendor and third party approvals. We believe professionals and executives alike deserve the confidence of quality coverage these authorizations provide.
Easy to PassIf you prepare for the exams using our ITbraindumps testing engine, It is easy to succeed for all certifications in the first attempt. You don't have to deal with all dumps or any free torrent / rapidshare all stuff.
Try Before BuyITbraindumps offers free demo of each product. You can check out the interface, question quality and usability of our practice exams before you decide to buy.