Power Platform Fundamentals - Practice Test

A company receives documents as PDF attachments by email. You need to process these documents automatically without user interaction by using Microsoft Power Platform. Which two components should you use? Each correct answer presents part of the solution.

AI Builder Power Automate cloud flow

A company uses Power Virtual Agents to display information to authenticated users. You need to retrieve data from a Microsoft Dataverse table. What should you use?

Actions

A company uses a model-driven app for customer data management. You create a new column. Users report that they cannot view the column when they edit records. You need to ensure users can view the column. Which two actions should you perform? Each correct answer presents part of the solution.

Add the column on the form. Publish customizations. This item tests the candidate's knowledge of modifying forms in model-driven apps. In model-driven apps, forms provide the UI that users can use to interact with the underlying Dataverse table data. A form allows a user to view or edit a record. If a new column is added to a Dataverse table, the column is not added to the form. To make the column available to users, the column must be added to the form and then published to ensure the changes are available to users. Views in Dataverse will display the list of records in a table based on filter criteria. Adding the column to a view will not enable users to edit the column value. Tables in model-driven apps can be added through pages. This does not affect column visibility on forms.

You plan to build a Power Automate flow. The flow needs to loop through all rows in an Excel spreadsheet and update the first column value for all rows with the current date. You need to configure the action for the flow. Which action should you use?

Apply to each The Apply to each action allows to loop through items in a collection. In this case, this action can be used to loop through each of the rows in the spreadsheet. Do until allows you to loop through items until a specified condition is met. In this scenario, there is no condition, and every item must be looped through. Switch allows taking an input parameter and performing different steps based on the input's value. In this case, there are no separate actions to take, but the same action to perform on every single row in the spreadsheet. The condition action allows setting up a conditional statement and then perform an action based on whether the condition is true or false. In this scenario, there is no condition to evaluate since every row must be handled the same way.

You create a model-driven app by using Power Apps. The app uses a custom Microsoft Dataverse table that has no privileges assigned. You need to share the app with a user. Which two actions should you perform? Each correct answer presents part of the solution.

Assign a security role to the custom table. Select the user with whom you want to share the app and select a security role for the user. Click the Share button. This item tests the candidate's knowledge of how to share a model-driven app. For users to have access to the custom table in the app, a security role must be assigned to it. To share a model-driven app, a security role must be assigned to a user when sharing the app. When sharing a canvas app, a co-owner can be selected. In this case, a co-owner cannot be set because this is a model-driven app. Navigating to the details page this will give the user the location of the app, but it will not grant any permissions to the user. If the user has not already been granted permission, they will get an error message when they load the Power Apps app.

A company uses Microsoft Power Platform. You need to recommend whether to use Microsoft Dataverse or Microsoft Dataverse for Teams to store data for a new Power Apps app. Which two features are unique to Microsoft Dataverse? Each correct answer presents a complete solution.

Auditing Multiple business units

You need to create a Power BI visualization that displays month-by-month revenue comparisons for the current and previous years. Which chart type should you use?

Bar

You plan to build a Power BI report for a sales team. You need to display the sales revenue for the top fifteen product categories. Which chart type should you use?

Bar

You plan to create a Power Apps app. You need to enable users to read and write data from SharePoint and OneDrive for Business. Which type of app should you use?

Canvas app

You plan to create a data model by using Microsoft Dataverse. You have a column that allows users to select one of two options: Approve or Reject. You need to allow for adding more options to the column or changing the label of the options in the future. Which type of column should you create?

Choice

You use Microsoft Dataverse to develop a data model for a company. You plan to use a custom table named Problem to store information about problems reported by customers. Problems will be assigned a low, medium, or high severity. You need to capture the problem severity. Which type of column should you use?

Choice

A real estate company plans to use Microsoft Dataverse to track apartments. You need to create a new column to store whether an apartment is available for rent, for sale, or both. Which column type you should use?

Choices This item tests the candidate's knowledge of selecting Microsoft Dataverse column types. The Choices column type can select multiple options between multiple values. The Choice column type can select only one option between multiple values. The Yes/No column type can select only one option between two values. Customer references to an Account or a Contact.

You build a Power BI report by using Power BI Desktop. The data is based on a complex set of data that includes multiple data tables that have many-to-one relationships with each other. You need to visually represent the tables and their relationships so that you can understand the data you are working with before you build the report. What should you do?

Click on the Modeling view and examine the diagram of available tables and their relationships with each other.

A tire manufacturer stores manufacturing data in SQL Server and sales data in Microsoft Dataverse tables. An operations manager needs to view a single page of information each day that shows the following: The number of defects in the manufacturing process. The sales by geographic region from the prior day. You need to configure Power BI. Which action should you perform?

Create a Power BI Dashboard by using the Power BI service

A company uses Microsoft Power Platform. You model the data in Microsoft Dataverse and create a model-driven app. You need to create a new model-driven app for a different group of users. The model-driven app must restrict the columns in a table that users can change the values. Which two actions should you perform? Each correct answer presents part of the solution.

Create a new form for the Microsoft Dataverse table. Select the form in the app designer. This item tests the candidate's knowledge of modifying forms in model-driven apps. Model-driven app forms are linked to a Microsoft Dataverse table. A form displays a subset of the columns for that table. To enable a different group of users to edit different fields, a new form should be created. A Microsoft Dataverse table can have multiple forms containing different columns from the table and different layouts. The app designer can select which of the forms is available in the app. Business process flows are associated with a Microsoft Dataverse table not the forms for the table. A view displays columns from the table but as a list. A form is required to edit the data.

A company uses Microsoft Power Platform. You need to prevent external leakage of corporate data. What should you do?

Create data policies.

You plan to build a canvas app. You need to ensure the app is automatically available to all members of a Microsoft 365 group. What should you do?

Create the app in a Microsoft Dataverse for Teams environment.

A company has three branch offices in New York, Paris, and Madrid. You need to create the Microsoft Dataverse environments and the Microsoft Dataverse instances. What should you do?

Create three environments, each with one instance.

A company uses an in-house web application for employee self-service. The company wants to automate business processes. You need to connect to the web application's API for the automation. Which Microsoft Power Platform service should you use?

Custom connector

A company has a public-facing portal for its partners. You need to fetch data from the portal in a flow. Which solution should you use?

Custom connector The item tests the candidate's knowledge of connectors in Microsoft Power Platform. Custom connectors can be used to connect to custom APIs and pull data, in the absence of a prebuilt connector. AI Builder connector enables adding intelligence to automated processes, predicting outcomes, and helping improve business performance. Microsoft Dataverse connector is used to perform data operations against a Microsoft Dataverse data store. It cannot be used to fetch data from a custom-built portal. Dataflows are used to extract and transform data. They cannot be used to fetch data in a Power Automate flow.

You create a Power Virtual Agents chatbot. You need to ensure that the chatbot understands natural language phrases. What should you add to the chatbot?

Custom entities This item tests the candidate's knowledge of the various components that can be used when building a chatbot. A Power Virtual Agents entity allows a chatbot to map natural language to a general subject. Topics are used to determine the general category of the conversation. A channel allows a bot to be available to a particular platform, such as Microsoft Teams. However, a channel does not handle natural language processing in a chatbot. While it is possible to call a Power Automate action from a chatbot, this is not intended for handling natural language processing in a chatbot.

You need to identify the capabilities of the Power BI service compared to Power BI Desktop. Which two features are only available in the Power BI service? Each correct answer presents a complete solution.

Dashboards Workspaces

You create Power BI reports by using Power BI Desktop. You need to recommend how to create a relationship between the two tables in Power BI Desktop. Which two sections should you recommend? Each correct answer presents a complete solution.

Data Model

You configure security and compliance features in Microsoft Power Platform. You need to restrict access to all social media connectors. What should you configure?

Data loss prevention (DLP) policy The item tests the candidate's knowledge of Microsoft Power Platform governance capabilities. Data loss prevention policies can be used to control the use of connectors to data and services. DLP policies allow classifying connectors as business, non-business, and blocked. Microsoft Dataverse security roles can be used to provide users access to tables and records. Licenses can be used to allow users to access components of Microsoft Power Platform. Microsoft Dataverse security roles and licenses cannot be used to restrict access to specific social media connectors. Office 365 security groups can be used to control access to environments in Microsoft Power Platform.

A company uses a set of model-driven apps within a single environment in Microsoft Power Platform. You need to share a new model-driven app with users. What should you assign to users to enable them to access the app?

Dataverse security role This item tests the candidate's knowledge of the Microsoft Power Platform security model. Model-driven apps use role-based security to control access to the app, its features, and its data. A model-driven app is associated with one or more Dataverse security roles. You must associate one of these security roles with users to enable them to access and run the app. When you share a model-driven app with a user, you are prompted to share the security roles with the user as well.

You create a Power BI report. You need to share the report with internal users. Which two actions should you perform? Each correct answer presents a complete solution.

Embed the report in a secure portal. Use the Power BI mobile app.

A company uses Microsoft Power Platform. You need to recommend a use case for formulas in canvas apps. Which two actions should you recommend? Each correct answer presents a complete solution.

Filter a list of rows. Save data when a user selects a button. This item tests the candidate's knowledge of the use cases for formulas. FILTER is a common formula used in canvas apps to restrict the rows from a data source or collection. The OnSelect property for a button contains the actions to perform. Formulas such as SubmitForm and Patch are used to save data to a data source. Formulas are not used to share a canvas app. Formulas can only be used when building a canvas app. There is no equivalent formula for the WEBSERVICE Excel function that retrieves XML data from an internet URL.

You need to install and configure prebuilt Power BI dashboards and reports. Which two actions should you perform? Each correct answer presents part of the solution.

Find a Power BI template app in the Power BI Apps marketplace and install it. Connect the app to the data.

You use a Microsoft Dataverse table to store products. You create a canvas app to list the products in the app. You need to enable users to view the product code, description, and image of each product. Which control should you use?

Gallery

A company uses Microsoft Dataverse. You plan to create a one-to-many relationship between two tables named TableA and TableB in Microsoft Dataverse. You need to identify the column data type that is created for the relationship in TableB. What should you identify?

Lookup

A company is evaluating Microsoft Dataverse and Microsoft Dataverse for Teams. You need to determine which features are only available in Microsoft Dataverse. Which two features should you identify? Each correct answer presents a complete solution.

Multiple currency support Mobile offline This item tests the candidate's knowledge of limitations regarding Microsoft Dataverse for Teams compared to Microsoft Dataverse. Microsoft Dataverse for Teams does not support multiple currencies or Mobile offline. These are unique to Microsoft Dataverse. Microsoft Dataverse and Microsoft Dataverse for Teams both have file and image support. Microsoft Dataverse for Teams also supports relational storage.

You plan to create a web-based knowledge base. You need to allow suppliers to register themselves to gain access to information stored in the knowledge base. What should you create?

Portal app This item tests the candidate's knowledge of the basic difference between Microsoft Power Platform components, including Power Apps app types. A portal app, using the Partner portal template, allows users to register themselves for your portal app web site. The knowledge management feature in the app can be used to allow suppliers to read documentation from the company. Canvas apps in general are built from scratch and would take much more time to build than a portal app that uses the partner portal template with the knowledge base feature. Additionally, canvas app requires the app to be shared explicitly with each external user and cannot be published in a way that allows users to sign themselves up for access. Model-driven apps do not allow for self-service registration to gain access to the app. A cloud flow can be used within a larger solution, but a flow does not have any user interface that users can interact with, so it does not meet the requirements of allowing users to log in and view information in a web-based solution.

You need to build a low-code application that includes online forms for collecting and displaying information from users. What should you use?

Power Apps

A company receives written letters. You need to allow users to record and track the letters. Which solution should you use?

Power Apps This item tests the candidate's knowledge of selecting the right Microsoft Power Platform component. Power Apps provides a rapid low code development environment for building custom apps for business needs. Power Automate is used to create workflows between applications and services. Power Virtual Agents allows chatbots to be created. Power BI is a business analytics service.

A company hosts conferences. You need to enable customers to view upcoming conferences hosted by your company. Which Power Apps component should you use?

Power Apps portal This item tests the candidate's knowledge of selecting Power Apps components. Power Apps portals allow you to create a website for external users. Canvas apps, model-driven apps, and business process flows are not suitable for external users.

A company is evaluating Microsoft Power Platform. The company needs to send out a reminder to specific teams to complete their timesheet. The reminder should be sent on Wednesday and Friday every week. You need to determine which Microsoft Power Platform tool to use. What should you use?

Power Automate

A company plans to use Microsoft Power Platform to transform its business. The company wants to digitize its invoice approval process to remove all manual steps. You need to recommend the appropriate Microsoft Power Platform product. Which product should you recommend?

Power Automate

A company uses Microsoft Power Platform to manage support activities. Support technicians must be notified by email when a new support request is created. You need to recommend the appropriate tool to meet this requirement. Which tool should you recommend?

Power Automate

A company uses Microsoft Power Platform. The company builds Power Apps canvas apps, Power BI dashboards, and Power Virtual Agents chatbots. You need to identify the Microsoft Power Platform component that can be used directly with these three components. What should you identify?

Power Automate

A company uses Power Virtual Agents. You need to perform actions in Microsoft Dataverse by using a chatbot. What should you use?

Power Automate

You need to create an approval process for sales quotes. Which Microsoft Power Platform component should you use?

Power Automate

A company plans to create an app by using Microsoft Power Platform. The app should be able to email sales quotes to customers. You need to automate the process of sending sales quotes. What should you use?

Power Automate The item tests the candidate's knowledge of using Power Automate to automate processes. With Power Automate, email notifications can be sent with attachments. Power Apps allows creating complex user interfaces with cross-browser and cross-device compatibility. Power BI is used for analytics and provides insights with interactive visualizations. Power Virtual Agents allow users to build chatbots for support scenarios. Power Apps, Power BI, and Power Virtual Agents cannot be used to send automated emails.

You need to modify a cloud flow. Which three solutions should you use? Each correct answer presents part of the solution.

Power Automate portal Power Automate mobile app Power Apps Studio This item tests the candidate's knowledge of modifying a cloud flow. The Power Automate portal, Power Automate mobile app, and Power Apps Studio can be used to modify cloud flows. Power Automate Desktop and Power Virtual Agents do not allow modifying cloud flows.

A company uses Microsoft Dynamics 365 Sales to manage its sales process. Sales managers need access to more detailed analytics than what is available in Sales. You need to identify which Microsoft Power Platform application creates the required analytics reports. Which application should you select?

Power BI

A company uses Microsoft Power Platform. You need to enable users to ask questions with natural language phrases. Which two Microsoft Power Platform components should you use? Each correct answer presents a complete solution.

Power BI Power Virtual Agents

A company uses Microsoft Power Platform. You need to enable users to ask questions with natural language phrases. Which two Microsoft Power Platform components should you use? Each correct answer presents a complete solution.

Power BI Power Virtual Agents This item tests the candidate's knowledge of the business value of Power BI and Power Virtual Agents. The Q&A feature in Power BI dashboards allows users to ask questions of their data using natural language and creates new visualizations based on the question and data. Power Virtual Agents chatbots can understand the phrases supplied by users in natural language and can determine the topic and conversation to be used to respond to the user. Power Automate and Microsoft Dataverse do not include a user interface that permits users to ask questions.

A company uses Microsoft Dynamics 365 Customer Service. You implement a portal app that allows customers to raise support tickets. You need to enable interactive support functionality in the portal. Which solution should you use?

Power Virtual Agents

You create a chatbot in Microsoft Teams by using Power Virtual Agents. You need to configure the chatbot to identify when an email address is included in a user's response to the chatbot. What should you use?

Prebuilt entities

A company has a custom API. The API downloads Microsoft Excel and Microsoft Word files from an internal server. You need to fetch data inside Power Automate. Which two connectors can you use? Each correct answer presents a complete solution.

Premium HTTP connector Custom connector This item tests the candidate's knowledge of custom connectors. The Premium HTTP connector and a custom connector can fetch data from a custom API. The Word Online (Business) connector and the Excel Online (Business) connector can only work with Word files in document libraries supported by Microsoft Graph.

You create a canvas app that is connected to a Microsoft Dataverse table. You need to share the app. Which two actions should you perform? Each correct answer presents part of the solution.

Publish the app. Assign a security role. This item tests the candidate's knowledge of sharing a canvas app when users need to edit it. A canvas app must be published before it can be shared. When a canvas app is connected to a Microsoft Dataverse table, a security role must be assigned. The email is only a notification. It does not affect sharing capabilities. To share an app, it is not required to allow users to edit it.

You create a Power Automate cloud flow. The cloud flow fails at a step. You need to send an email notification to the flow owner whenever a step fails. What should you configure?

Run after

A company stores data in different systems. You need to show the data by using Power BI. Which three data sources should you use? Each correct answer presents a complete solution.

SQL Server CSV file Excel workbook

You plan to create Power Pages websites on a new Microsoft Power Platform environment. You need to accelerate the creation of the websites. Which two types of templates can you use to meet the requirement? Each answer presents a complete solution.

Scenario-based Site design

A company has a list of new employees. The company wants to use Yammer to send a daily welcome message to new employees. You need to write a flow that checks the list for new employees without human intervention. Which type of flow should you use?

Scheduled cloud flow This item tests the candidate's knowledge of different types of cloud flows. Schedule flows run on an interval. The flow can be set to run once a day. Instant flows are usually triggered with manual action. In this case, the flow must run by itself daily. An automated cloud flow is triggered when a particular event takes place. In this case, the flow should run at a designated time each day, and not when an action is performed. Business process flows are used to guide users through multi-step processes. In this case, the flow is taking place without human intervention.

You plan to create a canvas app that allows users to view a list of current scores for all local professional sporting events. Each game should display the following: Name of the game. Amount of time left in the game. A link to a map of the game's location. You need to add controls to your Power Apps app. Which two controls should you use? Each correct answer presents part of the solution.

Screen Gallery This item tests the candidate's knowledge of the basic controls used when building a canvas app. A canvas app must have a minimum of one screen. A screen is a container for other controls. Adding a gallery control tied to game data means that each game can be displayed as an item in the gallery. Additionally, you can add other controls to a gallery item, such as a link to the game location. A form control displays information from one record in a dataset but does not present the data from multiple rows of data at once. A list box is used for displaying a list of values when a user needs to choose options from an available list. A data table returns information in a tabular format like a spreadsheet. It does not allow rich formatting such as adding hyperlinks to row or column data.

You create and publish a canvas app. Users report issues with the latest version of the app. You need to revert the app to an earlier working version. Which two actions should you perform? Each correct answer presents part of the solution.

Select an earlier version of the app and click on Restore. Publish the restored version of the app.

You create a custom AI Builder model to track the count of products by category. Users report that they are not able to use the model from within the Power Apps app that they use. You need to ensure the model is available to the users. What should you do?

Share the model. This item tests the candidate's knowledge of the life cycle of creating a custom AI Builder model. The life cycle of creating a custom AI Builder model consists of creating, training, publishing, and testing the model within your apps or flows. When a model is published, the model is available only to the maker unless it is explicitly shared with other users. Training or publishing a model does not make it available for users.

You build a solution by using Microsoft Power Platform and Microsoft Dataverse. You must use the default Currency table that comes with your Microsoft Dataverse subscription. You need to determine the table type for the Currency table. Which table type should you identify?

Standard

You are configuring Sitemap for a model-driven app. You need to add a table to the navigation pane of the app. Where should you add the table?

Subarea The item tests the candidate's knowledge of designing the navigation pane of a model-driven app. Subarea in sitemap can be used to show tables/ dashboards/custom pages. You can add multiple subareas to a group. A group in Sitemap cannot be linked to show a table. Area can have multiple groups and each group can have multiple subareas. An area cannot be used to show a table. Command bar in a model-driven app displays context-specific menu items on a grid, form, or subgrid. They are not part of Sitemap navigation.

A company uses Microsoft Dataverse. You need to define views to display data in model-driven apps. Which three items can you configure in the view designer? Each correct answer presents part of the solution.

The columns included in the view. The filter for rows shown in the view. The sort order of rows in the view. This item tests the candidate's knowledge of creating and modifying views. The view designer allows you to select the columns from the table to be shown and define the filter criteria for the rows to be shown in the view. The view designer also allows you to specify the sorting behavior of the rows in the view. The app designer determines which view is included in the app, not the view designer. All views can be filtered by the user in a model-driven app.

A company uses Microsoft Power Platform. You need to identify the features of model-driven apps. What are three features of model-driven apps? Each correct answer presents a complete solution.

They adjust the layout of the UI automatically in response to changes in a device's orientation or screen resolution. They embed Power BI dashboards. They guide users by using business process flows.

You build a Power Virtual Agents bot. You add a topic to the bot. You need to train the bot to understand how someone might ask for a topic. What should you add to the bot?

Trigger phrases

A company uses Power BI. You need to collaborate with others to build visualizations. What should you use?

Workspace This item tests the candidate's knowledge of comparing and contrasting the usage of dashboards, workspaces, and reports. Workspaces are used to collaborate on building content for Power BI including datasets, reports, and dashboards. Datasets are created when data is imported. Visualizations are created from datasets. A dataset can be used in many workspaces but to collaborate, a workspace must be used. My workspace is a personal space for creating reports and dashboards in Power BI. This workspace cannot be used to collaborate. My workspace is a personal space for creating reports and dashboards in Power BI, which cannot be used to collaborate. Visualizations are added to reports, but you must use a workspace in order to collaborate on building visualizations in reports. Dashboards can be created from the visualizations in the reports.

You have a table in a Power BI dataset. You add a clustered column chart visual to the report page. You need to show the count of rows in the table as columns for each category in the table. Which field well should you add to the row count measure?

Y-axis This item tests the candidate's knowledge of creating a Power BI report. The field that shows the numeric values, the height of the columns, should be added to the Y-axis in a column chart visual. The field that shows the colors for categories should be added to the legend well. The category that groups the rows by should be added to the X-axis in a column chart visual. The values are not available for a column chart visual. Other visuals such as the pie chart visual use the values well.

You create a canvas app. You need to format currency values in the app to always display two decimal places. Which code segment should you use?

`Text("Currency value", "$#, ###0.00") `

You create a flow by using Power Automate. The flow must notify a user every time a new item is added to a SharePoint list. You need to ensure an email notification is added to the flow. What should you use?

action

A company is considering using Power Pages for its website. You need to identify the capabilities of Power Pages. What are two capabilities of Power Pages? Each correct answer presents a complete solution.

building sites by using low-code tools exposing data in Dataverse to customers

A company has a sales management model-driven app. You need to add the contact job titles in the list of contacts that is displayed in the account form. What should you modify?

contact view This item tests the candidate's knowledge of the model-driven app components and how to modify views. The contact view that is displayed in the account form needs to be modified to include the contact's job title. The app sitemap defines the navigation and components that are part of the app; the form and the view are already part of it. The contact form is used to display the details of a specific contact, but the request is about the list of contacts. The account form is used to display the list of contacts (view) but doesn't define which columns appear in it. The account view lists accounts, not the contacts.

A company plans to use Power Automate to help digitize its operations. The company requires a solution that creates invoices in an application that does not include modern APIs. You need to select the Power Automate flow that meets the requirement. Which type of Power Automate flow should you select?

desktop flow

A company uses Power Virtual Agents to manage routine customer requests. You use Power Automate to pass these requests to your back-end systems. You need to mimic the onscreen actions that customer service agents perform manually by using robotic process automation (RPA). What should you use?

desktop flow

A coworker requires a personal Microsoft Power Platform environment to test preview features of Power Apps. The coworker wants to use this environment for at least two months. You need to recommend which type of environment the coworker should create. Which type of environment should you recommend?

developer

A company plans to use Microsoft Power Platform and Dataverse to transform its business. The company requires a central backend solution connected to Dataverse that managers and other employees can use to manage the day-to-day activities related to their business. The solution must include process guidance to ensure that everyone follows the same procedures. You need to identify the solution that meets the requirements. What should you select?

model-driven application. This item tests the candidate's knowledge of identifying which type of Power Apps app to use based on the business requirements. Model-driven applications are used to create backend applications connected to Dataverse. They are typically used by management and other employees and can include business process flows for providing guidance to employees. Canvas applications are used to create applications targeted at specific scenarios. Desktop flows are used to create robotic process automations that automate manual tasks typically done by end users. Power Pages sites provide external users access to Dataverse data. They use model-driven application forms and views to display information to external users.

A sales company plans to use Microsoft Power Platform and Dataverse to build solutions to help manage its day-to-day operations. The company requires a solution that at the end of each workday automatically identifies and cancels appointments from the previous workday that are not marked as complete. You need to create a Power Automate cloud flow that meets the requirement. Which type of cloud flow should you create?

scheduled flow that runs daily at a specific time

A company plans to use AI Builder to improve business productivity. You need to determine which prebuilt AI models are available for use. Which three types of models are available? Each correct answer presents a complete solution.

sentiment analysis text recognition language detection