Microsoft Certified Data Analyst Associate Microsoft Power Platform Fundamentals 3 — Questions and Answers
Question 1: In Power BI Desktop, which view is used to define relationships between tables?
- Report view
- Data view
- Model view (Correct answer)
- Query view
Correct answer: Model view
Model view in Power BI Desktop displays all tables and their relationships, allowing users to create, edit, or delete table relationships.
Question 2: Which connector type in Power Automate requires a premium license?
- SharePoint
- Outlook
- Salesforce (Correct answer)
- Microsoft Teams
Correct answer: Salesforce
Salesforce is a premium connector in Power Automate, meaning flows using it require a premium license plan.
Question 3: What is a 'solution' in the context of Microsoft Power Platform?
- A packaged set of components that can be exported and imported across environments (Correct answer)
- A pre-built dashboard template in Power BI
- A type of flow that resolves data conflicts automatically
- An AI model trained on business data
Correct answer: A packaged set of components that can be exported and imported across environments
A solution is a container for components like apps, flows, and tables that can be packaged and moved between environments for ALM purposes.
Question 4: Which DAX function in Power BI returns the total sales for all rows regardless of filters applied in the report?
- CALCULATE
- SUMX
- ALL (Correct answer)
- RELATED
Correct answer: ALL
The ALL function removes all filters from a specified table or column, enabling measures to calculate values regardless of current report context.
Question 5: In Power Apps model-driven apps, what drives the app's layout and components?
- Custom HTML and CSS code
- The underlying data model and metadata (Correct answer)
- The canvas design surface
- SharePoint list structure
Correct answer: The underlying data model and metadata
Model-driven apps are generated from the data model in Dataverse, meaning the structure and relationships of data define the app's forms, views, and navigation.
Question 6: Which Power Platform environment type is recommended for production workloads?
- Default environment
- Sandbox environment
- Production environment (Correct answer)
- Developer environment
Correct answer: Production environment
Production environments are intended for live business operations and have full capacity allocations, unlike sandbox or developer environments.
Question 7: What is the purpose of Row-Level Security (RLS) in Power BI?
- To encrypt data at rest in Power BI datasets
- To restrict data access for specific users based on roles (Correct answer)
- To limit the number of rows a report can display
- To prevent duplication of rows during data refresh
Correct answer: To restrict data access for specific users based on roles
Row-Level Security in Power BI restricts which rows of data a user can see by applying DAX-based filters tied to user roles.
Microsoft Certified Data Analyst Associate Microsoft Power Platform Fundamentals 3
In Power BI Desktop, which view is used to define relationships between tables?