Category Archives: Microsoft

DP-600 Implementing Analytics Solutions Using Microsoft Fabric Exam

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

Examkingdom DP-600 Microsoft Exam pdf,

MCTS Training, MCITP Trainnig

Best Microsoft DP-600 Downloads, Microsoft DP-600 Dumps at Certkingdom.com

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?

A. displayMTML
B. show
C. write
D. display

Answer: D

SC-100 Microsoft Cybersecurity Architect Exam update January 23, 2024

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.


Examkingdom SC-100 Microsoft Exam pdf,

MCTS Training, MCITP Trainnig

Best Microsoft SC-100 Downloads, Microsoft SC-100 Dumps at Certkingdom.com

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.

Answer:

PL-300 Microsoft Power BI Data Analyst Exam Update February 6, 2024

Power Platform Overview:
Understanding the components of Power Platform: Power BI, Power Apps, Power Automate, and Power Virtual Agents.

Power Apps:
Canvas Apps vs. Model-Driven Apps.
Building and designing Power Apps.
Data sources and connections.

Power Automate:
Workflow automation.
Creating flows.
Integration with other Microsoft and third-party services.

Power BI:
Creating reports and dashboards.
Data visualization.
Power Query and Data Modeling.

Power Virtual Agents:
Creating chatbots.
Integration with other Power Platform components.

Common Data Service (CDS):
Understanding and working with CDS.
Entities, relationships, and data modeling.

Examkingdom PL-300 Microsoft Exam pdf,

MCTS Training, MCITP Trainnig

Best Microsoft PL-300 Downloads, Microsoft PL-300 Dumps at Certkingdom.com

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

Answer: B

PL-200 Microsoft Power Platform Functional Consultant Exam January 12, 2024 update

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.

Examkingdom Microsoft PL-200 Microsoft Power Platform Exam pdf,

MCTS Training, MCITP Trainnig

Best Microsoft PL-200 Microsoft Power Platform Downloads, Microsoft PL-200 Microsoft Power Platform Dumps at Certkingdom.com

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

Answer: D

MS-700 Managing Microsoft Teams Exam

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.

Examkingdom Microsoft Dynamics 365 MS-700 Exam pdf,

MCTS Training, MCITP Trainnig

Best Microsoft Dynamics 365 MS-700 Downloads, Microsoft Dynamics 365 MS-700 Dumps at Certkingdom.com

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

Answer: A

MB-500 Microsoft Dynamics 365: Finance and Operations Apps Developer Exam Skills measured as of December 27, 2023

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.

Examkingdom Microsoft Dynamics 365 MB-500 Exam pdf,

MCTS Training, MCITP Trainnig

Best Microsoft Dynamics 365 MB-500 Downloads, Microsoft Dynamics 365 MB-500 Dumps at Certkingdom.com

Skills measured as of December 27, 2023

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.

MS-900 Study guide for Exam MS-900: Microsoft 365 Fundamentals Skills measured as of January 22, 2024

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.

Examkingdom Microsoft MS-900 Exam pdf,

MCTS Training, MCITP Trainnig

Best Microsoft MS-900 Downloads, Microsoft MS-900 Dumps at Certkingdom.com

Skills measured as of January 22, 2024

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

Answer: A

AZ-801 Configuring Windows Server Hybrid Advanced Services Exam

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.

Examkingdom Microsoft AZ-801 Exam pdf,

MCTS Training, MCITP Trainnig

Best Microsoft AZ-801 Downloads, Microsoft AZ-801 Dumps at Certkingdom.com

Skills measured as of August 24, 2023

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:

PL-600 Microsoft Power Platform Solution Architect Skills measured as of September 26, 2023

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.

Examkingdom Microsoft PL-600 Exam pdf,

MCTS Training, MCITP Trainnig

Best Microsoft PL-600 Downloads, Microsoft PL-600 Dumps at Certkingdom.com

Skills at a glance

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.
 

PL-100 Microsoft Power Platform App Maker Exam Skills measured as of March 15, 2023

Skills measured as of March 15, 2023

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%)

Examkingdom Microsoft PL-100 Exam pdf,

MCTS Training, MCITP Trainnig

Best Microsoft PL-100 Downloads, Microsoft PL-100 Dumps at Certkingdom.com

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.