Preguntas según tema PL-200 PDF

Preguntas según tema PL-200 Configure website security including web roles and 1. Configure Microsoft Dataverse page access...

Preguntas según tema PL-200 Configure website security including web roles and 1. Configure Microsoft Dataverse page access Describe use cases for templates 1.1. Manage the data model Describe authentication options Create or modify standard, activity, or virtual tables Create new tables or modify existing tables Determine which type of relationship to implement, 3. Create and manage logic and process automation including one-to-many and many-to-many 3.1. Create and manage cloud flows Configure table relationships including behaviors and Describe types of flows, use cases, and flow cascading rules components, including when to use a classic Create new or modify existing columns, including workflow calculated, rollup, and formula Describe components of a connector Configure table properties Implement logic controls including branches, loops, conditions, error handling, and variables 1.2. Manage Dataverse Implement dynamic content and expressions Configure Dataverse search, and manage the search Work with the Dataverse connector index Manage and troubleshoot flows Manage auditing Extra: Desktop flows Describe options for importing and exporting data Extra: AI Builder Configure duplicate detection settings Configure bulk deletion 3.2. Create and manage business process flows Configure a business process flow 1.3. Configure security settings Add stages, workflows, and flow steps to a business Manage business units process flow Create and manage security roles Manage the business process flow table for a Create and manage users and teams business process flow Create and manage column security Configure hierarchy security 3.3. Create and manage classic Dataverse workflows Configure Microsoft Entra ID group teams Configure a workflow Troubleshoot workflows 2. Create apps by using Microsoft Power Apps Manage workflow logs Implement low-code logic 2.1. Create model-driven apps Configure low-code plug-ins Create and configure multiple form types Write and use Power Fx functions and formulas Use controls in the form designer Create and configure business rules Create and configure views Configure custom pages Configure modern commanding by using Power Fx 4. Manage environments Embed a canvas app in a model-driven app form 4.1. Participate in application lifecycle management Add Microsoft Power BI dashboards and reports in a (ALM) model-driven app Describe use cases for app checker and solution Extra: Embed a Power App visual in a Power Bi checker dashboard Create and manage Dataverse solutions Extra: Site map Describe the difference between managed and unmanaged Dataverse solutions 2.2. Describe canvas apps Manage Microsoft Power Platform environments for Describe canvas app structure development Describe form navigation, formulas, variables and Import and export Dataverse solutions collections, and error handling + offline Extra: Currencies Describe how Microsoft Power Automate flows are Extra: Microsoft 365 / Dynamics 365 called from a canvas app Extra: Copilot Extra: Teams Extra: Teams Extra: Power Fx 4.2. Manage interoperability with other services 2.3. Build Microsoft Power Pages Configure email integration Configure pages, forms, and navigation Configure Microsoft SharePoint integration Describe advanced Power Pages features, including Describe options for document management document management, search, multi-step forms, Work with Microsoft Word template and Power BI 1 1. Configure Microsoft Dataverse 1.1. Manage the data model Create or modify standard, activity, or virtual tables Source ExamTopics Topic 1 Question 61: A company is evaluating the capabilities in Dataverse and the scenarios for using virtual tables. You need to identify the capabilities of virtual tables. What is a capability of virtual tables? A. Virtual tables store data in the Dataverse environment. B. Virtual tables retrieve data from an external data source. C. Virtual tables can be configured for user and team ownership. D. Virtual tables support Dataverse auditing. Source ExamTopics Topic 1 Question 58: HOTSPOT - A company is implementing a data model by using Dataverse. The company requires the following columns in a new custom table: You need to choose the column type that uses the least amount of database storage for each column. Which column types should you choose? Answer Area Column name: Special Notes o Text o Text Area o Multiline Text Column name: Specification o Text o Text Area o Multiline Text Column name: Student o Choices o Customer (Lookup will only enable relationship with either account or contact but not with both, therefore Customer type is correct) o Lookup Column name: Special Notes o Choices o Customer o Lookup Create new tables or modify existing tables Source ExamTopics Topic 2 Question 14: A customer tracks events by using a custom entity. The custom entity includes a custom field for the venue of the events. The customer must be able to display the events by venue in a calendar. You need to ensure that all events display by venue in the calendar. To which component should you add a control? A. Form B. Sub-grid C. Chart D. View Source MSFT Practice Assessment 3: Question 43 of 50 You manage a new instance of Microsoft Dataverse. You need to create a new column for a custom table. The new column must have the schema name abc_income. What should you create first? Select only one answer. new solution column in the Default Solution column in the Common Data Services Default Solution new publisher The prefix used in a field name is determined by the publisher associated with a solution. The publisher must be created before a solution. The prefix for a column is determined by the publisher associated with a solution. The publisher must be created before the solution. A field created in the Default Solution has the prefix “new.” A field created in the Common Services Default Solution has the prefix “cr” followed by random digits. 2  Determine which type of relationship to implement, including one-to-many and many-to-many Source MSFT Practice Assessment 1: Question 43 of 50. A company that delivers training courses uses Microsoft Dataverse. The company wants to record course registration and attendance. The company configures a Contact table and a Course table. You need to create a relationship between the attendees and registrations. Which type of relationship should you create? Select only one answer. one 1:N relationship with Contact as the parent one 1:N relationship with Course as the parent one N:N relationship between Contact and Course two 1:N relationships, one with Contact as the parent and one with Course as the parent To record course registrations and whether a person attended, a third table is required to store whether the person attended. Two 1:N relationships (with Contact and Course as parents) are required for this third table. A 1:N relationship with Contact or Course as the parent does not allow for a person to attend more than one course. Although an N:N relationship allows who is attending a course to be stored, it does not provide a way to record whether a person attended. Source ExamTopics Topic 1 Question 14: You create a parent entity and a child entity. The parent entity has a 1:N relationship with the child entity. You need to ensure that when the owner changes on the parent record that all child records are assigned to the new owner. You need to configure the relationship behavior type. What should you use? A. Referential B. Referential, Restrict Delete C. Parental D. Restrict Source ExamTopics Topic 1 Question 16: DRAG DROP – You are designing an app for a bank. You must create entities for the app and configure relationships between entities: Which relationship types should you use? Select and Place: Source MSFT Practice Assessment 3: Question 23 of 50 A company that delivers training courses uses Microsoft Dataverse. The company wants to record course registration and attendance. The company configures a Contact table and a Course table. You need to create a relationship between the attendees and registrations. Which type of relationship should you create? Select only one answer. one 1:N relationship with Contact as the parent one 1:N relationship with Course as the parent one N:N relationship between Contact and Course two 1:N relationships, one with Contact as the parent and one with Course as the parent To record course registrations and whether a person attended, a third table is required to store whether the person attended. Two 1:N relationships (with Contact and Course as parents) are required for this third table. A 1:N relationship with Contact or Course as the parent does not allow for a person to attend more than one course. Although an N:N relationship allows who is attending a course to be stored, it does not provide a way to record whether a person attended. Source MSFT Practice Assessment 4: Question 37 of 50 A company that uses Microsoft Dataverse runs regular events. The company configures the Contact and Event tables. You need to record who has attended each event. Which relationship should you create? Select only one answer. a 1:N relationship with Contact as the parent a 1:N relationship with Event as the parent an N:N relationship between Contact and Event This answer is correct. 3  two 1:N relationships, one with Contact as the parent and one with Event as the parent This answer is incorrect. This question tests the candidate’s knowledge of relationships in Dataverse, which is part of managing a data model. A N:N relationship allows a contact to be linked to multiple events and an event to be linked to multiple contacts. A 1:N relationship with Contact as the parent only allows for an event to be linked to just one contact. A 1:N relationship with Event as the parent only allows for a contact to be linked to one event. Two 1:N relationships allows for an event to be linked to just one contact and a contact to be linked to just one event. Question 38 of 50 An event planning company wants to capture information for each event. The captured information must include the following: contacts who attend the event the capacity in which a contact attends, such as customer, vendor, supplier, or from marketing You need to create a relationship between the records to capture the information. What should you implement? Select only one answer. 1:N relationship N:N relationship custom intersect table with two 1:N relationships N:1 relationship If users want to capture information about the nature of a relationship, they need to create a custom intersect table using two 1:N relationships to look up each side of the table. A 1:N relationship, an N:N relationship, and an N:1 relationship cannot capture any additional information about the nature of the relationship between the records. Configure table relationships including behaviors and cascading rules Source ExamTopics Topic 1 Question 51: DRAG DROP – A company uses Power Apps. You create a custom table and configure a child table relationship with the contact table. You need to configure the cascading rules for each action. Which behavior should you use? Answer area. Action - Behavior Custom table record is deleted: o Restrict o Cascade All o Cascade None Custom table record is shared: o Restrict o Cascade All o Cascade None Source MSFT Practice Assessment 3: Question 17 of 50. You manage a Microsoft Dataverse instance for a company. The Dataverse instance has a one-to-many (1:N) relationship between a Teachers table and a Classes table. If a teacher record is deleted, the deletion must have no impact on the related class records. You need to configure the behavior of the tables. Which relationship behavior should you use? Select only one answer. cascade all parental referential, remove link referential, restrict delete In a referential relationship between two tables, you can navigate to any related rows, but actions taken on one will not affect the other. In a cascade all relationship the same delete action will be performed on all related table rows. In a parental relationship between two tables, any action taken on a record of the parent table is also taken on any child table records that are related to the parent table record. In a referential, restrict delete relationship between two tables, actions taken on the parent row will not be applied to the child row, but the parent row cannot be deleted while the child row exists. Create new or modify existing columns, including calculated, rollup, and formula Source MSFT Practice Assessment 1: Question 49 of 50. A company uses Dataverse to store projects and project tasks. The Project table has a one-to-many relationship with the Project Tasks table. The Project Tasks table has a Due Date column. You need to create a column on the Project table that shows the earliest due date of the related project tasks. Which type of column should you create? Select only one answer. calculated formula rollup simple To perform aggregation on child records (those in the many parts of a relationship), a rollup column is required. The aggregation types include total, count, average, minimum (or earliest), and maximum (or latest). Calculated and formula columns can include columns 4 that are only in the same record or in a record in a parent table. Simple columns contain values that a user enters on a form; this column type cannot be used to aggregate data or hold the value of a calculation. Configure table properties Removed 12/01/24: Dataflows and their capabilities Source MSFT Practice Assessment 1: Question 47 of 50. You must schedule data to import automatically into Microsoft Dataverse. You need to define the days of the week to import the data and ensure that you are notified of any failures. Which tool should you use? Select only one answer. instant cloud flow scheduled cloud flow dataflow automated cloud flow A dataflow is used to import data into Dataverse and has native capabilities to send failure notifications. Instant cloud flows run when a user triggers the flow, not on a schedule. A scheduled cloud flow can be used to set the specific days to run but will not natively send failure notifications. An automated flow runs when an event happens, not on a schedule. Source MSFT Practice Assessment 3: Question 25 of 50 ¡REPASAR! A company collects lead information from its website. The first and last names of the leads are added to a.csv file. The file is stored in Microsoft OneDrive. New leads added to the file the previous day must be loaded into a Microsoft Dataverse table daily. You need to create a dataflow to add the new leads to the Dataverse table. What should you do? Select only one answer. Configure automatic refresh. Configure incremental refresh. Manually refresh each day. Edit the file each day to remove leads already in Dataverse, and then refresh manually. Automatic and manual refresh both add all leads in the file to Dataverse, resulting in duplicates, so the file must first be edited to remove the duplicates. An incremental refresh requires a date field to use for determining the time period of rows to import. Since one is not present in the file, it cannot be used. Source MSFT Practice Assessment 3: Question 26 of 50. You must schedule data to import automatically into Microsoft Dataverse. You need to define the days of the week to import the data and ensure that you are notified of any failures. Which tool should you use? Select only one answer. instant cloud flow scheduled cloud flow dataflow automated cloud flow A dataflow is used to import data into Dataverse and has native capabilities to send failure notifications. Instant cloud flows run when a user triggers the flow, not on a schedule. A scheduled cloud flow can be used to set the specific days to run but will not natively send failure notifications. An automated flow runs when an event happens, not on a schedule. Source ExamTopics Topic 5 Question 30: HOTSPOT – You plan to create a dataflow to import data into Microsoft Dataverse by using Power Query. The dataflow has the following requirements: A table of aggregated data must be created in dataflow storage. A unique identifier must be created for the table. You need to configure the dataflow. Which solutions should you use? Table of aggregated data: o Fact table o Merge query o Linked entity o Computed entity Unique identifier: o Key column o Pivot column o Alternate key Source ExamTopics Topic 5 Question 31: You plan to create a dataflow by using Power Query to transform the data. You observe that some cells display an error instead of the expected data. You need to obtain more details about the errors. What should you do? A. Use the App Checker. B. Select the cell with the error. C. Use the Flow Checker. D. Select the row that includes the cell with the error. E. Use the Advanced Editor. Source ExamTopics Topic 5 Question 34: HOTSPOT – You use a dataflow to import data into Microsoft Dataverse. The data uses the following schema: 5 The data must load in the least amount of time. You need to configure the incremental refresh settings for the dataflow. Which columns should you use? Answer area. Column names. Filter field: o createdon o accountid o accountnumber o versionnumber Detect data changes: o createdon o modifiedon o accountnumber o versionnumber Source ExamTopics Topic 5 Question 35: HOTSPOT – A company uses Dataverse to store the names of contacts. The company uses a shared Microsoft Excel file to collect the data. The company requires that the contacts be added to Dataverse automatically every day. You need to identify which tools are required to create and perform the import. What should you use? Answer area. Tool. Create the import: o Data map o Dataflow o Import from Excel o Import Wizard Perform the import: o Connections o Custom connectors o Power Apps o Power Query 1.2. Manage Dataverse Configure Dataverse search, and manage the search index Source ExamTopics Topic 1 Question 26: On a Contact record, a user creates a Note record that contains the word running. One week later, the user reports that they cannot find the Contact record associated with the Note record. You need to find the Note record. Solution: Use Categorized Search to search for the word run. Does the solution meet the goal? A. Yes B. No Categorized Search is not suitable for finding a Note record based on a partial word like “run.” Categorized Search looks for exact matches and is not effective in finding variations of words. In this scenario, using a more advanced search method, such as relevance search or advanced find, would be more appropriate as they can handle word variations and provide more accurate results. Source ExamTopics Topic 1 Question 27: On a Contact record, a user creates a Note record that contains the word running. One week later, the user reports that they cannot find the Contact record associated with the Note record. You need to find the Note record. Solution: Use Relevance Search to search for the word run. Does the solution meet the goal? A. Yes B. No Source ExamTopics Topic 1 Question 27: On a Contact record, a user creates a Note record that contains the word running. One week later, the user reports that they cannot find the Contact record associated with the Note record. You need to find the Note record. Solution: Use Relevance Search to search for the word run. Does the solution meet the goal? A. Yes B. No 6 Source ExamTopics Topic 1 Question 28: On a Contact record, a user creates a Note record that contains the word running. One week later, the user reports that they cannot find the Contact record associated with the Note record. You need to find the Note record. Solution: Use Quick Find search on the Notes list to search for the word run. Does the solution meet the goal? A. Yes B. No Source ExamTopics Topic 1 Question 46: DRAG DROP – You modify a model-driven app for a bicycle repair help desk. The model-driven app is for help desk users when customers have an issue with their bicycle. After you add a custom table named bicycle, you configure the table for Microsoft Dataverse search. The table will contain information from callers about their bicycles. The account table is related to the custom table. Contact information is brought over to the custom table. You add the following columns to the table: ✑ Bicycle type ✑ Tire brand ✑ Special equipment Users must be able to perform the following types of searches: ✑ Search for all customers who have a bicycle type of Contoso and live in Florida. ✑ Search all tables for any record that contains the word broken. You need to decide which type of search will give you the results desired. Which search should you configure? Select and Place: Reference Source ExamTopics Topic 1 Question 59: HOTSPOT – A company plans to implement a model-driven app. The company will enter data through the app. The company has the following requirements: Users must be able to search for the data inside the app. Users must be able to search for the data outside the app. You need to configure a solution for each requirement. What should you use? Answer area. Requirement – Solution. Search data inside the app: o Categorized Search o Dataverse Search o Microsoft Search o Quick Find Search Search data outside the app: o Content Search o Dataverse Search (ChatGPT) o Microsoft Search (ChatGPT) o Modern Search Source MSFT Practice Assessment 3: Question 19 of 50. A company is using Microsoft Dataverse search. You need to configure Quick Find View so the Relationship column appears in the filter pane when users search for accounts. Which part of Quick Find View should you configure? Select only one answer. Filter by Sort by Find columns View columns View columns appear in the filter pane in the search results. Filter by determines which records are shown in the results. Sort by determines the order in which records are shown in the results. Find columns set the columns that are searched. Source MSFT Practice Assessment 3: Question 24 of 50 ¡REPASAR! A company uses Microsoft Dataverse Search. You need to configure search so that the Account Number column is searched when users query for accounts using global search. What should you configure? Select only one answer. search index lookup view quick find view default public view The find columns in the quick find view are the columns searched when users query for records. The lookup view is not used to define which columns are searched. It determines the columns that are displayed inside a lookup control. The default public view is not used to define which columns are searched. These just determine which views are displayed for users. The search index is used to configure which tables are included in global search, not which columns are searched. Source MSFT Practice Assessment 4: Question 41 of 50 You are creating a cloud flow to perform bulk operations on data in Microsoft Dataverse. You verify that the configuration in Microsoft Power Platform admin center is set up correctly. Cloud flow searches two 7 columns in a table by using the Search rows action. Dataverse search does not return any results. What should you do? Select only one answer. In the Power Platform admin center, turn on Dataverse search for your environment. Add table to the search index. Add a column to the quick find view. Reset filter conditions for the column. This item tests the candidate’s knowledge of configuring Dataverse search to be used across Microsoft Power Platform tools. The reason no records are returned is caused by preset filters in the quick find view. The stem says Dataverse search is not returning data for the column, not that Dataverse search is not working. The table is indexed. The column is not being returned. Columns are already added to the view. Manage auditing Source MSFT Practice Assessment 1: Question 45 of 50 ¡REPASAR! You manage a Power Platform environment with a Microsoft Dataverse instance enabled. You need to ensure that a new user named User1 is able to enable or disable auditing for the environment. Which security role should you assign to User1? Select only one answer. System Customizer This answer is correct. Basic User Environment Maker Service Reader The System Customizer standard security role provides users the necessary access to enable or disable auditing for any Dataverse environment. The Basic User, Environment Maker, and Service Reader roles provide different access levels but do not allow working with the enabling or disabling of the auditing. Source ExamTopics Topic 1 Question 25: You plan to implement Microsoft Dataverse. You must track changes for two columns in the Account table. You must maintain a historical log of changes for the two columns and track only what is necessary. You configure the appropriate organization settings. You need to configure the system to track changes for the two columns. Which two actions should you perform? Each correct answer presents part of the solution. Enable auditing for the Account table. Enable auditing for the two specific columns. Enable change tracking for the Account table. D. Enable change tracking for the two specific columns. Source ExamTopics Topic 1 Question 53: A company uses Power Apps with Microsoft Dataverse. The company enables auditing on the Dataverse database. The company tenant reaches the maximum storage capacity. You need to delete some auditing data. Which three deletion options should you use? Each correct answer presents a complete solution. A. by record B. between two specified dates C. by table D. older than a specified date E. by column Link Source ExamTopics Topic 1 Question 1: HOTSPOT - The owner of a company needs to know who signs into the system. You need to ensure that the owner can view the user audit logs. Where does each action need to be performed? Hot Area: Answer area. Location. Activate user auditing: o System Settings o Personal Settings o Customize the System o Microsoft 365 Compliance View the user audit logs: o Advanced Find o Individual record o User Summary report o Microsoft 365 Compliance 8 Source ExamTopics Topic 1 Question 57: HOTSPOT - A company uses Power Apps. You enable auditing in Microsoft Dataverse. Users report the following issues when viewing the audit logs: Unable to view the read access audit logs. Unable to view the Account table audit logs. You need to troubleshoot the issues. What are the causes of the issues? Answer area. Issue – Cause. Unable to view the read access audit logs: o Storage for the tenant is over capacity o Auditing is not enabled at the environment level Unable to view the Account table audit logs: o Auditing is disabled at the app level o Auditing is disabled at the table level o Auditing for a read access is not enabled Describe options for importing and exporting data Source ExamTopics Topic 1 Question 43: You are using the Data import wizard to import records into the account table from a CSV file. The CSV-to-table mapping is as follows: ✑ The Name column represents the account name and maps to the Account Name column. ✑ The Parent Name column represents the holding company of the account with subsidiaries underneath. Records that are imported into the table are only related to other records in the file. You need to configure the import to create the relationship between records. What should you do? A. Map Parent Name in the CSV file to the Parent Account column. Select Account Name as the lookup criteria. B. Map Parent Name in the file to the Parent Account column. Select Parent Account as the lookup criteria. C. Create an alternate key on the account table by using the Account Name column. Do not map Parent Name in the file. D. Look up the record IDs of the records in the Parent Account column. Add the record IDs as a new column in the file. Map the new column to the Parent Account column. Source MSFT Practice Assessment 3: Question 18 of 50. A company stores customer data in a Microsoft SharePoint list. The SharePoint list does not use data validation. The company plans to deploy a model-driven app within Microsoft Dataverse to manage the customer data. You need to reduce the risk of errors when bringing the data into Dataverse by using standard functionality as much as possible. Which tool should you use? Select only one answer. Microsoft Power Automate Data map Template for data import Dataflow A template for data import will have the columns defined with the correct data types. Using this spreadsheet to enter data will ensure that the data is pre-validated and will reduce errors when importing the data into the Dataverse environment. Power Automate flows could be used to transfer data but will require a lot of validation logic and would require a much higher effort to create. Data mapping will assist in mapping columns but will not reduce the likelihood of any errors happening during the import process. Dataflows can import data from data sources, but a dataflow does not provide the capability for managing data validation issues. Source ExamTopics Topic 5 Question 18: The sales manager receives a list of leads from a partner company monthly. The field names that are provided do not match the fields in Microsoft Dataverse tables. A data map does not exist. You need to import the leads without changing the data from the partner company. What should you do? A. Create a data map on the first import by using the Import Data wizard. B. Add a template for Import Data. C. Use Import Field Translations. D. Create a data map in Data Management. Configure duplicate detection settings Source MSFT Practice Assessment 1: Question 38 of 50. You manage a Microsoft Dataverse instance. Users must receive a warning message when they try to save a contact that matches an existing contact record. A match in one of the following columns must trigger the message: First and last name. Email address. Mobile phone number. You need to configure duplicate detection on the Contact table. How many duplicate detection rules must you create? Select only one answer. One Two Three Four In a duplicate detection rule, all specified fields must match. For or conditions, separate rules are needed. One rule is needed for the first and last name match, another rule for the email address match, and another rule for the mobile phone number match. Source ExamTopics Topic 1 Question 54: A company uses a Power Apps app with Microsoft Dataverse. The company requires the import of records into Dataverse. Duplicate records in the data must be deleted without user intervention. You create a duplicate detection rule. You need to configure the rule for the data import. Which option should you configure? 9  A. Enable the During data import option. B. Enable the Templates for Data Import option. C. Disable the Allow Duplicates option. D. Enable the When a record is created or updated option. Source ExamTopics Topic 1 Question 62: A company uses a Dataverse environment. The environment is accessed from canvas and model-driven apps. The Dataverse environment contains a table that has the following columns: Name Company Contacted On. The company requires that the table not contain any duplicate rows when users create data in the environment. You need to implement a solution that meets the requirement. Solution: Create an alternate key for the columns. Does the solution meet the goal? A. Yes B. No Source ExamTopics Topic 1 Question 63: A company uses a Dataverse environment. The environment is accessed from canvas and model-driven apps. The Dataverse environment contains a table that has the following columns: Name Company Contacted On The company requires that the table not contain any duplicate rows when users create data in the environment. You need to implement a solution that meets the requirement. Solution: Create a Microsoft Power Fx formula for the columns. Does the solution meet the goal? A. Yes B. No Source ExamTopics Topic 1 Question 64: A company uses a Dataverse environment. The environment is accessed from canvas and model-driven apps. The Dataverse environment contains a table that has the following columns: Name Company Contacted On The company requires that the table not contain any duplicate rows when users create data in the environment. You need to implement a solution that meets the requirement. Solution: Create a duplicate detection rule for the columns. Does the solution meet the goal? A. Yes B. No Source ExamTopics Topic 1 Question 65: A company uses a Dataverse environment. The environment is accessed from canvas and model-driven apps. The Dataverse environment contains a table that has the following columns: Name Company Contacted On The company requires that the table not contain any duplicate rows when users create data in the environment. You need to implement a solution that meets the requirement. Solution: Create a business rule for the columns. Does the solution meet the goal? A. Yes B. No Configure bulk deletion - Delete bulk records - Power Platform | Microsoft Learn Source ExamTopics Topic 2 Question 29: DRAG DROP – A company uses a Microsoft Power Platform environment. The company plans to implement a Power Apps app. The application must meet the following requirements: Audit all user activity and only retain the audit logs for one year. Annually remove products that were created over a year ago. You need to configure the automated processes. What should you configure? Answer area. Requirement – Configuration. Audit log retention: o Table auditing o Bulk deletion job o Environment auditing o Filtered view Product removal: o Table auditing o Bulk deletion job o Environment auditing o Filtered view Source MSFT Practice Assessment 3: Question 46 of 50 You manage a Microsoft Dataverse instance. You need to create a custom bulk deletion job that deletes workflow records from the AsyncOperationBase table. The records must have been created in the last seven days and successfully completed. Which system job type should you select in the condition? Select only one answer. Bulk Delete System Event Deletion Service Workflow System Job Type Equals Workflow ensures that only the classic workflow records are queried and deleted. We can use other conditions to refine the query. The rest of the other choices will not fetch only workflow records. Bulk Delete fetches a list of bulk delete records and cannot be used to fetch only workflow records. System Event fetches a list of system events and cannot be used to fetch only workflow records. Deletion Service will not fetch only workflow records and can be used to query deletion services. 10  1.3. Configure security settings Manage business units Source ExamTopics Topic 1 Questions 9, 66: You must create a new entity to support a new feature for an app. Records for the entity must be associated with a business unit and specify security roles for the business unit. You need to configure entity/table ownership. Which entity ownership type should you use? A. user or team owned B. organization-owned C. none D. business-owned Source ExamTopics Topic 1 Question 40: HOTSPOT – You are designing the organization structure for a company that has 5,000 users. You need to configure security roles for the company while minimizing administrative effort. What should you do? Hot Area: Answer area. Requirement – Action. Apply a security role to everyone in a business unit: o Assign the security role to the default business unit team o Assign the security role individually to each user in the business unit o Create a new team, add the business unit users, and then assign the security role to the team Ensure an individual can see records in their current business unit and a child business unit: o Grant the user a security role from the child business unit o Grant the user the Parent: Child Business Units security permission o Grant the user a security role from the root business unit For Box 1 the correct answer should be option 1 as the docs claims: "You can assign a security role to the business unit's default team. This is done to simplify security role management where all your business unit team members can share the same data access." And for Box 2, the correct answer should be Option 2, as docs claims: "Deep. This access level gives a user access to records in the user's business unit and all business units subordinate to the user's business unit. Create and manage security roles Source ExamTopics Topic 1 Question 13: You create an app for the sales team at a company. Members of the sales team cannot access the app. You need to ensure that sales team members can access the app. Where should you configure app permissions? A. Dynamics administration center B. Manage Roles C. Security Roles Source ExamTopics Topic 1 Question 21: A user has access to an existing Common Data Service database. You need to ensure that the user can create canvas apps that consume data from Dataverse. You must not grant permissions that are not required. Which out-of- the-box security role should you assign to the user? A. Environment Admin B. System Customizer C. Common Data Service User D. Environment Maker Source ExamTopics Topic 1 Question 34: A user has access to an existing Microsoft Dataverse database. You need to ensure that the user can create canvas apps that consume data from Dataverse. You must not grant permissions that are not required. Which out-of- the-box security role should you assign to the user? A. Environment Admin B. Basic User C. Environment Maker D. System Customizer Source ExamTopics Topic 2 Question 26: A user needs to create a Power Apps portal app. The user is getting a permission denied error when creating the portal app. You need to configure permissions to create the portal app. Which three permissions should you configure? Each correct answer presents part of the solution. A. In the Power Platform admin center, ensure that the user account has read-write access. B. In Azure Active Directory, assign the Contributor role to the application at the subscription scope. C. In Azure Active Directory, ensure that the user has permission to register an app. D. In the Power Platform admin center, change the portal app owner to the user. E. In the Power Platform admin center, ensure that the user has the System administrator security role. 11 Source MSFT Practice Assessment 3: Question 22 of 50 A company uses Microsoft Power Platform in its Microsoft 365 tenant. The company requires specific users to manage environments within the tenant. You need to configure security for the tenant. What should you use? Select only one answer. Microsoft 365 role Microsoft Dataverse security role Access team Microsoft Power Platform license To allow users to be able to manage environments, they need to be assigned an appropriate Microsoft 365 role, such as Power Platform administrator, from within the Microsoft 365 admin center. Microsoft Dataverse security roles do not manage permissions for users to manage environments within the tenant. Access teams are used to share records within Microsoft Dataverse with other users. Licenses provide users with the ability to use applications. Access teams and licenses do not control security around environment management. Source ExamTopics Topic 5 Question 13: HOTSPOT - You have a model-driven app. You create five Microsoft Excel templates for analyzing customer data. Four of the templates must be available to all users. The remaining template must be available only to you. You configure the appropriate security roles for users. You need to determine how to upload the Excel templates. Which method should you use? Hot Area: Answer area. Availability – Method. Available to everyone: o In the settings menu, select document templates o In the view for the email records, select Excel Templates o In the Settings menu, select Email Templates Available only to yourself: o In the Settings menu, select Document Templates o In the view for the email records, select Excel templates o In the Settings menu, select Email Templates. Create and manage users and teams Source MSFT Practice Assessment 1: Question 41 of 50. A user requires access to a customized environment. The following error appears when you attempt to add the user: “User couldn’t be added because they haven’t met all of the access requirements.” You need to identify the issue. Which three issues can cause this error? Each correct answer presents a complete solution. Select all answers that apply. The user’s account does not have a license. The user is not a member of the environment’s security group. The user does not have a basic user security role assigned. The user’s account is not enabled in Microsoft Entra ID. Microsoft Dataverse is not provisioned in the environment. The user is not a member of a Microsoft 365 group connected with the environment. The user must have a license to be added to the environment. If there is a security group assigned to the environment, the user must be a member of it. The user’s account must be enabled in Microsoft Entra ID prior to adding the user to the environment. A security role is assigned after the user is added to the environment. If Dataverse is not provisioned, the user would be automatically added. The Microsoft 365 group is not a part of the Dataverse ecosystem. Source ExamTopics Topic 1 Question 8: HOTSPOT - You are a Dynamics 365 Customer Services administrator. You have a Production instance and Sandbox instance. Users record Production instance data in the Sandbox instance. You need to ensure that the users only record data in the Production instance. Which security function needs to be edited to prevent access to the Sandbox? Hot Area: Answer area. Application area – Security function. Microsoft 365 admin center: o Roles o Groups o Licenses o Access rights Dynamics 365 Sandbox instance: o Roles o Groups o Access rights Source ExamTopics Topic 1 Question 32: HOTSPOT - A company uses a canvas app to manage production resources in a specific region. Employees must be at company locations to use the app. Due to a sudden requirement for employees to work remotely, employees no longer commute to a specific location to conduct their work and cannot access the canvas app. You must reconfigure the app to ensure 12 that employees only access the app from a limited number of locations. You need to restrict access to the app. Which components should you configure? Hot Area: Answer area. Requirement – Component. Ensure that employees can only access the app form a specific region: o Canvas app settings o Power Platform admin center o Azure Active Directory o Office 365 admin center Specify the locations where a user can access the app: o Security role o Conditional Access policy o Local Security policy o Compliance policy Reference PENDIENTE COMPROBAR - Source ExamTopics Topic 1 Question 35: DRAG DROP – You are configuring Microsoft Dataverse security. You plan to assign users to teams. Record ownership and permissions will differ based on business requirements. You need to determine which team types meet the requirements. Which team type should you use? Select and Place: Answer area. Requirement – Team type. Ability to own records in Dataverse o Access team o Azure Active Directory (or -updated- Microsoft Entrata) o Microsoft Teams team Provides permissions without a security role assigned o Access team o Azure Active Directory group team o Microsoft Teams team Source MSFT Practice Assessment 3: Question 21 of 50. A company uses Microsoft Dataverse. Users often must share account records with team members. You create a team template for the account table to begin setup for a simplified record sharing process. What should you do next? Select only one answer. Create an access team. Create an owner team. Add the Users sub-grid to the account form. Add the Access Team Template sub-grid to the account form. With access team templates, users share records by adding other users to the Users sub-grid on the form. The system automatically creates an access team for each record when a record is first shared in this way. Sharing by using team templates creates access team templates automatically. Manually created access teams do not work with team templates. Sharing by using team templates creates access team templates automatically. Manually created owner teams do not work with team templates. Selecting an Access Team Template on a record does not automatically share a record to a user or a team. Source MSFT Practice Assessment 4: Question 47 of 50 You use Microsoft Entra ID Group teams to handle user security access to a Microsoft Dataverse application. You need to set up security group teams within Dataverse and apply security roles to them. What should you use to set up the team record in Dataverse? Select only one answer. Microsoft Entra ID Group Team name Security Role name Microsoft Entra ID Group ID Dataverse Business Unit To set up a team record in Dataverse that is linked to a Microsoft Entra ID Group team, you must use the Microsoft Entra ID Group ID. This will link the Dataverse team to the Azure team through this. It is not possible to use the Microsoft Entra ID Group Name to link the group with the Dataverse team. Security role/s are not required to set up the Dataverse team. Dataverse Business Unit is not needed to set up the Dataverse team, as the business unit is automatically set when the record is created. Create and manage column security Source MSFT Practice Assessment 1: Question 50 of 50. A company uses a Dataverse table named Milestones to store project milestone information. You need to ensure that only users in the Project Managers team can view data in the Milestone status column. Which three configuration steps should you perform? Each correct answer presents part of the solution. Select all answers that apply. Create a new security role. Create a new column security profile. 13  Enable column security on the Milestone status column. Apply a security role to the Project Managers team. Assign read privilege on the Milestones table to the security role. Assign permissions and add the Project Managers team to the column security profile. Column security should be enabled for columns that need to be secured. A column security profile should be created to assign privileges and users/groups who should be provided access to the specific column. A security role is used for record-level access and does not enable column-level security. Users must have the relevant privileges in a security role for the column security profile to be effective. A column security profile cannot provide a user with privileges that they do not have in their security roles. Source ExamTopics Topic 1 Question 50: A company uses Power Apps. Users must be able to view only the address1 columns in the Account table. You need to ensure other address columns are not visible to users when creating views and filters. What should you do? A. Delete the other address columns from the table. B. Disable the Search option for the columns. C. Use column-level security to remove read access to all users. D. Create business rules to hide the other address columns. Column-level security in Power Apps allows you to control access to specific columns within a table. By removing read access to the other address columns, you ensure that users can only view the address1 column and cannot see or use the other address columns when creating views and filters. This approach maintains the integrity of the data while providing the necessary visibility restrictions. Source ExamTopics Topic 1 Question 15: DRAG DROP – You need to recommend a role for users to perform several required tasks. The solution must use the principle of least privilege. Which roles should you recommend? Select and Place: Answer area. Function - Role Create new users o Office 365 global administrator o Office 365 service administrator o Dynamics 365 service administrator o Dynamics 365 system administrator Assign roles to users o Office 365 global administrator o Office 365 service administrator o Dynamics 365 service administrator o Dynamics 365 system administrator Perform backups for an instance o Office 365 global administrator o Office 365 service administrator o Dynamics 365 service administrator o Dynamics 365 system administrator Source ExamTopics Topic 1 Question 44: HOTSPOT - A company has a sales application that is supported by an Azure SQL database. You are developing a Power Apps app for use by customer service agents. The app must reference customer data from the sales application. Data in the sales application is constantly changing and must not be replicated in Microsoft Dataverse. Some customer data is considered sensitive. You must protect data for specific fields when users view data in the app. You need to configure table creation for the app. How should you configure the app? Hot Area: Answer area: Requirement – Action. Reference Dataverse table type to create for the referenced customer data: o Create a virtual table. o Create an activity table o Create a user-owned table o Create an organization-owned table Protect sensitive customer data for specific fields: o Create an alternate key o Create a secured column o Implement input method editor (IME) mode o Set the value of the visible property of the fields to false Configure hierarchy security 14 Source ExamTopics Topic 2 Question 20: You are configuring a new Power Apps portal. You have two web roles, one for authenticated users and one for anonymous users. You grant the Anonymous Users role to users. A test user reports that they can access the home page but cannot view a page linked from the home page. You need to determine why the test user cannot view the portal page. What is the cause of the issue? A. The setting to make the page available to everyone is disabled. B. Inherited permissions are not enabled for the linked page. C. The Authenticated Users Web role does not have permission to view the page. D. Maintenance mode is enabled on the portal. Source ExamTopics Topic 1 Question 37: HOTSPOT - You are setting up Power Apps security for a company. The company has a CEO, two vice presidents, and 10 managers. Five support representatives report to each manager. You set up Manager Hierarchy so managers are able to view data only for the representatives who report to them. The CEO must be able to view all data for everyone. All support representatives must be able to view customer information in each other's data across all managers. You need to resolve issues that arise during testing. What should you do? Hot Area: Answer area. Issue – Action. Managers are unable to view all their report data: o Add the manager’s name to the representative’s user record o Change the Manager Hierarchy depth to 2 o Move the manager and reports to a separate business unit o Set up a position in hierarchy The CEO is unable to view representative data but can view manager data: o Add the CEO to the representative user record as manager o Change Manager Hierarchy depth to 3 o Create team security Five support representatives can view only their own data: o Add the manager’s name to the representative’s user record o Add users to field security o Set up a position hierarchy Source ExamTopics Topic 1 Question 45: HOTSPOT – A customer uses Power Apps to view and maintain their contacts that are stored in Microsoft Dataverse. Several columns must be configured to ensure the security settings for sales associates are view only. You need to configure the access restrictions. Which component for field-level security should you use? Hot Area: Answer area. Action – Component. Enable the fields for record-level security: o Azure Data Lake Gen2 o Azure SQL o PowerApps app designer o Microsoft Power Platform admin center Set the security settings for the sales associates to view only: o Azure Active Directory group team o Dataverse table o Field security profiles o User Configure Microsoft Entra ID group teams 15 2. Create apps by using Microsoft Power Apps 2.1. Create model-driven apps Create and configure multiple form types Source ExamTopics Topic 1 Question 56: HOTSPOT - You create a model-driven app for an automobile parts help desk. A help desk agent uses a form to gather information about customers’ automobiles in two custom tables. The names of the tables are Client and Automobile. The form must prepopulate the following information about the customer from the client table: First name Last name The agent must be able to type the following information about the automobile: Automobile make Automobile model You need to implement the form. What should you configure? Answer area. Requirement – Configuration. Prepopulate client information: o Dataflow o Relationship o Alternate key o Virtual table Enter automobile information: o Table o View o Connector o Power Automate flow Comment: 1) Relationship (virtual table does not pre-populate, it just brings data up, data resides outside). 2) Table (you type into fields adding data to a table. if table is missing... you cannot. View, PowerAutomate, not to key in. Connector to load from but not to 'type in'.). But in terms of consistency this would mean that for 1) the table 'Client' would not yet exist to prepopulate from via relationship... (you cannot assume table client already existing and table Automobile not yet existing if you are consistent. Source ExamTopics Topic 2 Question 1: DRAG DROP – You create an app to manage customer service cases. Cases entered in forms require different types of data to be stored in different types of columns. You need to create forms for each of the following case types: Which form types should you create? Select and Place: A. Main B. Main C. Card D. Quick create E. Quick view 16 Source ExamTopics Topic 2 Question 4: DRAG DROP - You must create a form for team members to use. The form must provide the ability to: ✑ Lock a field on a form ✑ Trigger business logic based on a field value ✑ Use existing business information to enhance data entry. You need to implement business rule components to create the form. Which components should you use? Select and Place: Answer area. Requirement - Component Lock a form field: o Actions o Conditions o Recommendation Trigger business logic based on a field value: o Actions o Conditions o Recommendation Leverage existing business information to enhance data entry: o Actions o Conditions o Recommendation Source ExamTopics Topic 2 Question 38: DRAG DROP – You are modifying a model-driven app. You set up a customer table in Microsoft Power Platform to retrieve user data. You set up a form with the following columns for users to enter their data. The form includes the following columns: The form must do the following: The Country/region column must automatically populate with US when English is chosen as a language. If the user selects Other for this column, the column must remain blank so that user can enter a value. The Passport expiration date column must appear only if the user selects Yes in the Passport ownership column. You need to configure the app with the least amount of effort. What should you configure? Country/region: o Power Automate flow o Business rule o Business process flow o Formula Passport expiration date column appears: o Power Automate flow o Business rule o Business process flow o Formula Use controls in the form designer Source MSFT Practice Assessment 3: Question 40 of 50. You need to add a control to a form to extract contact information from images in a model-driven app. Which control should you add? Select only one answer. Image web resource Business card reader HTML web resource Rich text editor The AI Builder prebuilt model business card reader can be added as a component to a model-driven app form. This model is used to detect business cards and extract information from the cards. An image web resource control is used to upload new icons or images to add to a form. An HTML web resource control is used to display web resource information in a form. The rich text editor control is used to edit text formatting and include media in the text field. Create and configure views Source MSFT Practice Assessment 1: Question 25 of 50. A company is using a model-driven app. When users view contacts for an account by navigating to the Related tab, they do not see the Job Title column in the default view. You need to configure the view to include the Job Title column. Which view should you configure? Select only one answer. 17  Advanced Find Quick Find Associated Default public The default view shown when viewing contacts on the Related tab is the Associated view. Although a user can change to a different view, the default view shown cannot be set. The Advanced Find, Quick Find, and Default public views are not shown when viewing contacts on the Related tab. Source MSFT Practice Assessment 1: Question 33 of 50. You create a model-driven app. You need to configure the columns that are searched when users use global search. Which table view should you configure? Select only one answer. Default public view Quick Find view Lookup view Advanced Find view The Quick Find view is used to configure the columns that are searched when users use global search. The default public view, Lookup view, and Advanced Find view are not used to configure searching. Source ExamTopics Topic 1 Question 2, 30, 39, 41 y 48: Your organization does not permit the use of custom code for solutions. You need to create a view that can be viewed by all users in an organization. Where should you create the view? A. Advanced Find B. Entities component of a solution C. Microsoft Excel template D. Templates area E. System Settings F. Microsoft Visual Studio G. Maker portal H. List view of the entity Source ExamTopics Topic 2 Question 12: A company is creating a Power Apps solution for a production facility. The current solution is in English. The customized components must be translated into several languages. You need to extract the text for translation. In which location can you achieve this goal? A. The tables in the web application. B. The selected environment in the Microsoft Power Platform admin center. C. The solution in the web application. D. The individual solution components in the web application. Source ExamTopics Topic 1 Question 55: DRAG DROP – A company has a model-driven app that uses Microsoft Dataverse. Users need to add an alternate phone number when entering their account information. The users also require a list that displays the customers that do not have an alternate phone number. You need to enable the required features. Which features should you use? Answer area. Requirement – Feature. Add alternate phone number: o Table o View o Column o Relationship List of customers without alternate phone number: o Table o View o Column o Relationship 18 Source MSFT Practice Assessment 3: Question 38 of 50 (what is quick find view ¿?) You create a model-driven app. You need to configure the columns that are searched when users use global search. Which table view should you configure? Select only one answer. Default public view Quick Find view Lookup view Advanced Find view The Quick Find view is used to configure the columns that are searched when users use global search. The default public view, Lookup view, and Advanced Find view are not used to configure searching. Configure custom pages Source MSFT Practice Assessment 1: Question 31 of 50. A company plans to use Microsoft Power Platform to create an app. You need to add the app as a main page in the site map of a model-driven app. Which component should you use? Select only one answer. Iframe Custom page Web resource Embedded canvas app To add an app to the site map of a model-driven app, a custom page must be used. This is a special type of canvas app. Iframes, web resources, and embedded canvas apps cannot be added to a site map. Source ExamTopics Topic 1 Question 31: HOTSPOT - You develop a Power Apps app. Users report that the main form does not display data from other entities or allow them to edit data from other entities. You need to embed information from other entities in the form and allow users to edit the data. Which actions should you perform? Hot Area: Answer area. Requirement – Action. Edit data: o Add a mobile form o Add a quick create form o Add a sub-grid o Add a virtual entity View data: o Add a reference panel o Add a quick view Source MSFT Practice Assessment 3: Question 37 of 50. A company plans to use Microsoft Power Platform to create an app. You need to add the app as a main page in the site map of a model-driven app. Which component should you use? Select only one answer. Iframe Custom page Web resource Embedded canvas app To add an app to the site map of a model-driven app, a custom page must be used. This is a special type of canvas app. Iframes, web resources, and embedded canvas apps cannot be added to a site map. Source ExamTopics Topic 2 Question 25: DRAG DROP – You are customizing a model-driven app for a company. You create a Theme template to ensure the company logo and colors are properly used within these apps. The theme must meet the following requirements: ✑ Updated to add the logo ✑ Downloaded by the makers to create the app You need to configure the assets. Select and Place: Update logo: o Edit the theme in System settings and upload a jpg file o Replace an existing UI item’s hexadecimal number o Upload the theme elements as new web resources o Use the component library Change model-driven app colors: o Edit the theme in System settings and upload a jpg file o Replace an existing UI item's hexadecimal number o Upload the theme elements as new web resources o Use the component library 19 Question 22 of 50 You develop a custom page by using Power Fx in a model-driven app. You add a ContactsGallery1 gallery control to the custom page. You need to navigate to the Contacts table default main form to edit a selected item in ContactsGallery1. Which two Power Fx formulas can you use? Each correct answer presents a complete solution. Select all answers that apply. Navigate(Contacts) Navigate(Defaults(Contacts)) Navigate(ContactsGallery1.Selected) Navigate('Contacts (Views)'.'Active Contacts') Navigate( ContactsGallery1.Selected,{Page: 'Contacts (Forms)'.Contact } ) The custom page in the model-driven app allows us to navigate to the Dataverse table views and forms by using Power Fx. You can use the Navigate function with a second parameter to navigate to specific table forms and views. If the second parameter is not mentioned, then it will open the default form of the table. Configure modern commanding by using Power Fx Source MSFT Practice Assessment 1: Question 30 of 50. ¡REPASAR! You are creating a canvas app. You are using the Accounts table in the app. You need to set the action to navigate to the default view of the Accounts table. Which syntax should you use? Select only one answer. Navigate (Accounts) Navigate (‘Accounts (Views)’. ’Active Accounts’) Navigate (Account.Selected) Navigate ( Defaults (Accounts)) To navigate to a default view of a table, you should use the Navigate command and pass in just the table name as the only argument. Passing in anything else will not load the default view but will load the relevant item to the different syntax being used. Source MSFT Practice Assessment 1: Question 32 of 50. You need to add a custom command to a model-driven app main form. Which two methods can you use to define the action for the command? Each correct answer presents a complete solution. Select all answers that apply. Plug-in Power Fx Business rule JavaScript HTML The action for modern commands in model-driven apps can be defined by using Power Fx formulas or JavaScript. Plug-ins are used to perform business logic when records are created or saved. A business rule implements business logic on a form. HTML is a webpage definition language and can be used when adding web resources. Source MSFT Practice Assessment 3: Question 41 of 50. You are developing a modern command by using Power Fx for the Account table. The Account table has a related table named Appointment. You need to ensure that the modern command is available on the sub- grid of the Appointment table when it is shown on the Account main form. Where should you add the command? Select only one answer. Main form of the Account table Main form of the Appointment table Sub-grid view of the Account table Sub-grid view of the Appointment table The command should be added to the sub-grid view of the Appointment table because this command will be displayed in the sub-grid control that renders Appointment table data on the Account main form. The command added to the main form of the Appointment table will be displayed when we open a row of the Appointment table. The command added to the sub-grid view of the Account table will be displayed on forms of other tables that render Account table data within a sub-grid. The command added to the main form of the Account table will be displayed when we open a row of the account table. Source MSFT Practice Assessment 4: Question 21 of 50 You develop a new modern command for a model-driven app. You need to customize properties of the modern command. Which two properties can you modify? Each correct answer presents a complete solution. Select all answers that apply. Color DisplayMode OnSelect 20  Visible Width Modern command supports only two properties, OnSelect and Visible, that can include custom logic by using Power Fx. Command bar logic supports only a subset of the full Power Fx language capabilities. Embed a canvas app in a model-driven app form Source ExamTopics Topic 2 Question 32: A company uses model-driven apps. Users in the sales department enter the first name, last name, and phone number of customers in the app. The users request a single screen in the app to enter the customer data. You need to configure the app. What should you do? A. Create a Power Automate flow. B. Use a Power Virtual Agents app. C. Create a canvas app. D. Modify the site map. Canvas apps in Power Apps allow you to create an application from scratch, starting with a blank canvas. They are highly customizable and can be designed to fit the specific needs of your users. In this case, a canvas app would allow you to create a single screen where sales department users can enter the first name, last name, and phone number of customers. This would fulfill the users’ request for a single screen to enter customer data. Source MSFT Practice Assessment 4: Question 24 of 50 A company has a canvas app that is embedded on the model-driven app Main form of the Projects table. You need to obtain the Project Budget column value of the current row when the host model-driven app saves data. Which formula should you use in the OnDataRefresh action? Select only one answer. Set(CurrentProjectBudget, ModelDrivenFormIntegration.'Project Budget') Set(CurrentProjectBudget, 'Project Budget') Set(CurrentProjectBudget, ThisItem.'Project Budget') Set(CurrentProjectBudget, ModelDrivenFormIntegration.Item.'Project Budget') This item tests the candidate’s knowledge of embedding a canvas app in a model-driven app form. The ModelDrivenFormIntegration control is used to get contextual data from a model-driven form to the canvas app. The formula in the OnDataRefresh action is evaluated when the host model-driven form saves data. The item property of the ModelDrivenFormIntegration control provides column data associated with the current row. Add Microsoft Power BI dashboards and reports in a model-driven app Source MSFT Practice Assessment 1: Question 28 of 50. A company uses Microsoft Power BI and a model-driven app. A user needs to add a tile from a Power BI dashboard to the model-driven app. To which dashboard should you add the tile? Select only one answer. Microsoft Dynamics 365 system dashboard Power BI embedded system dashboard Microsoft Dynamics 365 user dashboard Power BI user dashboard The only place where a Power BI tile can be added in a model-driven app is a Dynamics 365 user dashboard. Source ExamTopics Topic 5 Question 12: You create a canvas app for a sales team. The app has an embedded Power BI tile that shows year-to-date sales. Sales users do not have access to the data source that the tile uses. Sales team users must be able to see data in the Power BI tile. You must minimize the level of permissions that you grant and minimize administrative overhead. You need to share another Power BI component to make the data visible. What should you share? A. The Power BI dataset the tile uses as a data source. B. The Power BI workspace that includes the tile. C. The Power BI dashboard that includes the tile. Source ExamTopics Topic 5 Question 13: You are creating Power BI reports for a company. A company that has a model-driven app wants to use Power BI reports within the app. You create the reports. You need to ensure that these reports are available within the app. Which two actions should you perform? Each correct answer presents a complete solution. A. Share the Power BI report to all users. B. Add the Power BI report to the Site Map dashboards. C. Create a PCF file. D. Use the native reports in model-driven apps. 21  E. Add the Power BI report to a dashboard in the model-driven app. Source ExamTopics Topic 5 Question 22: You are creating Power BI reports for a company. A company that has a model-driven app wants to use Power BI reports within the app. You create the reports. You need to ensure that these reports are available within the app. Which two actions should you perform? Each correct answer presents a complete solution. A. Share the Power BI report to all users. B. Add the Power BI report to the Site Map dashboards. C. Create a PCF file. D. Use the native reports in model-driven apps. E. Add the Power BI report to a dashboard in the model-driven app. Source ExamTopics Topic 5 Question 28: POWER BI: You have a canvas app with an embedded Power BI tile. You share the canvas app. Users report that they are unable to access the Power BI content. You need to determine why users are unable to access the content. What is the cause of the user's problems? A. The Power BI dashboard is not shared. B. The Power BI connection is not shared. C. The Power BI Display mode property on the Power BI tiles is set to Disabled. D. The Power BI interactions property on the Power BI tiles is set to Off. Source ExamTopics Topic 5 Question 32: POWER BI: A company creates a model-driven app. Users require access to a Power BI report that is embedded in the app. You need to configure the app. Where should you add the report? A. XML report B. Dashboard C. Business rule D. Power Automate cloud flow Extra: Embed a Power App visual in a Power Bi dashboard Source ExamTopics Topic 1 Question 38: You are embedding a Power Apps visual in a Power BI dashboard. External customers must authenticate to have access to the dashboard. You need to configure the solution. Which two actions should you perform? Each correct answer presents part of the solution. A. Set the Power BI service to authenticate users. B. Use a table in the Power BI dashboard. C. Publish to Power BI Report Server. D. Set the Power BI service to allow anonymous access. E. Share the Power Apps visual components with external users. Link al enlace. Power Apps visual is only supported for guest users when the following conditions are met: The canvas app URI (weblink) includes the tenantId of the app in the query string. The Power BI portal authenticates the user, instead of allowing anonymous access. The canvas app is shared with the guest user attempting to see the contents of the app. Extra: Flows or Workflows Link siguientes cuatro preguntas: Source ExamTopics Topic 3 Question 30: A company uses a model-driven app. The company needs to automatically update the Status column in real time. You need to configure this feature. Solution: Create a flow that has an Update item action. Does the solution meet the goal? A. Yes B. No Source ExamTopics Topic 3 Question 31: A company uses a model-driven app. The company needs to automatically update the Status column in real time. You need to configure this feature. Solution: Create a workflow that has an Update Record step. Does the solution meet the goal? A. Yes 22  B. No Source ExamTopics Topic 3 Question 32: A company uses a model-driven app. The company needs to automatically update the Status column in real time. You need to configure this feature. Solution: Create a flow that has an Update a row action. Does the solution meet the goal? A. Yes B. No Source ExamTopics Topic 3 Question 36: A company uses a model-driven app. The company needs to automatically update the Status column in real time. You need to configure this feature. Solution: Create a workflow that has a Change Status step. Does the solution meet the goal? A. Yes B. No Extra: Site map? DRAG DROP – You create an app. You need to create the site map for the app. 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: Answer area. Actions Add a view Add an area Add a group Add a group Add an area Add a subarea Add a subarea 2.2. Describe canvas apps Describe canvas app structure Source ExamTopics Topic 2 Question 31: A company uses Power Apps. The company plans to create a canvas app that uses a responsive design. You need to configure the app. Which two actions should you perform? Each correct answer presents part of the solution. A. Disable the Scale to fit setting. B. Configure the height and width properties by using drag handles. C. Enable the lock orientation setting. D. Configure the height and width properties by using a formula. You create a Power Apps app. The app must be able to display a list of records that are sorted by category. The app must also expand or hide the list by subtopics. You need to configure the app. Which tool should you use? A. card B. expression C. gallery D. Power BI dashboard Source ExamTopics Topic 2 Question 27: HOTSPOT – You have a Power Apps portal app that supports a sales community and a service community in the same environment. The only language configured in the environment is English. The company wants to add support for two more languages. The solution must meet the following requirements: ✑ Languages must be for both sales and service functions. ✑ The company logo and colors must be used and apply to all screens. ✑ Communities must be separate with different URLs and access lists. You need to configure the solution. What should you configure? To answer, select the appropriate options in the answer area Hot Area: Answer area. Requirement – Configuration. Languages: o Create two portals, one for each community o Create three portals, one for each language o Create one portal and import translations o Create six portals, one for each combination of language and community. 23  Company logo and colors: o Add themes o Add web resources o Add a portal header and footer Source ExamTopics Topic 5 Question 26: A company creates a canvas app. The app requires near real-time data from an accounting system that resides in a customer's data center. You need to implement a solution for the app. What should you create? A. On-premises data gateway B. Azure DevOps pipeline C. Data integration project D. Power Pages Source MSFT Practice Assessment 4: Question 17 of 50 You build a canvas app for a food testing company. Users enter their food preferences in the app. Users must be able to submit multiple values at once. You need to configure the functionality. Which component should you use? Select only one answer. check box combo box slider drop down Combo boxes are the only control that allow multiple values to be selected and submitted at the same time. The check box control allows for one of two possible values, such as yes/no, to be selected by the user. The slider control is for inputting numerical values. The drop- down control only allows a single value to be selected by a user from a list. Describe form navigation, formulas, variables and collections, and error handling + offline Source ExamTopics Topic 2 Question 7: You have a canvas app that allows users to view, select, and purchase products. The app uses a Gallery control to display products and checkboxes that allow users to select products. When users select items from the product catalog, they move to a different screen to complete a purchase. Users must be able to clear all product selections when they click the button. You need to configure the button. What should you do? A. Use the Reset(Control) formula and pass the gallery control as a parameter to the Reset formula. B. Use the Reload(Control) formula and pass the gallery control as a parameter to the Reload formula. C. Use the ForAll() function to iterate through each item of the Gallery and clear user selections. D. Set the OnCheck value to populate a collection and the OnUncheck value to remove the item from the collection. Clear collection when the user selects the button. Source ExamTopics Topic 2 Question 15: You are creating a canvas app. A user will click a button on each screen of a Power Apps app to proceed to the next screen. You need to implement the action which selects the next screen that the user sees. Which event should you handle? A. ScreenTransition B. OnSelect C. OnLoad D. OnCheck Source ExamTopics Topic 2 Question 39: You have a canvas app. The canvas app must store data in a variable that is available only to the current screen. You need to create the variable. Which two functions should you use? Each correct answer presents a complete solution. A. UpdateContext B. Navigate C. SaveData D. Set E. Collect Source ExamTopics Topic 3 Question 7: You are developing a canvas app. You need to apply business rules to the app without writing code. Which three actions can you use? Each correct answer presents a complete solution. A. Validate data and show error messages. B. Enable or disable fields. C. Set field requirement levels. 24  D. Set field values. E. Show or hide fields Source MSFT Practice Assessment 3: Question 32 of 50 You are building a canvas app for reporting accidents by on-site construction workers. Employees report experiencing intermittent internet connectivity. The employees must have access to up-to-date information for their work. You need to provide the employees with offline access to the latest data received when devices are online. What should you do? Select only one answer. Use a Microsoft Excel file as a data source. Store the data locally by using SaveData and a collection. Store the data locally by using LoadData and a collection. Get the data by using a Microsoft Power Automate cloud flow. The SaveData formula saves data from a collection locally on a device. An Excel file cannot be updated, so it cannot display up-to-date information. LoadData is used to load data from locally saved information. A cloud flow will not be able to deliver data to an offline device. Source ExamTopics Topic 2 Question 6: HOTSPOT – You are designing a canvas app that connects to Common Data Service. You need to configure the app to meet the requirements and ensure that the canvas app is available offline. What should you implement? Hot Area: Answer area. Requirement - Function Pass values from the current screen when moving to another screen: o Navigate o Back o MovePrevious Display data to a user when the app is offline: o LoadData o LoadDataOffline o ShowDataOffline Source ExamTopics Topic 2 Question 8: HOTSPOT – You have a canvas app that contains the following text input fields: Id, FirstName, LastName. The app also has a button named Button The OnSelect property for Button1 contains the following expression: Collect(People, {Id:Id.Text, FirstName:FirstName.Text, LastName:LastName.Text}) For each of the following statements, select Yes if the statement is true. Otherwise, select No. Hot Area: Answer area. Statement – Yes/No The People collection is automatically created if it does not already exist: o Yes o No When Button1 is pressed, if a record with the current value of Id.Text already exists in the People collection, the values for FirstName and LastName are updated: o Yes o No If you update the record in the Collection function to include the value from a new field name Age, it will result in an error: o Yes o No Source ExamTopics Topic 2 Question 16: HOTSPOT – A company has a canvas app that includes the following screens: Screen1 and Screen2. The OnVisible property for Screen1 contains the following expression. Set(AgeGroups, ["1-25", "26-54", "55+"]) For each of the following statements, select Yes if the statement is true. Otherwise, select No. Hot Area: AgeGroups can be accessed from Screen1 and Screen2: o Yes o No AgeGroups is a collection: o Yes o No You can use the Update function to change values in AgeGroups: o Yes o No 25 Source ExamTopics Topic 2 Question 34: HOTSPOT – You create a canvas app. The app requires access to data that is stored in collections. The app must provide the following actions: Create a new collection variable. Remove table values from a collection. You need to configure functions for the app. Which functions should you use? Create a new collection variable: o Set o Select o Collect o AddColumns Remove table values from a collection: o Clear o Reset o Revert o DropColumns Source ExamTopics Topic 2 Question 40: DRAG DROP – You plan to create a canvas app with multiple screens. The app needs to store temporary data while the app is running. The app has the following data requirements: Each screen must maintain a separate copy of data and pass the data to another screen. The app must be able to update separate rows of a table independently. You need to configure variables for the data. Which variable types should you use? Answer area. Requirement – Variable type. Screens maintain separate data and pass the data to another screen: o Collection o Global variable o Context variable Update separate rows of a table independently: o Collection o Global variable o Context variable Describe how Microsoft Power Automate flows are called from a canvas app Source ExamTopics Topic 3 Question 12: You manage Microsoft Power Platform apps for a company. You need to hide the Flows button on the user interface. Which configuration setting should you change? A. the SiteMap B. the Customizations section of System Settings C. the Entity component of the default solution D. the Buttons tab of Flow Source ExamTopics Topic 3 Question 24: You plan to create a canvas app. The app requires a button on the data entry screen that users can select to send an email. You need to configure the app. What should you create? A. Classic workflow B. Power Automate cloud flow C. Azure Logic App D. Business process flow Source ExamTopics Topic 3 Question 28: A company uses a canvas app. Supervisors must approve transactions when a user from the sales department enters a revenue amount that is over $1 million. You need to configure an approval process without using code. What should you create? A. Power Automate cloud flow B. Power Apps component framework (PCF) control C. Column Expression D. Azure Service Bus service Source ExamTopics Topic 2 Question 41: HOTSPOT – You plan to create a canvas app. The app must meet the following requirements: Send an email after a record is saved. Display the expiration column on a form if the creation date