Question 6
A company has an on-premises data warehouse and analytics solution- The data warehouse consists of multiple multi-dimensional data cubes representing over five years of operational data. The data warehouse consolidates and normalizes data that is sourced from 20 different systems.
The company plans to replace the existing solution with a Microsoft Power Platform solution that connects to the data warehouse. The company wants to provide analytical information to executives in a Microsoft Teams channel to support business planning.
The new solution must meet these requirements:
Support the current data warehouse.
The solution must support drill-through capabilities into the data.
You need to recommend a solution.
What should you recommend? To answer, select the appropriate options m the answer area. NOTE: Each correct selection is worth one point.
The company plans to replace the existing solution with a Microsoft Power Platform solution that connects to the data warehouse. The company wants to provide analytical information to executives in a Microsoft Teams channel to support business planning.
The new solution must meet these requirements:
Support the current data warehouse.
The solution must support drill-through capabilities into the data.
You need to recommend a solution.
What should you recommend? To answer, select the appropriate options m the answer area. NOTE: Each correct selection is worth one point.
Question 7
You need to recommend methods to resolve the organization's issues.
What should you recommend? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
What should you recommend? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Question 8
An automobile parts manufacturer wants to replace an existing system with a Microsoft Power Platform solution. The company has been experiencing undesired data changes in their current system. The cause of the changes is due to the relationships that are set up between tables in the database that the system uses.
The new solution must meet the following requirements:
* Track vehicle manufacturers and models.
* Display a list of all models that a manufacturer produces.
* Ensure that each vehicle model can be associated to only one manufacturer.
* Delete all associated models when a user deletes a manufacturer.
* Automatically populate information from the manufacturer when creating a new model from the model list on the manufacturer page.
You need to recommend table relationships to meet the business requirements.
Which relationship settings should you recommend? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
The new solution must meet the following requirements:
* Track vehicle manufacturers and models.
* Display a list of all models that a manufacturer produces.
* Ensure that each vehicle model can be associated to only one manufacturer.
* Delete all associated models when a user deletes a manufacturer.
* Automatically populate information from the manufacturer when creating a new model from the model list on the manufacturer page.
You need to recommend table relationships to meet the business requirements.
Which relationship settings should you recommend? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Question 9
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
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
Question 10
You are a Microsoft Power Platform architect reviewing requirements for an online shopping app.
You need to identify requirement types for the app.
How should you categorize the requirements? To answer, drag the appropriate categories to the correct requirements. Each category 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.
You need to identify requirement types for the app.
How should you categorize the requirements? To answer, drag the appropriate categories to the correct requirements. Each category 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.
