About the exam Languages Some exams are localized into other languages. You can find these in the Schedule Exam section of the Exam Details webpage. If the exam isn’t available in your preferred language, you can request an additional 30 minutes to complete the exam.
Note The bullets that follow each of the skills measured are intended to illustrate how we are assessing that skill. Related topics may be covered in the exam.
Note Most questions cover features that are general availability (GA). The exam may contain questions on Preview features if those features are commonly used.
Skills measured
Audience profile As a candidate for this exam, 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
Skills at a glance
Plan, implement, and manage a solution for data analytics (10–15%) Prepare and serve data (40–45%) Implement and manage semantic models (20–25%) Explore and analyze data (20–25%)
Plan, implement, and manage a solution for data analytics (10–15%) Plan a data analytics environment Identify requirements for a solution, including components, features, performance, and capacity stock-keeping units (SKUs) Recommend settings in the Fabric admin portal Choose a data gateway type Create a custom Power BI report theme Implement and manage a data analytics environment Implement workspace and item-level access controls for Fabric items Implement data sharing for workspaces, warehouses, and lakehouses Manage sensitivity labels in semantic models and lakehouses Configure Fabric-enabled workspace settings Manage Fabric capacity Manage the analytics development lifecycle Implement version control for a workspace Create and manage a Power BI Desktop project (.pbip) Plan and implement deployment solutions Perform impact analysis of downstream dependencies from lakehouses, data warehouses, dataflows, and semantic models Deploy and manage semantic models by using the XMLA endpoint Create and update reusable assets, including Power BI template (.pbit) files, Power BI data source (.pbids) files, and shared semantic models
Prepare and serve data (40–45%) Create objects in a lakehouse or warehouse Ingest data by using a data pipeline, dataflow, or notebook Create and manage shortcuts Implement file partitioning for analytics workloads in a lakehouse Create views, functions, and stored procedures Enrich data by adding new columns or tables Copy data Choose an appropriate method for copying data from a Fabric data source to a lakehouse or warehouse Copy data by using a data pipeline, dataflow, or notebook Add stored procedures, notebooks, and dataflows to a data pipeline Schedule data pipelines Schedule dataflows and notebooks Transform data Implement a data cleansing process Implement a star schema for a lakehouse or warehouse, including Type 1 and Type 2 slowly changing dimensions Implement bridge tables for a lakehouse or a warehouse Denormalize data Aggregate or de-aggregate data Merge or join data Identify and resolve duplicate data, missing data, or null values Convert data types by using SQL or PySpark Filter data
Optimize performance Identify and resolve data loading performance bottlenecks in dataflows, notebooks, and SQL queries Implement performance improvements in dataflows, notebooks, and SQL queries Identify and resolve issues with Delta table file sizes
Implement and manage semantic models (20–25%) Design and build semantic models Choose a storage mode, including Direct Lake Identify use cases for DAX Studio and Tabular Editor 2 Implement a star schema for a semantic model Implement relationships, such as bridge tables and many-to-many relationships Write calculations that use DAX variables and functions, such as iterators, table filtering, windowing, and information functions Implement calculation groups, dynamic strings, and field parameters Design and build a large format dataset Design and build composite models that include aggregations Implement dynamic row-level security and object-level security Validate row-level security and object-level security
Optimize enterprise-scale semantic models Implement performance improvements in queries and report visuals Improve DAX performance by using DAX Studio Optimize a semantic model by using Tabular Editor 2 Implement incremental refresh
Explore and analyze data (20–25%) Perform exploratory analytics Implement descriptive and diagnostic analytics Integrate prescriptive and predictive analytics into a visual or report Profile data Query data by using SQL Query a lakehouse in Fabric by using SQL queries or the visual query editor Query a warehouse in Fabric by using SQL queries or the visual query editor Connect to and query datasets by using the XMLA endpoint
Sample Questions and Answers QUESTION 1 What should you recommend using to ingest the customer data into the data store in the AnatyticsPOC workspace?
A. a stored procedure B. a pipeline that contains a KQL activity C. a Spark notebook D. a dataflow
Answer: D
QUESTION 2 Which type of data store should you recommend in the AnalyticsPOC workspace?
A. a data lake B. a warehouse C. a lakehouse D. an external Hive metaStore
Answer: C
QUESTION 3 You are the administrator of a Fabric workspace that contains a lakehouse named Lakehouse1. Lakehouse1 contains the following tables: Table1: A Delta table created by using a shortcut Table2: An external table created by using Spark Table3: A managed table
Answer: A
QUESTION 4 You plan to connect to Lakehouse1 by using its SQL endpoint. What will you be able to do after connecting to Lakehouse1?
A. ReadTable3. B. Update the data Table3. C. ReadTable2. D. Update the data in Table1.
Answer: D
QUESTION 5 You have a Fabric tenant that contains a warehouse. You use a dataflow to load a new dataset from OneLake to the warehouse. You need to add a Power Query step to identify the maximum values for the numeric columns. Which function should you include in the step?
A. Table. MaxN B. Table.Max C. Table.Range D. Table.Profile
Answer: B
QUESTION 6 You have a Fabric tenant that contains a machine learning model registered in a Fabric workspace. You need to use the model to generate predictions by using the predict function in a fabric notebook. Which two languages can you use to perform model scoring? Each correct answer presents a complete solution. NOTE: Each correct answer is worth one point.
A. T-SQL B. DAX EC. C. Spark SQL D. PySpark
Answer: C, D
QUESTION 7 You are analyzing the data in a Fabric notebook. You have a Spark DataFrame assigned to a variable named df. You need to use the Chart view in the notebook to explore the data manually. Which function should you run to make the data available in the Chart view?
Updates to the exam Our exams are updated periodically to reflect skills that are required to perform a role. We have included two versions of the Skills Measured objectives depending on when you are taking the exam.
We always update the English language version of the exam first. Some exams are localized into other languages, and those are updated approximately eight weeks after the English version is updated. While Microsoft makes every effort to update localized versions as noted, there may be times when localized versions of an exam are not updated on this schedule. Other available languages are listed in the Schedule Exam section of the Exam Details webpage. If the exam isn’t available in your preferred language, you can request an additional 30 minutes to complete the exam.
Note The bullets that follow each of the skills measured are intended to illustrate how we are assessing that skill. Related topics may be covered in the exam.
Note Most questions cover features that are general availability (GA). The exam may contain questions on Preview features if those features are commonly used.
Skills measured as of January 23, 2024 Audience profile
As a Microsoft cybersecurity architect, you translate a cybersecurity strategy into capabilities that protect the assets, business, and operations of an organization. You design, guide the implementation of, and maintain security solutions that follow Zero Trust principles and best practices, including security strategies for:
Identity Devices Data Applications Network Infrastructure DevOps Plus, you design solutions for: Governance and Risk Compliance (GRC) Security operations Security posture management
As a cybersecurity architect, you continuously collaborate with leaders and practitioners in IT security, privacy, and other roles across an organization to plan and implement a cybersecurity strategy that meets the business needs of an organization.
As a candidate for this exam, you have experience implementing or administering solutions in the following areas:
Identity and access Platform protection Security operations Data security Application security Hybrid and multicloud infrastructures
You should have expert skills in at least one of those areas, and you should have experience designing security solutions that include Microsoft security technologies.
Skills at a glance Design solutions that align with security best practices and priorities (20–25%) Design security operations, identity, and compliance capabilities (30–35%) Design security solutions for infrastructure (20–25%) Design security solutions for applications and data (20–25%)
Design solutions that align with security best practices and priorities (20–25%) Design a resiliency strategy for ransomware and other attacks based on Microsoft Security Best Practices Design a security strategy to support business resiliency goals, including identifying and prioritizing threats to business-critical assets Design solutions that align with Microsoft ransomware best practices, including backup, restore, and privileged access Design configurations for secure backup and restore by using Azure Backup for hybrid and multicloud environments Design solutions for security updates Design solutions that align with the Microsoft Cybersecurity Reference Architectures (MCRA) and Microsoft cloud security benchmark (MCSB) Design solutions that align with best practices for cybersecurity capabilities and controls Design solutions that align with best practices for protecting against insider and external attacks Design solutions that align with best practices for Zero Trust security, including the Zero Trust Rapid Modernization Plan (RaMP) Design solutions that align with the Microsoft Cloud Adoption Framework for Azure and the Microsoft Azure Well-Architected Framework Design a new or evaluate an existing strategy for security and governance based on the Microsoft Cloud Adoption Framework (CAF) for Azure and the Microsoft Azure Well-Architected Framework Recommend solutions for security and governance based on the Microsoft Cloud Adoption Framework for Azure and the Microsoft Azure Well-Architected Framework Design solutions for implementing and governing security by using Azure landing zones Design a DevSecOps process
Design security operations, identity, and compliance capabilities (30–35%) Design solutions for security operations Develop security operations capabilities to support a hybrid or multicloud environment Design a solution for centralized logging and auditing Design a solution for security information and event management (SIEM), including Microsoft Sentinel Design a solution for detection and response that includes extended detection and response (XDR) Design a solution for security orchestration automated response (SOAR), including Microsoft Sentinel and Microsoft Defender Design and evaluate security workflows, including incident response, threat hunting, incident management, and threat intelligence Design and evaluate threat detection coverage by using MITRE ATT&CK Design solutions for identity and access management Design a solution for access to software as a service (SaaS), platform as a service (PaaS), infrastructure as a service (IaaS), hybrid/on-premises, and multicloud resources, including identity, networking, and application controls Design a solution for Microsoft Entra ID, including hybrid and multi-cloud environments Design a solution for external identities, including business-to-business (B2B), business-to-customer (B2C), and decentralized identity Design a modern authentication and authorization strategy, including Conditional Access, continuous access evaluation, threat intelligence integration, and risk scoring Validate the alignment of Conditional Access policies with a Zero Trust strategy Specify requirements to secure Active Directory Domain Services (AD DS) Design a solution to manage secrets, keys, and certificates Design solutions for securing privileged access Design a solution for assigning and delegating privileged roles by using the enterprise access model Design an identity governance solution, including Microsoft Entra Privileged Identity Management (PIM), privileged access management, entitlement management, and access reviews Design a solution for securing the administration of cloud tenants, including SaaS and multicloud infrastructure and platforms Design a solution for cloud infrastructure entitlement management that includes Microsoft Entra Permissions Management Design a solution for Privileged Access Workstation (PAW) and bastion services Design solutions for regulatory compliance Translate compliance requirements into a security solution Design a solution to address compliance requirements by using Microsoft Purview risk and compliance solutions Design a solution to address privacy requirements, including Microsoft Priva Design Azure Policy solutions to address security and compliance requirements Evaluate infrastructure compliance by using Microsoft Defender for Cloud
Design security solutions for infrastructure (20–25%) Design solutions for security posture management in hybrid and multicloud environments Evaluate security posture by using MCSB Evaluate security posture by using Microsoft Defender for Cloud Evaluate security posture by using Microsoft Secure Score Design integrated security posture management and workload protection solutions in hybrid and multi-cloud environments, including Microsoft Defender for Cloud Design cloud workload protection solutions that use Microsoft Defender for Cloud, such as Microsoft Defender for Servers, Microsoft Defender for App Service, and Microsoft Defender for SQL Design a solution for integrating hybrid and multicloud environments by using Azure Arc Design a solution for Microsoft Defender External Attack Surface Management (Defender EASM) Design solutions for securing server and client endpoints Specify security requirements for servers, including multiple platforms and operating systems Specify security requirements for mobile devices and clients, including endpoint protection, hardening, and configuration Specify security requirements for IoT devices and embedded systems Design a solution for securing operational technology (OT) and industrial control systems (ICS) by using Microsoft Defender for IoT Specify security baselines for server and client endpoints Design a solution for secure remote access Specify requirements for securing SaaS, PaaS, and IaaS services Specify security baselines for SaaS, PaaS, and IaaS services Specify security requirements for IoT workloads Specify security requirements for web workloads, including Azure App Service Specify security requirements for containers Specify security requirements for container orchestration
Design security solutions for applications and data (20–25%) Design solutions for securing Microsoft 365 Evaluate security posture for productivity and collaboration workloads by using metrics, including Microsoft Secure Score and Microsoft Defender for Cloud secure score Design a Microsoft 365 Defender solution Design secure configurations and operational practices for Microsoft 365 workloads and data Design solutions for securing applications Evaluate the security posture of existing application portfolios Evaluate threats to business-critical applications by using threat modeling Design and implement a full lifecycle strategy for application security Design and implement standards and practices for securing the application development process Map technologies to application security requirements Design a solution for workload identity to authenticate and access Azure cloud resources Design a solution for API management and security Design a solution for secure access to applications, including Azure Web Application Firewall (WAF) and Azure Front Door Design solutions for securing an organization’s data Design a solution for data discovery and classification by using Microsoft Purview data governance solutions Specify priorities for mitigating threats to data Design a solution for protection of data at rest, data in motion, and data in use Design a security solution for data in Azure workloads, including Azure SQL, Azure Synapse Analytics, and Azure Cosmos DB Design a security solution for data in Azure Storage Design a security solution that includes Microsoft Defender for Storage and Microsoft Defender for SQL
Sample Questions and Answers
New Topic: Topic 1, Fabrikam, Inc Case Study 1 OverView Fabrikam, Inc. is an insurance company that has a main office in New York and a branch office in Paris. On-premises Environment The on-premises network contains a single Active Directory Domain Services (AD DS) domain named corp.fabrikam.com. Azure Environment Fabrikam has the following Azure resources: An Azure Active Directory (Azure AD) tenant named fabrikam.onmicrosoft.com that syncs with corp.fabnkam.com A single Azure subscription named Sub1 A virtual network named Vnet1 in the East US Azure region A virtual network named Vnet2 in the West Europe Azure region An instance of Azure Front Door named FD1 that has Azure Web Application Firewall (WAR enabled A Microsoft Sentinel workspace An Azure SQL database named ClaimsDB that contains a table named ClaimDetails 20 virtual machines that are configured as application servers and are NOT onboarded to Microsoft Defender for Cloud A resource group named TestRG that is used for testing purposes only An Azure Virtual Desktop host pool that contains personal assigned session hosts All the resources in Sub1 are in either the East US or the West Europe region. Partners Fabrikam has contracted a company named Contoso, Ltd. to develop applications. Contoso has the following infrastructure-. An Azure AD tenant named contoso.onmicrosoft.com An Amazon Web Services (AWS) implementation named ContosoAWS1 that contains AWS EC2 instances used to host test workloads for the applications of Fabrikam Developers at Contoso will connect to the resources of Fabrikam to test or update applications. The developers will be added to a security Group named Contoso Developers in fabrikam.onmicrosoft.com that will be assigned to roles in Sub1. The ContosoDevelopers group is assigned the db.owner role for the ClaimsDB database. Compliance Event Fabrikam deploys the following compliance environment: Defender for Cloud is configured to assess all the resources in Sub1 for compliance to the HIPAA HITRUST standard. Currently, resources that are noncompliant with the HIPAA HITRUST standard are remediated manually. Qualys is used as the standard vulnerability assessment tool for servers. Problem Statements The secure score in Defender for Cloud shows that all the virtual machines generate the following recommendation-. Machines should have a vulnerability assessment solution. All the virtual machines must be compliant in Defender for Cloud. ClaimApp Deployment Fabrikam plans to implement an internet-accessible application named ClaimsApp that will have the following specification ClaimsApp will be deployed to Azure App Service instances that connect to Vnetl and Vnet2. Users will connect to ClaimsApp by using a URL of https://claims.fabrikam.com. ClaimsApp will access data in ClaimsDB. ClaimsDB must be accessible only from Azure virtual networks. The app services permission for ClaimsApp must be assigned to ClaimsDB. Application Development Requirements Fabrikam identifies the following requirements for application development: Azure DevTest labs will be used by developers for testing. All the application code must be stored in GitHub Enterprise. Azure Pipelines will be used to manage application deployments. All application code changes must be scanned for security vulnerabilities, including application code or configuration files that contain secrets in clear text. Scanning must be done at the time the code is pushed to a repository. Security Requirement Fabrikam identifies the following security requirements: Internet-accessible applications must prevent connections that originate in North Korea. Only members of a group named InfraSec must be allowed to configure network security groups (NSGs} and instances of Azure Firewall, VJM. And Front Door in Sub1. Administrators must connect to a secure host to perform any remote administration of the virtual machines. The secure host must be provisioned from a custom operating system image. AWS Requirements Fabrikam identifies the following security requirements for the data hosted in ContosoAWSV. Notify security administrators at Fabrikam if any AWS EC2 instances are noncompliant with secure score recommendations. Ensure that the security administrators can query AWS service logs directly from the Azure environment. Contoso Developer Requirements Fabrikam identifies the following requirements for the Contoso developers; Every month, the membership of the ContosoDevelopers group must be verified. The Contoso developers must use their existing contoso.onmicrosoft.com credentials to access the resources in Sub1. The Comoro developers must be prevented from viewing the data in a column named MedicalHistory in the ClaimDetails table. Compliance Requirement Fabrikam wants to automatically remediate the virtual machines in Sub1 to be compliant with the HIPPA HITRUST standard. The virtual machines in TestRG must be excluded from the compliance assessment. QUESTION 1 You need to recommend a solution to meet the security requirements for the InfraSec group. What should you use to delegate the access?
A. a subscription B. a custom role-based access control (RBAC) role C. a resource group D. a management group
Answer: B
QUESTION 2 You need to recommend a solution to scan the application code. The solution must meet the application development requirements. What should you include in the recommendation?
A. Azure Key Vault B. GitHub Advanced Security C. Application Insights in Azure Monitor D. Azure DevTest Labs
Answer: B
QUESTION 3 You need to recommend a solution to resolve the virtual machine issue. What should you include in the recommendation? (Choose Two) A. Onboard the virtual machines to Microsoft Defender for Endpoint. B. Onboard the virtual machines to Azure Arc. C. Create a device compliance policy in Microsoft Endpoint Manager. D. Enable the Qualys scanner in Defender for Cloud.
Answer: A, B
QUESTION 4 HOTSPOT What should you create in Azure AD to meet the Contoso developer requirements? Answer: Box 1: A synced user account – Need to use a synched user account. Box 2: An access review
QUESTION 5 HOTSPOT You are evaluating the security of ClaimsApp. For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE; Each correct selection is worth one point. Answer: Explanation: QUESTION 6 You need to recommend a solution to secure the MedicalHistory data in the ClaimsDetail table. The solution must meet the Contoso developer requirements. What should you include in the recommendation?
A. Transparent Data Encryption (TDE) B. Always Encrypted C. row-level security (RLS) D. dynamic data masking E. data classification
Answer: D
QUESTION 7 HOTSPOT You need to recommend a solution to meet the AWS requirements. What should you include in the recommendation? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. Answer: QUESTION 8 You need to recommend a solution to meet the security requirements for the virtual machines. What should you include in the recommendation?
A. an Azure Bastion host B. a network security group (NSG) C. just-in-time (JIT) VM access D. Azure Virtual Desktop
Answer: A
QUESTION 9 HOTSPOT You need to recommend a solution to meet the requirements for connections to ClaimsDB. What should you recommend using for each requirement? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. Answer: Explanation: QUESTION 10 HOTSPOT You need to recommend a solution to meet the compliance requirements. What should you recommend? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.
Security and Governance: Implementing security measures. Managing access and permissions.
Administration and Deployment: Lifecycle management. Environment management.
Remember, these are general areas that may be covered in the PL-300 exam. For the most accurate and up-to-date information, it’s recommended to refer to the official Microsoft documentation and the skills measured section on the exam page.
Updates to the exam Our exams are updated periodically to reflect skills that are required to perform a role. We have included two versions of the Skills Measured objectives depending on when you are taking the exam.
We always update the English language version of the exam first. Some exams are localized into other languages, and those are updated approximately eight weeks after the English version is updated. Although Microsoft makes every effort to update localized versions as noted, there may be times when the localized versions of an exam are not updated on this schedule. Other available languages are listed in the Schedule Exam section of the Exam Details webpage. If the exam isn’t available in your preferred language, you can request an additional 30 minutes to complete the exam.
Note The bullets that follow each of the skills measured are intended to illustrate how we are assessing that skill. Related topics may be covered in the exam.
Note Most questions cover features that are general availability (GA). The exam may contain questions on Preview features if those features are commonly used.
Skills measured as of February 6, 2024
Audience profile As a candidate for this exam, you should deliver actionable insights by working with available data and applying domain expertise. You should:
Provide meaningful business value through easy-to-comprehend data visualizations. Enable others to perform self-service analytics. 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 should be proficient at using Power Query and writing expressions by using Data Analysis Expressions (DAX). You know how to assess data quality. Plus, you understand data security, including row-level security and data sensitivity.
Skills at a glance Prepare the data (25–30%) Model the data (25–30%) Visualize and analyze the data (25–30%) Deploy and maintain items (15–20%)
Prepare the data (25–30%) Get data from data sources Identify and connect to a data source Change data source settings, including credentials, privacy levels, and data source locations Select a shared semantic model, or create a local data model Choose between DirectQuery, Import, and Dual mode Change the value in a parameter Clean the data Evaluate data, including data statistics and column properties Resolve inconsistencies, unexpected or null values, and data quality issues Resolve data import errors Transform and load the data Select appropriate column data types Create and transform columns Transform a query Design a star schema that contains facts and dimensions Identify when to use reference or duplicate queries and the resulting impact Merge and append queries Identify and create appropriate keys for relationships Configure data loading for queries
Model the data (25–30%) Design and implement a data model Configure table and column properties Implement role-playing dimensions Define a relationship’s cardinality and cross-filter direction Create a common date table Implement row-level security roles Create model calculations by using DAX Create single aggregation measures Use CALCULATE to manipulate filters Implement time intelligence measures Identify implicit measures and replace with explicit measures Use basic statistical functions Create semi-additive measures Create a measure by using quick measures Create calculated tables Optimize model performance Improve performance by identifying and removing unnecessary rows and columns Identify poorly performing measures, relationships, and visuals by using Performance Analyzer Improve performance by choosing optimal data types Improve performance by summarizing data
Visualize and analyze the data (25–30%) Create reports Identify and implement appropriate visualizations Format and configure visualizations Use a custom visual Apply and customize a theme Configure conditional formatting Apply slicing and filtering Configure the report page Use the Analyze in Excel feature Choose when to use a paginated report Enhance reports for usability and storytelling Configure bookmarks Create custom tooltips Edit and configure interactions between visuals Configure navigation for a report Apply sorting Configure sync slicers Group and layer visuals by using the Selection pane Drill down into data using interactive visuals Configure export of report content, and perform an export Design reports for mobile devices Identify patterns and trends Use the Analyze feature in Power BI Use grouping, binning, and clustering Incorporate the Q&A feature in a report Use AI visuals Use reference lines, error bars, and forecasting Detect outliers and anomalies Create and share scorecards and metrics
Deploy and maintain items (15–20%) Create and manage workspaces and items Create and configure a workspace Assign workspace roles Configure and update a workspace app Publish, import, or update items in a workspace Create dashboards Choose a distribution method Apply sensitivity labels to workspace content Configure subscriptions and data alerts Promote or certify Power BI content Manage global options for files Manage semantic models Identify when a gateway is required Configure a semantic model scheduled refresh Configure row-level security group membership Provide access to semantic models
Sample Questions and Answers Version: 13.0 New Topic: Topic 1, Litware, Inc. Case Study Overview This is a case study. Case studies are not timed separately. You can use as much exam time as you would like to complete each case. However, there may be additional case studies and sections on this exam. You must manage your time to ensure that you are able to complete all questions included on this exam in the time provided. To answer the questions included in a case study, you will need to reference information that is provided in the case study. Case studies might contain exhibits and other resources that provide more information about the scenario that is described in the case study. Each question is independent of the other questions in this case study. At the end of this case study, a review screen will appear. This screen allows you to review your answers and to make changes before you move to the next section of the exam. After you begin a new section, you cannot return to this section. To start the case study To display the first question in this case study, click the Next button. Use the buttons in the left pane to explore the content of the case study before you answer the questions. Clicking these buttons displays information such as business requirements, existing environment and problem statements. If the case study has an All Information tab, note that the information displayed is identical to the information displayed on the subsequent tabs. When you are ready to answer a question, click the Question button to return to the question. Overview Litware, Inc. is an online retailer that uses Microsoft Power Bl dashboards and reports. The company plans to leverage data from Microsoft SQL Server databases, Microsoft Excel files, text files, and several other data sources. Litware uses Azure Active Directory (Azure AD) to authenticate users. – Existing Environment Sales Data Litware has online sales data that has the SQL schema shown in the following table. In the Date table, the dateid column has a format of yyyymmdd and the month column has a format of yyyymm. The week column in the Date table and the weekid column in the Weekly_Returns table have a format of yyyyww. The regionid column can be managed by only one sales manager. Data Concerns You are concerned with the quality and completeness of the sales data. You plan to verify the sales data for negative sales amounts. Reporting Requirements Litware identifies the following technical requirements: Executives require a visual that shows sales by region. Regional managers require a visual to analyze weekly sales and returns. Sales managers must be able to see the sales data of their respective region only. The sales managers require a visual to analyze sales performance versus sales targets. The sale department requires reports that contain the number of sales transactions. Users must be able to see the month in reports as shown in the following example: Feb 2020. The customer service department requires a visual that can be filtered by both sales month and ship month independently. QUESTION 1 You need to address the data concerns before creating the data model. What should you do in Power Query Editor?
A. Select Column distribution. B. Select the sales_amount column and apply a number filter. C. Select Column profile, and then select the sales_amount column. D. Transform the sales_amount column to replace negative values with 0.
Answer: C
QUESTION 2 You need to create a calculated column to display the month based on the reporting requirements. Which DAX expression should you use?
A. FORMAT(‘Date'[date], “MMM YYYY”) B. FORMAT(‘Date’ [date], “M YY”) C. FORMAT(‘Date'[date_id], “MMM”) & “” & FORMAT(‘Date'[year], “#”) D. FORMAT(‘Date’ [date_id], “MMM YYYY”)
Answer: A
QUESTION 3 You need to create the required relationship for the executive’s visual. What should you do before you can create the relationship?
A. Change the data type of Sales[region_id] to Whole Number. B. In the Sales table, add a measure for sum(sales_amount). C. Change the data type of sales[sales_id] to Text. D. Change the data type of sales [region_id] to Decimal Number.
Answer: A Scenario: Executives require a visual that shows sales by region. Need to change the sales_id column from Varchar to Whole Number (Integer).
QUESTION 4 What should you create to meet the reporting requirements of the sales department?
A. a measure that uses a formula of SUM (Sales [sales_id]) B. a calculated column that use a formula of COUNTA(sales [sales_id]) C. a measure that uses a formula of COUNTROWS (Sales) D. a calculated column that uses a formula of SUM (Sales [sales_id])
Answer: C
Explanation: The sale department requires reports that contain the number of sales transactions. The COUNTROWS function counts the number of rows in the specified table, or in a table defined by an expression.
QUESTION 5 You need to create a relationship between the Weekly_Returns table and the Date table to meet the reporting requirements of the regional managers. What should you do?
A. In the Weekly.Returns table, create a new calculated column named date-id in a format of yyyymmdd and use the calculated column to create a relationship to the Date table. B. Add the Weekly_Returns data to the Sales table by using related DAX functions. C. Create a new table based on the Date table where date-id is unique, and then create a many-tomany relationship to Weekly_Return.
Answer: A
Explanation: Scenario: Region managers require a visual to analyze weekly sales and returns. To relate the two tables we need a common column.
QUESTION 6 HOTSPOT You need to create a visualization to meet the reporting requirements of the sales managers. How should you create the visualization? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. Answer: Explanation: Scenario: The sales managers require a visual to analyze sales performance versus sales targets. Box 1: KPI A Key Performance Indicator (KPI) is a visual cue that communicates the amount of progress made toward a measurable goal. Box 2: Sales[sales_amount] Box 3: Date[month] Time > FiscalMonth. This value will represent the trend. Box 4: Targets[sales_target] QUESTION 7 You need to provide a solution to provide the sales managers with the required access. What should you include in the solution?
A. Create a security role that has a table filter on the Sales_Manager table where username = UserName() B. Create a security role that has a table filter on the Region_Manager table where sales_manager_id = UserPrincipalName(). C. Create a security role that has a table filter on the Sales_Manager table where name = UserName(). D. Create a security role that has a table filter on the Sales_Manager table where username = sales_manager_id.
Answer: A
QUESTION 8 You need to create relationships to meet the reporting requirements of the customer service department. What should you create?
A. an additional date table named ShipDate, a one-to-many relationship from Sales[sales_date_id] to Date[date_id], and a one-to-many relationship from Sales[sales_ship_date_id] to ShipDate[date_id] B. an additional date table named ShipDate, a many-to-many relationship from Sales[sales_date_id] to Date[date_id], and a many-to-many relationship from Sales[sales_ship_date_id] to ShipDate[date_id] C. a one-to-many relationship from Date[date_id] to Sales[sales_date_id] and another one-to-many relationship from Date[date_id] to Weekly_Returns[week_id] D. a one-to-many relationship from Sales[sales_date_id] to Date[date_id] and a one-to-many relationship from Sales[sales_ship_date_id] to Date[date_id] E. a one-to-many relationship from Date[date_id] to Sales[sales_date_id] and another one-to-many relationship from Date[date_id] to Sales[sales_ship_date_id]
Answer: A
Explanation: Scenario: The customer service department requires a visual that can be filtered by both sales month and ship month independently.
QUESTION 9 HOTSPOT You publish the dataset to powerbi.com. For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point. Answer: Explanation:
QUESTION 10 You need to get data from the Microsoft SQL Server tables. What should you use to configure the connection’
A. import that uses a Microsoft account B. DirectQuery that uses the end-user s credentials C. DirectQuery that uses a database credential D. Import that uses a database credential
The PL-200 exam is crucial for aspiring Microsoft Power Platform Functional Consultants. To succeed, candidates should focus on understanding PL-200 exam details, including objectives and updates. Utilize reliable study materials, practice questions, and official Microsoft Learning resources to prepare effectively for this certification, ensuring a comprehensive grasp of Power Platform concepts.
Updates to the exam Our exams are updated periodically to reflect skills that are required to perform a role. We have included two versions of the Skills Measured objectives depending on when you are taking the exam.
We always update the English language version of the exam first. Some exams are localized into other languages, and those are updated approximately eight weeks after the English version is updated. While Microsoft makes every effort to update localized versions as noted, there may be times when the localized versions of an exam are not updated on this schedule. Other available languages are listed in the Schedule Exam section of the Exam Details webpage. If the exam isn’t available in your preferred language, you can request an additional 30 minutes to complete the exam.
Note The bullets that follow each of the skills measured are intended to illustrate how we are assessing that skill. Related topics may be covered in the exam.
Note Most questions cover features that are general availability (GA). The exam may contain questions on Preview features if those features are commonly used.
Skills measured as of January 12, 2024
Audience profile As a candidate for this exam, you: Perform discovery. Capture requirements. Engage subject matter experts and stakeholders. Configure business solutions by using Microsoft Power Platform tools and components. You create: Application enhancements Tailored user experiences Process automation
As a candidate, you implement the design provided by and in collaboration with a solution architect and the standards, branding, and artifacts established by user experience designers. You implement integrations with third-party applications and services. You generate training documentation, and you facilitate training and enablement.
You must interact and effectively communicate with members of a delivery team, stakeholders, and customer teams while championing for their success. You must have an understanding of application lifecycle management (ALM) practices for Microsoft Power Platform and quality assurance.
You should be familiar with using the following Microsoft Power Platform components:
Microsoft Dataverse Microsoft Power Apps Microsoft Power Automate cloud flows Microsoft Power Pages Microsoft Power Platform environments You should have proficiency in: Data modeling User experience design Requirements analysis
Skills at a glance Configure Microsoft Dataverse (25–30%) Create apps by using Microsoft Power Apps (25–30%) Create and manage logic and process automation (25–30%) Manage environments (15–20%)
Configure Microsoft Dataverse (25–30%) Manage the data model Create or modify standard, activity, or virtual tables Create new tables or modify existing tables Determine which type of relationship to implement, including one-to-many and many-to-many Configure table relationships including behaviors and cascading rules Create new or modify existing columns, including calculated, rollup, and formula Configure table properties Manage Dataverse Configure Dataverse search, and manage the search index Manage auditing Describe options for importing and exporting data Configure duplicate detection settings Configure bulk deletion Configure security settings Manage business units Create and manage security roles Create and manage users and teams Create and manage column security Configure hierarchy security Configure Microsoft Entra ID group teams
Create apps by using Microsoft Power Apps (25–30%) Create model-driven apps Create and configure multiple form types Use controls in the form designer Create and configure views Configure custom pages Configure modern commanding by using Power Fx Embed a canvas app in a model-driven app form Add Microsoft Power BI dashboards and reports in a model-driven app Describe canvas apps Describe canvas app structure Describe form navigation, formulas, variables and collections, and error handling Describe how Microsoft Power Automate flows are called from a canvas app Build Microsoft Power Pages Configure pages, forms, and navigation Describe advanced Power Pages features, including document management, search, multi-step forms, and Power BI Configure website security including web roles and page access Describe use cases for templates Describe authentication options
Create and manage logic and process automation (25–30%) Create and manage cloud flows Describe types of flows, use cases, and flow components, including when to use a classic workflow Describe components of a connector Implement logic controls including branches, loops, conditions, error handling, and variables Implement dynamic content and expressions Work with the Dataverse connector Manage and troubleshoot flows Create and manage business process flows Configure a business process flow Add stages, workflows, and flow steps to a business process flow Manage the business process flow table for a business process flow Create and manage classic Dataverse workflows Configure a workflow Troubleshoot workflows Manage workflow logs Implement low-code logic Configure low-code plug-ins Write and use Power Fx functions and formulas Create and configure business rules
Manage environments (15–20%) Participate in application lifecycle management (ALM) Describe use cases for app checker and solution checker Create and manage Dataverse solutions Describe the difference between managed and unmanaged Dataverse solutions Manage Microsoft Power Platform environments for development Import and export Dataverse solutions Manage interoperability with other services Configure email integration Configure Microsoft SharePoint integration Describe options for document management Work with Microsoft Word templates
Sample Questions and Answers
Background Alpine SKi House is a boutique mountain resort that offers year-round spa and outdoor activities such as snow sports, hiking, mountain biking, and more. The resort has been family owned and operated for more than 50 years. The company has been able to remain profitable while not needing to adopt new technologies.
General Booking at the resort have decreased. The company has decided to focus on creating a tailored, firstclass experience for guest. The company also plans to target corporate meetings and events. The company recently purchased a chatbot named FAQbot from AppSoure. The chatbot uses the resort’s existing FAQS Communication * Communication between staff members is primarily conducted through email and SMS text messages. * Conversations between staff members and guest often lost. * Conference calls are used for all group meeting
Event Registration * Corporate customers can reserve a meeting room at the resort to host meetings. The meetings will include lunch and choice of either an inside-spa experience or a seasonally appropriate outdoor activity. * Event registration is conducted three weeks prior to start of the event. It is assumed that all event attendees will attend the meeting Check-in process * Guests wait in lines to check in and obtain name badges. At this time, guests can specify any dietary restrictions and select their activity preference. This can result in long wait times and crowding at the front desk. * For health and compliance reasons, guests must answer a series of questions with a yes or no answer during check-in. The front desk will ask and record these answers for the resort’s records.
Marketing At the check-in counter, the guests can drop their business cards into a bowl for a chance to win an all-inclusive weekend stay at the resort. The resort uses the business card information to send announcements about promotions and upcoming events.
Resort policies and event inquiries * A guest can call or send an email to the event coordinator at the resort to get information about hotel policies, snow conditions, or to pre-select their after-meeting event; * Guests can also go to the website to view the extensive list of frequently asked questions (FAQ) compiled over the years. Many of the answers to the FAQ’s are out of date.
General Alpine Ski House does not employ technical staff and does not have the budget to hire an external firm to develop solutions. There are two team members who are proficient at Microsoft Excel formulas. Any solution created must use the capabilities of current team members. All solutions must be simple to use, easy to maintain, and represent the brand of the resort. You must implement the following solutions: * a centrally managed communication solution * a customer service solution * a resort portal * a chat solution * a check-in solution Communication * Communication between team members must be centrally managed and unified in Microsoft Teams. * When the company confirms an event they, must provide a list of guest’s names and email addresses. * You must send guests a welcome email that includes a unique registration number for authentication with the resort’s portal. * Guests must receive a separate email to verify proof of ownership for their registration. Event attendance * Guests must create an account and sign into a resort portal to confirm their attendance to an event and pre-select an after-meeting event * Prior to the event, guests must be able to identify any personal dietary restrictions. Check-in processes * Check-in processes must be self-service. Each screen must ask for specific data from the guest. The check-in solution will use some data that is stored in Microsoft Excel. * The check-in solution must continue to function if there are internet issues. If the self-service kiosks are not available, staff must be able to use the check-in solution from within their communication solution. * The check-in solution must have a screen where the guest will select either yes or no to health and wellness questions. * Guests must physically interact with each answer before proceeding to the next screen. Guests must be able to confirm any dietary restrictions they may have entered from the portal or add new ones at this time. * Data must be entered in each screen before users move on to the next screen. Marketing * To eliminate the handling of business cards, the check-in solution must be able to translate the contents of the business cards into Alpine Ski House’s marketing system. * The solution must not require any effort or manual entry from the guest to prevent any mistyped information and to make it more appealing to the guest to participate. Hotel policies and event inquiries The portal must allow the guest to ask questions about hotel policies, event information, weather reports, and current weather condition at the resort. Chat solution The chat solution must specifically address the following key words. No additional key words will be added until a later implementation phase: * Snow reports * Weather conditions * Start time * End time * Event date * Outdoor activities * Indoor activities * Most popular The chat solution must be available always and not require staff to answer all of the questions. If a question does require a staff member’s attention, the solution must determine which staff member is best to assist the customer with the question. The information in the FAQ on the legacy website must be used in the chat solution but retyping all the data from the website should not be required. If quests ask about topics that are not listed in the FAQ, the chat solution must identify the issue and escalate to a staff member. Team members must be able to ask their own questions through a centrally managed communication solution instead of using the guest portal. Team members must be able to access the same FAQ across multiple solutions. Issue Guest1 inquires about snow conditions several times each day of their stay. QUESTION 1 You need to create the FAQ solution content What should you do first?
A. Al Builder B. Suggest topics C. Automate D. Trigger phrases
Explanation:
Answer: B You need to make sure there are three main steps need to do while doing import FAQ and add the topic to your bot application. Import Suggested Topics from FAQ webpage. Add a topic. Enable the topics
QUESTION 2 HOTSPOT You need to design the resort portal’s email registration process. Which solutions should you use? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. Explanation: Answer:
QUESTION 3 You need to design the resort portal to meet the business requirements. Which data source should you use?
A. Microsoft Excel B. Azure SQL Database C. SQL Server D. Common Data Service
Answer: A
QUESTION 4 HOTSPOT You need to design and create the solution for gathering contact information from guests for marketing purposes. What should you use? To answer, select the appropriate options In the answer area. NOTE: Each correct selection is worth one point. Explanation: Answer:
QUESTION 5 HOTSPOT You need to embed the check-in solution into the communication solution. To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. Explanation: Answer: Box 1: Power Apps Web Studio Scenario: The check-in solution must continue to function if there are internet issues. If the selfservice kiosks are not available, staff must be able to use the check-in solution from within their communication solution. PowerApps Studio is a browser application used to edit your apps. PowerApps Studio includes a drag-and-drop canvas in the center of the screen and a screen or object list pane on the left. Properties, Rules, and Advanced Properties for selected screens or controls are displayed in the right pane. Box 2: in a tab You can customize the Teams experience by adding Power Apps canvas apps to your channels in Teams using the PowerApps tab.
QUESTION 6 HOTSPOT You need to design the guest check-in solution. Which technologies should you use? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. Answer: Explanation: Canvas app, Power Apps mobile app
QUESTION 7 You need to add controls to the check-in solution for the health and wellness questions. Which form control should you use? A. Drop down B. Check box C. Text input
Answer: A
QUESTION 8 You need to design the resort portal’s email registration process. Which solution should you use?
A. Default the invitation code from the email upon logging into the portal B. Auto-populate the invitation code field on the sign in screen from the email link C. Embed the invitation code in the email link URL D. Send the customer their username and temporary password in the email link
Answer: C Scenario: Guests must receive a separate email to verify proof of ownership for their registration. Note: You can setup redeem an invitation code for power apps portal.
QUESTION 9 HOTSPOT A guest asks about the start time of a specific scheduled event and wants to know what the snow conditions will be like during their stay. You need to determine how to design the chat solution to answer those questions. What should you do? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. Explanation: Answer: Box 1: Load the extracted topic into a variable Power Virtual Agents uses entities to understand and identify a specific type of information from a user’s responses. When saving the identified information to a variable, a variable type will be associated with it. The variable type is analogous with the entity. In Power Virtual Agents, a topic defines a how a bot conversation plays out. A topic has trigger phrases – these are phrases, keywords, or questions that a user is likely to type that is related to a specific issue – and conversation nodes – these are what you use to define how a bot should respond and what it should do. Box 2: Create a custom entity The prebuilt entities cover commonly used information types, but on some occasions, such as when building a bot that serves a specific purpose, you’ll need to teach the bot’s language understanding model some domain-specific knowledge.
QUESTION 10 You need to design the chat solution to answer the inquiry from Guest1. Which three components can you use? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.
A. Variables B. Escalations C. Smart match D. Synonyms E. Topics
Answer: ACD Scenario: Guest1 inquires about snow conditions several times during each day of their stay. Variables let you save responses from your customers in a conversation with your bot so that you can reuse them later in the conversation. Synonyms allows you to manually expand the matching logic by adding synonyms. Smart match and synonyms seamlessly work together to make your bot even smarter. Reference: QUESTION 11 You need to embed the business card solution in the check-in app. What you use?
A. control B. Button control C. Custom component D. Al Builder component
Preparing for the MS-700 exam requires a comprehensive approach. Utilize official documentation and a reliable study guide for effective MS-700 exam preparation. Avoid the temptation of MS-700 exam dumps, as they violate certification terms. Practice tests, exam questions, and a Microsoft Teams administrator certification can enhance your readiness for success.
Updates to the exam Our exams are updated periodically to reflect skills that are required to perform a role. We have included two versions of the Skills Measured objectives depending on when you are taking the exam.
We always update the English language version of the exam first. Some exams are localized into other languages, and those are updated approximately eight weeks after the English version is updated. While Microsoft makes every effort to update localized versions as noted, there may be times when the localized versions of an exam are not updated on this schedule. Other available languages are listed in the Schedule Exam section of the Exam Details webpage. If the exam isn’t available in your preferred language, you can request an additional 30 minutes to complete the exam.
Note The bullets that follow each of the skills measured are intended to illustrate how we are assessing that skill. Related topics may be covered in the exam.
Note Most questions cover features that are general availability (GA). The exam may contain questions on Preview features if those features are commonly used.
Skills measured as of January 30, 2024
Audience profile As a Microsoft Teams administrator, you manage and maintain internal and external collaboration and communication solutions using Teams and Microsoft 365. You’re responsible for configuring and managing teams, channels, chat, apps, calling, meetings, and events. You manage: Phone numbers and services for Teams Phone. Operational aspects of Teams clients and devices. You collaborate with owners of other workloads, including: Networking Identity Licensing Information management
User adoption You work with collaboration and communication system engineers to implement advanced Teams Phone and Teams Rooms scenarios. You plan and implement governance, security, and compliance for Teams. As a candidate for this exam, you should have a working knowledge of Microsoft 365 services, including: Microsoft 365 groups Microsoft SharePoint Online OneDrive Exchange Microsoft Entra ID You should understand the options for integrating and extending Teams with other apps, including: Microsoft Viva Power Platform Third-party apps Custom apps
Skills at a glance Configure and manage a Teams environment (45–50%) Manage teams, channels, chats, and apps (20–25%) Manage meetings and calling (15–20%) Monitor, report on, and troubleshoot Teams (10–15%)
Configure and manage a Teams environment (45–50%) lan and configure network settings for Teams Calculate network bandwidth capacity for Teams voice, video, meetings, and live events Analyze network impact by using Network planner Specify network ports and protocols used by Teams Specify optimal network architecture for Teams Assess network readiness and connectivity by using the Microsoft Teams Network Assessment Tool and Microsoft 365 network connectivity test tool Manage security and compliance settings for Teams Identify licensing requirements for security and compliance features Specify security and compliance alert policies for Teams Choose appropriate Teams administrator roles Plan and configure Enhanced encryption policies Plan and configure threat policies in Microsoft 365 Defender Plan and configure retention policies Plan and configure sensitivity labels and policies Plan and configure data loss prevention (DLP) policies Plan Conditional Access for Teams Plan and configure information barrier (IB) policies Identify appropriate use cases for communication compliance and insider risk management Plan and implement governance and lifecycle management Identify licensing requirements for advanced lifecycle management of teams Identify where Teams stores content Plan and manage update policies, including Public Preview, Office Insider, and Targeted release Create and manage policy packages in Teams Plan and configure policy assignment for users and groups Configure settings for Microsoft 365 group creation Configure an expiration policy for Microsoft 365 groups Configure a naming policy for Microsoft 365 groups, including blocked words Archive, delete, or unarchive one or more teams Restore or troubleshoot the deletion of a Microsoft 365 group Identify when to use Microsoft Entra Access reviews for Teams and Groups. Perform operations for Teams by using PowerShell Configure and manage external collaboration Identify licensing requirements for external collaboration Configure SharePoint Online and OneDrive external sharing settings Configure External access in the Microsoft Teams admin center Configure External collaboration settings in Microsoft Entra ID for guest access Configure guest access and sharing in the Microsoft Teams admin center, Microsoft 365 admin center, or Microsoft Entra admin center Control guest access to a specific team, including sensitivity labels and Microsoft Entra ID Remove guests from Teams, including from a team or a tenant Configure shared channels for external access Configure and manage cross-tenant access for B2B direct connect in Microsoft Entra ID for shared channels Manage Teams clients and devices Identify licensing requirements for Teams Phone and resource accounts Identify licensing requirements for Teams devices Manage configuration profiles for Teams devices Configure Teams Rooms accounts and systems Manage device settings and firmware Manage Teams device tags Provision and configure remote sign-in for new devices
Manage teams, channels, chats, and apps (20–25%) Create and manage teams Plan for a Microsoft Teams rollout by using Advisor for Teams Create a team by using the Microsoft Teams admin center, Teams client, or the Teams PowerShell module Create a team from an existing Microsoft 365 group, SharePoint site, or team Create a team from a template Create and manage Teams templates and template policies Manage the membership of a team Assign and modify user roles in a team Manage a team in the Microsoft Teams admin center Manage Teams environment settings in the Microsoft Teams admin center Configure privacy and sensitivity settings for Teams Manage channels and chats Recommend channel types, including standard, private, and shared Add, edit, and remove channels Manage Teams channel settings Create and manage teams policies for channels Manage private and shared channel membership Create and manage messaging policies Manage apps for Teams Manage Org-wide app settings in the Microsoft Teams admin center Create and manage app permission policies Create and manage app setup policies Manage permissions and consent for apps, including blocking apps Recommend appropriate extensibility options, including apps, connectors, tabs, meetings, and messaging extensions Manage purchasing of apps in the Teams app store Customize the appearance of the Teams app store Customize the branded experience of an app Upload an app to Teams
Manage meetings and calling (15–20%) Manage meetings and events Recommend meeting types, including live events, webinars, and virtual appointments Enable enhanced meeting features for a user by assigning Microsoft Teams Premium licenses Configure meeting settings Create and manage meeting templates and template policies Create and manage meeting policies Create and manage conference bridges Create and manage audio conferencing policies Plan and configure live events settings and policies Manage phone numbers and services for Teams Phone Evaluate Public Switched Telephone Network (PSTN) options, including Calling Plan, Direct Routing, Operator Connect, and Teams Phone Mobile Add, change, or remove an emergency address for an organization Provision and manage phone numbers for users, services, and conferencing bridges Assign, change, or remove a phone number for a user or a resource account Create and manage resource accounts in the Microsoft Teams admin center Manage voice settings and policies for users Create and manage voicemail policies Configure auto-attendants and call queues Create and manage calling policies
Monitor, report on, and troubleshoot Teams (10–15%) Monitor and report on Teams Monitor and report on voice and meeting quality Report on Teams usage, including team activity, app usage, active users, per-meeting metrics, and storage usage Monitor and report on the creation and deletion of teams Monitor and report on guest access Monitor the Microsoft 365 network connectivity test tool Manage feedback policies Troubleshoot audio, video, and client issues Collect client-side logs Clear the Teams client cache Troubleshoot issues by using self-help diagnostics for Teams Troubleshoot Team client installation and update issues Troubleshoot sign-in issues to Teams
Sample Questions and Answers
New Topic: Topic 1, Contoso, Ltd Overview This is a case study. Case studies are not timed separately. You can use as much exam time as you would like to complete each case. However, there may be additional case studies and sections on this exam. You must manage your time to ensure that you are able to complete all questions included on this exam in the time provided. To answer the questions included in a case study, you will need to reference information that is provided in the case study. Case studies might contain exhibits and other resources that provide more information about the scenario that is described in the case study. Each question is independent of the other questions in this case study. At the end of this case study, a review screen will appear. This screen allows you to review your answers and to make changes before you move to the next section of the exam. After you begin a new section, you cannot return to this section. To start the case study To display the first question in this case study, click the Next button. Use the buttons in the left pane to explore the content of the case study before you answer the questions. Clicking these buttons displays information such as business requirement, existing environment, and problem statements. If the case study has an All Information tab, note that the information displayed is identical to the information displayed on the subsequent tabs. When you are ready to answer a question, click the Question button to return to the question. Overview Contoso, Ltd. is a pharmaceutical company that has 3,000 users in offices across North America. Existing Environment Active Directory The network contains an on-premises Active Directory domain. All user accounts are in departmental organizational units (OUs). Microsoft Office 365 All users are assigned a Microsoft Office 365 E5 license and are enabled for the following services: Microsoft Yammer Microsoft Exchange Online Microsoft SharePoint Online Microsoft OneDrive for Business Azure Active Directory (Azure AD) Azure AD dynamic group membership Microsoft Skype for Business Contoso has an on-premises deployment of Microsoft Skype for Business Server 2015. All the latest cumulative updates are installed on all the servers. The following services are used in Skype for Business Server 2015: Meetings PSTN calling Instant messaging (IM) Federation to external companies Departments Contoso has the following departments: IT Sales Human resources (HR) Research and deployment (R&D) All groups are created by using dynamic group membership that use the department attribute. Requirements Business goals Contoso identifies the following business goals: Migrate the maximum number of users to Microsoft Teams. Minimize administrative effort. Device requirements Contoso identifies the following device requirements: Replace Skype for Business IP phones with Microsoft Teams phones. All Microsoft Teams phones must be set to lock automatically after 60 seconds. Meeting and Live Event Requirements Contoso identifies the following meeting and live event requirements: Requirement1: Guest users must be able to join live events. Requirement2: Guest users must always wait in a meeting lobby. Requirement3: Contoso users must always bypass the meeting lobby when they join by using the Microsoft Teams client. Requirement4: After the upgrade to Microsoft Teams, all meetings must be scheduled by using Microsoft Teams. Calling Requirements Contoso identifies the following calling requirements: Migrate all existing auto attendants and response groups to Office 365. Minimize the on-premises PSTN infrastructure. Technical Requirements Guest users must be prevented from making private calls. Security Requirements Contoso has the following security requirements for the Microsoft Teams deployment: The number of ports allowed on the company?s firewall must be limited. Team names must be prevented from containing the name of any products produced by Contoso. Users in the R&D group must be prevented from sending chat messages to users in other departments. To meet the company?s compliance policy, users in the sales department must continue to use onpremises Skype for Business for IM and calling only. Pilot Project Contoso begins a pilot project for the upgrade to Microsoft Teams. You identify the following issues during the pilot project: Microsoft Teams users report that they often receive continuous notifications from the Microsoft Teams client for 20 minutes. Two pilot users in the HR department report that they are not members of the HR team. QUESTION 1 You need to configure the environment to meet the security requirements for the R&D group. What should you do first?
A. Start the information barrier policy application. B. Add an identity provider. C. Create two information barrier segments. D. Create one information barrier policy.
Answer: C Explanation: Create information barrier segments first, then create information barrier policy based on the segments then start the information barrier application.
QUESTION 2 You need to configure the user accounts of the sales department users to meet the security requirements. What should you do for each user?
A. From the Microsoft Teams admin center, set the Microsoft Teams upgrade policy to Skype for Business with Teams collaboration and meetings coexistence mode. B. From PowerShell, run the Grant-CsTeamsUpgradePolicy -PolicyName SfBWithTeamsCollab cmdlet. C. From PowerShell, run the Grant-CsTeamsUpgradePolicy -PolicyName Islands cmdlet. D. From the Microsoft Teams admin center, set the Microsoft Teams upgrade policy to Skype for Business coexistence mode.
Answer: A
QUESTION 3 You need to resolve the notification issues identified during the pilot project. What should you modify?
A. the global meeting policy B. the global messaging policy C. the org-wide Teams settings D. the app permission policy
Answer: B
QUESTION 4 You need to configure the environment to meet the technical requirements for guest users. What should you modify from the Microsoft Teams admin center?
A. the global app permission policy B. the Org-wide settings C. the global meeting policy D. the global messaging policy
Answer: B
Explanation: Microsoft Teams admin center > Org-wide settings > Guest access > Make private calls = off.
QUESTION 5 You need to resolve the membership issues for the two pilot users. What should you do?
A. Modify the department attribute of both users. B. Invite both users to the HR team. C. Add both users to the HR group. D. Modify the privacy level of the HR team.
Answer: A QUESTION 6 HOTSPOT You need to recommend which inbound ports to the network and outbound ports to Office 365 must be allowed on the company?s firewall after the planned upgrade. The solution must meet the security requirements. Which inbound and outbound ports should you recommend? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.
Answer: Explanation:
QUESTION 7 You need to configure the user accounts of the sales department users to meet the security requirements. What should you do for each user?
A. From PowerShell, run the Grant-CsTeamsUpgradePolicy -PolicyName SfBWithTeamsCollabAndMeetings cmdlet. B. From the Microsoft Teams admin center, set the Microsoft Teams upgrade policy to Islands coexistence mode. C. From PowerShell, run the Grant-CsTeamsUpgradePolicy -PolicyName Islands cmdlet. D. From PowerShell, run the Grant-CsTeamsUpgradePolicy -PolicyName SfBOnly cmdlet.
Answer: A
QUESTION 8 You need to configure the environment to meet the security requirements for team names. What should you do?
A. From the Security & Compliance admin center, create a sensitivity label and a sensitivity policy. B. From the Microsoft Teams admin center, modify the Teams setting policies. C. From the Azure Active Directory admin center, upload a blocked word list for the group naming policy.
Answer: C
QUESTION 9 HOTSPOT During the pilot project, you review the global policies in the Microsoft Teams admin center. Contoso has a global meeting policy configured as shown in the following exhibit. Contoso has a global live events policy configured as shown in the following exhibit. For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point. Answer: Explanation:
QUESTION 10 You need to configure the environment to meet the device requirements for the Microsoft Teams phones. What should you do from the Microsoft Teams admin center?
A. Create a configuration profile B. Modify the Teams settings C. Create a meeting policy D. Create a calling policy
The MB-500 exam, focused on Microsoft Dynamics 365: Finance and Operations Apps Developer certification, demands thorough preparation. Aspiring candidates should explore study materials, practice questions, and the official syllabus to enhance their skills. Microsoft Learn offers valuable resources for effective exam preparation. Good luck in your journey towards becoming a certified Dynamics 365 FO Apps Developer!
Updates to the exam Our exams are updated periodically to reflect skills that are required to perform a role. We have included two versions of the Skills Measured objectives depending on when you are taking the exam.
We always update the English language version of the exam first. Some exams are localized into other languages, and those are updated approximately eight weeks after the English version is updated. While Microsoft makes every effort to update localized versions as noted, there may be times when the localized versions of an exam are not updated on this schedule. Other available languages are listed in the Schedule Exam section of the Exam Details webpage. If the exam isn’t available in your preferred language, you can request an additional 30 minutes to complete the exam.
Note The bullets that follow each of the skills measured are intended to illustrate how we are assessing that skill. Related topics may be covered in the exam. Note
Most questions cover features that are general availability (GA). The exam may contain questions on Preview features if those features are commonly used.
Audience profile As a candidate for this exam, you’re a developer who works with finance and operations apps in Microsoft Dynamics 365 to implement and extend applications that meet the requirements of a business. You provide fully realized solutions by using:
Standardized application coding patterns Extensible features External integrations As a candidate for this exam, you do the following: Develop business logic by using X++. Create and modify finance and operations app reports and workspaces. Customize the UI. Provide endpoints and APIs to support Microsoft Power Platform apps and external systems. Perform testing. Monitor performance. Analyze and manipulate data. You also create technical designs and implementation details, and implement permission policies and security requirements.
You should have a deep knowledge and experience using the underlying framework, data structures, and objects associated with the finance and operations solutions.
You should have experience with products and services that include Microsoft Visual Studio, Azure, Power Apps, Power Automate, Azure DevOps, Lifecycle Services tools, Postman, GitHub, Microsoft 365, reporting tools [for example, SQL Server Reporting Services (SSRS), Power BI], and SQL Server Management Studio.
Skills at a glance Plan the architecture and solution design (5–10%) Apply developer tools (5–10%) Design and develop AOT elements (15–20%) Develop and test code (20–25%) Implement reporting (10–15%) Integrate and manage data solutions (15–20%) Implement security and optimize performance (5–10%) Plan the architecture and solution design (5–10%)
Identify the major components of finance and operations apps Identify finance and operations app modules required for a solution based on business requirements Identify architectural differences between the cloud and on-premises versions of finance and operations apps Identify components of the application stack Differentiate the purposes and interrelationships between packages, projects, models, and elements Design and implement a UI Describe the finance and operations UI layouts and components Design workspaces Design and personalize UI elements including forms and saved views Define navigation elements including menus and menu items Configure filtering and sorting options Implement application lifecycle management (ALM) and Microsoft Dynamics 365 Lifecycle Services Describe the capabilities of the Environment Monitoring Tool within Lifecycle Services Select the purpose and appropriate uses of Lifecycle Services tools and components Research and resolve issues by using Issue Search Identify activities that require asset libraries Prepare deployment packages and deploy packages between environments
Apply developer tools (5–10%) Customize finance and operations apps by using Visual Studio Create extension models Design and build projects Manage metadata using Application Explorer Synchronize data dictionary changes with the application database Create elements by using element designers Perform debugging activities Manage source code and artifacts by using Microsoft Azure DevOps version control Create, check out, and check in code and artifacts Branch and merge code Compare code and resolve version conflicts
Design and develop AOT elements (15–20%) Create and extend UI elements Add a new form to a project and apply a pattern (template) Configure a data source for the form Add a grid and grid fields, groups, and other controls to a form Create and extend menus and menu items Test form functionality and data connections Add a form extension to a project for selected standard forms Create and use label files Create and extend the data model Create and extend tables Add table fields and field properties to a table Add field groups, relations, delete actions, methods, and indices Create and extend views, queries, and maps Create Extended Data Types (EDTs) and enumerations Add an EDT to a project and populate EDT properties Add an enumeration to a project Add or update enumeration elements and enumeration element properties Add an extension of EDTs and enumerations Create classes and extend AOT elements Add a new class to a project Create a new class extension and add new methods Add event handler methods to a class Add attributes to a class
Develop and test code (20–25%) Develop X++ code Identify and implement base types and operators Implement common structured programming constructs of X++ Create, read, update, and delete (CRUD) data Identify and implement global functions in X++ Implement table and form methods Develop object-oriented code Implement X++ variable scoping Implement inheritance and abstraction concept Implement query objects and the QueryBuilder class Implement attribute classes Implement Chain of Command (CoC) and wrapper classes Implement event handler classes and delegates Implement finance and operations app framework functionality Implement the SysOperation framework Implement the workflow framework Implement the batch framework Implement the SysExtensionSerializer Perform testing Implement the Regression suite automation tool (RSAT) Perform unit/component testing using SysTest framework and Task recorder Perform testing using Acceptance Test Library (ATL) tool
Implement reporting (10–15%) Describe the capabilities and limitations of reporting tools in finance and operations apps Create and modify report data sources and supporting classes Implement reporting security requirements Describe the report publishing process Describe the differences between using Entity store and Bring your own database (BYOD) or Azure Data Lake as reporting data stores Design, create, and revise Dynamics 365 reports Create and modify reports in finance and operations apps that use SSRS Create and modify finance and operations apps reports by using Power BI Create and modify finance and operations apps reports by using Microsoft Excel Implement Business document management Design, create, and revise Dynamics 365 workspaces Design and implement key performance indicators (KPIs) Create drill-through workspace elements Implement built-in charts, Power BI embedded visualizations, aggregate measurements, aggregate dimensions, and other reporting components
Integrate and manage data solutions (15–20%) Identify data integration patterns and scenarios Identify data integration patterns Select an appropriate data integration API Identify differences between synchronous and asynchronous patterns Implement data integration concepts and solutions Develop a data entity by using Visual Studio Develop, import, and export composite and aggregate data entities. Consume external web services by using RESTful APIs and Simple Object Access Protocol (SOAP) Implement electronic reporting Implement custom services and Batch OData API Implement data management Import and export data using entities between finance and operations apps and other systems Monitor the status and availability of entities Enable change tracking for entities Set up a data project and recurring data jobs Design entity sequencing Generate field mapping between source and target data structures Develop data transformations Integrate with Microsoft Power Platform, Microsoft 365, and Azure Integrate Power Automate and Power Apps with finance and operations apps Integrate Microsoft Dataverse with finance and operations apps by using dual-write Integrate Microsoft Dataverse with finance and operations apps by using virtual entities Integrate finance and operations apps with Microsoft Excel by using OData Implement business events
Implement security and optimize performance (5–10%) Implement security policies and requirements Create or modify duties, privileges, permissions, and roles Enforce permissions policies Implement Extensible Data Security (XDS) policies Enforce Microsoft Entra ID authentication Apply fundamental performance optimization techniques Identify and apply caching mechanisms for forms and tables Implement the global cache and singleton Create or modify temporary tables for optimization purposes Determine when to use set-based queries and row-based queries Modify queries to optimize performance Modify variable scope to optimize performance Analyze and optimize concurrency Optimize performance Capture traces by using TraceParser and analyze traces Diagnose and optimize client performance by using browser-based tools Diagnose and optimize client performance by using Performance Timer Optimize performance for data entities, data source queries, batch processes, and reports Implement Async and Sandbox framework
Sample Question and Answers
QUESTION 1 HOTSPOT You need to configure security for the CashDisc form. What changes should you make? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. Answer: Explanation:
QUESTION 2 You have an enumeration named truckStatus that has the following statuses: Empty Loaded Completed You have the following code: You need to add the following statuses to the enumeration: Quarantine, InTransit What should you do?
A. Add a new case statement in the model of the existing code, B. Add a post handler to the method that checks the enumeration and logic for your new enumeration values using the enumeration value. C. Add a post handler to the method that checks the enumeration and logic for your new enumeration values using the integer value of the enumeration. D. Add a post handler to the method that checks the enumeration and logic for your new enumeration values using a range comparison for your new values.
Answer: B
QUESTION 3 You need to update the CashDisc report to meet the requirements. What should you do?
A. Customize the existing CashDisc report in the overlayering model and add the new field to the design. B. Extend the existing CashDisc report in the extension model and add the new field to the design. C. Duplicate the existing CashDisc report in the extension model and add the new field to the design. D. Delete the existing CashDisc report in the extension model and create a new report.
Answer: B
QUESTION 4 You need to configure models for the project. What are two possible ways to achieve the goal? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.
A. Overlay the existing FinanceExt model and populate the solution definition. B. Modify the DefaultModelForNewProject setting in the DefaultConfig.xml file and name the model FinanceExt. C. Create a new model that extends the existing FinanceExt model. D. Extend the existing FinanceExt model and populate the project model definition.
Answer: A, D
QUESTION 5 HOTSPOT You need to modify the CashDisc form to meet the requirements. Which objects should you use? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. Answer: Explanation: Scenario: CashDisc form You must extend the CashDisc form to add a new field named MinimumInvoiceAmount to the form. You must add a new Extended Data Type to the extension model for the new field. The new field must be added above the discount method field. The field must display 10 characters. Box 1: extension To add a new field to an existing table, you must first create a table extension. Box 2: field Box 3: field group Box 4: data source Often, the information that is stored in existing tables doesn’t satisfy customer requirements. Therefore, additional tables must be created, and data from those tables must be shown on pages. You can add new data sources to existing forms through extension. Follow these steps. In the extension model, create a form extension for the selected form. Right-click the form extension, and then select New Data Source. QUESTION 6 You need to configure filtering for the Vendor Past Due Invoices form. Which two filtering types can you use? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.
A. QuickFilter B. Advanced Filter C. Grid Column Filtering D. Filter pane
Answer: A, C
QUESTION 7 You need to modify the environment to meet User1s requirements. What should you do?
A. Create an extension of CashDisc in a new project and add the field to the extended table, B. Create a new table named CashDiscExtension in the project. C. Use Open Designer to add the field to the table. D. Create an overlayer of CashDisc in a new project and add the field.
Answer: A
Explanation: Scenario: A sales manager suspects a data-related issue in the vendor exclusion list. User1 must identify the user who created the referenced exclusion records.
QUESTION 8 DRAG DROP You need to create the outstanding invoice report for the CFO. Which attributes should you use? To answer, drag the appropriate attributes to the requirements. Each attribute answer may be used once, more than once, or not at all. You may need to drag the split between panes or scroll to view content. NOTE: Each correct selection is worth one point.
Answer:
Explanation: Scenario: The Chief Financial Officer (CFO) requires the following reports: A report that shows all outstanding invoices, their cash discount types including the new minimum threshold applicable, and the amount of the discount. The report must only be accessed by users who are members of the Accounts Payable Manager role. Box 1: DataContractAttribute DataContractAttribute “ This attribute is applied to an X++ class and specifies that the class can be used as a data contract (that it should be serialized). Box 2: DataMemberAttribute DataMemberAttribute “ This attribute is applied to a parm (parameter) method on an X++ data contract class and specifies that the data member should be serialized. Box 3: SRSReportParameterAttribute You set the SRSReportParameterAttribute attribute to the data contract you created for the RDP class.
Updates to the exam Our exams are updated periodically to reflect skills that are required to perform a role. We have included two versions of the Skills Measured objectives depending on when you are taking the exam.
We always update the English language version of the exam first. Some exams are localized into other languages, and those are updated approximately eight weeks after the English version is updated. While Microsoft makes every effort to update localized versions as noted, there may be times when localized versions of an exam are not updated on this schedule. Other available languages are listed in the Schedule Exam section of the Exam Details webpage. If the exam isn’t available in your preferred language, you can request an additional 30 minutes to complete the exam.
Note The bullets that follow each of the skills measured are intended to illustrate how we are assessing that skill. Related topics may be covered in the exam.
Note Most questions cover features that are general availability (GA). The exam may contain questions on Preview features if those features are commonly used.
Audience profile This exam is designed for you, if you’re looking to demonstrate foundational-level knowledge of cloud-based solutions to facilitate productivity and collaboration among on-site, remote, and hybrid workers. As a candidate, you may:
Have knowledge of cloud-based solutions.
Be new to Microsoft 365.
You can use this exam to prepare for other Microsoft certifications, but it’s not a prerequisite for the related ones.
As a candidate, you should be able to recommend Microsoft 365 solutions that address common organizational IT challenges. You should understand how Microsoft 365 solutions:
Improve productivity
Facilitate collaboration
Optimize communications
Help secure data
Identity and facilitate compliance
You should be able to recommend solutions for:
Endpoint and application management
Desktop virtualization
Automated operating system deployment
Reporting and analytics
You should be familiar with Microsoft 365 licensing, deployment and migration assistance, and support options for organizations looking to maximize their investment in the cloud.
Skills at a glance
Describe cloud concepts (5–10%) Describe Microsoft 365 apps and services (45–50%) Describe security, compliance, privacy, and trust in Microsoft 365 (25–30%) Describe Microsoft 365 pricing, licensing, and support (10–15%)
Describe cloud concepts (5–10%) Describe the different types of cloud services available Describe Microsoft software as a service (SaaS), infrastructure as a service (IaaS), and platform as a service (PaaS) concepts and use cases Describe differences between Office 365 and Microsoft 365 Describe the benefits of and considerations for using cloud, hybrid, or on-premises services Describe public, private, and hybrid cloud models Compare costs and advantages of cloud, hybrid, and on-premises services Describe the concept of hybrid work and flexible work
Describe Microsoft 365 apps and services (45–50%) Describe productivity solutions of Microsoft 365 Describe the core productivity capabilities and benefits of Microsoft 365 including Microsoft Outlook and Microsoft Exchange, Microsoft 365 apps, and OneDrive Describe core Microsoft 365 Apps including Microsoft Word, Excel, PowerPoint, Outlook, and OneNote Describe work management capabilities of Microsoft 365 including Microsoft Project, Planner, Bookings, Forms, Lists, and To Do Describe collaboration solutions of Microsoft 365 Describe the collaboration benefits and capabilities of Microsoft 365 including Microsoft Exchange, Outlook, SharePoint, OneDrive, and Stream Describe the collaboration benefits and capabilities of Microsoft Teams and Teams Phone Describe the Microsoft Viva apps Describe the ways that you can extend Microsoft Teams by using collaborative apps Describe endpoint modernization, management concepts, and deployment options in Microsoft 365 Describe the endpoint management capabilities of Microsoft 365 including Microsoft Endpoint Manager (MEM), Intune, AutoPilot, and Configuration Manager with cloud attach Compare the differences between Windows 365 and Azure Virtual Desktop Describe the deployment and release models for Windows-as-a-Service (WaaS) including deployment rings Identify deployment and update channels for Microsoft 365 Apps Describe analytics capabilities of Microsoft 365 Describe the capabilities of Viva Insights Describe the capabilities of the Microsoft 365 Admin center and Microsoft 365 user portal Describe the reports available in the Microsoft 365 Admin center and other admin centers
Describe security, compliance, privacy, and trust in Microsoft 365 (25–30%) Describe identity and access management solutions of Microsoft 365 Describe the identity and access management capabilities of Microsoft Entra ID Describe cloud identity, on-premises identity, and hybrid identity concepts Describe how Microsoft uses methods such as multi-factor authentication (MFA), self-service password reset (SSPR), and conditional access, to keep identities, access, and data secure Describe threat protection solutions of Microsoft 365 Describe Microsoft 365 Defender, Defender for Endpoint, Defender for Office 365, Defender for Identity, Defender for Cloud Apps, and the Microsoft 365 Defender Portal Describe Microsoft Secure Score benefits and capabilities Describe how Microsoft 365 addresses the most common types of threats against endpoints, applications, and identities Describe trust, privacy, risk, and compliance solutions of Microsoft 365 Describe the Zero Trust Model Describe Microsoft Purview compliance solutions such as insider risk, auditing, and eDiscovery Describe Microsoft Purview Information Protection features such as sensitivity labels and data loss prevention Describe how Microsoft supports data residency to ensure regulatory compliance Describe the capabilities and benefits of Microsoft Priva
Describe Microsoft 365 pricing, licensing, and support (10–15%) Identify Microsoft 365 pricing and billing management options Describe the pricing model for Microsoft cloud services including enterprise agreements, cloud solution providers, and direct billing Describe available billing and bill management options including billing frequency and methods of payment Identify licensing options available in Microsoft 365 Describe license management Describe the differences between base licensing and add-on licensing Identify support options for Microsoft 365 services Describe how to create a support request for Microsoft 365 services Describe support options for Microsoft 365 services Describe service-level agreements (SLAs) including service credits Determine service health status by using the Microsoft 365 admin center or the Microsoft Entra admin center
QUESTION 2 You need to consider the underlined segment to establish whether it is accurate. All applications will remain in a hybrid environment after migrating to Microsoft Azure. Select ”’?No adjustment required”’? if the underlined segment is accurate. If the underlined segment is inaccurate, select the accurate option.
A. No adjustment required. B. Applications that manage sensitive information C. Applications where access requires a USB-token device D. All legacy applications
Answer: B
QUESTION 3 Note: The question is included in a number of questions that depicts the identical set-up. However, every question has a distinctive result. Establish if the solution satisfies the requirements. Your company plans to move their Server environment to the cloud. You have been tasked with identifying a cloud model that allows for the current email environment to be upgraded, while also reducing server and application maintenance. You need to make sure that the requirements are met. Solution: You recommend the Platform as a service (PaaS) model. Does the solution meet the goal?
A. Yes B. No
Answer: B
QUESTION 4 Note: The question is included in a number of questions that depicts the identical set-up. However, every question has a distinctive result. Establish if the solution satisfies the requirements. Your company plans to move their Server environment to the cloud. You have been tasked with identifying a cloud model that allows for the current email environment to be upgraded, while also reducing server and application maintenance. You need to make sure that the requirements are met. Solution: You recommend the Infrastructure as a service (IaaS) model. Does the solution meet the goal?
A. Yes B. No
Answer: B
QUESTION 5 Note: The question is included in a number of questions that depicts the identical set-up. However, every question has a distinctive result. Establish if the solution satisfies the requirements. Your company plans to move their Server environment to the cloud. You have been tasked with identifying a cloud model that allows for the current email environment to be upgraded, while also reducing server and application maintenance. You need to make sure that the requirements are met. Solution: You recommend the Software as a service (SaaS) model. Does the solution meet the goal?
A. Yes B. No
Answer: A
QUESTION 6 Your company makes use of Platform as a Service (PaaS) for their Azure solution. Which of the following options are components that your IT employees are responsible for?
A. Networks. B. Databases. C. Applications. D. Servers.
Answer: C QUESTION 7 Your company makes use of Platform as a Service (PaaS) for their Azure solution. Which of the following options are components that Microsoft are responsible for? (Choose all that apply).
A. Storage. B. Databases. C. Applications. D. Operating system.
Answer: A,B,D
QUESTION 8 Your company is planning to migrate to Microsoft Azure and Microsoft 365. You are required to identify a cloud service that allows for website hosting. Which of the following is the model you should choose?
A. Software as a Service (SaaS) B. Platform as a Service (PaaS) C. Infrastructure as a Service (IaaS) D. Container as a Service (CaaS)
Answer: B
QUESTION 9 Your company is planning to migrate to Microsoft Azure and Microsoft 365. You are required to identify a cloud service that allows for the deployment of a Linux virtual machine. Which of the following is the model you should choose?
A. Software as a Service (SaaS) B. Platform as a Service (PaaS) C. Infrastructure as a Service (IaaS) D. Container as a Service (CaaS)
Answer: C
QUESTION 11 You need to consider the underlined segment to establish whether it is accurate. To ensure that when a new Microsoft Word feature is available for worker to install as soon as it becomes available, you should subscribe to the Targeted release channel. Select ”’?No adjustment required”’? if the underlined segment is accurate. If the underlined segment is inaccurate, select the accurate option.
A. No adjustment required. B. Standard release C. Semi-annual D. Annual
AZ-801 Configuring Windows Server Hybrid Advanced Services Exam
Updates to the exam Our exams are updated periodically to reflect skills that are required to perform a role. We have included two versions of the Skills Measured objectives depending on when you are taking the exam.
We always update the English language version of the exam first. Some exams are localized into other languages, and those are updated approximately eight weeks after the English version is updated. While Microsoft makes every effort to update localized versions as noted, there may be times when the localized versions of an exam are not updated on this schedule. Other available languages are listed in the Schedule Exam section of the Exam Details webpage. If the exam isn’t available in your preferred language, you can request an additional 30 minutes to complete the exam.
Note The bullets that follow each of the skills measured are intended to illustrate how we are assessing that skill. Related topics may be covered in the exam.
Note Most questions cover features that are general availability (GA). The exam may contain questions on Preview features if those features are commonly used.
Audience profile Candidates for this exam are responsible for configuring and managing Windows Server on-premises, hybrid, and Infrastructure as a Service (IaaS) platform workloads. The Windows Server Hybrid Administrator is tasked with integrating Windows Server environments with Azure services and managing Windows Server in on-premises networks. This role manages and maintains Windows Server IaaS workloads in Azure as well as migrating and deploying workloads to Azure. This role typically collaborates with Azure Administrators, Enterprise Architects, Microsoft 365 administrators, and network engineers.
Candidates for this exam deploy, package, secure, update, and configure Windows Server workloads using on-premises, hybrid, and cloud technologies. This role implements and manages on-premises and hybrid solutions, such as identity, security, management, compute, networking, storage, monitoring, high availability, and disaster recovery. This role uses 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 Defender for Cloud, and IaaS VM administration.
Candidates for this exam have several years of experience with Windows Server operating systems.
Secure Windows Server on-premises and hybrid infrastructures (25–30%) Implement and manage Windows Server high availability (10–15%) Implement disaster recovery (10–15%) Migrate servers and workloads (20–25%) Monitor and troubleshoot Windows Server environments (20–25%)
Secure Windows Server on-premises and hybrid infrastructures (25–30%) Secure Windows Server operating system Configure and manage Exploit Protection Configure and manage Windows Defender Application Control Configure and manage Microsoft Defender for Servers Configure and manage Windows Defender Credential Guard Configure SmartScreen Implement operating system security by using Group Policies Secure a hybrid Active Directory infrastructure Configure password policies Enable password block lists Manage protected users Manage account security on an RODC Harden domain controllers Configure authentication policy silos Restrict access to domain controllers Configure account security Manage AD built-in administrative groups Manage AD delegation Implement and manage Microsoft Defender for Identity Identify and remediate Windows Server security issues by using Azure services Monitor on-premises servers and Azure IaaS VMs by using Microsoft Sentinel Identify and remediate security issues on-premises servers and Azure IaaS VMs by using Microsoft Defender for Cloud Secure Windows Server networking Manage Windows Defender Firewall Implement domain isolation Implement connection security rules Secure Windows Server storage Manage Windows BitLocker Drive Encryption (BitLocker) Manage and recover encrypted volumes Enable storage encryption by using Azure Disk Encryption Manage disk encryption keys for IaaS virtual machines
Implement and Manage Windows Server high availability (10–15%) Implement a Windows Server failover cluster Implement a failover cluster on-premises, hybrid, or cloud-only Create a Windows failover cluster Implement a stretch cluster across datacenters or Azure regions Configure storage for failover clustering Modify quorum options Configure network adapters for failover clustering Configure cluster workload options Configure cluster sets Configure Scale-Out File servers Create an Azure witness Configure a floating IP address for the cluster Implement load balancing for the failover cluster Manage failover clustering Implement cluster-aware updating Recover a failed cluster node Upgrade a node to Windows Server 2022 Failover workloads between nodes Install Windows updates on cluster nodes Manage failover clusters using Windows Admin Center Implement and manage Storage Spaces Direct Create a failover cluster using Storage Spaces Direct Upgrade a Storage Spaces Direct node Implement networking for Storage Spaces Direct Configure Storage Spaces Direct
Implement disaster recovery (10–15%) Manage backup and recovery for Windows Server Back up and restore files and folders to Azure Recovery Services Vault Install and manage Azure Backup Server Back up and recover using Azure Backup Server Manage backups in Azure Recovery Services Vault Create a backup policy Configure backup for Azure VM using the built-in backup agent Recover VM using temporary snapshots Recover VMs to new Azure VMs Restore a VM Implement disaster recovery by using Azure Site Recovery Configure Azure Site Recovery networking Configure Site Recovery for on-premises VMs Configure a recovery plan Configure Site Recovery for Azure VMs Implement VM replication to secondary datacenter or Azure region Configure Azure Site Recovery policies Protect virtual machines by using Hyper-V replicas Configure Hyper-V hosts for replication Manage Hyper-V replica servers Configure VM replication Perform a failover
Migrate servers and workloads (20–25%) Migrate on-premises storage to on-premises servers or Azure Transfer data and share Cut over to a new server by using Storage Migration Service (SMS) Use Storage Migration Service to migrate to Azure VMs Migrate to Azure file shares Migrate on-premises servers to Azure Deploy and configure Azure Migrate appliance Migrate VM workloads to Azure IaaS Migrate physical workloads to Azure IaaS Migrate by using Azure Migrate Migrate workloads from previous versions to Windows Server 2022 Migrate IIS Migrate Hyper-V hosts Migrate RDS host servers Migrate DHCP Migrate print servers Migrate IIS workloads to Azure Migrate IIS workloads to Azure Web Apps Migrate IIS workloads to containers Migrate an AD DS infrastructure to Windows Server 2022 AD DS Migrate AD DS objects, including users, groups and Group Policies using AD Migration Tool Migrate to a new Active Directory forest Upgrade an existing forest
Monitor and troubleshoot Windows Server environments (20–25%) Monitor Windows Server by using Windows Server tools and Azure services Monitor Windows Server by using Performance Monitor Create and configure Data Collector Sets Monitor servers and configure alerts by using Windows Admin Center Analyze Windows Server system data by using System Insights Manage event logs Deploy Azure Monitor agents Collect performance counters to Azure Create alerts Monitor Azure VMs by using Azure diagnostics extension Monitor Azure VMs performance by using VM Insights Troubleshoot Windows Server on-premises and hybrid networking Troubleshoot hybrid network connectivity Troubleshoot on-premises connectivity Troubleshoot Windows Server virtual machines in Azure Troubleshoot deployment failures Troubleshoot booting failures Troubleshoot VM performance issues Troubleshoot VM extension issues Troubleshoot disk encryption issues Troubleshoot storage Troubleshoot VM connection issues Troubleshoot Active Directory Restore objects from AD recycle bin Recover Active Directory database using Directory Services Restore mode Recover SYSVOL Troubleshoot Active Directory replication Troubleshoot Hybrid authentication issues Troubleshoot on-premises Active Directory
QUESTION 1 DRAG DROP You are planning the implementation of Cluster2 to support the on-premises migration plan. You need to ensure that the disks on Cluster2 meet the security requirements. In which order should you perform the actions? To answer, move all actions from the list of actions to the answer area and arrange them in the correct order.
Answer:
QUESTION 2 HOTSPOT You need to implement a security policy solution to authorize the applications. The solution must meet the security requirements. Which service should you use to enforce the security policy, and what should you use to manage the policy settings? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.
Answer:
Explanation:
QUESTION 3 You are remediating the firewall security risks to meet the security requirements. What should you configure to reduce the risks?
A. a Group Policy Object (GPO) B. adaptive network hardening in Microsoft Defender for Cloud C. a network security group (NSG) in Sub1 D. an Azure Firewall policy
Answer: A
QUESTION 4 You are planning the deployment of Microsoft Sentinel. Which type of Microsoft Sentinel data connector should you use to meet the security requirements?
A. Threat Intelligence – TAXII B. Azure Active Directory C. Microsoft Defender for Cloud D. Microsoft Defender for Identity
Answer: D
QUESTION 5 You are planning the migration of Archive1 to support the on-premises migration plan. What is the minimum number of IP addresses required for the node and cluster roles on Cluster3?
A. 2 B. 3 C. 4 D. 5
Answer: B
Explanation: One IP for each of the two nodes in the cluster and one IP for the cluster virtual IP (VIP).
QUESTION 6 HOTSPOT You are planning the www.fabrikam.com website migration to support the Azure migration plan. How should you configure WebApp1? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.
Answer:
Explanation: Box 1: Add a custom domain name To migrate www.fabrikam.com website to an Azure App Service web app, you need to add Fabrikam.com as a custom domain in Azure. This will make the domain name available to use in the web app.
Box 2: Modify a DNS record You need to change the DNS record for www.fabrikam.com to point to the Azure web app. HTTP redirect rules wont work because WEB1 and WEB2 will be decommissioned.
QUESTION 7 DRAG DROP You are planning the DHCP1 migration to support the DHCP migration plan. Which two PowerShell cmdlets should you run on DHCP1, and which two PowerShell cmdlets should you run on DHCP2? To answer, drag the appropriate cmdlets to the correct servers. Each cmdlet may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
Answer:
QUESTION 8 You are planning the data share migration to support the on-premises migration plan. What should you use to perform the migration?
A. Storage Migration Service B. Microsoft File Server Migration Toolkit C. File Server Resource Manager (FSRM) D. Windows Server Migration Tools
Answer: A QUESTION 9 HOTSPOT You are planning the migration of APP3 and APP4 to support the Azure migration plan. What should you do on Cluster1 and in Azure before you perform the migration? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.
Answer:
QUESTION 10 HOTSPOT You are planning the europe.fabrikam.com migration to support the on-premises migration plan- Where should you install the Password Export Server (PES) service, where should you generate the encryption key? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. Answer: Explanation:
Updates to the exam Our exams are updated periodically to reflect skills that are required to perform a role. We have included two versions of the Skills Measured objectives depending on when you are taking the exam.
We always update the English language version of the exam first. Some exams are localized into other languages, and those are updated approximately eight weeks after the English version is updated. While Microsoft makes every effort to update localized versions as noted, there may be times when the localized versions of an exam are not updated on this schedule. Other available languages are listed in the Schedule Exam section of the Exam Details webpage. If the exam isn’t available in your preferred language, you can request an additional 30 minutes to complete the exam. Note
The bullets that follow each of the skills measured are intended to illustrate how we are assessing that skill. Related topics may be covered in the exam. Note
Most questions cover features that are general availability (GA). The exam may contain questions on Preview features if those features are commonly used.
Skills measured as of September 26, 2023 Audience profile As a candidate for this exam, you’re a solution architect who: Leads successful implementations. Focuses on how solutions address the broader business and technical needs of organizations. This role requires you to have the ability to identify opportunities to solve business problems. You should have functional and technical knowledge of: Microsoft Power Platform Dynamics 365 customer engagement apps Related Microsoft cloud solutions Other third-party technologies You apply knowledge and experience throughout an engagement. You perform proactive and preventative work to: Increase the value of the customer’s investment. Promote organizational health.
As a candidate for this exam, you should have experience across functional and technical disciplines of Microsoft Power Platform. You should be able to facilitate design decisions across development, configuration, integration, infrastructure, security, licensing, availability, storage, and change management. In this role, you balance project’s business needs while meeting functional and non-functional requirements.
Perform solution envisioning and requirement analysis (35–40%) Architect a solution (40–45%) Implement the solution (15–20%)
Perform solution envisioning and requirement analysis (35–40%) Initiate solution planning Evaluate business requirements Identify Microsoft Power Platform solution components Identify other components including existing apps, Microsoft Dynamics 365 apps, AppSource apps, third-party components, and components from independent software vendors (ISVs) Identify and estimate migration and integration efforts Identify organization information and metrics Identify desired high-level organizational business processes Identify business process improvement opportunities Assess an organization’s risk factors Review key success criteria Identify existing solutions and systems Evaluate an organization’s enterprise architecture Identify data sources needed for a solution Define use cases and quality standards for existing data Identify and document an organization’s existing business processes Capture requirements Refine high-level requirements Identify functional requirements Identify non-functional requirements Confirm that requirements meet an organization’s goals Identify and document an organization’s desired business processes Perform fit/gap analyses Determine the feasibility of meeting specific requirements Evaluate Dynamics 365 apps and AppSource options to solve requirements Address functional gaps through alternate solutions Determine the scope for a solution
Architect a solution (40–45%) Lead the design process Design the solution topology Design customizations for existing apps Design and validate user experience prototypes Identify opportunities for component reuse Communicate system design visually Design application lifecycle management (ALM) processes Design a data migration strategy Design apps by grouping required features based on role or task Design a data visualization strategy Design an automation strategy that uses Power Automate Design environment strategy Design the data model Design tables and columns Design reference and configuration data Design relationships and relationship behaviors Determine when to connect to external data versus import data Design data models to address complex sets of requirements Design integrations Design collaboration integrations Design integrations between Microsoft Power Platform solutions and Dynamics 365 apps Design integrations with an organization’s existing systems Design third-party integrations Design an authentication strategy Design a business continuity strategy Identify opportunities to integrate and extend Microsoft Power Platform solutions by using Microsoft Azure Design robotic process automation (RPA) Design networking Design the security model Design the business unit and team structure Design security roles Design column and row level security Design security models to address complex sets of requirements Determine security model management policies and processes Identify Microsoft Entra groups and app registrations required to support a solution Identify data loss prevention (DLP) policies for a solution Determine how external users will access a solution
Implement the solution (15–20%) Validate the solution design Evaluate detail designs and implementation Validate security Ensure that the solution conforms to API limits Assess the solution performance and impact on resources Resolve automation conflicts Resolve integration conflicts Support go-live Identify and resolve potential and actual performance issues Troubleshoot data migration Resolve any identified issues with deployment plans Identify factors that impact go-live readiness and remediate issues
Sample Question:
QUESTION 2 You need to recommend a reporting solution for the organization. Which two options should you recommend? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.
A. AI Builder B. SQL Server Reporting Services (SSRS) C. Dynamics 365 D. Power BI
Answer: BC
Explanation: Scenario: The reporting and analytics team must be able to create reports that include data from all facilities and all workers. Management reports must present an overview of the entire organization. Other reports may be limited to specific offices. B: Power Apps apps can include reports that provide useful business information to the user. These reports are based on SQL Server Reporting Services and provide the same set of features that are available for typical SQL Server Reporting Services reports. C: Microsoft Dynamics 365 online and Model-Driven PowerApps offers several advanced reporting options. Advanced reports are often necessary when business requirements demand complex calculations, returning multiple data sets, grouping large sets of data based on rules, and retrieving data from different data sources. Incorrect Answers: D: Scenario: Users cannot view Power BI reports within the Power Platform apps. Note: Power BI enables data insights and better decision-making, while Power Apps enables everyone to build and use apps that connect to business data. Using the Power Apps visual, you can pass context-aware data to a canvas app, which updates in real time as you make changes to your report.
QUESTION 3 You need to recommend a solution for handling data entry requirements for the mobile audit teams. What are two possible ways to achieve the goal? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.
A. Canvas app within Power Apps Player B. Canvas app within a browser C. Dynamics 365 Field Service D. Dynamics 365 App for Outlook
Answer: AB
Explanation: Scenario: Audit teams must have the ability to view worker information on their mobile devices. Audit teams must be able to record data during visits to locations where workers are placed. When you create an app, or someone shares an app with you, you can run that app on the Power Apps mobile app or in a web browser.
QUESTION 6 You need to recommend technology for accessing historical job placement data. What should you recommend?
A. Power Virtual Agents chatbots B. Virtual tables C. Power Bl D. Power Automate flows
Answer: B
Explanation: A virtual table is a custom table in Microsoft Dataverse that has columns containing data from an external data source. Virtual tables appear in your app to users as regular table rows, but contain data that is sourced from an external database, such as an Azure SQL Database. Rows based on virtual tables are available in all clients including custom clients developed using the Dataverse web services. Scenario: First Up uses an on-premises system to manage current and historical patient data including medications and medical visits. The company plans to reference historical data in the existing system. The records held in these systems will not be migrated to the new solution except for medication information. The solution must provide a worker appointment booking system that can access worker historical job placement data. First Up staff members must be able to view and update worker records. They must be able to see current and historical job placement data on the same form in the new solution.
QUESTION 7 HOTSPOT You need to design tables for the solution. What should you recommend? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. Answer: Explanation: Box 1: Virtual Table A virtual table is a custom table in Microsoft Dataverse that has columns containing data from an external data source. Virtual tables appear in your app to users as regular table rows, but contain data that is sourced from an external database, such as an Azure SQL Database. Rows based on virtual tables are available in all clients including custom clients developed using the Dataverse web services. Scenario: First Up uses an on-premises system to manage current and historical patient data including medications and medical visits. The company plans to reference historical data in the existing system. The records held in these systems will not be migrated to the new solution except for medication information. The solution must provide a worker appointment booking system that can access worker historical job placement data. First Up staff members must be able to view and update worker records. They must be able to see current and historical job placement data on the same form in the new solution. Box 2: Lookup (N:1) Each worker can have many security clearances, so need a 1:N relationship. Scenario: The solution must support tracking of security clearance information for a worker including the date, status, and certifying agency.
QUESTION 8 HOTSPOT You need to recommend solutions for the organizations technical challenges. What should you recommend? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. Answer: Explanation: Box 1: Power Automate Self-service purchase is available for Power Platform (Power BI, Power Apps, and Power Automate), Project, and Visio. Box 2: Azure Active Directory B2B Scenario: First Up Consulting recruits information technology (IT) workers for temporary or permanent positions at client companies. Azure Active Directory (Azure AD) business-to-business (B2B) collaboration is a feature within External Identities that lets you invite guest users to collaborate with your organization. With B2B collaboration, you can securely share your company’s applications and services with guest users from any other organization, while maintaining control over your own corporate data. Work safely and securely with external partners, large or small, even if they don’t have Azure AD or an IT department. A simple invitation and redemption process lets partners use their own credentials to access your company’s resources. Note, Scenario: Workers must be able to sign into a portal by using their own email address. Workers must be required to use a secure method of authentication to be able to view their data. User security roles must be customized to ensure that users are able to interact only with the specific data in which they need access. Box 3: Dynamics 365 Field Service Dynamics 365 Field Service functionality include: An interactive schedule board helps dispatchers assign work orders to the best resources based on location, availability, skill set, priority, and more. This is done via a manual drag-and-drop method, a semi-automated scheduling assistant, or fully automated with Resource Scheduling Optimization. The schedule board displays each resource–whether an employee, contractor, or equipment–and their scheduled work orders. Resources and their assigned jobs are also displayed on a map along with routes and traffic patterns in real time. QUESTION 9 HOTSPOT You need to recommend methods to resolve the organizations issues. What should you recommend? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. Answer: Explanation: Box 1: Add users to Microsoft 365. Scenario: Users cannot view Power BI reports within the Power Platform apps. Issue: The people you share with may see a locked tile in a dashboard, or a “Permission required” message when they try to view a report. Solution: You need to grant them permission to the underlying dataset. Go to the All or the Datasets + dataflows tab in your content list. Select More options (…) next to a dataset, then select Manage permissions. Select Add user. Enter the full email addresses for individuals, distribution groups, or security groups. Select Grant access. Box 2: Configure an on-premises data gateway. Scenario: The company plans to reference historical data in the [on-premises] existing system. The records held in these systems will not be migrated to the new solution except for medication information. The on-premises data gateway acts as a bridge to provide quick and secure data transfer between onpremises data (data that isn’t in the cloud) and several Microsoft cloud services. These cloud services include Power BI, PowerApps, Power Automate, Azure Analysis Services, and Azure Logic Apps. By using a gateway, organizations can keep databases and other data sources on their on-premises networks, yet securely use that on-premises data in cloud services.
QUESTION 10 DRAG DROP You need to recommend methods for assigning security to each group of users. What should you recommend? To answer, drag the appropriate methods to the correct groups of users. Each method may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content. NOTE: Each correct selection is worth one point. Answer: Explanation: Box 1: Power Platform Local Business Owner Team Owner team: An owner team owns records and has security roles assigned to the team. A user’s privileges can come from their individual security roles, those of the teams that they’re part of or the ones they inherit. A team has full access rights on the records that the team owns. Team members are added manually to the owner team. Scenario: Employee authentication with the existing system is provided by an on-premises Active Directory instance that is linked to Azure Active Directory. Box 2: Azure Active Directory Security Group Team An Azure Active Directory (Azure AD) group team. Similar to owner team, an Azure AD group team can own records and can have security roles assigned to the team. Note: The administration of app and data access for Microsoft Dataverse has been extended to allow administrators to use their organization’s Azure Active Directory (Azure AD) groups to manage access rights for licensed Dataverse users. Box 3: Azure Active Directory B2B Guest Access An Azure AD B2B collaboration user is an external user, typically from a partner organization, that you invite to sign into your Azure AD organization using their own credentials. This B2B collaboration user (also generally referred to as a guest user) can then access the apps and resources you want to share with them. A user object is created for the B2B collaboration user in the same directory as your employees. B2B collaboration user objects have limited privileges in your directory by default, and they can be managed like employees, added to groups, and so on. Scenario: Before First Up signs a contract to place workers at a client company, a member of the audit team visits the company and interviews company management. Audit members use different types of devices including Android and iOS devices. First Up has no plans to require the use of a single type of device.
QUESTION 11 You need to investigate the canvas app functionality issues. Which two tools can you use? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.
A. App checker B. Errors function C. Solution checker D. Power Platform admin center
Answer: AC
Explanation: Scenario: The testing team reports that one of the canvas apps is not working as expected. An error message displays as specific pages load. A: The App checker is now available to help provide a clear list of formula issues in your app, and to provide items to fix to make your app accessible. The App checker is an area that the PowerApps team will continue to invest in, and build on in order help to make debugging, performance and best practice decisions an easier and more guided experience. C: With the solution checker feature, you can perform a rich static analysis check on your solutions against a set of best practice rules and quickly identify these problematic patterns. After the check completes, you receive a detailed report that lists the issues identified, the components and code affected, and links to documentation that describes how to resolve each issue.
Audience profile The candidate envisions and creates business solutions to simplify and automate tasks and processes for themselves and their team. They understand the data that they are working with, the issues that they need to resolve, and the required processes and app 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 that they encounter as part of their primary job role. They may connect to and use features of apps including Microsoft Power Platform, Microsoft Teams, Microsoft 365 apps and services, and third-party solutions. The candidate has a desire to understand the capabilities and limitations of available tools and understand how to apply them.
Design business solutions (20–25%) Analyze and visualize data (10–15%) Create business solutions (60–65%)
Design business solutions (20–25%) Create a high-level design Identify existing data sources needed to support a business solution Describe the expected user experience for targeted devices and describe the differences between Microsoft Power Platform app types Describe the expected logic and steps that a process will execute Create a high-level structure for a new data source Identify Microsoft Power Platform components Determine the required Microsoft Power Apps app type for a business solution Determine when to use Microsoft Dataverse for Teams Map a problem domain to Microsoft Power Platform tools Identify options for implementing business logic Describe connectors Describe uses cases for cloud flows and desktop flows Describe use cases for chatbots Design the user interface (UI) for a business solution Identify opportunities for component reuse Select UI elements for canvas apps Identify the model-driven forms and Dataverse views that are needed Design reporting and visualizations for business solutions Select reporting options for business solutions including views, Microsoft Power BI visualizations, and dashboards Define visualizations for Power BI dashboards Define visualizations for model-driven dashboards Define visualizations for canvas apps
Analyze and visualize data (10–15%) Create and consume Power BI dashboards Create a simple report from an existing dataset by using Power BI Service Create Power BI dashboards from existing reports Embed Power BI dashboards and tiles in canvas apps and model-driven apps Share Power BI dashboards Describe AI Builder models Describe use cases for AI Builder Describe differences between prebuilt models and custom models Describe the process for training custom models Use a model from within Microsoft Power Automate or Microsoft Power Apps
Create business solutions (60–65%) Manage Microsoft Power Platform components during development Create a publisher in Dataverse Create a Dataverse solution Export or import Dataverse solution Export or import a canvas app or a cloud flow Add existing apps and flows to a Dataverse solution Create model-driven apps Create model-driven apps Create and configure Dataverse table forms Create and configure Dataverse table views Share model-driven apps with other users and groups Create and configure model-driven dashboards Create and manage canvas apps Connect to data sources in canvas apps Interpret App checker results Manage versions of canvas apps Publish canvas apps Share canvas apps with other users and groups Build canvas apps screens Add canvas app assets and components to screens Create screens for canvas apps Determine when to use forms, galleries, button, labels, input controls, images, and custom controls Configure UI elements Implement Power Fx formulas Implement collections and variables Run a cloud flow from a canvas app Configure Microsoft Dataverse Create tables and table columns based on a data model Link tables by using lookups Describe use cases and capabilities of business rules Create Dataverse business rules Describe how Dataverse uses role-based access control (RBAC) Add table permissions to existing Dataverse security roles Create Power Automate flows Describe types of triggers for cloud flows Create cloud flows Configure triggers for cloud flows Configure flow actions Test a cloud flow and interpret flow checker results Implement conditional logic for a cloud flow Create approvals and monitor the approval process by using Power Automate and Teams Share cloud flows Create a desktop flow for personal use Create Microsoft Power Virtual Agents chatbots in Microsoft Teams Identify use cases and capabilities for chatbots Create a chatbot that uses topics and trigger phrases Test a chatbot Publish a chatbot
Sample Questions and Answeers
New Topic: Topic 1, Wide World Importers This is a case study. Case studies are not timed separately. You can use as much exam time as you would like to complete each case. However, there may be additional case studies and sections on this exam. You must manage your time to ensure that you are able to complete all questions included on this exam in the time provided. To answer the questions included in a case study, you will need to reference information that is provided in the case study. Case studies might contain exhibits and other resources that provide more information about the scenario that is described in the case study. Each question is independent of the other questions in this case study. At the end of this case study, a review screen will appear. This screen allows you to review your answers and to make changes before you move to the next section of the exam. After you begin a new section, you cannot return to this section. To start the case study To display the first question in this case study, click the Next button. Use the buttons in the left pane to explore the content of the case study before you answer the questions. Clicking these buttons displays information such as business requirements, existing environment, and problem statements. When you are ready to answer a question, click the Question button to return to the question. Background Current environment Sales representatives submit weekly status reports to regional managers. There is no standardized format for these status reports. The process for managing status reports is challenging. Wide World Importers has decided to use Microsoft 365, Microsoft Azure, and Power Platform for future app development. Both Wide World Importers and Tailwind Traders have identical Microsoft SharePoint and Azure configurations. Both companies use separate tenants. Requirements Application You must create a mobile app to streamline the creation of status reports by sales representatives. You must make the same app available to Tailwind Traders. The mobile app must meet the following requirements: Minimize the use of code. Use formulas and expressions when necessary. Support a variety of visual layouts. Use a SharePoint list to store information about regional managers and sales representatives. Use Azure SQL Database to store other data. Status reports Sales representatives must provide a weekly status report for all work processes each Monday. Representatives must enter the following information for each process: If a sales representative submits a status report and assigns the At Risk status to a process, the app must prompt the sales representative to enter a detailed description for the risk. This information must be emailed to the regional manager. If the category is Work/life balance, the information must be carbon copied to the human resources department. If a sales representative does not submit a weekly status report by an agreed upon deadline, the system must send an email to remind the sales representative. The app must be able to run both online and offline. If the mobile device on which the app runs is connected to the internet, the app must immediately submit the status report. You must display a visual indicator in the app so that sales representatives know whether the app is offline before submitting reports. When data is submitted offline, the data must be stored in the app until the app is back online. Technical Regardless of the UI layouts, the data recorded must be standardized in the Azure DB tables. You must use global variables in the app. Deployment Before deploying the app to production, you must ensure that the app conforms to Microsoft accessibility and performance guidelines. The completed app and all supporting components must be provided to Tailwind Traders. Tailwind Traders must not be able to make changes to any of the components. You must use the following version control numbering scheme: Major: The last two digits of the year the app is packaged Minor: Two digits that represent the month when the app is packaged Build: A number that is incremented to represent significant changes to the app Revision: The incremented revision for a package New versions of the application must completely replace previous versions of the app. When identifying versions of the app solution, all dependencies, entities, and user interfaces components must be identified to avoid any unintentional issues caused by reverting individual components to a previous version. Previous versions of the mobile app must be available for roll back purposes. All versions of software that have been used in production must be retained for five years. Issues The mobile app has been live for several months. Eight versions of the app have been released since the initial version of the app was deployed to sales representatives. You must revert the app to an earlier version and redesign some features. User1 often works in a warehouse that does not have internet connectivity. User1 needs to edit an existing status report and submit a new status report. Several sales representatives have accessibility restrictions. User2 is visually impaired and cannot see images. User3 is unable to use a mouse. QUESTION 1 You need to provide the app to Tailwind Traders. What should you do?
A. Within Managed Properties, set the value of the Allow customizations option to true. Export the app as a managed solution. B. Use the Share App feature. C. Within Managed Properties, set the value of the Allow customizations option to false. Export the app as a managed solution. D. Within Managed Properties, set the value of the Allow customizations option to false. Export the app as an unmanaged solution.
Answer: C
Explanation: Scenario: The completed app and all supporting components must be provided to Tailwind Traders. Tailwind Traders must not be able to make changes to any of the components. Managed Solution: A managed solution is a finalized solution that can be distributed and installed. They are created by exporting an unmanaged solution by setting restrictions to prevent any further customizations. The whole point of Managed is locking down the Component states so they cannot be edited. Deleting the Managed Solution will remove all its customisations as well as data contained. Managed Solutions become read only once deployed so they cannot be manipulated.
QUESTION 6 You need to provide all app components of the application to Tailwind Traders. What should you do?
A. Package the application and flow components into a single solution for export. B. Run the app checker and flow checker prior to publishing each component for export. C. Export each component separately but use the same version number for each component. D. Publish the application and flow solutions at the same time before exporting each one.
Answer: B
Explanation: Scenario: When identifying versions of the app solution, all dependencies, entities, and user interfaces components must be identified to avoid any unintentional issues caused by reverting individual components to a previous version. Power Apps has added components to the rule set that encourages best practices in the Power Apps Checker. You can check your canvas apps and flows that are included in solutions and then review all issues in a single, consolidated report.
QUESTION 8 You need to meet the requirements for sales representative that submit status reports. How should you configure the flow?
A. Add a parallel branch that uses the value of a dynamic content variable B. Add a number functions action that evaluates the risk value by using a static variable to determine if an email is required C. Add a condition that evaluates the risk value by using a dynamic content variable D. Add a data operation action that evaluates a dynamic content variable
Answer: C
Explanation: Salespeople often do not set status of RFQs in the Sales Log to Won when a sale is closed and the customer purchase order is received. Include a dashboard that shows all currently active quotes, their status in the sales cycle, the probability of closing, and estimated manufacturing and installation dates, by customer, product division, status, and salesperson.
QUESTION 10 You need to create the mobile app. Which type of app should you create?
A. model-driven app B. portal app C. Microsoft 365 web app D. canvas app
Answer: D
Explanation: An accessible canvas app will allow users with vision, hearing, and other impairments to successfully use the app. In addition to being a requirement for many governments and organizations, following the below guidelines increases usability for all users, regardless of their abilities.