Microsoft certification exams: official practice tests and study materials

Prove that you can describe the following: AI workloads and considerations, machine learning fundamentals in Azure, computer vision workload capabilities in Azure, natural language processing (NLP) workload capabilities in Azure.

This exam is an opportunity to demonstrate knowledge of machine learning and AI concepts and related Microsoft Azure services. As a candidate for this exam, you should be familiar with the AI-900 Exam self-paced or instructor-led learning material.

This exam is designed for candidates with technical and non-technical backgrounds. No experience with data science and software engineering is necessary. However, you would benefit from knowing:
– Cloud basics
– Client/server applications

You can use Azure AI Essentials to prepare for other Azure role-based certifications, such as Azure Data Scientist Associate or Azure AI Engineer Associate, but they are not a prerequisite for any of them.

This exam assesses your ability to perform the following technical tasks: plan and manage an Azure IA solution; implement video and image processing solutions; natural language processing solutions; knowledge mining solutions; and conversational AI solutions.

Microsoft Azure AI engineers build, manage, and deploy AI solutions that make the most of Azure Cognitive Services and Azure services. Responsibilities include participation in all phases of the development of AI solutions, ranging from requirements definition and design, through development, deployment, integration and maintenance to performance tuning and monitoring.

These professionals work with solution architects to translate their vision and with data scientists, data engineers, IoT experts, infrastructure administrators, and other software developers to create complete end-to-end AI solutions.

Azure AI engineers have experience developing solutions that use languages ​​such as Python or C# and should be able to use REST-based APIs and SDKs (software development kits) to create secure image processing, video processing, natural language processing (NLP), knowledge mining, and conversational AI solutions in Azure. They must be familiar with all methods of implementing AI solutions. Additionally, candidates understand the components that make up the Azure AI portfolio and the data storage options available. Azure AI engineers also need to understand and be able to apply responsible AI usage principles.

This exam measures your ability to describe the following: cloud concepts; Azure architecture and services and Azure management and governance.

As a candidate for this exam, you are a technology professional who wants to demonstrate basic knowledge of cloud concepts in general and Microsoft Azure in particular. This exam is a common starting point on a path to a career in Azure.

You can describe Azure architectural components and Azure services, such as:
– Computing
- Network
- Storage

You can also describe resources and tools for securing, controlling, and administering Azure.

You must have skills and experience working in an IT area, such as:
– Infrastructure management
– Database management
– Software development

This exam measures your ability to perform the following technical tasks: manage Azure identities and governance, implement and manage storage, deploy and manage Azure compute resources, implement and manage virtual networks, and monitor and maintain Azure resources.

As a candidate for this exam, you must have experience implementing, managing, and monitoring your organization's Microsoft Azure environment, including:
– Virtual networks
- Storage
– Computing
– Identity
- Security
– Governance

As an Azure administrator, you are typically part of a larger team dedicated to implementing your organization's cloud infrastructure. You also coordinate with other functions to deliver Azure networking, security, database, application development, and DevOps solutions.

You must be familiar with:
– Operating systems
- Network
– Servers
– Virtualization

Additionally, you must have experience with the following:
– PowerShell
– Azure CLI
– The Azure portal
– Azure Resource Manager templates
– Azure AD (Microsoft Azure Active Directory), part of Microsoft Entra.

This exam measures your ability to perform the following technical tasks: manage Azure identities and governance, implement and manage storage, deploy and manage Azure compute resources, implement and manage virtual networks, and monitor and maintain Azure resources.

As a candidate for this exam, you must have experience implementing, managing, and monitoring your organization's Microsoft Azure environment, including:
– Virtual networks
- Storage
– Computing
– Identity
- Security
– Governance

As an Azure administrator, you are typically part of a larger team dedicated to implementing your organization's cloud infrastructure. You also coordinate with other functions to deliver Azure networking, security, database, application development, and DevOps solutions.

You must be familiar with:
– Operating systems
- Network
– Servers
– Virtualization

Additionally, you must have experience with the following:
– PowerShell
– Azure CLI
– The Azure portal
– Azure Resource Manager templates
– Azure AD (Microsoft Azure Active Directory), part of Microsoft Entra.

This exam measures your ability to perform the following technical tasks: design and implement core network infrastructure; design, implement and manage connectivity services; design and implement application delivery services; design and implement private access to Azure services; and secure network connectivity to Azure resources.

As a candidate for this exam, you must have expertise in planning, implementing, and managing Azure networking solutions, including:
– Core network infrastructure
– Hybrid connectivity
– Application delivery services
– Private access to Azure services
– Network security

As an Azure Network Engineer, your responsibilities include optimizing the performance, resilience, scale, and security of Azure networking solutions. You deploy the solutions using the Azure portal, command line, and templates. You proactively monitor network environments to identify problems and minimize risks.

To deliver Azure solutions, you work with:
– Solution architects
– Cloud administrators
– Security engineers
– Application developers
– DevOps engineers

You also help Azure Support engineers resolve connectivity issues reported by customers.

As a candidate for this exam, you must have experience creating and managing compute, storage, and networking resources in Azure. You must understand basic networking concepts such as:
– Name resolution
– Network protocols
– Network address management

This exam assesses your ability to perform the following technical tasks: deploy and manage Active Directory Domain Services (AD DS) in on-premises and cloud environments; manage Windows Server operating systems and workloads in a hybrid environment; manage virtual machines and containers; implement and manage a hybrid and on-premises network infrastructure; and manage storage and file services.

As a candidate for this exam, you are responsible for configuring and managing Windows Server infrastructure-as-a-service (IaaS), hybrid, and on-premises platform workloads. As a Windows Server hybrid administrator, you have the following tasks:
– Integrate Windows Server environments with Azure services.
– Manage Windows Server on local networks.

In this role, you manage and maintain Windows Server IaaS workloads in Azure, as well as migrate and deploy workloads to Azure. Typically, you collaborate with the following:
– Azure Administrators
– Enterprise architects
– Microsoft 365 administrators
– Network engineers

As a candidate for this exam, you deploy, package, secure, update, and configure Windows Server workloads across on-premises, hybrid, and cloud technologies. In this role, you implement and manage hybrid and on-premises solutions such as identity, security, management, compute, networking, storage, monitoring, high availability, and disaster recovery.

You use administrative tools and technologies such as Windows Admin Center, PowerShell, Azure Arc, Azure Policy, Azure Monitor, Azure Automation Update Management, Microsoft Defender for Identity, Microsoft Security Center, and IaaS Virtual Machine (VM) Administration.

It assesses your ability to perform the following technical tasks: securing on-premises and hybrid Windows Server infrastructures; implement and manage Windows Server high availability; implement disaster recovery; migrate servers and workloads, and monitor and troubleshoot Windows Server environments.

As a candidate for this exam, you are responsible for configuring and managing Windows Server infrastructure-as-a-service (IaaS), hybrid, and on-premises platform workloads. As a Windows Server hybrid administrator, you have the following tasks:
– Integrate Windows Server environments with Azure services.
– Manage Windows Server on local networks.

In this role, you manage and maintain Windows Server IaaS workloads in Azure, as well as migrate and deploy workloads to Azure. Typically, you collaborate with the following:
– Azure Administrators
– Enterprise architects
– Microsoft 365 administrators
– Network engineers

As a candidate for this exam, you deploy, package, secure, update, and configure Windows Server workloads across on-premises, hybrid, and cloud technologies. In this role, you implement and manage hybrid and on-premises solutions such as identity, security, management, compute, networking, storage, monitoring, high availability, and disaster recovery.

You use administrative tools and technologies such as Windows Admin Center, PowerShell, Azure Arc, Azure Policy, Azure Monitor, Azure Automation Update Management, Microsoft Defender for Identity, Microsoft Security Center, and IaaS Virtual Machine (VM) Administration.

As a candidate for this exam, you must have several years of experience with Windows Server operating systems.

Prove that you can perform the following tasks: describe key data concepts, identify considerations for relational data in Azure, describe considerations for working using non-relational data in Azure, and describe an analytics workload in Azure.

This exam is an opportunity to demonstrate knowledge of core Microsoft Azure data concepts and related data services. As a candidate for this exam, you should be familiar with the self-paced or instructor-led learning material for Exam DP-900.

This exam is intended for candidates who are just starting to work with data in the cloud.

You must be familiar with:
– The concepts of relational and non-relational data.
– Different types of data workloads, such as transactional or analytical.

You can use the Azure Data Fundamentals certification to prepare for other Azure role-based certifications, such as Azure Database Administrator Associate or Azure Data Engineer Associate, but it is not a prerequisite for any of them.

This exam assesses your ability to perform the following technical tasks: design and implement data storage; develop data processing; and secure, monitor and optimize data storage and data processing.

As a candidate for this exam, you must be an expert in integrating, transforming, and consolidating data from multiple structured, unstructured, and streaming data systems into a schema suitable for creating analytics solutions.

As an Azure data engineer, you help stakeholders understand data through exploration and create and maintain secure and compliant data processing pipelines using different tools and techniques. You use various Azure data services and frameworks to store and produce clean, rich datasets for analysis. This data store can be designed with different architectural patterns based on business requirements, including:
– MDW (modern data warehouse)
– Big Data
– Lakehouse architecture

As an Azure data engineer, you also help ensure that the operationalization of data pipelines and data stores is high-performance, efficient, organized, and reliable, given a set of business requirements and constraints. You help identify and resolve operational and data quality issues. You also design, implement, monitor, and optimize data platforms to serve data pipelines.

As a candidate for this exam, you must have a solid understanding of data processing languages, including:
– SQL
– Python
– Scala

You need to understand parallel processing and data architecture patterns. You must 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

This exam measures your ability to perform the following technical tasks: plan and implement data platform capabilities; implement a safe environment; monitor, configure and optimize database resources; configure and manage task automation; and plan and configure an HA/DR (high availability and disaster recovery) environment.

Candidates for this exam must have subject matter expertise in creating database solutions designed to support various workloads built with on-premises SQL Server and Azure SQL Database Services.

Candidates for this exam are database administrators who manage on-premises and cloud databases built using SQL and SQL Server database services.

The Azure Database Administrator implements and manages the operational aspects of cloud-native and hybrid data platform solutions built on SQL and SQL Server database services. Professionals in this role use a variety of methods and tools to perform and automate daily operations, including applying knowledge of using T-SQL and other tools for administrative management purposes.

These professionals are responsible for the management, availability, security, monitoring and performance optimization of database solutions. They evaluate and implement migration strategies for moving databases between Azure and on-premises. Additionally, they work with Azure data engineers, Azure solutions architects, Azure developers, data scientists, and other professionals to manage operational aspects of data platform solutions.

Candidates for this exam must have knowledge and experience with Azure SQL Edge, Azure SQL Database, Azure SQL Managed Instance, and SQL Server on Azure Virtual Machines (Windows and Linux).

This exam measures your ability to perform the following technical tasks: prepare data; model the data; visualize and analyze data and deploy and maintain assets.

As a candidate for this exam, you must present actionable insights by working with available data and applying domain expertise. You must:
– Deliver significant business value through easy-to-understand data visualizations.
– Empower others to perform self-service analysis.
– Deploy and configure solutions for consumption.

As a Power BI data analyst, you work closely with business stakeholders to identify business requirements. You collaborate with enterprise data analysts and data engineers to identify and acquire data. You use Power BI to:
– Transform the data.
– Create data models.
– Visualize data.
– Share assets.

You must be proficient in using Power Query and creating expressions using Data Analysis Expressions (DAX). You know how to evaluate data quality. Additionally, you understand data security, including row-level security and data confidentiality.

This exam assesses your ability to perform the following technical tasks: developing identity, governance and monitoring solutions; develop data storage solutions; business continuity solutions; and infrastructure solutions.

As a Microsoft Azure Solutions Architect, you specialize in building cloud and hybrid solutions that run on Azure, including:
– Computing
- Network
- Storage
– Monitoring
- Security

This role's responsibilities include advising stakeholders and translating business requirements into Azure solution designs aligned to the Azure Well-Architected Framework. In this role, you implement solutions in Azure in partnership with several other job roles, including:
– Developers
– Administrators
– Security engineers
– Data engineers

As a candidate for this exam, you must have advanced experience and knowledge in IT operations, including networking, virtualization, identity, security, business continuity, disaster recovery, data platforms, and governance. You must manage how decisions in each area affect an overall solution. Additionally, you must have experience with the following:
– Azure Administration
– Azure development
– DevOps processes

This exam assesses your ability to perform the following technical tasks: develop Azure computing solutions; develop solutions for Azure storage, implement Azure security; monitor, troubleshoot, and optimize Azure solutions and connect to and consume Azure and third-party services. You will be able to select the code language (C# or Python) included in the questions when you start the exam.

As a candidate for this exam, you are responsible for participating in all phases of development, including requirements gathering, design, development, deployment, security, maintenance, performance tuning, and monitoring. You must be proficient in the following aspects related to Azure:
– SDKs (Software Development Kits)
– Data storage options
– Data connections
– APIs
– Application authentication/authorization
– Compute/container deployment
– Debugging

To implement solutions, you work in partnership with:
– Cloud solution architects
– DBAs (database administrators)
– DevOps
– Infrastructure administrators
– Other stakeholders

As a candidate, you must have a minimum of two years of professional development experience and experience with Azure. You must be:
– Able to program in an Azure-compatible language.
– Proficient in using the Azure CLI, Azure PowerShell, and other tools.

This exam measures your ability to perform the following technical tasks: configure processes and communications; design and implement source code control; design and implement release and build pipelines; develop a security and compliance plan; and implement an instrumentation strategy.

DevOps engineers are developers or infrastructure administrators who also have experience working with people, processes, and products to enable continuous delivery of value across organizations.

Responsibilities for this role include designing and implementing collaboration strategies, code, infrastructure, source control, security, compliance, continuous integration, testing, delivery, monitoring, and feedback.

DevOps engineers work in cross-functional teams that include developers, site reliability engineers, and Azure administrators.

DevOps engineers must have experience in Azure administration and development, with strong skills in at least one of these areas. They should be familiar with Azure DevOps and GitHub.

This exam assesses your ability to describe the following: Dynamics 365 Marketing, Dynamics 365 Sales, Dynamics 365 Customer Service, Dynamics 365 Field Service, and explore the core capabilities of Dynamics 365 customer engagement applications.

This exam covers the features and functionality of Microsoft Dynamics 365 Marketing, Dynamics 365 Sales, Dynamics 365 Customer Service, and Dynamics 365 Field Service. A basic understanding of business processes and computing skills is helpful for candidates for this exam.

This exam assesses your ability to describe the following: Dynamics 365 Supply Chain Management; Dynamics 365 Finance; Dynamics 365 Commerce; Dynamics 365 Human Resources; Project Operations and basic finance and operations functionality.

This exam covers the features and functionality of Dynamics 365 finance and operations applications.

As an exam candidate, you must have general knowledge or relevant work experience with an IT (information technology) environment. You must also have a fundamental understanding of financial principles and business operations.

This exam assesses your ability to perform the following technical tasks: describe Finance and Operations applications and extend applications using Microsoft Power Platform technologies; configure administrative resources and workflows; manage Finance and Operations data; validate the solution and support it.

Candidates for this exam collect and analyze business requirements and transform those requirements into fully realized business processes and solutions that implement industry best practices. They act as a key resource in implementing and configuring applications to meet business requirements.

Candidates must be able to implement shared resources used by finance and operations applications. The candidate must be able to use LCS (Lifecycle Services), Azure DevOps, and other Microsoft tools and platforms to manage the Application Lifecycle Management (ALM) process. They must also have recognition of how finance and operations applications integrate with Microsoft Power Platform solutions, external systems, and tools.

Candidates for this exam typically specialize in one or more feature sets of finance and operations applications, including Microsoft Dynamics 365 Finance, Supply Chain Management (which also contains manufacturing modules), Commerce, Project Operations, and Human Resources.

Prove that you understand cloud concepts; Microsoft 365 services and applications; Microsoft 365 security, compliance, privacy and reliability; and Microsoft 365 pricing, licensing, and support.

This course is designed for candidates looking to demonstrate entry-level knowledge of cloud-based solutions that facilitate productivity and collaboration on-site, remotely, or in a hybrid modality. Candidates may have knowledge of cloud-based solutions or be new to Microsoft 365. Candidates can use this exam to prepare for other Microsoft certifications, but it is not a prerequisite for any of the related certifications.

Candidates should be able to recommend Microsoft 365 solutions that solve common organizational IT challenges. They must understand how Microsoft 365 solutions improve productivity, facilitate collaboration, and streamline communication. They must also understand how Microsoft 365 solutions help protect data and identities and facilitate compliance.

Candidates should also be able to recommend solutions for endpoint and application management, desktop virtualization, automated operating system deployment, and reporting and analytics. They should be familiar with Microsoft 365 licensing, deployment, and migration assistance and support options for organizations looking to maximize their cloud investment.

This exam measures your ability to perform the following technical tasks: configure and manage a Teams environment; manage teams, channels, chats and apps; manage meetings and calls; and monitor, report, and troubleshoot Teams issues.

As a Microsoft Teams administrator, you manage and maintain internal and external collaboration and communication solutions using Teams and Microsoft 365.

You are responsible for setting up and managing teams, channels, chat, apps, calls, meetings, and events. You manage:
– Teams Telephony phone numbers and services.
– Operational aspects of Teams clients and devices.

You collaborate with owners of other workloads, such as:
- Network
– Identity
– Licensing
– Information management
– User adoption

You work with collaboration and communications system engineers to implement advanced Telephony and Teams Rooms scenarios. You plan and implement governance, security, and compliance for Teams.

As a candidate for this exam, you must have working knowledge of Microsoft 365 services, such as:
– Microsoft 365 Groups
– Microsoft SharePoint Online
– OneDrive
– Exchange
– Azure AD (Azure Active Directory), part of Microsoft Entra

You must understand the options for integrating and extending Teams with other applications, such as:
– Microsoft Viva
– PowerPlatform
– Third-party applications
– Customized applications

This exam assesses your ability to describe the business value of Microsoft Power Platform, identify the core components of Microsoft Power Platform, demonstrate Power BI capabilities, demonstrate Power Apps capabilities, demonstrate Power Automate capabilities, and demonstrate Microsoft Power Platform add-on solutions.

Candidates for this exam aim to understand how Microsoft Power Platform technologies can be used to improve processes and help drive business results. The exam is aimed at candidates looking to start their journey creating solutions with the Microsoft Power Platform.

This exam can be used to prepare for role-based or specialty certifications, but is not a prerequisite for either.

This exam measures your ability to perform the following technical tasks: design business solutions; analyze and visualize data; and create business solutions.

The candidate for this exam envisions and creates business solutions to simplify and automate tasks and processes for themselves and their team. They understand the data they are working with, the problems they need to solve, and the required processes and application experiences. The candidate may not have formal IT training, but is comfortable using technology to solve business problems.

The candidate is self-directed and focuses on solving problems they encounter as part of their primary role. Can connect to and use application resources, including Microsoft Power Platform, Microsoft Teams, Microsoft 365 apps and services, and third-party solutions. The candidate has the desire to understand the functionalities and limitations of the available tools and understands how to apply them.

This exam assesses your ability to complete the following tasks: configure Microsoft Dataverse; create applications using Microsoft Power Apps; create and manage process automation; describe Microsoft Power Virtual Agents; import and visualize data using dataflows and Power BI and define an environment strategy.

Candidates for this exam perform discovery, obtain requirements, engage experts and stakeholders, and configure Microsoft Power Platform solutions and applications. They create application enhancements, personalized user experiences, process automation, and reporting.

Candidates implement the design provided by or in collaboration with a solutions architect and the standards, branding, and artifacts established by user experience designers. They implement the integration points to connect to third-party applications and services. They generate training documentation and facilitate training and enablement.

Candidates must connect and communicate effectively with delivery team members, stakeholders, and customer teams while championing their success. Candidates must have an understanding of Application Lifecycle Management (ALM) practices for Power Platform and quality assurance.

Candidates must be familiar with using Power Platform components to work with Microsoft Teams, Excel, and Word. Candidates must have proficiency in data modeling, user experience design, requirements analysis, and process analysis. Candidates must have two years of experience.

This exam assesses your ability to perform the following technical tasks: create a technical project, configure Microsoft Dataverse, create and configure Power Apps, configure business process automation, extend the user experience and platform, and develop integrations.

Candidates for this exam design, develop, test, secure, and troubleshoot Microsoft Power Platform solutions. Candidates implement solution components that include application enhancements, custom user experiences, system integrations, data conversions, and custom process automation.

Candidates must have a solid applied knowledge of Microsoft Power Platform services, including an in-depth understanding of their capabilities, limits, and constraints. Candidates must have a basic understanding of authentication, security, and Application Lifecycle Management (ALM) practices for the Microsoft Power Platform.

Candidates must have development experience that includes Microsoft Power Platform services, JavaScript, JSON, TypeScript, C#, HTML, RESTful Web APIs, and Microsoft Azure.

This exam assesses your ability to describe the following: security, compliance, and identity concepts; features of Microsoft Azure AD (Azure Active Directory), part of Microsoft Entra; features of Microsoft Security solutions and features of Microsoft compliance solutions.

This exam is for you if you want to know the fundamentals of SCI (security, compliance, and identity) in cloud-based and related Microsoft services.

This exam is suitable for those who are interested in Microsoft SCI solutions and are:
– Corporate stakeholder
– Beginner or experienced IT professional
- Student

Prove that you are familiar with Microsoft Azure and Microsoft 365 and understand how Microsoft SCI solutions span these solution areas to deliver an end-to-end, all-inclusive solution.

This exam assesses your ability to perform the following technical tasks: mitigate threats using Microsoft 365 Defender, mitigate threats using Security Center, and mitigate threats using Azure Sentinel.

Microsoft security operations analysts reduce organizational risk by quickly remediating active attacks in the environment, providing recommendations for improvements to threat protection practices, and escalating violations of organizational policies to the appropriate stakeholders. They perform screening, incident response, vulnerability management, threat hunting, and cyber threat intelligence analysis.

Microsoft security operations analysts monitor, identify, investigate, and respond to threats in multi-cloud environments using Microsoft Sentinel, Azure Security Center, Microsoft 365 Defender, and third-party security solutions. Microsoft security operations analysts collaborate with business stakeholders, architects, identity administrators, Azure administrators, and endpoint administrators to secure IT systems for the organization.

Candidates must be familiar with Microsoft 365, Azure cloud services, and Windows and Linux operating systems.

This exam measures your ability to perform the following technical tasks: implement identities in Azure AD; implement authentication and access management; implement access management for applications; and plan and implement identity governance in Azure AD.

The Microsoft identity and access administrator designs, implements, and operates an organization's identity and access management systems using Microsoft Azure AD (Azure Active Directory), part of Microsoft Entra. They configure and manage identity authentication and authorization for users, devices, Azure resources, and applications.

Identity and Access Administrator provides seamless experiences and self-service management capabilities for all users. They ensure identity is explicitly verified to support Zero Trust principles. They automate management of Azure AD using PowerShell and analyze events using KQL (Kusto Query Language). They are also responsible for troubleshooting, monitoring, and reporting for the identity and access environment.

The identity and access administrator collaborates with many other functions within the organization to advance strategic identity projects to modernize identity solutions, implement hybrid identity solutions, and implement identity governance. They should be familiar with Azure and Microsoft 365 services and workloads.

This exam measures your ability to perform the following technical tasks: manage identity and access; secure network; secure computing, storage and databases; and manage security operations.

Candidates for this exam deploy, manage, and monitor the security of resources in Azure, multi-cloud, and hybrid environments as part of an end-to-end infrastructure. It recommends security components and configurations to protect access and identity. data, applications and networks.

An Azure security engineer's responsibilities include managing security posture, identifying and remediating vulnerabilities, performing threat modeling, and implementing threat protection. He may also participate in security incident response.

Azure security engineers work with architects, administrators, and developers to plan and implement solutions that meet security and compliance requirements.

The Azure security engineer must have hands-on experience administering Microsoft Azure and hybrid environments. The Azure security engineer should be very familiar with compute, networking, and storage in Azure, as well as Azure Active Directory, part of Microsoft Entra.