PDF Preguntas según tema PL-200-2-15

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

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