- (Exam Topic 3)
You need to display sales orders greater than a specific threshold in a Power Bl report. What should you use?

Correct Answer:D

- (Exam Topic 1)
You create a user-owned custom entity by using Common Data Service.
For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point.

Solution:
Box 1: No
Common Data Service supports two types of record ownership. Organization owned, and User or Team owned. This is a choice that happens at the time the entity is created and can’t be changed.
Box 2: Yes
By combining conditions and actions, you can do any of the following with business rules: Set field values
Clear field values
Set field requirement levels Show or hide fields
Enable or disable fields
Validate data and show error messages
Create business recommendations based on business intelligence. Reference:
https://docs.microsoft.com/en-us/power-platform/admin/wp-security-cds

Does this meet the goal?

Correct Answer:A

- (Exam Topic 3)
You create a Power Bl dashboard that displays Common Data Model data. You need to share the Power Bl dashboard with coworkers and allow the coworkers to collaborate. What are two possible ways to achieve the goal? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

Correct Answer:AB
Reference:
https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-create-the-new-workspaces

- (Exam Topic 4)
You create a canvas app that allows contractors to submit time they work against a project.
Contractors must be able to use the canvas app to enter time. Contractors must not be able to perform any other actions in the app.
You need to configure permissions for the contractors. Which type of permissions should you use?

Correct Answer:D
Field-level security feature to allow more granular control of security at the field level. Reference:
https://docs.microsoft.com/en-us/power-platform/admin/security-roles-privileges https://docs.microsoft.com/en-us/power-platform/admin/wp-security-cds

- (Exam Topic 3)
You have a Power BI report.
For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point.

Solution:
Box 1: Yes
If you'd like to see the data that Power BI uses to create a visualization, you can display that data in Power BI. You can also export that data to Excel as an .xlsx or .csv file. The option to export the data requires a Pro or Premium license and edit permissions to the dataset and report.
Note: Export data from a Power BI dashboard
Choose the Export data icon.
Power BI exports the data to a .csv file. If you've filtered the visualization, then the app will filter the downloaded data.
Your browser will prompt you to save the file. Once saved, open the .csv file in Excel. Box 2: No
Underlying data: Select this option if you want to see the data in the visual and additional data from the model (see chart below for details). If your visualization has an aggregate, selecting Underlying data removes the aggregate. When you select Export, Power BI exports the data to an .xlsx file and your browser prompts you to save the file. Once saved, open the file in Excel.
Box 3: Yes
A KPI dataset needs to contain goal values for a KPI. If your dataset doesn't contain goal values, you can create them by adding an Excel sheet with goals to your data model or PBIX file.
Note: A Key Performance Indicator (KPI) is a visual cue that communicates the amount of progress made toward a measurable goal.
Reference:
https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-export-data
https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-kpi

Does this meet the goal?

Correct Answer:A

- (Exam Topic 1)
A rapidly growing company wants to empower users to build apps, automate business processes, and analyze data without requiring I expertise or development skills and without increasing IT expenses and dependencies.
You need to recommend tools so that users can accomplish specific tasks.
Which tools should you recommend? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

Solution:
Box 1: Microsoft Flow
Microsoft Flow, now called Power Automate, is cloud-based software that allows employees to create and
automate workflows and tasks across multiple applications and services without help from developers.
Box 2: Power Apps
PowerApps is a suite of apps, services, connectors and data platform that provides a rapid application development environment to build custom apps for your business needs.
Box 3: Power BI
Power BI is a business analytics solution that lets youvisualizeyour data and share insights across your organization, or embed them in your app or website. Connect to hundreds of data sources and bring your data to life with live dashboards and reports.
Reference:
https://docs.microsoft.com/en-us/powerapps/powerapps-overview

Does this meet the goal?

Correct Answer:A