nerdexam
Microsoft

PL-400 · Question #125

You plan to create a canvas app to manage large sets of records. Users will filter and sort the data. You must implement delegation in the canvas app to mitigate potential performance issues. You…

The correct answer is A. SQL Server B. Common Data Service. Delegation in Power Apps canvas apps means the data source - not the app - processes filter, sort, and other query operations server-side, allowing the app to work with large datasets beyond the 500/2000 record local limit. SQL Server (A) and Common Data Service/Dataverse (B)…

Submitted by javi_es· Apr 18, 2026

Question

You plan to create a canvas app to manage large sets of records. Users will filter and sort the data. You must implement delegation in the canvas app to mitigate potential performance issues. You need to recommend data sources for the app. Which two data sources should you recommend? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

Options

  • ASQL Server
  • BCommon Data Service
  • CAzure Data Factory
  • DAzure Table Storage

How the community answered

(31 responses)
  • A
    77% (24)
  • C
    16% (5)
  • D
    6% (2)

Explanation

Delegation in Power Apps canvas apps means the data source - not the app - processes filter, sort, and other query operations server-side, allowing the app to work with large datasets beyond the 500/2000 record local limit. SQL Server (A) and Common Data Service/Dataverse (B) both have robust delegation support for functions like Filter, Sort, Search, and LookUp. Azure Data Factory (C) is an ETL/data integration pipeline service and is not a supported direct connector for canvas app delegation. Azure Table Storage (D) has very limited delegation support in Power Apps, making it unsuitable for large-scale filtering and sorting requirements.

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full PL-400 Practice