Question bank
Microsoft Certified: Power Platform Functional Consultant Associate
44 Microsoft Certified: Power Platform Functional Consultant Associate questions with the correct answer and a written explanation, organised across 6 exam domains.
- 44 questions
- 6 domains
- Foundation level
certilumQuestion index
Jump straight to any question. Answers and explanations are inline.
Analyze data
6 questions in this domain
- Question 1Single Choice
When you need to display a metric over a continuous period of time, which chart type is the most appropriate to select?
- ALine chartCorrect answer
- BBar chart
- CPie chart
- DScatter plot
Why this is the answer
Line charts are used for temporal trends, while bar charts are better for categorical comparisons.
- Question 2Multiple Select
Which two statements correctly describe the difference between standard and premium connectors in the Power Platform?
- ASharePoint and OneDrive are included with standard licensing.Correct answer
- BSQL Server and HTTP require premium licensing.Correct answer
- CAll connectors are included with standard licensing.
- DPremium connectors are included with basic Power Platform licensing.
Why this is the answer
Standard connectors, such as SharePoint and OneDrive, are included with basic licensing; premium connectors, such as SQL Server and HTTP, require additional licensing.
- Question 3Interactive
The Power Query expression in the code block is used in a dataflow. Which type of data source is it referencing?
- AOn-premises SQL ServerCorrect answer
- BSharePoint Online
- CDataverse
- DREST API
Why this is the answer
The Sql.Database function targets SQL Server. For an on-premises SQL Server, an On-premises Data Gateway is required to make it available to cloud services.
- Question 4Single Choice
A report is being designed to compare many product categories. Which chart type should be avoided in this scenario?
- APie chartCorrect answer
- BLine chart
- CBar chart
- DScatter plot
Why this is the answer
The Pie Chart Pitfall states that a pie chart with too many categories obscures the ability to compare relative values effectively.
- Question 5Multiple Select
Which two behaviors are common traps when planning data integration and visualization for a Power Platform solution?
- ASelecting Dataflows when duplication must be avoided.Correct answer
- BOverlooking the On-premises Data Gateway requirement.Correct answer
- CUsing virtual tables to unify data without moving it.
- DDesigning a custom connector for an unsupported REST API.
Why this is the answer
Dataflows physically copy data and can create duplication; virtual tables provide a window to existing data. On-premises SQL Server requires a gateway for cloud access.
- Question 6Interactive
The JSON definition in the code block describes a REST API that has no pre-built connector. What should you create to use it?
- ACustom ConnectorCorrect answer
- BDataflow
- CDataverse Virtual Table
- DPower BI Dataset
Why this is the answer
When a pre-built connector does not exist for a REST API, a Custom Connector is required. It requires understanding API authentication and endpoint structure.
Build Power Apps
12 questions in this domain
- Question 7Single Choice
In Power BI, which visual type is most appropriate for showing a trend over time?
- ALine chartCorrect answer
- BPie chart
- CBar chart
- DScatter chart
Why this is the answer
Line charts are recommended for temporal trends; bar charts are for categorical comparisons. Pie charts show parts of a whole and can obscure comparisons.
- Question 8Multiple Select
Which of the following are standard connectors that are included with basic Power Platform licensing?
- ASharePointCorrect answer
- BOneDriveCorrect answer
- CSQL Server
- DAzure DevOps
Why this is the answer
SharePoint and OneDrive are standard connectors. SQL Server and Azure DevOps are premium connectors and require additional Power Platform licensing.
- Question 9Interactive
The code block configures a visual with order date and sales amount. Which business question is this visual best suited to answer?
- AHow sales change over timeCorrect answer
- BHow sales compare across product categories
- CWhat proportion of total sales each product represents
- DWhether two numeric variables are correlated
Why this is the answer
A line chart with a date field and a measure is ideal for analyzing changes over time, not categorical comparison or proportion.
- Question 10Single Choice
What is the primary difference between a Power BI dashboard and a detailed report in the Power BI Service?
- ADashboard is single-page; report is multi-pageCorrect answer
- BReport is single-page; dashboard is multi-page
- CDashboards are for raw data entry
- DTerms are interchangeable
Why this is the answer
A report provides detailed multi-page views of data. A dashboard is a single-page, high-level overview used for monitoring critical metrics.
- Question 11Multiple Select
Which actions support effective visual hierarchy and layout on a Power Apps canvas?
- AUse size and color for KPIsCorrect answer
- BPlace secondary data above KPIs
- CPosition KPIs prominentlyCorrect answer
- DAvoid overloading the canvasCorrect answer
Why this is the answer
Visual hierarchy uses size, color, and position to emphasize KPIs and reduce cognitive overload. Secondary data should not outrank primary KPIs.
- Question 12Interactive
The code block describes a connection to a data source located behind a corporate firewall. Which component provides the secure bridge?
- AOn-premises Data GatewayCorrect answer
- BDataverse Virtual Table
- CCustom Connector
- DDataflow
Why this is the answer
The On-premises Data Gateway works as a secure bridge between cloud services and on-premises data, avoiding the need for complex VPN configurations.
- Question 13Single Choice
What does the Dataverse Virtual Tables feature allow you to do with data stored in external sources?
- ASurface external data without moving itCorrect answer
- BCopy external data into Dataverse
- CTransform data using Power Query Online
- DCreate custom REST API connectors
Why this is the answer
Virtual Tables surface external data within Dataverse without copying or moving the data, reducing duplication and storage costs.
- Question 14Multiple Select
Which two statements describe common traps when making Power Platform architecture choices?
- ASelecting Dataflows to avoid data duplicationCorrect answer
- BOverlooking On-premises Data Gateway requirementCorrect answer
- CUsing line charts for temporal trends
- DUsing Model-driven dashboards for operational views
Why this is the answer
Common traps include using Dataflows when duplication is a concern and overlooking the Data Gateway for on-premises sources. Line charts and model-driven dashboards are appropriate in their contexts.
- Question 15Interactive
The code block describes an API endpoint that has no pre-built connector. What should be created to use this endpoint?
- ACustom ConnectorCorrect answer
- BDataflow
- COn-premises Data Gateway
- DDataverse Virtual Table
Why this is the answer
Custom Connectors are designed when no pre-built connector exists for a REST API. They require understanding authentication methods like OAuth 2.0 and endpoint structure.
- Question 16Single Choice
What is the role of an On-premises Data Gateway in a Power Platform solution?
- ASecurely bridges cloud and on-premises dataCorrect answer
- BPhysically moves data into Dataverse
- CReplaces custom connectors
- DTransforms data before loading
Why this is the answer
The gateway is a secure bridge between cloud services and local data. It does not move or transform data, and it is separate from connectors.
- Question 17Multiple Select
Which statements are true about Dataflows in the Power Platform?
- AUse Power Query OnlineCorrect answer
- BPhysically copy dataCorrect answer
- CProvide virtual data views
- DSupport ETL processesCorrect answer
Why this is the answer
Dataflows use Power Query Online for ETL and physically copy data. Virtual Tables provide a window into existing data without copying it.
- Question 18Interactive
The code block describes an analytics artifact. Which type of Power BI artifact is this?
- ADashboardCorrect answer
- BReport
- CDataflow
- DCustom Connector
Why this is the answer
A dashboard is a single-page, high-level overview used for monitoring. A report is detailed and often multi-page.
Build Power Automate
8 questions in this domain
- Question 19Single Choice
Which chart type is best for showing temporal trends?
- ALine chartCorrect answer
- BBar chart
- CPie chart
- DScatter chart
Why this is the answer
Line charts are ideal for temporal trends because they emphasize changes over a continuous time interval. Use bar charts for categorical comparisons.
- Question 20Multiple Select
Which of the following connectors are classified as Standard connectors included with basic Power Platform licensing?
- ASharePointCorrect answer
- BOneDriveCorrect answer
- CSQL Server
- DHTTP
Why this is the answer
SharePoint and OneDrive are Standard connectors included with basic licensing. SQL Server and HTTP are Premium connectors that require additional licensing.
- Question 21Interactive
You are reviewing a Power Automate flow. Review the connector name in the trigger shown in the code block. What is true about this connector?
- AIt requires a Premium licenseCorrect answer
- BIt is included with basic licensing
- CIt is a custom connector
- DIt uses Dataverse Virtual Tables
Why this is the answer
shared_sql indicates SQL Server, a Premium connector. Using it without the appropriate license can cause unexpected costs.
- Question 22Single Choice
What is the primary distinction between a dashboard and a report in Power BI?
- ADashboard is a single-page high-level overviewCorrect answer
- BDashboard contains detailed multi-page data
- CReport is a single-page overview
- DReport is limited to real-time task lists
Why this is the answer
A report is a detailed multi-page view, while a dashboard is a single-page high-level overview used for monitoring critical metrics.
- Question 23Multiple Select
Which statements about Dataverse Virtual Tables are correct?
- AThey surface external data without copying itCorrect answer
- BThey provide a unified view across sourcesCorrect answer
- CThey reduce duplication and storage costsCorrect answer
- DThey perform ETL using Power Query Online
Why this is the answer
Virtual Tables create a window to external data without physical movement, reducing duplication. Dataflows, not virtual tables, use Power Query Online for ETL.
- Question 24Interactive
You need to connect to a REST API that uses the authentication method shown in the code block. What should you build?
- ACustom ConnectorCorrect answer
- BDataflow
- COn-premises Data Gateway
- DDataverse Virtual Table
Why this is the answer
A Custom Connector is needed when no pre-built connector exists for a REST API. It requires understanding authentication methods such as OAuth 2.0.
- Question 25Single Choice
What is the purpose of the On-premises Data Gateway?
- AIt securely bridges cloud services and on-premises dataCorrect answer
- BIt transforms data before loading into Dataverse
- CIt replaces Power Query Online
- DIt creates virtual tables from external data
Why this is the answer
The Data Gateway enables cloud services to access data behind a firewall securely, without requiring complex VPN configurations.
- Question 26Multiple Select
Which of the following are common architectural traps to avoid in Power Platform solutions?
- ASelecting Dataflows to avoid data duplicationCorrect answer
- BOverlooking the On-premises Data GatewayCorrect answer
- CConfusing Custom Connectors with DataflowsCorrect answer
- DUsing Power BI for complex analytics
Why this is the answer
Using Dataflows to avoid duplication is wrong; use Virtual Tables. Overlooking the gateway and confusing connectors/dataflows are also common traps.
Configure the data model
7 questions in this domain
- Question 27Single Choice
Which chart type is most appropriate for showing a sales trend over a twelve-month period?
- ABar chart
- BLine chartCorrect answer
- CPie chart
- DScatter chart
Why this is the answer
Line charts are designed to show temporal trends, making them the correct choice for time-series data such as a 12-month sales trend.
- Question 28Multiple Select
Which two statements accurately describe standard vs premium connectors? Choose two.
- AStandard connectors such as SharePoint and OneDrive are included with basic Power Platform licensing.Correct answer
- BPremium connectors such as SQL Server and HTTP require additional licensing.Correct answer
- CStandard connectors include SQL Server and HTTP with no additional cost.
- DAll connectors are free when used inside Dataverse Virtual Tables.
Why this is the answer
Standard connectors are included with basic Power Platform licensing, while Premium connectors such as SQL Server, HTTP, and Azure DevOps require additional licensing.
- Question 29Interactive
Review the JSON definition. Based on the actions listed, which Power Platform component is being configured to move and transform data into Dataverse?
- ADataflowCorrect answer
- BVirtual Table
- CCustom Connector
- DOn-premises Data Gateway
Why this is the answer
Dataflows use Power Query Online to extract, transform, and load data into Dataverse, matching the ETL actions shown in the definition.
- Question 30Single Choice
Which feature allows you to access and query data from an external SQL Server directly inside Dataverse without moving or duplicating the data?
- ADataverse Virtual TableCorrect answer
- BDataflow
- CCustom Connector
- DOn-premises Data Gateway
Why this is the answer
Dataverse Virtual Tables surface external data within Dataverse without physically copying it, reducing duplication and storage costs.
- Question 31Multiple Select
Which two options describe common traps when building Power Platform data integration solutions? Choose two.
- ASelecting Dataflows when the requirement is to avoid data duplication.Correct answer
- BAssuming a cloud service can access a local SQL Server without an On-premises Data Gateway.Correct answer
- CUsing Virtual Tables to reduce storage costs by avoiding data copies.
- DChoosing Power BI for advanced analytical reporting.
Why this is the answer
Dataflows physically copy data, so they should not be used when the goal is to avoid duplication. Also, cloud services cannot natively access on-premises SQL Server without the Data Gateway.
- Question 32Interactive
A custom connector is being designed with the authentication methods shown in the JSON snippet. Which two authentication methods are configured? Choose two.
- AOAuth 2.0Correct answer
- BAPI KeyCorrect answer
- CBasic Authentication
- DWindows Authentication
Why this is the answer
Custom Connectors often use OAuth 2.0 and API Key authentication when connecting to REST APIs, as shown in the configuration snippet.
- Question 33Single Choice
What is the key distinction between a Power BI report and a Power BI dashboard?
- AA report is a single-page overview, while a dashboard is a detailed multi-page view.
- BA dashboard is a single-page high-level overview, while a report is a detailed multi-page view.Correct answer
- CA dashboard replaces Power BI Desktop for data modeling.
- DA report cannot be embedded in a Power App.
Why this is the answer
A dashboard is a single-page high-level overview used for monitoring critical metrics, whereas a report is a detailed multi-page view of data.
Create a Power Platform solution
8 questions in this domain
- Question 34Single Choice
Which chart type should be used to display data that changes over a continuous period of time?
- ALine chartCorrect answer
- BBar chart
- CPie chart
- DScatter chart
Why this is the answer
Line charts are best for showing trends over time; bar charts are better for categorical comparisons.
- Question 35Multiple Select
According to the playbook, which two statements correctly describe a dashboard as defined in Power Platform concepts?
- ASingle-page high-level overviewCorrect answer
- BUsed for monitoring critical metricsCorrect answer
- CDetailed multi-page view of data
- DDesigned for deep-dive analysis
Why this is the answer
A dashboard is a single-page high-level overview for monitoring key metrics; reports provide detailed multi-page views.
- Question 36Interactive
A consultant is creating a custom connector for a REST API. Review the authentication configuration in the code block. Which authentication type is being used?
- AOAuth 2.0Correct answer
- BAPI Key
- CBasic Authentication
- DAnonymous
Why this is the answer
The code block shows an OAuth 2.0 configuration with authorization and token URLs, commonly used for secured REST APIs.
- Question 37Single Choice
What is the primary role of the On-premises Data Gateway in a Power Platform solution?
- ASecure bridge between cloud and on-premises dataCorrect answer
- BPhysically migrates data to Dataverse
- CReplaces VPN in all cases
- DOnly works for SharePoint data
Why this is the answer
The On-premises Data Gateway securely connects cloud-based Power Platform services to local data without complex VPN setups.
- Question 38Multiple Select
According to the playbook, which two statements correctly describe Dataverse Virtual Tables and their behavior?
- ASurfaces external data without moving itCorrect answer
- BReduces duplication and storage costsCorrect answer
- CPhysically copies external data into Dataverse
- DRequires gateway for all external sources
Why this is the answer
Virtual tables provide a unified view of external data without physical copy, reducing duplication and storage costs.
- Question 39Interactive
A consultant uses Power Query Online to clean and transform data before loading it into Dataverse. Which component is shown in the code block?
- ADataflowsCorrect answer
- BCustom Connector
- CVirtual Table
- DOn-premises Data Gateway
Why this is the answer
Dataflows use Power Query Online to ingest, transform, and load data into Dataverse or other destinations.
- Question 40Single Choice
According to the playbook, which of the following connectors typically requires premium licensing in Power Platform?
- ASQL ServerCorrect answer
- BSharePoint
- COneDrive
- DOffice 365 Outlook
Why this is the answer
SQL Server is a premium connector; SharePoint, OneDrive, and Outlook are standard connectors included with basic Power Platform licensing.
- Question 41Multiple Select
According to the playbook, which two common visualization traps should be avoided in Power Platform solutions?
- AUsing pie chart with many categoriesCorrect answer
- BComplex 3D charts instead of simple bar chartsCorrect answer
- CLine chart for temporal trends
- DKPIs placed first in layout
Why this is the answer
Too many pie slices obscure comparisons, and complex 3D visuals violate functional design when a simple chart suffices.
Implement Power Virtual Agents chatbots
3 questions in this domain
- Question 42Single Choice
Which chart type best displays data changes over time?
- ALine chartCorrect answer
- BBar chart
- CPie chart
- DScatter chart
Why this is the answer
Line charts are best for temporal trends; bar charts compare categories, and pie charts show parts of a whole.
- Question 43Multiple Select
Which of the following are known traps to avoid with data integration and connectors? (Select all that apply.)
- ASelecting Dataflows to avoid data duplicationCorrect answer
- BAssuming cloud services can natively access on-premises SQLCorrect answer
- CConfusing Custom Connectors with DataflowsCorrect answer
- DUsing line charts for temporal trends
Why this is the answer
Dataflows physically copy data; on-premises data needs a gateway; Custom Connectors are for APIs, not data movement.
- Question 44Interactive
Review the code block. What must be created if no pre-built connector exists for this REST API?
- ACustom ConnectorCorrect answer
- BDataflow
- COn-premises Data Gateway
- DVirtual Table
Why this is the answer
A Custom Connector is needed when no pre-built connector exists for a REST API, and the code shows an external REST API with OAuth 2.0.
Frequently asked questions
Everything about the Microsoft Certified: Power Platform Functional Consultant Associate question bank and how to use it.