Microsoft Certified Data Analyst Associate Microsoft Power Platform Fundamentals 5 — Questions and Answers
Question 1: What is the maximum number of environments an organization can create by default in Power Platform (excluding the default environment)?
- It depends on the number of purchased Power Apps/Power Automate licenses (Correct answer)
- 5 environments per tenant regardless of licenses
- 1 production and 1 sandbox only
- Unlimited environments for any tenant
Correct answer: It depends on the number of purchased Power Apps/Power Automate licenses
The number of environments an organization can create scales with the number of qualifying Power Apps and Power Automate licenses purchased.
Question 2: In Power BI, which storage mode keeps data in Power BI's in-memory engine for the fastest query performance?
- DirectQuery
- Live Connection
- Import (Correct answer)
- Composite
Correct answer: Import
Import mode loads and compresses data into Power BI's in-memory VertiPaq engine, providing the fastest query performance at the cost of requiring periodic refreshes.
Question 3: Which Dataverse security concept allows an administrator to grant a user access to only the records they own or that are shared with them?
- Field-level security
- Business unit security
- Record-level security via access teams (Correct answer)
- Role-based access control at table level
Correct answer: Record-level security via access teams
Access teams in Dataverse enable record-level sharing, allowing specific users to access individual records without changing their broader security roles.
Question 4: In Power Automate, what is the function of a 'condition' action in a flow?
- It pauses the flow until a specific date and time
- It loops through items in a collection
- It branches the flow into 'yes' and 'no' paths based on a logical expression (Correct answer)
- It sends an HTTP request to an external service
Correct answer: It branches the flow into 'yes' and 'no' paths based on a logical expression
A condition action evaluates a logical expression and directs the flow to either a 'yes' branch or a 'no' branch based on the result.
Question 5: Which Power Platform tool allows organizations to monitor adoption, usage, and governance of Power Apps and Power Automate across their tenant?
- Power BI Admin Portal
- Microsoft 365 Admin Center
- Center of Excellence (CoE) Starter Kit (Correct answer)
- Dataverse Analytics Dashboard
Correct answer: Center of Excellence (CoE) Starter Kit
The CoE Starter Kit is a collection of templates and tools that help organizations establish governance, visibility, and best practices for Power Platform adoption.
Question 6: What does 'DirectQuery' mode in Power BI mean for data freshness?
- Data is refreshed once daily on a schedule
- Queries are sent directly to the source every time a visual is interacted with, so data is always current (Correct answer)
- Data is cached for 15 minutes before the next refresh
- Data must be manually pushed to refresh
Correct answer: Queries are sent directly to the source every time a visual is interacted with, so data is always current
In DirectQuery mode, Power BI sends a live query to the data source each time a user interacts with a report, ensuring the data reflects the latest state of the source.
Question 7: Which of the following best describes the purpose of a 'Business Process Flow' in Power Apps?
- An automated background process that triggers on data changes in Dataverse
- A guided, stage-based UI that walks users through a defined business process (Correct answer)
- A scheduled flow that runs business logic at regular intervals
- A chatbot conversation flow defined in Copilot Studio
Correct answer: A guided, stage-based UI that walks users through a defined business process
Business Process Flows provide a visual, stage-gated guide in model-driven apps that ensures users follow a consistent sequence of steps to complete a process.
Microsoft Certified Data Analyst Associate Microsoft Power Platform Fundamentals 5
What is the maximum number of environments an organization can create by default in Power Platform (excluding the default environment)?