Exam Preparation

In a Common Data Service database, you create a canvas app and a custom entity. The app also reads data from the Account entity in the Common Data Service database. Entity access permissions will be controlled by the Common Data Service User security role. You create a Common Data Service solution. You need to replicate the changes to a new Common Data Service database. Which two components should you include with the canvas app? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point. a. Custom entity b. Account entity c. Common Data Service User security role d. Sitemap

a. Custom entity c. Common Data Service User Security role

DRAG DROP -The company is adding a multi-stream interactive dashboard to a model-driven app. The company requires configuration of the dashboard to filter the table data based on modified accounts over the last month. You need to configure the filters for the model-driven app dashboard. Which configuration should you use? To answer, drag the appropriate locations to the correct requirements. Each configuration 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. Select and Place: Configurations: - Filter by - Table view - Filter table - Time frame Requirements: - Configure visual filter attributes that the dashboard can use - Configure the field that the dashboard uses to filter the table dats monthly

- Configure visual filter attributes that the dashboard can use - Filter table - Configure the field that the dashboard uses to filter the table dats monthly - Filter by Filter Table: The visual filters and global filter attributes are based on this table. Table View: The visual filters are based on this view. Filter By: The column that the time frame filter applies to. Time Frame: The default time frame filter value for the Filter By column.

DRAG DROP -You plan to create apps for a company. You need to identify the Power Platform tools required. What should you use? To answer, drag the appropriate tools to the correct requirements. Each tool 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. Select and Place: Tools - Power Virtual Agents bot - Power Automate - Canvas app - Model-driven app Requirement - Create an app with a customized user interface that allows users to quickly create support tickets. - Create an app that uses a guided business process to navigate through all records associated with a support ticket. - Send an email to a customer support manager every time a support ticket is created. - Create an automated chat tool that guides a customer through the support ticket creation process.

- Create an app with a customized user interface that allows users to quickly create support tickets - Canvas app - Create an app that uses a guided business process to navigate through all records associated with a support ticket - Model-driven app. Model-driven app design is a component-focused approach to app development. Model-driven app design doesn't require code and the apps you make can be simple or very complex. Unlike canvas app development where the designer has complete control over app layout, with model-driven apps much of the layout is determined for you and largely designated by the components you add to the app. - Send an email to a customer support manager every time a support ticket is created - Power Automate Power Automate is a service that helps you create automated workflows between your favorite apps and services to synchronize files, get notifications, collect data, and more. - Create an automated chat tool that guides a customer through the support ticket creation process - Power Virtual Agents bot When you create bots with Power Virtual Agents, you author, and edit topics. Topics are discrete conversation paths that, when used together within a single bot, allow for users to have a conversation with a bot that feels natural and flows appropriately. Creating a bot with Power Virtual Agents is easy to do with the no-code authoring canvas, and there are a number of ways you can manage how topics interact, how you want the conversation to flow, and what it should feel like.

HOTSPOT -You are configuring security to enable users to analyze data by using Microsoft Excel templates. You create a security role named TemplateAdministrator and configure the role as shown below and assign the role to a user named User1. You need to ensure that User1 can see the pre-configured example templates. Which permission should you change? - Bulk Edit - Export to Excel - Read on Document Template - Read on Personal Document Template You need to ensure that User1 can download the file to create an Excel template. Which permission should you change? - Bulk Edit - Export to Excel - Read on Document Template - Read on Personal Document Template

You need to ensure that User1 can see the pre-configured example templates. Which permission should you change? - Read on Document Template You need to ensure that User1 can download the file to create an Excel template. Which permission should you change? - Read on Personal Document Template

HOTSPOT -An administrator plans to create and deploy dashboards for use only by sales associates. The dashboards will display the current sales pipeline, open cases, recent major wins, and key opportunities by postal code. Sales associates must be able to act on the specific data displayed in dashboards. You need to create the dashboards. Which type of dashboards should you create? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. Requirement - Ensure that all sales associates can view the dashboard * User * System - Ensure that sales associates can interact with data from the dashboard * Standard * Multi-stream * Single-stream

- Ensure that all sales associates can view the dashboard * User - Ensure that sales associates can interact with data from the dashboard * Single-stream

DRAG DROP -A company must use a Power Apps app custom control that is exported from a different canvas Power Apps app. You need to insert the custom control into the Power Apps app. Where should you complete the actions? To answer, drag the appropriate locations to the correct actions. Each location 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. Select and Place: Objects: - Display - Screens - Components Actions: - Import a custom control from a file - Add an alignment to the custom control to display it in the middle of the Power Apps app screen.

- Import a custom control from a file - Components - Add an alignment to the custom control to display it in the middle of the Power Apps app screen - Display

DRAG DROP -You create the following apps for a company that provides financial guidance services: a model-driven app for financial advisers that work in the company's offices and a canvas app for remote financial advisers. You need to create business rules for a custom counselling entity used by all financial advisers. Who will be affected by the business rules? To answer, drag the appropriate financial adviser types to the correct business rules. Each financial adviser type may be used once, more than once, or not at all. You may need to drag the split bat between panes or scroll to view content. NOTE: Each correct selection is worth one point. Select and Place: Financial adviser types: - Office-based financial advisers only - Remote financial advisers only - Office-based and remote financial advisers Business rule: - Set a field value with the scope set to Entity - Clear a field value with the scope set to All Forms - Set visibility of a field with the scope set to Entity

- Set a field value with the scope set to Entity - Office-based and remote financial advisers - Clear a field value with the scope set to All Forms - Office-based financial advisers only - Set visibility of a field with the scope set to Entity - Office-based financial advisers only Box 1: Office-based and remote financial advisers Model-driven apps can use all actions available on business rules, however not all business rule actions are available for canvas apps at this time. Box 2: Office-based financial advisers only If you're building a Canvas app, you must use table as the scope (not All forms, not a specific form) Box 3: Office-based financial advisers only The following actions are not available on Canvas apps: Show or hide columns - Enable or disable columns - Create business recommendations based on business intelligence.

HOTSPOT -You are creating a Power Automate flow. You have an array that contains items with different color attributes. You plan to filter the array by using the following filter expression within the flow:@or(equals(item()?['color'], 'red'),contains(item()?['color'],'blue'))The filter returns results only when the expression resolves to true. For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point. Hot Area: Statements: - The filter expression yields a result if the array contains the color orange - The filter expression yields a result if the array contains the color red - The filter expression yields a result if the array contains the color sky blue

- The filter expression yields a result if the array contains the color orange - No - The filter expression yields a result if the array contains the color red - Yes - The filter expression yields a result if the array contains the color sky blue - Yes

HOTSPOT -A coworker creates a canvas app. The canvas app contains the following formula. The formula is attached to the OnVisible property of the first screen that users see: Collect( Toolbox, { Tool: "Hammer", Quantity: 1 }, { Tool: "Screwdriver", Quantity: 2 } ) You are updating the canvas app. For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point. Hot Area: - The formula will update multiple records in a data source named Toolbox if the record exists. - A local collection is created to store data if a data source named Toolbox does not already exist. - If a collection named Toolbox exists the formula will clear any existing records before making any changes.

- The formula will update multiple records in a data source named Toolbox if the record exists - No - A local collection is created to store data if a data source named Toolbox does not already exist - Yes - If a collection named Toolbox exists the formula will clear any existing records before making any changes - No Box 1: No -Records are added, not updated. Box 2: Yes -The Collect function adds records to a data source. Syntax: Collect( DataSource, Item, ... ) DataSource ג€" Required. The data source that you want to add data to. If it doesn't already exist, a new collection is created. Item(s) - Required. One or more records or tables to add to the data source. Box 3: No -No records are cleared.

HOTSPOT -You need to store a list of products and their colors. You have a Power Apps app that includes the following elements: ✑ a text box for the product name ✑ a drop-down list for the product color ✑ a button to add a product to the list ✑ a status message that shows whether the addition of a product to the list was successful The button uses the following formula: Collect ( colProductList, { Product: txtProductName.Text, Color: drpColors.Selected.Value } ); Set( vStatusMessage, "Added ' " & txtProductName.Text & " ' " ); timStatusMessage.Start; For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point. Hot Area: Statements: - You must explicitly declare the collection before you can add product names and colors to the collection - The formula stores the product name and the color in a collection - vStatusMessage is a context variable that is used to store the status message

- You must explicitly declare the collection before you can add product names and colors to the collection - No - The formula stores the product name and the color in a collection - Yes - vStatusMessage is a context variable that is used to store the status message - No Box 1: No -The Collect function adds records to a data source. If the data source doesn't already exist, a collection is created. Box 2: Yes - Box 3: No -Use the Set function to set the value of a global variable, which temporarily holds a piece of information, such as the number of times the user has selected a button or the result of a data operation.

DRAG DROP -A company uses Power Automate and Power Apps to streamline business processes. You need to use AI Builder to analyze customer reviews of the company's products. 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. Select and Place: *Publish the Model *Connect data to the model *Train the model *Use the model in a Power Automate flow

1. Connect data to the model 2. Train the model 3. Publish the model 4. Use the model in a Power Automate flow

DRAG DROP - You are an app maker for a college. You create an app for student enrollment. The app captures the education level of the applicants. The education level at the time of enrollment is an option set is in the student entity. The entity includes three levels: ✑ High school ✑ College ✑ Bachelor You must split the College option into two option sets: ✑ College ג€" 1 Year ✑ College ג€" 2 years The split must not impact existing data. You need to create the two option sets. Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order. Select and Place: Actions: - Open the maker app and navigate to the student table - Publish the student entity - Save the student table - Open settings in the Power Platform admin center - Create new options for College - 1 Year and College - 2 years

1. Open the maker app and navigate to the student table 2. Create new options for College - 1 Year and College - 2 years 3. Publish the student entity

DRAG DROP -You are designing a canvas app that will be used by all users including users who have vision impairments. Which outcome is achieved by each action? To answer, drag the appropriate outcomes to the correct actions. Each outcome 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. Select and Place: Outcomes: a. Not visible to any users b. Visible to sighted users only c. Visible to screen-reader users only d. Visible to both sighted and screen-reader users Action 1. Set the values for the X and Y properties of a control to move the control off-screen 2. Set the Color and other related properties of a control to transparent 3. set the Height and Width properties of the control to 1.

1. Set the values for the X and Y properties of a control to move the control off-screen - Visible to sighted users only 2. Set the Color and other related properties of a control to transparent - Visible to screen-reader users only 3. set the Height and Width properties of control to 1 - Not visible to any users

DRAG DROP -You are developing a Power BI report for a company. The Power BI report must display company performance metrics in Power BI service. The report must include three fields in a visualization. The data for the report exists in a dataset. The company will display the report on a large television screen during team meetings. You need to create the report. Which four actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer and arrange them in the correct order. Select and Place: Actions: - Add the report to a new dashboard - Create a report - Add a visualization to the report - Create a paginated report - Select a dataset

1: Select a dataset - Sign in to your Power BI online account, or sign up, if you don't have an account yet. Open the Power BI service. Get some data and open it in report view. 2: Create a report -Use that data to create visualizations and save it as a report. 3: Add visualization to the report 4: Add the report to a new dashboard Visualizations (known as visuals for short) display insights that have been discovered in the data. A Power BI report might have a single page with one visual or it might have pages full of visuals. In the Power BI service, visuals can be pinned from reports to dashboards.

You create a model-driven app for a company. The app will be used to manage events that the company organizes. The Events entity ownership type is set to User or team. Members of the marketing team are assigned the MarketingTeam security role. All privileges for the role are set to User access. All employees must be able to view event records. Only members of the marketing team are permitted to create or edit event records. You create a role named OtherEmployees. You need to configure the MarketingTeam and OtherEmployees security roles. Which three actions should you perform? Each correct selection presents a part of the solution. NOTE: Each correct selection is worth one point. A. Set the access level for the OtherEmployees security role to Organization for the Read permission. B. Set the access level for the MarketingTeam security role to Organization for the Read permission. C. Set the access level for the OtherEmployees security role to None Selected for the Read permission. D. Set the access level for the MarketingTeam security role to None Selected for the Read permission. E. Set the access level for the MarketingTeam security role to None Selected for the Create and White permission. F. Set the access level for the OtherEmployees security role to None Selected for the Create and Write permission.

A. Set the access level for the OtherEmployees security role to Organization for the Read permission. B. Set the access level for the MarketingTeam security role to Organization for the Read permission. E. Set the access level for the MarketingTeam security role to None Selected for the Create and White permission.

HOTSPOT -You are creating a capacity planning dashboard with Power BI desktop. The dashboard must be able to be used within a model-driven manufacturing planning app as well as be embedded within a Microsoft Teams channel. The data sources are as follows: You need to determine the appropriate method for accomplishing each task. Which methods should you use? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

Box 1: Connect to the ERP system - Use a Date Gateway -You can install an on-premises data gateway on the same local computer as SQL Server (in production, it would typically be a different computer). Box 2: Create the relationship between the employee file and the work estimates - Create an entity relationship in CDS Solution Explorer You can create relationships with CDS Solution Explorer. Box 3: Create calculations for work remaining, remaining budget - Create an aggregate tableRollup columns to help users obtain insights into data by monitoring key business metrics. A rollup column contains an aggregate value computed over the rows related to a specified row. This includes regular tables and activity tables such as emails and appointments. Incorrect Answers:✑ Data Analysis Expressions (DAX) is a library of functions and operators that can be combined to build formulas and expressions in Power BI, AnalysisServices, and Power Pivot in Excel data models. With the Modeling view in Power BI Desktop, you can view and work with complex datasets that contain many tables.

You are an app maker. You are creating a canvas app. You do not have access to Power BI. You need to add charts to the app. Which three chart types can you add directly to the canvas app? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point. a. Pie b. Area c. Funnel d. Column e. Line

Correct Answer: A - Pie D - Column E - Line 🗳️You can use line charts, pie charts, and bar charts to display your data in a canvas app. Add a bar chart to display your data: 1. On the Home tab, add a screen. 2. On the Insert tab, select Charts, and then select Column Chart.

A company has a Common Data Service custom entity that stores customer account data. You need to create a relationship between the custom entity and the Account entity. Which two tools can you use? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point. a. Power Platform Admin center b. Power Apps solution explorer c. Power Apps Maker portal d. SQL Server Management Studio e. Visual Studio Code

Correct Answer: B - Power Apps solution explorer C - Power Apps Maker portal 🗳️There are two designers you can use to create and edit 1:N (one-to-many) or N:1 (many-to-one) relationships: ✑ You can create and edit 1:N (one-to-many) or N:1 (many-to-one) entity relationships in the Power Apps portal ✑ You can create and edit 1:N (one-to-many) or N:1 (many-to-one) entity relationships using solution explorer

A company uses data loss prevention (DLP) policies. You have a Power Automate flow that posts Twitter mentions into a Microsoft SharePoint list. You are not able to activate the flow. You need to troubleshoot the issue. What are two possible reasons why you cannot activate the flow? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point. a. You are not assigned the Power Platform Admin role. b. You placed all connectors into the Business group within the DLP policy. c. You placed all connectors into the Non-Business group within the DLP policy. d. You are not assigned the Environment Admin role.

Correct Answer: B - You placed all connectors into the Business group within the DLP policy D - You are not assigned the Environment Admin role🗳️ D: DLP policies are created in the Power Platform admin center. They affect Power Platform canvas apps and Power Automate flows. To create a DLP policy, you need to be a tenant admin or have the Environment Admin role. B: This table describes how the DLP policy you created affects data connections in apps and flows. Note: Any connector that resides in the Non-Business data groupג€" such as Outlook.comג€"won't share data with apps and flows by using SharePoint or Salesforce connectors. Facebook and Twitter connectors are altogether blocked from being used in any app or flow in non-test environments such as production or default environments.

You are creating a canvas app. You need to display a limited list of choices to the end user. You must standardize the values and appearance of the list across all forms. Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point. a. Add a drop-down field in the app b. Create a Global Option Set c. Add a new business rule d. Add a component to the component library

Correct Answer: A - Add drop-down field in the app B - Create a Global Option Set 🗳️A global Option Set can be shared across entities.

A company has an on-premises system that stores product information. The company plans to replace the information with a Power Platform solution that uses the Common Data Service. The Power Platform solution needs to use data from the product information system. You need to transform and import the data from the product information system. Which two tools should you use? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point. a. Dataflow b. Business process flow c. Power BI Desktop d. Data gateway

Correct Answer: A - Dataflow and D - Data gateway 🗳️The on-premises data gateway acts as a bridge to provide quick and secure data transfer between on-premises 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. Can use the Power Platform dataflows to load entity in CDS with the option to transform data.

You create a canvas app for technicians at a computer store. You assign technicians cases to work on. The technicians update cases at the end of customer site visit. The manager wants the technicians to sell warranties to the customers. If a customer agrees to purchase a warranty, technicians use the canvas app to immediately alert the sales team, and then the technician records details about the warranty into the app. You need to create a flow to alert the sales team. Which type of trigger should you use? a. Flow button for mobile b. Power Apps c. Office 365 Outlook d. Common Data Service

Correct Answer: A - Flow button for mobile 🗳️Create a button flow to run routine tasks by simply tapping a button. Customize your flow by allowing the user to provide specific details that will be used when the flow runs. Note: There are many repetitive tasks that we all wish we could run with just a tap of a button. For example, you may need to quickly email your team to remind them to join the daily team sync, or you may want to start a new Visual Studio Codespaces build of your code base after you've been notified that there are no more checkins planned for the day. Button flows allow you to accomplish these and many other tasks simply by tapping a button on your mobile device.

You create a canvas app. You need to make the app available to other people in your company. 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. Grant access to individual users in your company. B. Share the app with a Microsoft Exchange distribution list. C. Grant access to a Microsoft Teams team. D. Share the app with a Microsoft Azure Active Directory security group.

Correct Answer: A - Grant access to individual users in your company. D - Share the app with a Microsoft Azure Active Directory security group. 🗳️After you build a canvas app that addresses a business need, specify which users in your organization can run the app and which can modify and even reshare it. Specify each user by name, or specify a security group in Azure Active Directory. Incorrect Answers: C: You can share an app you've created by embedding it directly into Microsoft Teams. When completed, users can select + to add your app to any of your team channels or conversations in the team you are in. The app appears as a tile under Tabs for your team.

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. A company has locations in multiple countries and regions across four continents. The company stores the total amount of each order in the local currency of the country/region where the customer is located. The company stores the applicable exchange rates in a custom US dollars (USD) exchange rate table. You need to create a visualization that displays the total amount of orders by country/region in USD. Proposed solution: Create a custom calculated field of type currency on the order table that converts the order total to USD and displays the total amounts by region in a Power BI chart. Does the solution meet the goal? A. Yes B. No

Correct Answer: A - YES 🗳️Need to calculate the exchange rate in USD. Calculated columns are calculated in real-time when they are retrieved.

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 that displays a list of accounts. Users must be able to select an account and view details for the account. The app must include a feature that brings the user back to the list of accounts. You add a blank screen named Screen_Accounts and add a gallery named Gallery_Accounts to the screen. You set the data source of Gallery_Accounts to Accounts and add another blank screen named Screen_AccountDetail. You need to complete the app. Solution: ✑ Add a display form to Screen_AccountDetail. ✑ Set the OnSelect property of Gallery_Accounts to Navigate(Screen_AccountDetail). ✑ Set the data source of the form to Accounts. ✑ Set the Item property of the form to Selected. ✑ Add a back icon on Screen_AccountDetail and set its OnSelect property to Navigate(Screen_Accounts). Does the solution meet the goal? A. Yes B. No

Correct Answer: A - Yes 🗳️ If you add a Display form control, the user can display all fields of a record or only the fields that you specify.

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 build a canvas app for a manufacturing company. The company receives parts and materials from many vendors. You create a form to collect information from packing slips. Receivers must be able to take a picture of packing slips to receive materials instead of manually entering data in the app. You need to ensure that users can scan packing slip information into the form. Proposed solution: Use a Text Recognition model. Does the solution meet the goal? a. Yes b. No

Correct Answer: A - Yes 🗳️Create a canvas app and add the text recognizer AI Builder component to your screen. This component takes a photo or loads an image from the local device, and then processes it to detect and extract text based on the text recognition prebuilt model. If it detects text in the image, the component outputs the text and identifies the instances by showing a rectangle for each instance in the image.

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 that displays a list of accounts. Users must be able to select an account and view details for the account. The app must include a feature that brings the user back to the list of accounts. You add a blank screen named Screen_Accounts and add a gallery named Gallery_Accounts to the screen. You set the data source of Gallery_Accounts to Accounts and add another blank screen named Screen_AccountDetail. You need to complete the app.Solution: ✑ Add an edit form to Screen_AccountDetail and set the Default Mode of the form to View. ✑ Set the OnSelect property of Gallery_Accounts to Navigate(Screen_AccountDetail). ✑ Set the data source of the form to Accounts. ✑ Set the Item property of the form to Selected. ✑ Add a back icon on Screen_AccountDetail and set its OnSelect property to Navigate(Screen_Accounts).Does the solution meet the goal? A. Yes B. No

Correct Answer: A - Yes 🗳️View, edit, or create an item, save the contents, and reset the controls in an Edit form control. FormMode. View: The form is populated with an existing record but the user cannot modify the values of the fields. This function is often invoked from the OnSelect formula of a Button or Image control.

You are creating a canvas app. You need to store and retrieve small amounts of data on a local device when the app is offline. Which set of functions should you use? a. SaveData, LoadData b. Set, Patch c. Patch, Collect d. Set, Collect

Correct Answer: A 🗳️LoadData and SaveData combine to form a simple mechanism to store small amounts of data on a local device. By using these functions, you can add simple offline capabilities to your app.

You are an app designer for a hotel. The hotel wants to create an app to help the housekeeping staff schedule work. You need to create a new environment for the app. Where should you create the environment? a. Power Platform Admin center b. Power Apps Maker portal c. Dynamics 365 Admin center

Correct Answer: A 🗳️Manage environment in the Power Platform admin center.

You use a Microsoft SharePoint list to record information about customers. You must perform a series of actions only when a new item is added to a SharePoint list. You need to configure a Power Automate flow. Which trigger should you use? a. When an item is created b. When an item is created or modified c. When a file is created (properties only) d. For a selected item

Correct Answer: A 🗳️Trigger - When an item is created MS Flow will trigger when an item is created in the list. It will return all list item properties which can be used in the Flow. Incorrect Answers:D: Trigger - For a selected item This trigger allows you to start a flow for a selected item in a SharePoint list or library. You can use the columns of the list or library as output parameters. For a file, you can use the "identifier" column to get file content. This is basically one that will trigger a flow when an item is selected and you want the user to trigger workflow manually.

Each maker at a company has a separate Common Data Service environment. You are customizing a canvas app. You create two new entities in your environment. You are leaving for a vacation. Another maker will continue customizing the app in your absence. You need to transfer the work to the other maker and ensure that you can work on the updated app when you return from your vacation. What should you export? a. An unmanaged solution that includes all customizations b. The default solution c. A managed solution that includes all customizations d. The app

Correct Answer: A 🗳️Unmanaged Solution: The beginning state of solution is the unmanaged solution state. During this phase, you can add, edit, update, remove, delete, and test any of the components of the solution. Incorrect Answers: C: 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 customizations as well as data contained. Managed Solutions become read only once deployed so they cannot be manipulated.

You are creating an app for an organization's human resources (HR) department. You create an Employee entity in an unmanaged Common Data Service solution. Another user creates the following Power Automate flows separately from the solution: You need to incorporate the flows that can be added to the solution. Which two flows can you include? Each correct selection presents a complete solution. NOTE: Each correct selection is worth one point. a. FlowA - Send email to the HR manager when a new document is uploaded to Microsoft SharePoint b. FlowB - Send email to the HR manager after a user selects a document in Microsoft OneDrive for Business and runs the flow. c. FlowC - Send email to the HR manager at 8 AM daily if a new documents are uploaded in Microsoft OneDrive for Business since the previous day. d. FlowD - Send email to the HR manager when a new employee record is added.

Correct Answer: AD FlowA - Send email to the HR manager when a new document is uploaded to Microsoft SharePoint FlowD - Send email to the HR manager when a new employee record is added. 🗳️You can add any of these conditions to determine precisely when your flow is triggered.

You create a canvas app named Hardware Order that suggests computer hardware to customers. A value must be entered for the EmployeeID field when creating a new order if the value in the OrderType field does not contain the prefix test. You need to configure the business rule. Which two actions should you perform? Each correct answer presents part of the complete solution. NOTE: Each correct selection is worth one point. a. Set the scope of the business rule to Entity. b. Add a Recommendation action and configure it to enter the order type. c. Set the scope of the business rule to All Forms. d. Use the following condition expression: (OrderType Does not begin with [test]) AND (Modified By Does not contain data)

Correct Answer: AD 🗳️ A: Set the scope of the business rule to Entity - If you're building a Canvas app, you must use Entity as the scope. D: Use the following condition expression: (OrderType Does not begin with [test]) AND (Modified By Does not contain data) - A business rule needs a condition.

You create a canvas app within a Power Platform environment. You need to identify potential accessibility issues for the canvas app before making the app available to other users. Which tool should you use? A. Portal Checker B. App Checker C. Solution Checker

Correct Answer: B - App Checker 🗳️Find accessibility issues - 1. In the upper-right corner of Power Apps Studio, select the icon for the App checker. 2. In the menu that appears, select Accessibility. A list of issues appears, sorted first by severity and then by screen.

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. A company has locations in multiple countries and regions across four continents. The company stores the total amount of each order in the local currency of the country/region where the customer is located. The company stores the applicable exchange rates in a custom US dollars (USD) exchange rate table. You need to create a visualization that displays the total amount of orders by country/region in USD. Proposed solution: Create a custom column that converts the order total to USD by using the relationship between order local currency and the USD exchange rate table in Power BI Desktop and display this column in a Power BI chart by country/region. Does the solution meet the goal? A. Yes B. No

Correct Answer: B - NO 🗳️Instead use a calculated field. Need to calculate the exchange rate in USD. Calculated columns are calculated in real-time when they are retrieved.

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. A company has locations in multiple countries and regions across four continents. The company stores the total amount of each order in the local currency of the country/region where the customer is located. The company stores the applicable exchange rates in a custom US dollars (USD) exchange rate table. You need to create a visualization that displays the total amount of orders by country/region in USD. Proposed solution: Create a custom rollup field of type currency on the country/region table that aggregates all the total amounts for the orders from that country/region and display this rollup field in a Power BI chart. Does the solution meet the goal? A. Yes B. No

Correct Answer: B - NO 🗳️Instead use a calculated field. Need to calculate the exchange rate in USD. Calculated columns are calculated in real-time when they are retrieved.

You build a canvas app for a manufacturing company. The company receives parts and materials from many vendors. You create a form to collect information from packing slips. Receivers must be able to take a picture of packing slips to receive materials instead of manually entering data in the app. You need to ensure that users can scan packing slip information into the form. Proposed solution: Use a Key Phrase Extraction model. Does the solution meet the goal? a. Yes b. No

Correct Answer: B - NO 🗳️The key phrase extraction prebuilt model identifies the main points in a text document.

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 that displays a list of accounts. Users must be able to select an account and view details for the account. The app must include a feature that brings the user back to the list of accounts. You add a blank screen named Screen_Accounts and add a gallery named Gallery_Accounts to the screen. You set the data source of Gallery_Accounts to Accounts and add another blank screen named Screen_AccountDetail. You need to complete the app. Solution: ✑ Add an edit form to Screen_AccountDetail and set the Default Mode of the form to New ✑ Set the OnSelect property of Gallery_Accounts to Navigate(Screen_AccountDetail). ✑ Set the data source of the form to Accounts. ✑ Set the Item property of the form to Selected. ✑ Add a back icon on Screen_AccountDetail and set its OnSelect property to Navigate(Screen_Accounts). Does the solution meet the goal? A. Yes B. No

Correct Answer: B - No 🗳️ FormMode. New: the form is populated with default values and the user can modify the values of the fields. Once complete, the user can add the record to the data source.

You are creating a canvas app. You plan to use variables that are scoped to a screen to store values. You need to create and update the value of the variables. Which three functions can you use? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point. A. Collect B. Patch C. Navigate D. Set E. UpdateContext

Correct Answer: B - Patch, C - Navigate, E - UpdateContext 🗳️B: Use the Patch function to modify records in complex situations. Such as, when you do updates that require no user interaction or use forms that span multiple screens. CE: Context variables are scoped for Screen. They are great for passing values to a screen, much like parameters to a procedure in other languages. Can be referenced from only one screen. Functions available for context variables: ✑ UpdateContext ✑ NavigateNote: Use the UpdateContext function to create a context variable, which temporarily holds a piece of information, such as the number of times the user has selected a button or the result of a data operation. Context variables are also preserved when a user navigates between screens. You can use Navigate to set one or more context variables for the screen that the formula will display, which is the only way to set a context variable from outside the screen.

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 on the review screen. You build a canvas app for a manufacturing company. The company receives parts and materials from many vendors. You create a form to collect information from packing slips. Receivers must be able to take a picture of packing slips to receive materials instead of manually entering data in the app. You need to ensure that users can scan packing slip information into the form. Proposed solution: Use a Category classification model. Does the solution meet the goal? a. Yes b. No

Correct Answer: B No 🗳️A Category classification model categorizes text by its meaning.

You build a canvas app for a manufacturing company. The company receives parts and materials from many vendors. You create a form to collect information from packing slips. Receivers must be able to take a picture of packing slips to receive materials instead of manually entering data in the app. You need to ensure that users can scan packing slip information into the form. Proposed solution: Use an Entity Extraction model. Does the solution meet the goal? A. Yes B. No

Correct Answer: B No 🗳️Instead use the Use a Text Recognition model. Note: Create a canvas app and add the text recognizer AI Builder component to your screen. This component takes a photo or loads an image from the local device, and then processes it to detect and extract text based on the text recognition prebuilt model. If it detects text in the image, the component outputs the text and identifies the instances by showing a rectangle for each instance in the image. Incorrect Answers: AI Builder entity extraction models recognize specific data in the text that you target based on your business needs. The model identifies key elements in the text and then classifies them into predefined categories. This can help you transform unstructured data into structured data that's machine-readable. You can then apply processing to retrieve information, extract facts, and answer questions.

You create a canvas app. A user is not able to determine which field currently has focus. You run App checker to identify errors. You need to verify that the focused border thickness is set to a value greater than zero. Which section of the App checker results should you check? A. Rules B. Performance C. Accessibility D. Runtime

Correct Answer: C - Accessibility 🗳️ The Accessibility checker classifies each issue as an error, a warning, or a tip based on the issue's severity. Issues include: ✑ Focus isn't showing When the FocusBorderThickness of a control is set to 0. It is good practice to ensure a proper color-contrast ratio between the focus border and the control itself so it's clearly visible.

A company delivers products to multiple communities. The company creates a canvas app connected to a Common Data Service database. The app tracks communities to see where the delivery volume is the highest. Drivers must enter delivery information on a form that uses an entity named Delivery. Depot staff must enter information on a pick-up form that uses an entity named Pick-up. Each form contains a community field that is based on a shared list across both forms. You need to create the community field. Which type of field should you create? a. Local option set b. Text c. Global option set d. Text area

Correct Answer: C - Global option set 🗳️Can use a global option set, no need to use localized option sets. Note: In PowerApps Option set is one of the field types you can use in your Entity. The information type that Option Set stores is a list of text values. And here comes the Option Set advantage ג€" once you define its text values you can centrally manage it.

You create and publish a canvas app component library to perform complex calculations. You discover an error in one of the calculations. You correct the issue and publish the component library. A co-worker uses the original version of the component library in a canvas app. You need to ensure that the co-worker uses the updated version of the component library. What should you do? a. Export the updated component library and instruct the co-worker to import the updated version into the canvas app b. Inform the co-worker to edit the canvas app and manually add the updated version of the component library c. Instruct the co-worker to edit the canvas app and update the component library

Correct Answer: C - Instruct the co-worker to edit the canvas app and update the component library 🗳️You can modify an existing component library and save any changes with additional version notes. However, the updated component library version must be published for use in existing apps that use the component library. Makers of other apps are notified of updated components being available. The notification appears when makers edit the apps in canvas app studio. They can choose to update the components:

You are an app maker. You want to create apps and track customizations as part of the default solution. You need to determine the impact of performing the work in the default solution. What should you conclude? a. The default solution does not contain all components and customizations from all solutions in the environment. b. The prefix used when creating components as part of the default solution can be set to a specific value. c. The default solution cannot be exported and distributed to another environment.

Correct Answer: C 🗳️Default Solution. This is a special solution that contains all components in the system. The default solution is useful for discovering all the components and configurations in your system. Why you shouldn't use the default solutions to manage customizations. There are a few reasons why you shouldn't create apps and make customizations in either of the default solutions: ✑ The default solution can't be exported; therefore, you can't distribute the default solution to another environment. The default solution contains all components and customizations from all solutions in the environment. By default, all enabled users can create apps and customize components in the Common Data Services Default Solution. It's difficult to locate or identify the customizations you've made in the environment by using either default solution. When you use either default solution to create components, you'll also use the default publisher assigned to the solution. This often results in the wrong publisher prefix being applied to some components.

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: C 🗳️Imagine that you have a collection of data (such as a list of sales orders, a set of service tickets, or a directory of contacts) and that you want to show this data in your Microsoft PowerApps app in a tabular format, where each column represents a field and each row represents a record. In the past, you might have been able to roughly simulate this visualization, although the process required some effort. However, we've been listening to your requests and are happy to announce that you can now quickly and easily achieve this very typical visualization by using the new Data table control that has been recently added to PowerApps.

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 🗳️ 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.

You need to set the value for a global variable named RunningTotal to 5 and navigate to the previous screen named MainScreen. Which formula should you use? A. UpdateContext( { RunningTotal: 5 } ); Navigate( MainScreen, ScreenTransition.Cover, RunningTotal ); B. If( Value(TextBox1.Text) >= 0, (Set( RunningTotal, 5); Back();), Color.Green ) C. UpdateContext( { RunningTotal:5 } ); Back() D. Set( RunningTotal, 5 ); Back();

Correct Answer: D - Set( RunningTotal, 5 ); Back();🗳️You set the value of the global variable with the Set function. Set( MyVar, 1 ) sets the global variable MyVar to a value of 1. Use the Back and Navigate function to change which screen is displayed.

You create a Power Platform solution. Solution data is stored in a variety of documented cloud services. You must also be able to connect to one or more industry data sources. You need to configure the data sources. What should you do? a. Create a business process flow. b. Create a data policy template. c. Create a UI flow. d. Use an existing data connector.

Correct Answer: D - Use an existing data connector 🗳️In Power Apps, add a data connection to an existing canvas app or to an app that you're building from scratch. Your app can connect to SharePoint, CommonData Service, Salesforce, OneDrive, or many other data sources. Note: Add data source - 1. In the center pane, select connect to data to open the Data pane. 2. Select Add data source. 3. If the list of connections includes the one that you want, select it to add it to the app. Otherwise, skip to the next step.

You are developing a canvas app to monitor time. The app includes a Text Input control named TIC1 and a Timer control named TIM1. You need to set TIM1 to a default value. What should you do? a. In the OnChange property of TIC1, set the value of the Text property for TIC1 to a context variable that stores the duration value. Assign the value of the variable to the OnTimerStart property for TIM1. b. Assign the Text property of TIC1 to the Duration property of TIM1. c. Assign the Text property of TIC1 to the OnSelect property of a TIM1. d. Write code in the OnChange property of TIC1 that assigns the value of the Duration property of the Timer control to Text property of the TIC1. In the OnChange property of TIC1, assign the value to the Duration property for TIM1.

Correct Answer: D - Write code in the OnChange property of TIC1 that assigns the value of the Duration property of the Timer control to Text property of the TIC1. In the OnChange property of TIC1, assign the value to the Duration property for TIM1. 🗳️The OnTimerStart, OnTimerEnd and OnSelect are the configurations where you can add your code. Most of the people voted for B

DRAG DROP -You are creating entities in a Common Data Service database to capture sales data. You create an entity named Sales that includes the following fields: You create a new entity that includes a field named TotalSales. The field is used to capture the aggregated sales for each salesperson. You need to configure the fields for the entities. Which field types should you use? To answer, drag the appropriate field types to the correct field names. Each field type 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. Select and Place: Field types: Rollup Calculated Simple Field Name: GrossAmount DiscountAmount TotalSales

GrossAmount - Calculated DiscountAmount - Simple TotalSales - Rollup Box 1: Calculated - Calculated columns are calculated in real-time when they are retrieved. Calculated columns can be composed using different data types. For example, an Integer calculated column may reference values from Decimal or Currency columns. Box 2: Simple -A simple column isn't defined as a calculated or rollup column. Box 3: Rollup -Because rollup columns persist in the database, they can be used for filtering or sorting just like regular columns.

DRAG DROP -You are an app builder for a medical office. The medical office uses activities to book appointments and business process flows to track patient status. The cleaning staff wants the app to connect directly to a Microsoft Excel workbook to track cleaning tasks. The office does not have access to reporting tools includingPower BI. You need to create apps for the following groups of users. Apps must not require customizations or the use of additional products. Which type of app should you build for each group? To answer, drag the appropriate app types to the correct groups. Each app type 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. Select and Place: - Canvas app - Model-driven app - Embedded canvas app

Reception area staff - Canvas app Medical staff - Embedded canvas app Cleaning staff - Model-driven app

DRAG DROP -You are designing an app for a bank. You plan to use the following entities in the app: Entity & Comments Clients - Clients are assigned to a branch office Bank accounts - A client may have multiple bank accounts. A bank account may have multiple clients as bank account owners Branch offices - Clients are assigned to a branch office Employees - Each employee works at only one branch office Relationship types: One-to-one One-to-many Many-to-one Many-to-many You need to configure the relationships between the entities.Which relationship types should you use? To answer, drag the appropriate relationship types to the correct relationships. Each source 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.Select and Place:

Source entity - Target entity: Clients - Bank accounts -> Many-to-many Clients - Branch offices -> Many-to-one Branch offices - Employees -> One-to-many

DRAG DROP -You have a model-driven app that has an entity named Marinas. You have an entity named Boats that list the boats associated with each marina. You must add a list of boats to the Marinas form. You must also add an option for users to select different views including boat owners and marina members. You need to embed the list of boats associated with a Marina record in the entity form. 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. Select and Place: Actions: - Add a Subgrid component to a form - Select Show related records and then select the related entity and default view for the subgrid - Save and publish the form - Select the Allow users to change view option

Step 1: Add a Subgrid component to a form You add a subgrid component the same way as you add any other component. Step 2: Select Show related records and then select the related entity and default view for the subgrid Configure a subgrid component. Properties available to configure when using a subgrid component on a form using the form designer include: ✑ Show related rows When selected, the subgrid displays only rows related to the current row that is displayed on the form. Step 3: Select the Allow users to change view option Configure a subgrid component. Properties available to configure when using a subgrid component on a form using the form designer include: ✑ Allow users to change view When selected, app users can change from the Default view to another view of the table selected in the Table property. Step 4: Save and publish the form

DRAG DROP -You create an app with multiple screens. Test users report that the size and type of gallery displayed on each screen are different. You must improve the consistency for the app screens. You need to create a reusable gallery that displays information based on the current record. Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order. NOTE: More than one order of answer choices is correct. You will receive credit for any of the correct orders you select. Select and Place: - Add a gallery control - Add an input property - Create a component - Add a screen - Create a form - Add an output property

Step 1: Add a gallery control - Add a gallery to a blank screen - 1. On the Insert tab, select Gallery, and then select Vertical. 2. On the Properties tab of the right-hand pane, open the Items list and then select your Gallery Step 2: Add a screen - Add a gallery on a screen - 1. On the Home tab, select New screen > List screen. A screen that contains a Gallery control and other controls, such as a search bar, appears. Step 3: Add an input property - Input property is how a component receives data to be used in the component. Incorrect Answers: Output property is used to emit data or component state. For example, the Selected property on a Gallery control is an output property.

DRAG DROP -You have a solution that contains a Power Automate flow, an environment variable, and a model-driven app. Which three steps should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order. Select and Place: Actions: - Select the managed solution - Adjust the version number - Publish all changes - Select the unmanaged solution

Step 1: Adjust the version number. Step 2: Select the managed solution. 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 customizations as well as the data contained. Managed Solutions become read-only once deployed so they cannot be manipulated. Step 3: Publish all changes.

DRAG DROP -You have the following Common Data Service entities: BusinessContracts and BusinessAccounts. You need to configure an N:N relationship between the two entities. Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order. - Select Add relationship and then select the many-to-many relationship option - Select the BusinessAccounts entity as the related entity - Open the relationship tab of the businessContracts entity - Choose the Relationship Name and Relationship Entity Prefix

Step 1: Open the relationship tab of the BusinessContracts entity. View entity relationships - From the Power Apps portal, select either Model-driven or Canvas design mode. Select Data > Entities and select the entity that has the relationships you want to view. With the Relationships tab selected, you can select the following views: Step 2: Select Add relationship. Create relationships - While viewing entity relationships, in the command bar, select Add relationship and choose Many-to-many. Step 3: Select the BusinessAccounts entity as the related entity.

DRAG DROP -You have an existing Power Apps environment. You need to create a Common Data Service database for the environment. Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order. Select and Place: - Select Create my database - Configure currency and language settings - Configure database collation settings - Set the environment type to Production - Select an existing environment

Step 1: Select an existing environment Add a database in the admin center: 1. In the admin center, in the left navigation pane, select Environments. 2. Select the environment to which you want to add the database. Step 2: Select Create my database 3. Select + Add Database Step 3: Configure currency and language settings 4. Enter the following, and then select Add.

DRAG DROP -You create multiple apps as part of an unmanaged solution. You need to move the apps to another environment. You need to pick the appropriate solution type for each requirement. Which types of solutions should you create? To answer, drag the appropriate solution types to the correct requirements. Each solution type 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. Select and Place: Requirement a. Edit existing components of the solution b. Add new components to the solution c. Export the solution Solution types 1. Managed 2. Unmanaged

a. Edit existing components of the solution - Unmanaged b. Add new components to the solution - Unmanaged c. Export the solution - Managed

HOTSPOT -You need to create a model-driven app without using code. Which tools should you use? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. Requirement: a. Select the forms and views that the app will use 1. Site Map designer 2. Solution Explorer 3. App designer 4. Entity view b. Design the navigation for the app 1. Site Map designer 2. Dynamics 365 Admin center 3. Microsoft Azure DevOps

a. Select the forms and views that the app will use 3. App designer b. Design the navigation for the app 1. Site Map designer Box 1: App designer -As an app maker, you can create and edit public views by using Power Apps. Box 2: Site Map designer -Site maps define the navigation for your app. Create a site map for your app with ease by using the tile-based site map designer.