You must create a new table to support a new feature for an app. Records for the table must be associated with a business unit and specify security roles for the business unit.
You need to configure table ownership.
Which table ownership type should you use?
A. user or team owned
B. business-owned
C. none
D. organization-owned
Show Answer
Correct Answer: A
Explanation: Use a user or team-owned table. User/team-owned tables support record ownership, business unit association through the owning user or team, and Dataverse role-based security at the business unit level. Business-owned tables are owned by a business unit but are not the standard choice for record-level ownership and security role scenarios. Organization-owned tables grant organization-wide access, and none (elastic/virtual ownership contexts) does not meet the requirement.
Question 62
HOTSPOT
-
This is a case study. Case studies are not timed separately. You can use as much exam time as you would like to complete each case. However, there may be additional case studies and sections on this exam. You must manage your time to ensure that you are able to complete all questions included on this exam in the time provided.
To answer the questions included in a case study, you will need to reference information that is provided in the case study. Case studies might contain exhibits and other resources that provide more information about the scenario that is described in the case study. Each question is independent of the other questions in this case study.
At the end of this case study, a review screen will appear. This screen allows you to review your answers and to make changes before you move to the next section of the exam. After you begin a new section, you cannot return to this section.
To start the case study
-
To display the first question in this case study, click the Next button. Use the buttons in the left pane to explore the content of the case study before you answer the questions. Clicking these buttons displays information such as business requirements, existing environment, and problem statements. If the case study has an All Information tab, note that the information displayed is identical to the information displayed on the subsequent tabs. When you are ready to answer a question, click the Question button to return to the question.
Background
-
Bellows College is a post-secondary school that wants to start a football team. The college uses Microsoft Power Platform to manage its recruiting efforts. The registration team and assistants use model-driven apps. The coaches use canvas apps on their mobile devices.
Prospects are considered underage if they are younger than 18 years old at the time of registration.
Current environment
-
Environment
-
• Custom code is not allowed in the system.
• Server-side synchronization is configured for emails, appointments, contacts, and tasks.
• The database and file storage of Dataverse must be minimized to keep costs low.
Contact table
-
• Birthdate is a custom date and time field.
• Age at Registration is a calculated field that displays the age of the prospect at the time of registration.
• Current Age is a calculated field that displays the age of the prospect based on the current date and time.
Evaluation table
-
• The Evaluation table is a custom table used to track evaluation criteria.
• Evaluation records cannot be manually created.
• Users must not be able to continue until an evaluation record is created automatically for the prospect.
Consent table
-
• The consent forms completed by the parents are stored as records in the Consent table.
• Occasionally, a parent cannot complete the consent online and a paper copy must be printed. The signed copy must be scanned and stored with the consent record.
Team website
-
• The team website is created by using Power Pages.
• A starter layout template was used to create the site.
• The site consists of five pages:
o Home: A page open to everyone to view the announcements from the team.
o Schedule: A page open to everyone to view the tryout and game schedule.
o Evaluations: A page that displays tracking from the evaluation table. Prospects are able to view their own information only.
o Forms: A page that displays the consent form.
o Contact Us: A page for anyone to submit questions and comments.
• Two web roles for authenticated users are created: Primary Contact User and Prospect User.
o All primary contacts and prospects are assigned to their respective roles.
Requirements
-
Registration
-
• Parents and prospects are created as contacts and must be linked.
• The registration team must be able to rapidly create prospects without navigating away from the Parents form. Only the First Name, Last Name, and Birthdate fields should be displayed for the team.
• Assistants must be able to update prospect information and add teams that the prospect has previously played on to a subgrid.
Parental consent
-
• When a prospect is underage, a Primary Contact field will appear. The field must be populated before the prospect record can be saved.
• A view named Underage Prospects that lists all underaged prospects is required.
• The Underage Prospects view must run once a week without requiring modifications to display correct information.
• A consent email must meet the following requirements:
o be sent to the primary contact of each new underage prospect
o contain a link to the team website
o be automatically sent weekly and tracked to the contact record in Dataverse
o include the current date using the full month name, date, and year
Evaluations
-
• Coaches rate prospects each day on a scale of 1-10 in three categories: endurance, coordination, and skill.
• The total of the three categories is displayed at the bottom of the form. If the total for the day is greater than 25, the number should appear green.
You need to create a filter for the Underage Prospects view.
How should you set up the expression for the filter? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Show Answer
Correct Answer: Age at Registration
Is less than
18
Explanation: The case study explicitly defines underage status as being younger than 18 at the time of registration. The calculated 'Age at Registration' field matches that business rule and remains stable over time, so the weekly view continues to evaluate correctly without manual changes.
Question 63
HOTSPOT
-
This is a case study. Case studies are not timed separately. You can use as much exam time as you would like to complete each case. However, there may be additional case studies and sections on this exam. You must manage your time to ensure that you are able to complete all questions included on this exam in the time provided.
To answer the questions included in a case study, you will need to reference information that is provided in the case study. Case studies might contain exhibits and other resources that provide more information about the scenario that is described in the case study. Each question is independent of the other questions in this case study.
At the end of this case study, a review screen will appear. This screen allows you to review your answers and to make changes before you move to the next section of the exam. After you begin a new section, you cannot return to this section.
To start the case study
-
To display the first question in this case study, click the Next button. Use the buttons in the left pane to explore the content of the case study before you answer the questions. Clicking these buttons displays information such as business requirements, existing environment, and problem statements. If the case study has an All Information tab, note that the information displayed is identical to the information displayed on the subsequent tabs. When you are ready to answer a question, click the Question button to return to the question.
Background
-
Bellows College is a post-secondary school that wants to start a football team. The college uses Microsoft Power Platform to manage its recruiting efforts. The registration team and assistants use model-driven apps. The coaches use canvas apps on their mobile devices.
Prospects are considered underage if they are younger than 18 years old at the time of registration.
Current environment
-
Environment
-
• Custom code is not allowed in the system.
• Server-side synchronization is configured for emails, appointments, contacts, and tasks.
• The database and file storage of Dataverse must be minimized to keep costs low.
Contact table
-
• Birthdate is a custom date and time field.
• Age at Registration is a calculated field that displays the age of the prospect at the time of registration.
• Current Age is a calculated field that displays the age of the prospect based on the current date and time.
Evaluation table
-
• The Evaluation table is a custom table used to track evaluation criteria.
• Evaluation records cannot be manually created.
• Users must not be able to continue until an evaluation record is created automatically for the prospect.
Consent table
-
• The consent forms completed by the parents are stored as records in the Consent table.
• Occasionally, a parent cannot complete the consent online and a paper copy must be printed. The signed copy must be scanned and stored with the consent record.
Team website
-
• The team website is created by using Power Pages.
• A starter layout template was used to create the site.
• The site consists of five pages:
o Home: A page open to everyone to view the announcements from the team.
o Schedule: A page open to everyone to view the tryout and game schedule.
o Evaluations: A page that displays tracking from the evaluation table. Prospects are able to view their own information only.
o Forms: A page that displays the consent form.
o Contact Us: A page for anyone to submit questions and comments.
• Two web roles for authenticated users are created: Primary Contact User and Prospect User.
o All primary contacts and prospects are assigned to their respective roles.
Requirements
-
Registration
-
• Parents and prospects are created as contacts and must be linked.
• The registration team must be able to rapidly create prospects without navigating away from the Parents form. Only the First Name, Last Name, and Birthdate fields should be displayed for the team.
• Assistants must be able to update prospect information and add teams that the prospect has previously played on to a subgrid.
Parental consent
-
• When a prospect is underage, a Primary Contact field will appear. The field must be populated before the prospect record can be saved.
• A view named Underage Prospects that lists all underaged prospects is required.
• The Underage Prospects view must run once a week without requiring modifications to display correct information.
• A consent email must meet the following requirements:
o be sent to the primary contact of each new underage prospect
o contain a link to the team website
o be automatically sent weekly and tracked to the contact record in Dataverse
o include the current date using the full month name, date, and year
Evaluations
-
• Coaches rate prospects each day on a scale of 1-10 in three categories: endurance, coordination, and skill.
• The total of the three categories is displayed at the bottom of the form. If the total for the day is greater than 25, the number should appear green.
You need to configure the Primary Contact field.
What should you configure? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Show Answer
Correct Answer: Primary Contact data type: Lookup
Visibility: Business rule where the Set Visibility action is Yes
Requirement: Business rule where the Business Required action is Business Required
Explanation: Primary Contact must reference a parent contact, so it should be a Lookup. Because it is only needed for underage prospects, use a business rule to show the field conditionally and make it Business Required only under that condition.
Question 64
DRAG DROP
-
A company has a business process flow that executes on the Contact table.
The company requires that the steps in the flow be executed in real time when users create a new task and update the status of a Contact row.
You need to implement a solution that automates the steps.
Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
NOTE: More than one order of answer choices is correct. You will receive credit for any of the correct orders you select.
Show Answer
Correct Answer: Modify the business process flow
Add a flow step
Create a new custom action with action steps
Explanation: An existing business process flow is extended by adding a Flow Step, which invokes a custom action. The custom action contains the logic that executes in real time when the flow step is reached.
Question 65
This is a case study. Case studies are not timed separately. You can use as much exam time as you would like to complete each case. However, there may be additional case studies and sections on this exam. You must manage your time to ensure that you are able to complete all questions included on this exam in the time provided.
To answer the questions included in a case study, you will need to reference information that is provided in the case study. Case studies might contain exhibits and other resources that provide more information about the scenario that is described in the case study. Each question is independent of the other questions in this case study.
At the end of this case study, a review screen will appear. This screen allows you to review your answers and to make changes before you move to the next section of the exam. After you begin a new section, you cannot return to this section.
To start the case study -
To display the first question in this case study, click the Next button. Use the buttons in the left pane to explore the content of the case study before you answer the questions. Clicking these buttons displays information such as business requirements, existing environment, and problem statements. If the case study has an All Information tab, note that the information displayed is identical to the information displayed on the subsequent tabs. When you are ready to answer a question, click the Question button to return to the question.
Background -
Bellows College is a post-secondary school that wants to start a football team. The college uses Microsoft Power Platform to manage its recruiting efforts. The registration team and assistants use model-driven apps. The coaches use canvas apps on their mobile devices.
Prospects are considered underage if they are younger than 18 years old at the time of registration.
Current environment -
Environment -
• Custom code is not allowed in the system.
• Server-side synchronization is configured for emails, appointments, contacts, and tasks.
• The database and file storage of Dataverse must be minimized to keep costs low.
Contact table -
• Birthdate is a custom date and time field.
• Age at Registration is a calculated field that displays the age of the prospect at the time of registration.
• Current Age is a calculated field that displays the age of the prospect based on the current date and time.
Evaluation table -
• The Evaluation table is a custom table used to track evaluation criteria.
• Evaluation records cannot be manually created.
• Users must not be able to continue until an evaluation record is created automatically for the prospect.
Consent table -
• The consent forms completed by the parents are stored as records in the Consent table.
• Occasionally, a parent cannot complete the consent online and a paper copy must be printed. The signed copy must be scanned and stored with the consent record.
Team website -
• The team website is created by using Power Pages.
• A starter layout template was used to create the site.
• The site consists of five pages:
o Home: A page open to everyone to view the announcements from the team. o Schedule: A page open to everyone to view the tryout and game schedule. o Evaluations: A page that displays tracking from the evaluation table. Prospects are able to view their own information only. o Forms: A page that displays the consent form. o Contact Us: A page for anyone to submit questions and comments.
• Two web roles for authenticated users are created: Primary Contact User and Prospect User. o All primary contacts and prospects are assigned to their respective roles.
Requirements -
Registration -
• Parents and prospects are created as contacts and must be linked.
• The registration team must be able to rapidly create prospects without navigating away from the Parents form. Only the First Name, Last Name, and Birthdate fields should be displayed for the team.
• Assistants must be able to update prospect information and add teams that the prospect has previously played on to a subgrid.
Parental consent -
• When a prospect is underage, a Primary Contact field will appear. The field must be populated before the prospect record can be saved.
• A view named Underage Prospects that lists all underaged prospects is required.
• The Underage Prospects view must run once a week without requiring modifications to display correct information.
• A consent email must meet the following requirements:
o be sent to the primary contact of each new underage prospect o contain a link to the team website o be automatically sent weekly and tracked to the contact record in Dataverse o include the current date using the full month name, date, and year
Evaluations -
• Coaches rate prospects each day on a scale of 1-10 in three categories: endurance, coordination, and skill.
• The total of the three categories is displayed at the bottom of the form. If the total for the day is greater than 25, the number should appear green.
You need to create the evaluation record for a prospect.
What should you use?
A. a classic Dataverse workflow
B. a cloud flow
C. a plug-in
D. a quick create form
Show Answer
Correct Answer: B
Explanation: A cloud flow can automatically create an Evaluation record when a Prospect is created, satisfying the requirement that evaluation records cannot be created manually. Plug-ins are excluded because custom code is not allowed. A quick create form still requires manual user action. Although classic Dataverse workflows can create records, cloud flows are the modern supported automation approach for Dataverse and fit the automatic record-creation requirement.
Question 66
This is a case study. Case studies are not timed separately. You can use as much exam time as you would like to complete each case. However, there may be additional case studies and sections on this exam. You must manage your time to ensure that you are able to complete all questions included on this exam in the time provided.
To answer the questions included in a case study, you will need to reference information that is provided in the case study. Case studies might contain exhibits and other resources that provide more information about the scenario that is described in the case study. Each question is independent of the other questions in this case study.
At the end of this case study, a review screen will appear. This screen allows you to review your answers and to make changes before you move to the next section of the exam. After you begin a new section, you cannot return to this section.
To start the case study -
To display the first question in this case study, click the Next button. Use the buttons in the left pane to explore the content of the case study before you answer the questions. Clicking these buttons displays information such as business requirements, existing environment, and problem statements. If the case study has an All Information tab, note that the information displayed is identical to the information displayed on the subsequent tabs. When you are ready to answer a question, click the Question button to return to the question.
Background -
Bellows College is a post-secondary school that wants to start a football team. The college uses Microsoft Power Platform to manage its recruiting efforts. The registration team and assistants use model-driven apps. The coaches use canvas apps on their mobile devices.
Prospects are considered underage if they are younger than 18 years old at the time of registration.
Current environment -
Environment -
• Custom code is not allowed in the system.
• Server-side synchronization is configured for emails, appointments, contacts, and tasks.
• The database and file storage of Dataverse must be minimized to keep costs low.
Contact table -
• Birthdate is a custom date and time field.
• Age at Registration is a calculated field that displays the age of the prospect at the time of registration.
• Current Age is a calculated field that displays the age of the prospect based on the current date and time.
Evaluation table -
• The Evaluation table is a custom table used to track evaluation criteria.
• Evaluation records cannot be manually created.
• Users must not be able to continue until an evaluation record is created automatically for the prospect.
Consent table -
• The consent forms completed by the parents are stored as records in the Consent table.
• Occasionally, a parent cannot complete the consent online and a paper copy must be printed. The signed copy must be scanned and stored with the consent record.
Team website -
• The team website is created by using Power Pages.
• A starter layout template was used to create the site.
• The site consists of five pages:
o Home: A page open to everyone to view the announcements from the team. o Schedule: A page open to everyone to view the tryout and game schedule. o Evaluations: A page that displays tracking from the evaluation table. Prospects are able to view their own information only. o Forms: A page that displays the consent form. o Contact Us: A page for anyone to submit questions and comments.
• Two web roles for authenticated users are created: Primary Contact User and Prospect User. o All primary contacts and prospects are assigned to their respective roles.
Requirements -
Registration -
• Parents and prospects are created as contacts and must be linked.
• The registration team must be able to rapidly create prospects without navigating away from the Parents form. Only the First Name, Last Name, and Birthdate fields should be displayed for the team.
• Assistants must be able to update prospect information and add teams that the prospect has previously played on to a subgrid.
Parental consent -
• When a prospect is underage, a Primary Contact field will appear. The field must be populated before the prospect record can be saved.
• A view named Underage Prospects that lists all underaged prospects is required.
• The Underage Prospects view must run once a week without requiring modifications to display correct information.
• A consent email must meet the following requirements:
o be sent to the primary contact of each new underage prospect o contain a link to the team website o be automatically sent weekly and tracked to the contact record in Dataverse o include the current date using the full month name, date, and year
Evaluations -
• Coaches rate prospects each day on a scale of 1-10 in three categories: endurance, coordination, and skill.
• The total of the three categories is displayed at the bottom of the form. If the total for the day is greater than 25, the number should appear green.
You need to view website questions and comments.
Where should you view this information?
A. Evaluations
B. Lead
C. Contact
D. Feedback
Show Answer
Correct Answer: D
Explanation: The Power Pages starter layout template includes a Contact Us page that submits records to the Feedback table. Website questions and comments are therefore viewed in the Feedback table rather than business tables such as Contact, Lead, or the custom Evaluation table.
Question 67
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
A company 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
Show Answer
Correct Answer: B
Explanation: Power Fx formula columns in Dataverse calculate or derive values; they do not enforce table-level uniqueness or prevent creation of duplicate records. To prevent duplicates, use Dataverse duplicate detection rules, alternate keys (where appropriate), or other server-side validation mechanisms rather than a Power Fx formula.
Question 68
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
Show Answer
Correct Answer: C
Explanation: A Gallery control is designed to display lists of records from a data source and supports grouping, nested galleries, and expandable/collapsible layouts for categories and subtopics. Cards are for forms, expressions are formulas rather than UI controls, and a Power BI dashboard is not the appropriate Power Apps control for this requirement.
Question 69
A company deploys a chatbot that is embedded in a Power Pages website.
The company has the following requirements for the chatbot:
• Microsoft Entra ID users only must be able to use the chatbot when accessing sensitive data.
• The chatbot must be accessible only from the Power Pages website.
You need to recommend a solution that meets the requirements.
Which two options should you recommend? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
A. Enable Only for Teams authentication.
B. Configure a data loss prevention policy.
C. Set up a new channel for the chatbot.
D. Enable Manual authentication.
E. Enable web channel security.
Show Answer
Correct Answer: D, E
Explanation: Manual authentication can be configured to require Microsoft Entra ID authentication for users accessing sensitive functionality. Web channel security restricts access to the bot from trusted web locations (such as the intended Power Pages site) using Direct Line security, preventing use from arbitrary sites. Creating a new channel is not inherently required if the existing web channel is secured.
Sources:
https://www.microsoft.com/en-us/power-platform/blog/2023/10/17/introducing-the-next-generation-ai-chatbot-for-power-pages-websites-preview
Question 70
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
A company 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
Show Answer
Correct Answer: B
Explanation: Duplicate detection rules identify potential duplicates but do not reliably prevent duplicate record creation across all Dataverse entry points, including canvas apps. The requirement is that the table not contain duplicate rows when users create data. Enforcing uniqueness should be done with an alternate key (or other uniqueness constraint), not a duplicate detection rule alone.
$19
Get all 301 questions with detailed answers and explanations
Instant download HTML + PDF delivered the moment payment clears.
Secure Stripe checkout we never see or store your card details.
7-day refund if files are defective see our refund policy.