Introduction to Microsoft DP-900: Microsoft Azure Data Fundamentals Exam
Microsoft Azure Data Fundamentals is an exam that identifies individuals who have the knowledge to work with Azure data storage features. Building on previous core principles of data management, Azure Data Fundamentals exam is designed to evaluate the ability of the candidate. Money designed to assess the skills level for both professionals and students. Determine the type of skills required for a particular situation, for example, a cloud administrator or a data analyst. Gen candidate will have to know the fundamentals of Data Management to work with Azure data storage, create tools to manage data, locate, protect and process it. Relevant topics in a data management environment, a certified candidate should understand. Dml, Db, protection tools through recovery, recovery strategies, documentation data management policies, data loss prevention tools to backup and recovery for backup recovery.
Reference: https://docs.microsoft.com/en-us/learn/certifications/exams/dp-900
Explain the Techniques Involved in Working with Relational Data on Microsoft Azure: 25-30%
- Explain the Query Methods for Data with the SQL Language: The learners should be capable of comparing the Data Manipulation Language with the Data Definition Language. They should also be able to query relational data within Azure Database for MySQL, Azure SQL Database, and Azure Database for PostgreSQL.
- Explain the Concepts of Relational Data Workloads: The examinees should be able to explain the structures of relational data and identify the appropriate data for relational workloads.
- Explain Relational Azure Data Services: The individuals should have the ability to explain and compare SaaS, PaaS, and IaaS solutions as well as Azure Synapse Analytics. They also need the knowledge of Azure SQL database services, Azure Database for PostgreSQL, Azure Database for MySQL, and Azure Database for MariaDB.
- Identify the Fundamental Management Tasks for Relational Data: The applicants should be able to explain the deployment and provisioning of relational data services. They also need to understand the techniques for deployment, such as Azure Resource Manager templates, Azure portal, Azure CLI, and Azure PowerShell. In addition, the students should be able to identify the fundamental connectivity issues and components of data security.
Helpful Books to Ace DP-900
By and large, candidates can incorporate the listed study guides from Amazon as they prepare for DP-900 so they have a better chance of passing the official test:
- ‘DP-900: Microsoft Azure Data Fundamentals: 110+ Exam Practice Questions with Detail Explanation and Reference Link’ by Analytiq Tech and Daniel Scott — this kindle guide contains more than 110 original and challenging sample questions for DP-900. What’s more is that each question is accompanied by detailed answers, which help students grasp why an answer is correct or incorrect, hence they can improve faster. In all, there are two entire mock tests in this e-book and the question type, time limit, structure, and passing score of those mock tests will exactly replicate that of DP-900, meaning students will receive the perfect practice. Taking mock tests such as these helps students assess their performance and identify the topics they are weak in. The question bank of this book is being constantly updated and improved using students’ feedback, and new items are added to the stock on a regular basis. The book even has an active Q&A forum online, where past and future candidates discuss the exam topics of DP-900 and share their test-taking experiences, all of which should facilitate further learning for potential candidates.
- ‘Exam Ref DP-900 Microsoft Azure Data Fundamentals’ by Daniel Seara & Francesco Milano — this is the official paperback provided by Microsoft for DP-900 test. Both the authors of this book are experienced IT veterans who have spent decades working with countless technologies. The target audience for this book is IT professionals, functional consultants, and business users. Simply put, it focuses on the main concepts and skills one would need in order to provide data solutions using Microsoft Azure data services out in the real world. Plus, such material promotes critical thinking in learners so they will be able to make better decisions on the job. More so, this book comprehensively covers each and every topic that candidates need to know for their DP-900 tests. This official paperback is also packed with ‘what if’ questions to further challenge the learners and teach them how to solve real-world IT problems. To easily blaze through the pages of this revision guide, candidates must be familiar with working with cloud-related data, Microsoft Azure data services, and know all the basic data concepts.
- ‘DP-900: Microsoft Azure Data Fundamentals 2020 Practice Exam (Solved Practice Test 120+)’ by Eaze Teach — Eaze Teach is one of the largest online IT content providers in the world and they have study guides & mock tests for technical exams of numerous IT vendors such as Linux, Cisco, and Microsoft. Plus, Eaze Teach even provides training courses to IT workers to succeed in their job positions. This almost 150-page paperback from such a provider is loaded with practice tests consisting of 120+ original and challenging questions for the Microsoft exam DP-900. These practice tests are meant to exactly replicate the actual DP-900 test, hence the structure, question types, time limit, and passing score are the same as DP-900. Significantly, each question in this book has been created in accordance with the official exam syllabus issued by Microsoft for DP-900, meaning they’ll cover all the necessary topics. Taking the mock tests in this book is a great way to assess where the candidate currently stands in terms of exam preparation and advance accordingly. Furthermore, these mocks will also help candidates identify gaps in their knowledge.
Microsoft DP-900 Korean Exam Syllabus Topics:
| Section | Weight | Objectives |
| Topic 1: Identify considerations for relational data on Azure | 20-25% | - Describe relational concepts
- 1. Identify features of relational data
- 2. Describe normalization
- Describe relational Azure data services
- 1. Describe Azure SQL Managed Instance
- 2. Describe Azure Database for MySQL
- 3. Describe Azure SQL Database
- 4. Describe Azure Database for PostgreSQL
- 5. Describe Azure Database for MariaDB
- 6. Describe Azure SQL family of products
- 7. Describe SQL Server on Azure Virtual Machines
|
| Topic 2: Describe considerations for working with non-relational data on Azure | 15-20% | - Describe non-relational Azure data services
- 1. Describe Azure Cosmos DB
- 2. Describe Azure File storage
- 3. Describe Azure Table storage
- 4. Describe Azure Blob storage
- Describe non-relational concepts
- 1. Describe non-relational data offerings
- 2. Identify non-relational data
|
| Topic 3: Describe an analytics workload on Azure | 25-30% | - Describe analytics concepts
- 1. Describe analytical workloads
- 2. Describe ETL and ELT processes
- 3. Describe data warehousing
- 4. Describe transactional workloads
- Describe data visualization in Microsoft Power BI
- 1. Describe Power BI
- 2. Describe Power BI reports and dashboards
- 3. Describe Power BI tools and workflow
- Describe Azure data analytics services
- 1. Describe Microsoft Fabric
- 2. Describe Azure HDInsight
- 3. Describe Azure Databricks
- 4. Describe Azure Data Factory
- 5. Describe Azure Synapse Analytics
- 6. Describe Azure Stream Analytics
|
| Topic 4: Describe core data concepts | 25-30% | - Describe ways to represent data
- 1. Describe features of structured data
- 2. Describe features of unstructured data
- 3. Describe features of semi-structured data
- Identify options for data storage
- 1. Describe common formats for data files
- 2. Describe types of databases
|