As a candidate for this certification, you should have subject matter expertise in integrating, transforming, and consolidating data from various structured, unstructured, and streaming data systems into a suitable schema for building analytics solutions. As an Azure data engineer, you help stakeholders understand the data through exploration, and build and maintain secure and compliant data processing pipelines by using different tools and techniques. You use various Azure data services and frameworks to store and produce cleansed and enhanced datasets for analysis. This data store can be designed with different architecture patterns based on business requirements, including: Modern data warehouse (MDW) Big data Lakehouse architecture As an Azure data engineer, you also help to ensure that the operationalization of data pipelines and data stores are high-performing, efficient, organized, and reliable, given a set of business requirements and constraints. You help to identify and troubleshoot operational and data quality issues. You also design, implement, monitor, and optimize data platforms to meet the data pipelines. As a candidate for this certification, you must have solid knowledge of data processing languages, including: SQL Python Scala You need to understand parallel processing and data architecture patterns. You should be proficient in using the following to create data processing solutions: Azure Data Factory Azure Synapse Analytics Azure Stream Analytics Azure Event Hubs Azure Data Lake Storage Azure Databricks Important The English language version of this certification was updated on November 2, 2023. Review the study guide linked on the Exam DP-203 page for details about recent changes.

This certification offers the foundation you need to build your technical skills to start working with data in the cloud. Mastering the basics can help you jump-start your career and prepare you to dive deeper into other technical opportunities Azure offers. The Microsoft Certified: Azure Data Fundamentals certification could be a great fit for you if you’d like to: Validate your foundational knowledge of core data concepts and how they’re implemented using Azure data services. Reinforce your basics for other Azure role-based certifications, like Azure Database Administrator Associate, Azure Data Engineer Associate, Power BI Data Analyst Associate, or Azure Developer Associate, but it’s not a prerequisite for any of them. If you’re new to the cloud or just starting out with Azure, first choose Azure fundamentals training and certification. If you’re beginning to work with data in the cloud, this certification is for you. It is recommended to have familiarity with: The concepts of relational and nonrelational data. Different types of data workloads, such as transactional or analytical. To prepare for the exam, we recommend that you: Fully understand the skills measured. Study the relevant self-paced content on Microsoft Learn, attend a Microsoft Azure Virtual Training Day: Data Fundamentals, or sign up for an instructor-led training event with a Training Services Partner. Take the free Practice Assessment to validate your knowledge and understanding of the exam experience. Get a trial subscription and give it a try. Check out Master the basics with the Azure Data Fundamentals certification to learn more about this certification and how to get ready. What's next? Register for your exam! After you pass the exam and earn your certification, celebrate your certification badge and skills on social platforms such as LinkedIn. To find out more, visit use and share certification badges. Depending on your goals and your profession, you may choose to: Master the basics with the Azure AI Fundamentals certification. Level up with the Azure Database Administrator Associate, Azure Data Engineer Associate, Power BI Data Analyst Associate, or Azure Developer Associate certifications. Find the right Microsoft Azure certification for you. Important The English language version of this certification was updated on February 1, 2024. Review the study guide linked on the Exam DP-900 page for details about recent changes.

As a candidate for this certification, you should have subject matter expertise in building database solutions that are designed to support multiple workloads built with: SQL Server on-premises Azure SQL services You’re a database administrator who manages on-premises and cloud databases built with SQL Server and Azure SQL services. As the Azure database administrator, you implement and manage the operational aspects of cloud-native and hybrid data platform solutions built on SQL Server and Azure SQL services. You use a variety of methods and tools to perform and automate day-to-day operations, including applying knowledge of using Transact-SQL (T-SQL) and other tools for administrative management purposes. You’re responsible for the following concerning database solutions: Management Availability Security Performance monitoring and optimization You evaluate and implement migration strategies for moving databases between Azure and on-premises. Plus, you work with Azure data engineers, Azure solution architects, Azure developers, data scientists, and other professionals to manage operational aspects of data platform solutions. As a candidate for this certification, you should have knowledge of and experience with: Azure SQL Database Azure SQL Managed Instance SQL Server on Azure Virtual Machines (Windows and Linux) Important The English language version of this certification was updated on February 7, 2024. Review the study guide linked on the Exam DP-300 page for details about recent changes.

Warning This certification will retire on April 30, 2024. You will no longer be able to earn this certification after this date. Certification renewal will be available for at least six months after the certification retires. Read the blog post. As a candidate for the Azure Enterprise Data Analyst Associate certification, you should have subject matter expertise in designing, creating, and deploying enterprise-scale data analytics solutions. Your responsibilities for this role include performing advanced data analytics at scale, such as: Cleaning and transforming data. Designing and building enterprise data models. Incorporating advanced analytics capabilities. Integrating with IT infrastructure. Applying development lifecycle practices. As a professional in this role, you: Help collect enterprise-level requirements for data analytics solutions that include Azure and Power BI. Advise on data governance and configuration settings for Power BI administration. Monitor data usage. Optimize performance of the data analytics solutions. As an Azure enterprise data analyst, you collaborate with other roles, such as: Solution architects Data engineers Data scientists AI engineers Database administrators Power BI data analysts As a candidate for this certification, you should have advanced Power BI skills, including managing data repositories and data processing in the cloud and on-premises, along with using Power Query and Data Analysis Expressions (DAX). You should also be proficient in consuming data from Azure Synapse Analytics and should have experience querying relational databases, analyzing data by using Transact-SQL (T-SQL), and visualizing data. Important The English language version of this certification was updated on January 30, 2024. Review the study guide linked on the Exam PL-200 page for details about recent changes.

As a Microsoft Azure solutions architect, you have subject matter expertise in designing cloud and hybrid solutions that run on Azure, including: Compute Network Storage Monitoring Security Your responsibilities for this role include advising stakeholders and translating business requirements into designs for Azure solutions that align with the Azure Well-Architected Framework and Cloud Adoption Framework for Azure. In this role, you implement solutions on Azure by partnering with various other job roles, including: Developers Administrators Security engineers Data engineers As a candidate for this certification, you should have advanced experience and knowledge of IT operations, including networking, virtualization, identity, security, business continuity, disaster recovery, data platforms, and governance. You should manage how decisions in each area affect an overall solution. In addition, you should have experience with: Azure administration Azure development DevOps processes Important The English language version of this certification was updated on January 22, 2024. Review the study guide linked on the Exam AZ-305 page for details about recent changes.

As a candidate for this certification, you should have subject matter expertise in designing, creating, and deploying enterprise-scale data analytics solutions. Your responsibilities for this role include transforming data into reusable analytics assets by using Microsoft Fabric components, such as: Lakehouses Data warehouses Notebooks Dataflows Data pipelines Semantic models Reports You implement analytics best practices in Fabric, including version control and deployment. To implement solutions as a Fabric analytics engineer, you partner with other roles, such as: Solution architects Data engineers Data scientists AI engineers Database administrators Power BI data analysts In addition to in-depth work with the Fabric platform, you need experience with: Data modeling Data transformation Git-based source control Exploratory analytics Languages, including Structured Query Language (SQL), Data Analysis Expressions (DAX), and PySpark