Mixed Deck — All Microsoft Certified: Power Platform App Maker Associate Topics Flashcards

What is the key difference between a Managed and Unmanaged Solution in Power Platform?

Answer: Managed solutions lock components in the target environment; unmanaged solutions allow full customization

Importing a Managed Solution restricts editing its components in the target environment, while Unmanaged Solutions allow modification.

What is the recommended approach for deploying a Power Platform solution from a development environment to production?

Answer: Export the solution as a managed solution and import it into the production environment

Best practice ALM dictates exporting solutions as managed solutions from lower environments and importing them into production, ensuring consistent deployments and preventing direct edits in production.

What is a Power BI 'measure'?

Answer: A dynamic DAX calculation that aggregates data at query time based on the current filter context

Measures are DAX expressions that calculate results dynamically in response to slicers, filters, and visual context, enabling flexible aggregations like total sales or year-over-year growth.

What does a Many-to-Many (N:N) relationship in Dataverse require behind the scenes?

Answer: An auto-created intersect (junction) table to store the associations

Dataverse automatically creates a hidden intersect table to store the pairs of related records for N:N relationships.

Which component type in Power Apps allows you to create reusable UI elements with custom input and output properties?

Answer: Component

Power Apps Components are reusable canvas controls that encapsulate UI and logic with custom properties, enabling consistent design across apps.

What is an Environment Variable used for in Power Platform solutions?

Answer: Holding environment-specific configuration values separate from app logic

Environment variables store configuration values like URLs, keys, or settings that differ between environments, enabling solutions to move between environments without code changes.

Which Power Apps feature allows makers to add client-side logic to Model-Driven app forms without writing JavaScript?

Answer: Business Rules

Business Rules apply logic such as show/hide, set field values, and validate data directly on forms using a no-code interface.

There are two entities for the Common Data Service. You are to establish a Many-to-Many link between the two entities, as specified. Which of the following statements about many-to-many relationships is TRUE?

Answer: No explicit hierarchy exists

By storing associations between the records from both entities, the relationship table acts as a middleman. Usually, it contains foreign keys that refer to the primary keys of the two parties to the connection. It is clear that there is no hierarchy between the two entities from the sentence "No explicit hierarchy exists." When there is a many-to-many link, the entities are often on the same level and lack a hierarchical structure. It follows that both of the following are true when establishing a many-to-many link between two entities in the Common Data Service: you require a relationship table to hold the associations, and there is no clear hierarchy between the entities.

What is a 'Solution Patch' in Power Platform?

Answer: An incremental update to a managed solution that ships only the changed components

Solution Patches are child solutions that include only the subset of components that changed, reducing the size and risk of updates.

In Power Platform, what does the 'Connection Reference' component in a solution do?

Answer: Store a logical pointer to a connector connection so the actual connection can be set per environment at import

Connection References decouple the connection identity from the flow or app so that each environment can use its own credentials.

What does the 'LookUp()' function return in Power Apps?

Answer: The first record from a table that matches a condition

LookUp() scans a table and returns the first single record that satisfies the specified condition, or blank if none is found.

In a Model-Driven app, which setting on a lookup column allows users to create a new related record inline without navigating away?

Answer: Allow Quick Create

Enabling 'Allow Quick Create' on a lookup causes a Quick Create Form to open when users click 'New' in the lookup dialog.

In Power BI, what is 'drill-through'?

Answer: A navigation technique allowing users to right-click a data point and jump to a detail page filtered by that value

Drill-through lets report designers create a target page that receives filter context from a selected value, allowing users to jump to a detailed view of a specific item.

Which control in Power Apps canvas apps is best suited for displaying a scrollable list of records with custom formatting?

Answer: Gallery

The Gallery control allows custom layouts and formatting for each record and supports vertical or horizontal scrolling.

In a model-driven app, which form type is used for creating a new record in a dialog without navigating away from the current page?

Answer: Quick Create Form

Quick Create Forms appear as lightweight popups when users click '+ New' in sub-grids or lookup searches, allowing fast record creation without a full navigation.

In Power Platform ALM, what is the recommended environment strategy for a production deployment pipeline?

Answer: Development → Test/UAT → Production environments

Microsoft recommends a minimum of three environments: Development for building, Test/UAT for validation, and Production for live use.

Which Canvas app component feature allows you to define output properties that can pass values back to the hosting screen?

Answer: Custom output properties

Components support custom output properties that expose internal values to the parent screen or app.

In Dataverse, what does enabling 'Auditing' on a table do?

Answer: Records a history of all data changes including who changed what and when

Auditing logs create, update, and delete operations on records, capturing the user, timestamp, and changed values.

Which connector in Power Automate allows flows to create, update, read, and delete records in Microsoft Dataverse?

Answer: Microsoft Dataverse connector

The Microsoft Dataverse connector provides actions to perform full CRUD operations on any Dataverse table.

In Power Apps, what is a 'collection'?

Answer: A local in-memory table stored within the app

A collection is a temporary in-memory table created and manipulated with functions like Collect(), ClearCollect(), and Remove() within the app.