- (Exam Topic 2)
A company plans to use Power BI to visualize data from business systems.
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
The following list provides advantages to using aggregations:
Query performance over big data - as users interact with visuals on Power BI reports, DAX queries are submitted to the dataset. Boost query speeds by caching data at the aggregated level, using a fraction of the resources required at the detail level. Unlock big data in a way that would otherwise be impossible.
Box 2: No
You can connect to model-driven apps in Dynamics 365 with Power BI Desktop to create custom reports and dashboards for use with the Power BI service.
You can use similar steps to connect to model-driven apps in Dynamics 365 using Office Excel Power Query by selecting From Other Sources on the Power Query tab in Excel.
Box 3: Yes
Using the PowerApps custom visual, you will be able to pass context aware data to a PowerApps app which updates in real time as you make changes to your report.
Reference:
https://docs.microsoft.com/en-us/power-bi/desktop-aggregations https://docs.microsoft.com/en-us/power-platform/admin/use-power-bi https://powerapps.microsoft.com/sv-se/blog/powerbi-powerapps-visual/

Does this meet the goal?

Correct Answer:A

- (Exam Topic 3)
Your company has an on premises Microsoft SQL Server database that contains legacy sales data. You must display information from the database in a new Power Apps app.
You need to establish a secure connection between the database and the app. What should you use?

Correct Answer:C
For an on-premises database, identify a data gateway that was shared with you (or create one).
Specify Connect using on-premises data gateway, type or paste the server name, the database name, the user name, and the password for the database that you want to use, and specify the authentication type and the gateway.
Reference:
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/connections/connection-azure-sqldatabase

- (Exam Topic 1)
You are building Power Apps apps that use both Dynamics 365 Sales and Microsoft 365.
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
When you offer your application for use by other companies through a purchase or subscription, you make your application available to customers within their own Azure tenants. This is known as creating a
multi-tenant application.
Box 2: No Reference:
https://docs.microsoft.com/en-us/azure/active-directory/manage-apps/isv-sso-content

Does this meet the goal?

Correct Answer:A

- (Exam Topic 3)
You create a Power BI dashboard.
Match each option to its function. To answer, drag the appropriate option from the column on the left to its function on the right. Each option may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.

Solution:
Reference:
https://docs.microsoft.com/en-us/power-bi/service-set-data-alerts https://docs.microsoft.com/en-us/power-bi/service-analyze-in-excel https://docs.microsoft.com/en-us/power-bi/service-dashboard-pin-tile-from-report

Does this meet the goal?

Correct Answer:A

- (Exam Topic 1)
A company uses Power Apps.
You need to perform administrative tasks for the company.
Which admin centers should you use? To answer, drag the appropriate admin centers to the correct requirements. Each admin center may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.

Solution:
Box 1: Azure Active Directory
Create the company users in the Azure Active Directory. Box 2: Power Apps admin center
In the Power Apps Admin center, manage environments that you've created and those for which you have been added to the Environment Admin or System Administrator role. From the admin center, you can perform these administrative actions:
Create environments. Rename environments.
Add or remove a user or group from either the Environment Admin or Environment Maker role. Etc.
Reference:
https://docs.microsoft.com/en-us/power-platform/admin/environments-administration https://docs.microsoft.com/en-us/dynamics365/marketing/dynamics-365-admin-center https://powerapps.microsoft.com/sv-se/blog/introducing-admin-center-for-powerapps/

Does this meet the goal?

Correct Answer:A

- (Exam Topic 1)
You need to implement Microsoft Business Applications along with the Microsoft Power platform. Which three Microsoft products are part of the Power platform? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.

Correct Answer:ACE
The Power Platform uses PowerApps, Power BI, and Power Automate (previously named Flow) to customize, extend, and build all the apps you need for your business and unlock the potential of Office 365 and Dynamics 365.
Reference:
https://docs.microsoft.com/en-us/learn/powerplatform/