- (Topic 4)
You are designing tables and columns for a Microsoft Power Platform solution The solution will contain an interactive experience dashboard.
You need to ensure that the columns you create can be used as global filters for the dashboard
Which two data types can you use? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point
Correct Answer:
AB
https://docs.microsoft.com/en-us/powerapps/maker/data-platform/create-edit-field-solution-explorer#column-data-types
With interactive dashboards, a chart uses the color assigned to the categories that make up the different values, even if the chart is configured to use random colors, when the chart is configured to be grouped by any of the following column types:
Choice Yes/No
Status Reason
Reference:
https://docs.microsoft.com/en-us/powerapps/maker/model-driven-apps/configure-interactive-experience-dashboards
HOTSPOT
An animal welfare organization wants to track the movement of wolf packs in a region. Cameras at specific locations capture images when motion is detected within the camera sensor range. Staff upload the images manually to a shared drive and then analyze the images.
The organization wants to automate image capture and analysis.
The organization has the following requirements: Save captured images in an appropriate location.
Analyze saved images by using an image recognition process.
Display data in real-time dashboards.
You need to recommend the correct technology for the requirements.
What should you recommend? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:
Solution:
Box 1: Automated cloud flow.
Create a cloud flow when you want your automation to be triggered either automatically, instantly, or via a schedule.
Automated flows: Create an automation that is triggered by an event such as arrival of an email from a specific person, or a mention of your company in social media.
Incorrect Answers:
Business process flows provide a guide for people to get work done. Desktop flows are used to automate tasks on the Web or the desktop.
Instant flows: Start an automation with a click of a button. Wide range of tasks such as requesting an approval, an action in Teams or SharePoint.
Box 2: Desktop flow and AI Builder
Desktop flows are used to automate tasks on the Web or the desktop. Using Power Automate Desktop you can automate tasks on the desktop as well as the Web.
Box 3: Model-driven app dashboard with Power BI
The Power BI cloud service works with Microsoft Dataverse apps to provide a self-service analytics solution. Power BI automatically refreshes the app's data displayed.
Reference: https://docs.microsoft.com/en-us/power-automate/flow-types https://docs.microsoft.com/en-us/powerapps/maker/model-driven-apps/use-power-bi
Does this meet the goal?
Correct Answer:
A
A company has a Power Platform solution that integrates with a third-party system. The client reports that unexpected updates are being made to the Accounts table. You need to determine the root cause of the issue.
In which three locations should you investigate? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.
Correct Answer:
ABD
A: How to View Auditing Log Details?
System administrators can see activities for the entities that are enabled for audit logging. To view the audit logs:
* 1. Go to Settings > System >Auditing.
* 2. Choose Audit Summary View.
* 3. Under Audit Summary View, you will see the list of audit entries
B: You can view details about solution operations from the Solutions area of Power Apps. An operation can be a solution import, export, or uninstall. The solution history displays information such as solution version, solution publisher, type of operation, operation start and end time, and operation status.
D: Trace log records are written to the PluginTraceLog Table. Writing of these records is controlled by the trace settings mentioned in Enable trace logging. This data can be found in model-driven applications by navigating to Settings and choosing the Plug-in Trace Log tile.
Reference: https://www.sherweb.com/blog/dynamics-365/audits-dynamics-365/ https://docs.microsoft.com/en-us/powerapps/developer/data-platform/logging-tracing
HOTSPOT
You design a Power Platform solution for a customer. The solution uses Microsoft Dataverse as the data store. You are managing the go-live process for the solution. The customer reports the following performance issues:
Form load time is much slower than it was during testing.
Overall system performance has been significantly slower that it was during testing. You need to recommend how to troubleshoot system performance.
Which actions should you recommend? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area: Correct
[MISSING]
Solution:
Box 1: Review the fields that are on the form
Keep the number of table columns (fields) to a minimum.
The more table columns (formerly referred to as fields) you have in a form, the more data that needs to be downloaded to view each record.
Box 2: Review one to many relationships to verify whether cascade settings are necessary.
Reference: https://docs.microsoft.com/en-us/powerapps/maker/model-driven-apps/optimize-form- performance
Does this meet the goal?
Correct Answer:
A
You are designing the data model for a school. The school wants to track students’ enrollments in courses. The system must meet the following requirements:
Track the courses in which each student is enrolled. Track the students that are enrolled in each course.
Track dates when each student enrolled in each course and the person who approved the enrollment. Allow users to create a report that details which students are enrolled in which courses.
You need to recommend a data model that will fit the school’s requirements. Which logical model should you recommend?
Correct Answer:
A
Need a relationship table.
N:N (Many-to-Many): A table relationship that depends on a special Relationship table, sometimes called an Intersect table, so that many rows of one table can be related to many rows of another table. When viewing rows of either table in a N:N relationship you can see a list of any rows of the other table that are related to it.
Reference: https://docs.microsoft.com/en-us/powerapps/maker/data-platform/create-edit-entity-relationships
