Microsoft Certified Data Analyst Associate Microsoft Power Platform Fundamentals 3

Question 1

In Power BI Desktop, which view is used to define relationships between tables?

Accepted Answer

Model view

Answer

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?

Accepted Answer

Salesforce

Answer

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?

Accepted Answer

A packaged set of components that can be exported and imported across environments

Answer

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?

Accepted Answer

ALL

Answer

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?

Accepted Answer

The underlying data model and metadata

Answer

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.

Microsoft Certified Data Analyst Associate Practice Test

Microsoft Certified Data Analyst Associate Practice Test

Microsoft Certified Data Analyst Associate Microsoft Power Platform Fundamentals 3