Microsoft Certified Data Analyst Associate Microsoft Power Platform Fundamentals 4 — Questions and Answers
Question 1: Which Power Automate flow type is triggered manually by a user from within Power Apps or Teams?
- Scheduled flow
- Automated flow
- Instant flow (Correct answer)
- Business process flow
Correct answer: Instant flow
Instant flows (also called button flows) are triggered on-demand by a user action, such as pressing a button in Power Apps or Teams.
Question 2: In Power BI, what is a 'measure' as opposed to a 'calculated column'?
- A measure is computed row by row; a calculated column aggregates data
- A measure is evaluated in the context of a report visual; a calculated column is computed during data load (Correct answer)
- A measure is stored in the dataset; a calculated column is computed on the fly
- A measure applies to one table; a calculated column can span multiple tables
Correct answer: A measure is evaluated in the context of a report visual; a calculated column is computed during data load
Measures are dynamic calculations evaluated at query time based on report filter context, while calculated columns are computed and stored when data is loaded.
Question 3: Which feature in Power Apps allows makers to incorporate AI capabilities such as object detection and form processing without building custom models?
- Dataverse AI
- AI Builder (Correct answer)
- Azure ML connector
- Cognitive Services API
Correct answer: AI Builder
AI Builder is a Power Platform capability that lets makers add pre-built AI models like form processing, object detection, and sentiment analysis to their apps and flows.
Question 4: What distinguishes a 'canvas app' from a 'model-driven app' in Power Apps?
- Canvas apps require premium licenses; model-driven apps do not
- Canvas apps offer pixel-perfect design freedom; model-driven apps are data-structure-driven with a standardized UI (Correct answer)
- Canvas apps only work on mobile; model-driven apps work on desktop
- Canvas apps cannot connect to Dataverse; model-driven apps require it
Correct answer: Canvas apps offer pixel-perfect design freedom; model-driven apps are data-structure-driven with a standardized UI
Canvas apps give makers full control over layout via a drag-and-drop design surface, while model-driven apps generate their UI automatically based on the Dataverse data model.
Question 5: In Power BI Service, what is a 'workspace'?
- A local storage location in Power BI Desktop
- A collaborative environment where teams can create, share, and manage Power BI content (Correct answer)
- An individual user's personal dashboard collection
- A Power BI Premium capacity region
Correct answer: A collaborative environment where teams can create, share, and manage Power BI content
Workspaces in Power BI Service are collaborative containers where teams can store, manage, and share reports, dashboards, and datasets.
Question 6: Which Power Platform feature provides pre-built AI-powered chatbots that can be deployed without any code?
- Power Apps Portals
- Power Automate AI flows
- Copilot Studio (formerly Power Virtual Agents) (Correct answer)
- AI Builder chatbot model
Correct answer: Copilot Studio (formerly Power Virtual Agents)
Copilot Studio, formerly known as Power Virtual Agents, enables users to build and deploy AI-powered chatbots using a guided, no-code authoring canvas.
Question 7: Which Power BI visual type is best for showing how a value changes over a continuous time period?
- Pie chart
- Treemap
- Line chart (Correct answer)
- Funnel chart
Correct answer: Line chart
Line charts are ideal for displaying trends and changes in values over a continuous time axis, making temporal patterns easy to interpret.
Microsoft Certified Data Analyst Associate Microsoft Power Platform Fundamentals 4
Which Power Automate flow type is triggered manually by a user from within Power Apps or Teams?