- (Exam Topic 3)
A company manages a chain of retail stores. The company stores a list of retail store names and numbers in one Power BI table. The company stores sales transaction data including a transaction ID in another table.
The transaction ID includes the store number.
You need to show the store name for all retail transactions in all Power BI reports. Which tool should you use?
Correct Answer:A
Power BI Desktop comes with Query Editor, where you can connect to one or many data sources, shape and transform the data to meet your needs, then load that model into Power BI Desktop.
Reference:
https://docs.microsoft.com/en-us/power-bi/desktop-query-overview
- (Exam Topic 4)
A company plans to build new apps for the business to allow employees to work more efficiently. You need to recommend the appropriate types of Power Apps to meet the company’s requirements.
To answer, drag the appropriate app types to the correct requirements. Each app type 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:
Reference:
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/getting-started https://docs.microsoft.com/en-us/powerapps/maker/portals/overview
Does this meet the goal?
Correct Answer:A
- (Exam Topic 4)
A user is trying to understand the differences between the various ways apps can be built by using Power Apps.
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
You can create a canvas app and then embed that within a model driven app. Box 2: No
With the capability to build a portal in PowerApps, you can create a website for external and internal users enabling them to interact with data stored in Common Data Service.
Note: Common Data Service lets you securely store and manage data that's used by business applications. Data within Common Data Service is stored within a set of entities. An entity is a set of records used to store data, similar to how a table stores data within a database. Common Data Service includes a base set of standard entities that cover typical scenarios, but you can also create custom entities specific to your organization and populate them with data using Power Query. App makers can then use PowerApps to build rich applications using this data.
Box 3: Yes
To get started building a report you'll need the latest version of Power BI Desktop and a PowerApps environment with the latest version of the Common Data Service.
Reference:
https://carldesouza.com/how-to-embed-a-canvas-app-in-a-model-driven-app-in-powerapps/ https://docs.microsoft.com/en-us/powerapps/maker/portals/create-portal https://docs.microsoft.com/en-us/powerapps/maker/common-data-service/data-platform-intro
Does this meet the goal?
Correct Answer:A
- (Exam Topic 5)
For which scenarios can you use Power Automate?
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:
Reference:
https://flow.microsoft.com/en-us/galleries/public/templates/b923bbd04bda11e78896d10a96d3fac3/notify-the-tea https://flow.microsoft.com/en-us/galleries/public/templates/65ceb79430ef4956a0855fbe09249cdf/save-office-36 https://flow.microsoft.com/en-us/blog/get-notified-of-negative-posts/
Does this meet the goal?
Correct Answer:A
- (Exam Topic 6)
You need to create a mobile application which will allow sales associates to enter customer sales leads. Which four 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.
Solution:
Reference:
https://docs.microsoft.com/en-us/powerapps/maker/model-driven-apps/build-first-model-driven-app
Does this meet the goal?
Correct Answer:A
- (Exam Topic 4)
A company is building a Power Apps portal.
You need to select out-of-the-box portal types to meet the company's requirements.
Which portal types should you use? To answer, drag the appropriate portal types to the correct requirements. Each portal type 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: Partner portal
A partner portal allows every organization with resellers, distributors, suppliers, or partners to have real-time access to every stage of shared activities.
Box 2: Community portal
A community portal leverages peer-to-peer interactions between customers and experts to organically grow the catalog of available knowledge from knowledge base articles, forums, and blogs as well as providing feedback through comments and ratings.
Reference:
https://docs.microsoft.com/en-us/powerapps/maker/portals/portal-templates
Does this meet the goal?
Correct Answer:A