Microsoft Certified: Power Platform App Maker Associate

If you’re a business professional with deep expertise in your solution domain and you want to use your passion for building Microsoft Power Platform solutions to simplify, automate, and transform tasks and processes for your team, this certification is designed for you. You must have the skills to accomplish key technical business analyst tasks, such as data modeling, basic UX design, requirements analysis, and process analysis.

You fit the profile for the app maker role if you’re self-directed and solution-focused, and you work with the maker tools of Microsoft Power Platform to solve business problems. You might have experience with Visual Basic for Applications, Excel PivotTables, Teams, and other tools. Although you might not have formal IT training, you’re comfortable working with IT administrators and Microsoft Power Platform developers using technology to solve business problems. You’re responsible for:

Designing and creating apps and automating workflows.
Analyzing and visualizing data in context of an app or automated workflow.
Implementing and managing apps and automated workflows.
To learn more, read our post: Are you a Power Platform App Maker? Now’s the time to get certified. If you need more experience before you try for this certification, you could:
Volunteer on a project to get real-life experience with data modeling, basic UX design, requirements analysis, or process analysis.
Take learning paths on Microsoft Learn.
Sign up for an instructor-led training course.
Job role: Business Analyst, Business Owner, Business User, Data Analyst, Developer, DevOps Engineer, App Maker, Technology Manager
Required exams: PL-100
Important: See details

Audience Profile
The candidate envisions and creates 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 are comfortable using technology to solve business problems. The candidate is self-directed, and solution focused. They may connect to and use features of apps including 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 understands how to apply them. The candidate is an advocate for Power Platform solutions.

Skills Measured
NOTE: The bullets that follow each of the skills measured are intended to illustrate how we are assessing that skill. This list is NOT definitive or exhaustive.
NOTE: Most questions cover features that are general availability (GA). The exam may contain questions on Preview features if those features are commonly used.

business requirements  identify data sources  describe real-world objects as app entities  describe the user experience  create a high-level data model Identify required Microsoft Power Platform components  determine required app types  identify existing resources and licenses  identify gaps  map problem domain to Microsoft Power Platform tools  identify required flows  evaluate accelerators and third-party solutions Design data models Design business solutions (35- 40%) Create a high-level design  identify required data sources for a business solution  describe real-world objects as tables  describe the expected user experience for targeted devices and describe the differences between Microsoft Power Platform app types  create a high-level data model including source, volume, and intended uses Identify Microsoft Power Platform components  determine the required Power Apps app type  determine when to use Dataverse for Teams  determine required entities and objects  identify relationships  identify attribute types  determine requirements for offline access Design User Interface  identify opportunities for component reuse  apply user interface (UI) standards  design for accessibility  design for localization Design output  define data output requirements  define requirements for visualizations  identify sources for analytical data including Azure Data Lake Design security, privacy and compliance  identify sensitive data  identify applicable government regulations Understand app environments  understand how to get started building apps  describe the different types of app environments  understand solutions  understand where source data for a solution is located  map a problem domain to Microsoft Power Platform tools  identify options for implementing business logic  describe connectors  describe unmanaged solutions  describe uses cases for desktop flows  describe use cases for chatbots Design data models  determine required tables  identify relationships between tables  identify columns and data types Design the user interface (UI) for a business solution  identify opportunities for component reuse  apply UI standards  identify the model-driven forms and Dataverse views that are needed Design reporting  define data output requirements  define visualizations for Power BI dashboards  define visualization requirements for model-driven dashboards Create solutions (50-55%) Create a Microsoft Power Platform solution in a development environment  create a solution as a workspace for an app  create a Solution Publisher for a solution  modify the solution publisher for a solution Create model-driven apps Create solutions (45-50%) Manage Microsoft Power Platform development environments  create a solution  add existing apps and flows to a solution  run Solution Checker and interpret results Create model-driven apps  create model-driven apps within a solution  create a site map  create and configure Common Data Service entity forms  create and configure Common Data Service entity views  create model-driven dashboards  create model-driven charts for views  add existing Power BI reports to model-driven dashboards Create canvas apps  create canvas apps within a solution  connect to data sources in canvas apps  build canvas apps screens  configure solutions for offline access  use formulas and expressions  use collections and variables  describe the implications of design choices on app performance Create and Use Controls  add canvas app assets and components to screens  build canvas app components

Create and configure data stores  create a Common Data Service database  configure a connection for a data store  create Common Data Service entities based on a data model  link entities by using Common Data Service entity relationships  load or create data records for testing and development Create business logic  create Common Data Service business rules  create Common Data Service business process flows  compose model-driven apps  create a site map  create and configure Dataverse table forms  create and configure Dataverse table views  embed model-driven apps in Microsoft Teams channels  embed a canvas app on a form in a model-driven app  manage versions of canvas apps  publish and share canvas apps  share model-driven apps Create canvas apps  create canvas apps  connect to data sources in canvas apps  build canvas apps screens  compose Power Fx formulas  implement collections and variables  interpret App Checker results  add canvas app assets and components to screens Configure Microsoft Dataverse  create tables and table columns based on a data model  link tables by using lookups or relationships  load or create data records for testing and development  publish customizations  create Dataverse business rules  configure security roles Create Power Automate flows  create business process flows  create cloud flows  configure triggers  create Common Data Service classic workflows  create business logic using Power Automate flows  create Canvas app formulas and events Create Power Automate flows  create flows as a solution  create trigger actions  build scheduled, automated, and instant flows  create flow actions  run Flow Checker  test a flow  create expressions and loops  build scheduled, automated, and instant flows  configure flow steps  test a flow  implement common expressions and loops  create adaptive cards for Microsoft Teams  create and monitor approvals from Power Automate, Microsoft Teams, and SharePoint  share flows Create Power Virtual Agents chatbots in Microsoft Teams  create a chatbot  test a chatbot  publish a chatbot Analyze data (5-10%) Create Power BI reports  create Power BI report by using Power BI Desktop  create Power BI report by using Power BI service Implement other reports  consume SQL Server Reporting Services (SSRS) reports  merge data from a solution into a template Build AI Builder models  create AI Builder model types  consume AI Builder models  train models by using historical data Analyze and visualize data (15- 20%) Create Power BI reports  create Power BI report by using Power BI Desktop  create Power BI report by using Power BI service  embed canvas apps in Power Bi reports and dashboards  share Power BI reports and dashboards Implement other reports  merge data from a data source into a Microsoft Word or Excel template  create model-driven dashboards  embed Power BI content in Power Apps Describe AI Builder models  identify model types including prebuilt and custom models  describe the process for preparing data and training models  use a model from within Power Automate or Power Apps Implement and manage solutions (15-20%) Configure solution security  configure Common Data Service security roles  configure Common Data Service field security Test an application and flows  describe the solution testing process  implement available Microsoft Power Platform testing tools  validate accessibility Secure the solution  manage data security  manage app security  define a distribution method for flows  configure security for Power BI Deploy the solution  export solutions  support deployment of solutions to production environments Manage versions of the solution  create new versions of an app  restore a previous version of an app  publish a new version of an app

QUESTION 1
You are creating a multi-page canvas app that loads tabular data from an external data source.
Once loaded, the data must be available to all screens within the canvas app.
You need to reduce the number of times that the app must retrieve data from the data source.
Which two data stores can you use? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.

A. parameter
B. global variable
C. collection
D. environment variable

Correct Answer: CD

Explanation:
C: A special kind of data source is the Collection, which is local to the app and not backed by a connection to a service in the cloud, so the information can not be shared across devices for the same user or between users.
Collections can be loaded and saved locally.
D: Don’t use environment variables if you only have one environment. Use collection variables. Having a single environment connected to the collection creates more overhead.

QUESTION 2
You are creating a model-driven app that allows users to create and edit a list of existing accounts.
You need to display a list of all active accounts.
Which user interface components should you use?

A. view
B. gallery
C. data table
D. form

Correct Answer: A

Explanation:
With Power Apps apps, use views to define how a list of rows for a specific table is displayed in the application.

QUESTION 3
You need to connect to the data source for the Job Setup app.
What should you do?

A. Configure a scheduled synchronization with the Common Data Service database
B. Configure SQL Server database permissions
C. Create a stored procedure that retrieves time records for a specific employee
D. Configure an on-premises data gateway

Correct Answer: D

Explanation:
Scenario: The Job Setup entity must store its data in the existing on-premises SQL Server instance.
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, Power Apps, 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 4
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You are creating a canvas app.
You need to automatically detect bicycles in pictures taken with the camera.
Proposed solution:
Create an Object Detection custom model in AI Builder.
Train the model with pictures of bicycles and then publish the trained model.
Add the Object Detector control to your canvas app.
Does the solution meet the goal?

A. Yes
B. No

Correct Answer: A

Explanation:
To train an object detection model to recognize your objects, you have to gather images that contain those objects.
The first thing you’ll do when you create an AI Builder object detection model is to define its domain.
Upload images
Then Train and publish your object detection model
The object detector component takes a photo or loads an image file to do an object detection scan. On a mobile device, the user chooses between taking a photo or selecting one already available in the device user
interface. When an image is selected, the component automatically scans it to identify objects.

QUESTION 5
You create a dashboard in Power BI. You share the dashboard with the sales team.
Sales team members report that they can see information for the entire company.
You need to ensure that the team is able to see only data for their team.
Where must you configure this restriction?

A. Dashboard
B. Report
C. Dataset
D. Settings

Correct Answer: C

Explanation:
Restrict access to the dataset.
Note: Another way of setting access is through manage permission in the dashboard, report, or dataset. If you share a dashboard, by default the report and the dataset will also be shared as read-only for users.

Actualkey Microsoft PL-100 Exam pdf, Certkingdom Microsoft PL-100 PDF

Best Microsoft PL-100 Certification, Microsoft PL-100 Training at Certkingdom.com