Free Microsoft Power Platform Fundamentals Questions and Answers — Questions and Answers

Question 1: A business hosts gatherings. Customers must be able to see forthcoming conferences that your business will be hosting. Which component of the Power Apps should you use?

Power Apps portal (Correct answer)
Business process flow
Canvas app
Model-driven app

Correct answer: Power Apps portal

A Power Apps portal is the ideal component for hosting public-facing websites that allow external users, like customers, to view information and interact with business data. Unlike canvas or model-driven apps, which are typically for internal users, portals are designed for broad public access and can display forthcoming events or conferences.

Question 2: Microsoft Power Platform is utilized by a business. You must suggest an application scenario for formulae in canvas apps. Which two steps would you suggest? Each accurate response offers an entire resolution. Select all applicable answers.

Filter a list of rows. (Correct answer)
Control which users can operate a canvas app.
When a user clicks a button, the data is saved. (Correct answer)
Get XML information from a web page.

Correct answer: Filter a list of rows.

Formulas in canvas apps are essential for defining logic, calculations, and actions. They can be used to 'Filter a list of rows' based on specific criteria, allowing users to view relevant data. Additionally, formulas are used to trigger actions, such as 'When a user clicks a button, the data is saved,' enabling data manipulation and interaction within the app.

Question 3: You design the app. You must make sure the app shows information from an Azure SQL database. Which should you employ?

Canvas app (Correct answer)
Microsoft Dataverse
Model-driven app
Power Apps portal

Correct answer: Canvas app

A canvas app is the most suitable choice for displaying information from an Azure SQL database. Canvas apps offer great flexibility in design and allow direct connections to a wide variety of data sources, including external databases like Azure SQL. This enables developers to create highly customized user interfaces for data presentation.

Question 4: You want to build a knowledge base for the web. For suppliers to have access to the knowledge base's stored data, you must permit self-registration. What should you create?

Cloud flow
Portal app (Correct answer)
Model-driven app
Canvas app

Correct answer: Portal app

To build a web-based knowledge base accessible to suppliers with self-registration capabilities, a Portal app (Power Apps portal) is the correct choice. Portals are designed for external-facing websites, allowing non-licensed users to securely access and interact with data, including features like self-registration for account creation.

Question 5: A Microsoft Dataverse table is linked to a canvas app that you construct. You must share the app. What are the two things you should do? Each right response offers a piece of the answer. Select all applicable answers.

Email the users to inform them.
Publish the app. (Correct answer)
Permit users to edit the application.
Incorporate a security role. (Correct answer)

Correct answer: Publish the app.

When sharing a canvas app linked to Microsoft Dataverse, two crucial steps are required. First, you must 'Publish the app' to make the latest version available to users. Second, you need to 'Incorporate a security role' to control what data users can access within Dataverse, ensuring data security and proper permissions.

Question 6: You set up a canvas app to monitor and purchase office supplies. Users of the app can order a variety of stationery products. Every time a user reopens the app, the items they previously selected must be reset. User choices must be stored. Which one should you select?

Dataverse
SharePoint
Variable
Collection (Correct answer)

Correct answer: Collection

To store user selections temporarily within a canvas app session, where the data resets each time the app is reopened, a 'Collection' is the appropriate choice. Collections are in-memory tables that allow you to store and manipulate data locally within the app, making them ideal for managing temporary selections or shopping cart items that don't need persistent storage.

Question 7: Microsoft Power Platform and SharePoint are used by a corporation. A canvas app that can see and edit items in an existing SharePoint list must be created. Which two places can you make this app in? Each accurate response offers an entire resolution. Select all applicable answers.

SharePoint list (Correct answer)
SharePoint document library
Power Apps maker portal (Correct answer)
Power Apps Studio

Correct answer: SharePoint list

A canvas app that interacts with an existing SharePoint list can be created from two primary locations. You can initiate the app creation directly from the 'SharePoint list' itself, which automatically generates a basic app connected to that list. Alternatively, you can start from the 'Power Apps maker portal' and then connect to the SharePoint list as a data source.

Question 8: Create a canvas application. Users must be able to choose from one or more values for a field. Which three controls are the best to use? Each accurate response offers an entire resolution. Select all applicable answers.

List box (Correct answer)
Rating
Radio
Combo box (Correct answer)
Dropdown (Correct answer)

Correct answer: List box

To allow users to select one or more values for a field in a canvas app, several controls are effective. A 'List box' explicitly supports multi-selection, letting users pick multiple items from a visible list. A 'Combo box' also offers multi-select capabilities and a search function, while a 'Dropdown' allows selection from a list and can be configured for multi-select in some contexts, or is a common choice for single selection from a list of values.

Question 9: You save your products in a Microsoft Dataverse table. To list the products in the app, you construct a canvas app. You must make it possible for users to view each product's code, description, and image. Which control should you employ?

Form
Drop-down
Data table
Gallery (Correct answer)

Correct answer: Gallery

A 'Gallery' control is the best choice for displaying a list of products with multiple fields like code, description, and an image. Galleries allow you to create custom, repeating layouts for each item in a data source, making them highly flexible for showcasing complex data records visually. You can easily arrange text labels and image controls within each gallery item.

Question 10: A business has an app that uses models. All users must be given access to the app's data. What should you do?

Create a new model-driven app.
Create a new public view. (Correct answer)
Create a new table.
Create a new personal view.

Correct answer: Create a new public view.

To give all users access to the data presented in a model-driven app, you should 'Create a new public view.' Public views define how records are displayed (which columns, filters, and sort order) and are accessible to everyone with appropriate security roles. This ensures consistent data presentation across the organization.

Question 11: A company has a sales management model-driven app. The contact job titles that are presented in the account form's list of contacts must be included. What has to be changed?

app sitemap
contact view (Correct answer)
contact form
account form
account view

Correct answer: contact view

To include contact job titles in the list of contacts displayed within an account form, you need to modify the 'contact view.' Views define which columns (fields) are visible when a list of records is presented. By editing the contact view associated with the subgrid on the account form, you can add the job title column to be displayed.

Question 12: You must create a low-code application that has web forms for gathering and displaying user data. Which should you employ?

Power Apps (Correct answer)
Power Automate
Power BI
Power Virtual Agents

Correct answer: Power Apps

Power Apps is the core component of the Microsoft Power Platform for building low-code applications with web forms. It enables users to create custom applications that can gather and display data without extensive coding knowledge. These apps can connect to various data sources and be deployed across web and mobile platforms.

Question 13: You must establish a sales quote approval procedure. Which component of the Microsoft Power Platform should you use?

Power BI
Power Virtual Agents
Power Automate (Correct answer)
AI Builder

Correct answer: Power Automate

To establish a sales quote approval procedure, 'Power Automate' is the ideal component of the Microsoft Power Platform. Power Automate specializes in creating automated workflows and business processes, including multi-step approvals. It can integrate with various services to trigger actions, send notifications, and manage the approval flow for sales quotes.

Question 14: A business employs a customer service program from a third party. The solution employs Microsoft SQL Server as the data store and is on-premises. In a canvas app, you must display the customer service data. Which should you employ?

AI Builder
Power Virtual Agents
Power BI
Connector (Correct answer)

Correct answer: Connector

To display customer service data from an on-premises Microsoft SQL Server in a canvas app, you must employ a 'Connector.' Connectors act as bridges that allow Power Apps to communicate with external data sources. For on-premises data, a data gateway is also required to securely connect the Power Platform to your local SQL Server.

Question 15: Microsoft Power Platform is employed by a business. The business must read text from photographs that have been uploaded. You must choose the connector to use. Which connector should you utilize?

Azure Cognitive Services (Correct answer)
Microsoft Dataverse
Microsoft Teams
Azure Blob storage

Correct answer: Azure Cognitive Services

To read text from uploaded photographs, the 'Azure Cognitive Services' connector should be utilized. Azure Cognitive Services provides powerful AI capabilities, including Optical Character Recognition (OCR), which can extract text from images. This connector allows Power Platform components to leverage these advanced AI features for text extraction and analysis.

Question 16: Microsoft Power Platform is employed by a business. The business creates Power BI dashboards, Power Apps canvas apps, and Power Virtual Agents chatbots. You must determine which Microsoft Power Platform component can be used in direct conjunction with these three components. What should you identify?

Power Automate (Correct answer)
AI Builder
Model-driven apps
Microsoft Dataverse

Correct answer: Power Automate

Power Automate is the Microsoft Power Platform component that can be used in direct conjunction with Power BI dashboards, Power Apps canvas apps, and Power Virtual Agents chatbots. It serves as the automation engine, allowing you to create workflows that trigger actions, move data, and automate tasks across these different components, enhancing their functionality and integration.

Free Microsoft Power Platform Fundamentals Questions and Answers

A business hosts gatherings.
Customers must be able to see forthcoming conferences that your business will be hosting.
Which component of the Power Apps should you use?