Microsoft Certified: Power Platform App Maker Associate Microsoft Certified: Microsoft Power Platform Developer 4 — Questions and Answers
Question 1: Which formula in Power Apps would correctly filter a Dataverse table called 'Orders' to show only records where the Status field equals 'Active'?
- Filter(Orders, Status = 'Active')
- Filter(Orders, Status = "Active") (Correct answer)
- Search(Orders, "Active", "Status")
- LookUp(Orders, Status = "Active")
Correct answer: Filter(Orders, Status = "Active")
In Power Apps formulas, string literals use double quotes, so Filter(Orders, Status = "Active") is the correct syntax.
Question 2: In Power Automate, what does the 'Apply to each' action do?
- Applies a condition to filter items
- Iterates over each item in an array and executes actions for each (Correct answer)
- Merges multiple arrays into one
- Splits a string into an array
Correct answer: Iterates over each item in an array and executes actions for each
'Apply to each' loops through every item in an array output from a previous step and runs its child actions for each item.
Question 3: Which Power BI feature allows report consumers to ask questions about data using natural language?
- Drill-through
- Q&A visual (Correct answer)
- Key influencers visual
- Smart narrative
Correct answer: Q&A visual
The Q&A visual in Power BI lets users type natural language questions and get instant visualizations based on the underlying data model.
Question 4: A developer wants to create a reusable component in a canvas app that encapsulates a set of controls with custom input and output properties. What should they use?
- A screen template
- A component library component (Correct answer)
- A named formula
- A child flow
Correct answer: A component library component
Component library components in Power Apps allow developers to build reusable UI elements with custom properties that can be shared across apps.
Question 5: In Dataverse, what is a 'many-to-many' relationship used for?
- Linking exactly two records from the same table
- Allowing multiple records in one table to relate to multiple records in another table (Correct answer)
- Creating a hierarchy within a single table
- Enforcing one owner per record
Correct answer: Allowing multiple records in one table to relate to multiple records in another table
A many-to-many relationship in Dataverse uses an intersect table to allow any number of records in both related tables to be linked to each other.
Question 6: Which action in Power Automate is used to pause a flow until a specified date and time?
- Wait action
- Delay until action (Correct answer)
- Schedule trigger
- Recurrence action
Correct answer: Delay until action
The 'Delay until' action pauses flow execution until a specific timestamp is reached before continuing to the next step.
Question 7: When publishing a canvas app in Power Apps, what does 'Share' allow the owner to do?
- Deploy the app to Azure
- Grant other users or groups access to use the app (Correct answer)
- Publish the app to AppSource marketplace
- Export the app as a .msapp file
Correct answer: Grant other users or groups access to use the app
Sharing a canvas app grants specified users or Azure AD groups permission to run the app within the Power Apps environment.
Microsoft Certified: Power Platform App Maker Associate Microsoft Certified: Microsoft Power Platform Developer 4
Which formula in Power Apps would correctly filter a Dataverse table called 'Orders' to show only records where the Status field equals 'Active'?