Question bank
Microsoft Certified: Intelligent Applications Builder Associate
41 Microsoft Certified: Intelligent Applications Builder Associate questions with the correct answer and a written explanation, organised across 3 exam domains.
- 41 questions
- 3 domains
- Foundation level
certilumQuestion index
Jump straight to any question. Answers and explanations are inline.
Build business application logic and automation
17 questions in this domain
- Question 1Single Choice
Which type of cloud flow starts automatically when an event occurs in a data source?
- AAutomatedCorrect answer
- BInstant
- CScheduled
- DRecurrence
Why this is the answer
Automated flows are event-driven and start when a defined event occurs, such as a row being created or an email arriving.
- Question 2Multiple Select
Which three options are primary cloud flow types in Power Automate?
- AAutomatedCorrect answer
- BInstantCorrect answer
- CScheduledCorrect answer
- DRecurrence
Why this is the answer
Power Automate has three primary cloud flow types: automated, instant, and scheduled. Recurrence is a trigger, not a flow type.
- Question 3Interactive
Based on the trigger configuration shown in the code block, which type of cloud flow should the builder select?
- AAutomatedCorrect answer
- BInstant
- CScheduled
- DDesktop flow
Why this is the answer
The trigger listens for a data event, such as a row being added, which makes it an automated flow trigger.
- Question 4Single Choice
A user needs to press a button in a Power Apps app to start an approval. Which type of cloud flow should be created?
- AAutomated
- BScheduled
- CInstantCorrect answer
- DBusiness process flow
Why this is the answer
Instant flows start on demand through a manual action, such as clicking a button in Power Apps or selecting a Flow button.
- Question 5Multiple Select
Which two statements about business process flows are correct?
- AThey guide users through stages and steps.Correct answer
- BThey execute unattended backend logic automatically.
- CThey must be activated before users can see them.Correct answer
- DThey replace all cloud flows in an organization.
Why this is the answer
Business process flows provide guided stages and steps. They must be activated before they are available to users, and they do not execute unattended automation.
- Question 6Interactive
A model-driven app displays the sequence in the code block as an interactive process bar. Which component is being used?
- ABusiness process flowCorrect answer
- BCloud flow
- CBusiness rule
- DCanvas app
Why this is the answer
Business process flows display a stage-based process bar and guide users through defined stages and steps.
- Question 7Single Choice
Which Power Automate control evaluates a logical expression and sends execution to one of two branches?
- AConditionCorrect answer
- BScope
- CParallel branch
- DApply to each
Why this is the answer
The Condition action evaluates a logical expression and routes the flow into either the If yes or If no branch.
- Question 8Multiple Select
Which statuses can be evaluated in the Configure Run After setting?
- ASucceededCorrect answer
- BFailedCorrect answer
- CTimed outCorrect answer
- DSkippedCorrect answer
Why this is the answer
Configure Run After supports four statuses: succeeded, failed, timed out, and skipped. All four can be selected as conditions for the next action.
- Question 9Interactive
According to the code block, when will the Send email action run?
- AOnly after Update_record succeeds
- BOnly after Update_record fails
- CAfter Update_record succeeds or failsCorrect answer
- DOnly after Update_record times out
Why this is the answer
The run-after configuration includes both Succeeded and Failed, so Send email runs after Update_record either succeeds or fails.
- Question 10Single Choice
Which action should be used to map an array to a new array with selected properties?
- ACompose
- BSelectCorrect answer
- CParse JSON
- DCreate CSV table
Why this is the answer
The Select action maps an array to a new array with configured properties, leaving the original source unchanged.
- Question 11Multiple Select
Which actions are part of the Data Operation group in Power Automate?
- AComposeCorrect answer
- BSelectCorrect answer
- CFilter arrayCorrect answer
- DParse JSONCorrect answer
Why this is the answer
Compose, Select, Filter array, and Parse JSON are all part of the Data Operation action group in Power Automate.
- Question 12Interactive
What is the output of the expression in the code block when ordernumber is ORD-1001?
- AOrder #ORD-1001Correct answer
- BOrder #
- CORD-1001 #Order
- DAn error
Why this is the answer
The concat expression combines the text Order # with the trigger output value, producing Order #ORD-1001.
- Question 13Single Choice
Which component is required to trigger an unattended desktop flow on a machine from a cloud flow?
- AOn-premises data gatewayCorrect answer
- BMicrosoft Dataverse
- CCustom connector
- DPower Apps
Why this is the answer
The on-premises data gateway securely connects cloud flows to on-premises resources and is required to trigger desktop flows.
- Question 14Multiple Select
Which statements correctly describe desktop flows used for RPA?
- AThey can interact with user interface elements on Windows devices.Correct answer
- BThey are only used for systems that expose APIs.
- CThey can be used for legacy applications with no API.Correct answer
- DThey mimic human interaction such as clicking and typing.Correct answer
Why this is the answer
Desktop flows automate UI interactions on Windows machines and are especially useful for legacy systems that do not expose APIs.
- Question 15Interactive
Based on the permissions shown in the code block, which role has the exclusive ability to delete the flow?
- AOwnerCorrect answer
- BCo-owner
- CRun-only user
- DAll roles
Why this is the answer
The primary owner can edit, share, and delete the flow. Co-owners and run-only users do not have delete permission.
- Question 16Single Choice
Which setting controls how many instances of a cloud flow can run at the same time at the trigger level?
- ATrigger concurrencyCorrect answer
- BApply to each concurrency
- CParallel branches
- DScope
Why this is the answer
Trigger concurrency controls how many flow runs can execute at the same time for a given trigger, preventing collisions.
- Question 17Multiple Select
Which requirements are necessary for unattended RPA desktop flows?
- AA user must be present to approve each step.
- BThe target machine must be accessible and powered on.Correct answer
- CAn on-premises data gateway is needed to communicate with Power Automate.Correct answer
- DUnattended desktop flows never require a license.
Why this is the answer
Unattended RPA requires the machine to be available and an on-premises data gateway. A user does not need to approve each step.
Create a foundation for intelligent applications
12 questions in this domain
- Question 18Single Choice
Which option set type should you use when multiple Dataverse tables must share the same list of values?
- AGlobal choiceCorrect answer
- BLocal choice
- CLookup column
- DMulti-Select choice
Why this is the answer
A global choice is reusable across tables; a local choice belongs to one table only.
- Question 19Multiple Select
Which two statements are true about business rules in Microsoft Dataverse?
- ARun client-side on formsCorrect answer
- BUpdate records in another table
- CHide or show fieldsCorrect answer
- DTrigger server-side workflows
Why this is the answer
Business rules run on the model-driven form only; they cannot update cross-table records or trigger workflows.
- Question 20Interactive
Refer to the relationship metadata in the code block. How should this relationship be implemented in Dataverse?
- ACustom intersection table with 1:N relationshipsCorrect answer
- BStandard N:N relationship
- COne-to-many relationship
- DSame-table lookup
Why this is the answer
Because the association stores EnrollmentDate and Grade, a custom intersection table with 1:N relationships is required.
- Question 21Single Choice
Which Dataverse access level includes records in a user's business unit and all child business units?
- ADeepCorrect answer
- BBasic
- CLocal
- DGlobal
Why this is the answer
Deep access covers the user's business unit plus child business units; Local covers only the current unit.
- Question 22Multiple Select
Which statements about managed solutions are correct?
- AComponents are read-only after importCorrect answer
- BManaged solutions can be edited directly in production
- CPublisher prefix is part of component namesCorrect answer
- DUnmanaged solutions are used for final production deployment
Why this is the answer
Managed solutions are read-only after import and use publisher prefixes; production changes require a new managed version.
- Question 23Interactive
Use the business rule configuration in the code block. What is this rule able to do on a form?
- AConditionally set field values and requirementsCorrect answer
- BCreate a new record in another table
- CTrigger a Power Automate flow
- DDelete child records
Why this is the answer
Business rules apply form-based actions such as setting values and making fields required; they cannot create records or trigger flows.
- Question 24Single Choice
What determines the default prefix for a custom table in Dataverse?
- ASolution publisherCorrect answer
- BEnvironment owner
- CDefault solution
- DTable creator
Why this is the answer
The solution publisher defines the custom prefix, such as new_, and it should remain consistent across environments.
- Question 25Multiple Select
Which capabilities are provided by calculated and rollup columns in Dataverse?
- ACalculate values from fields in the same rowCorrect answer
- BAggregate values from related recordsCorrect answer
- CTrigger real-time workflows
- DEnforce security roles
Why this is the answer
Calculated columns use same-row values; rollup columns aggregate related records on a scheduled basis, not in real time.
- Question 26Interactive
Use the DLP policy classifications in the code block. Which two statements are true?
- ASharePoint and SQL Server are both BusinessCorrect answer
- BGmail is classified as Non-BusinessCorrect answer
- CPersonal Email is classified as Business
- DAll connectors can be used together
Why this is the answer
The policy places SharePoint and SQL Server in Business, Gmail in Non-Business, and Personal Email blocked; mixed categories cannot be used together.
- Question 27Single Choice
Which standard Dataverse table should be reused to represent a company that purchases products?
- AAccountCorrect answer
- BContact
- CLead
- DOpportunity
Why this is the answer
Account represents organizations; Contact represents individuals; Lead is an unqualified prospect; Opportunity is a potential sale.
- Question 28Multiple Select
Which actions can a Dataverse business rule perform?
- AShow or hide fieldsCorrect answer
- BSet default valuesCorrect answer
- CCreate a new row in another table
- DTrigger Power Automate
Why this is the answer
Business rules support show/hide and default value actions on forms; they cannot create rows or trigger automation.
- Question 29Interactive
Refer to the solution metadata in the code block. How should you update a component after this package is imported?
- AEdit the component directly in production
- BUpdate source and import new managed versionCorrect answer
- CDelete the solution and create a new environment
- DChange the publisher prefix in production
Why this is the answer
Managed solution components are read-only in production; updates must come from a new managed version built from the source solution.
Create intelligent applications
12 questions in this domain
- Question 30Single Choice
Which model-driven app component displays a read-only snapshot of a related record inside a main form?
- AQuick View FormCorrect answer
- BQuick Create Form
- CMain Form
- DBusiness Process Flow
Why this is the answer
Quick view forms provide a compact read-only snapshot of a related record. Quick create forms are for data entry, while main forms are used for editing and displaying records.
- Question 31Multiple Select
Which statements about business process flows (BPFs) are true? Select all that apply.
- AThey are interactive and user-drivenCorrect answer
- BThey can span multiple tablesCorrect answer
- CThey run automatically in the background
- DThey replace business rules
Why this is the answer
Business process flows guide users through stages manually and can span multiple tables. They are not background automation like Power Automate flows, and they do not replace business rules.
- Question 32Interactive
A canvas app uses the following expression to update a variable. What is the scope of this variable?
- AApp-wideCorrect answer
- BCurrent screen only
- CCurrent gallery only
- DCurrent flow only
Why this is the answer
Set creates and updates global variables that are visible across all screens. UpdateContext would create a screen-scoped context variable.
- Question 33Single Choice
What is the main purpose of a model-driven app main form?
- AViewing and editing a record's dataCorrect answer
- BBrowsing a list of records
- CRunning background automation
- DDefining data source permissions
Why this is the answer
Main forms are the primary interface for creating, viewing, and editing records. Views are used for browsing lists of records.
- Question 34Multiple Select
Which statements about public and personal views are correct? Select all that apply.
- APublic views can be shared with other usersCorrect answer
- BPersonal views are visible only to the user who created themCorrect answer
- CSystem views cannot be modified
- DPersonal views can be set as a table's default view
Why this is the answer
Public views are shared with other users, while personal views are private to the creator. System views are customizable, and personal views cannot be set as the default view.
- Question 35Interactive
What does the following Power Fx expression accomplish in a canvas app?
- AIt handles errors gracefully and notifies the userCorrect answer
- BIt creates a new order in the data source
- CIt disables all controls on the screen
- DIt permanently deletes the filtered order
Why this is the answer
IfError catches a failing Filter operation and runs Notify to show an error message, enabling graceful error handling.
- Question 36Single Choice
What is required to connect a canvas app to an on-premises SQL Server?
- AOn-premises data gatewayCorrect answer
- BA custom JavaScript plug-in
- CA Dataverse virtual table only
- DA standard Outlook connector
Why this is the answer
An on-premises data gateway bridges cloud services to on-premises data sources such as SQL Server.
- Question 37Multiple Select
Which Power Fx functions can create or update state in a canvas app? Select all that apply.
- ASetCorrect answer
- BUpdateContextCorrect answer
- CClearCollectCorrect answer
- DForAll
Why this is the answer
Set creates global variables, UpdateContext creates context variables, and ClearCollect creates collections. ForAll loops over data but does not define state.
- Question 38Interactive
The following Power Fx formula is used in a gallery over a large Dataverse table. What is true about it?
- AIt is delegable and can be processed by the data sourceCorrect answer
- BIt is non-delegable and loads all rows locally
- CIt is invalid because Filter cannot query Dataverse
- DIt will always return zero records
Why this is the answer
Filter with an equality comparison on a column is a delegable query, so the filtering is pushed to the data source.
- Question 39Single Choice
What must a builder do before an AI Builder model is available for use in production?
- APublish the modelCorrect answer
- BRetrain the model
- CCreate a new environment
- DConvert the model to a canvas app
Why this is the answer
After training, an AI Builder model remains in draft status until it is published. Publishing makes it available for use in production.
- Question 40Multiple Select
Which statements about AI Builder are true? Select all that apply.
- AIt provides low-code AI model creationCorrect answer
- BModels must be published before production useCorrect answer
- CTraining data may come from Dataverse or SharePointCorrect answer
- DIt requires custom C# code
Why this is the answer
AI Builder is a low-code/no-code tool. Models are published after training, and training data can be stored in Dataverse or SharePoint. No custom C# code is required.
- Question 41Interactive
What does this Power Fx formula return when placed in a Visible property?
- AWhen the app width is less than 640Correct answer
- BWhen the app width is greater than 640
- CWhen the app is exactly 640 wide
- DWhen the app is running on a desktop
Why this is the answer
The formula compares App.Width to 640 and returns true only when the app width is less than 640.
Frequently asked questions
Everything about the Microsoft Certified: Intelligent Applications Builder Associate question bank and how to use it.