PL-400 Exam QuestionsBrowse all questions from this exam

PL-400 Exam - Question 5


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.

Show Answer
Correct Answer: AB

To efficiently manage large sets of records while allowing users to filter and sort data in a canvas app, it is crucial to implement data sources that support delegation. Delegation allows operations to be performed on the server side, thus minimizing network traffic and enhancing performance. Among the available options, SQL Server and Common Data Service (now known as Microsoft Dataverse) are the appropriate choices as they both support delegation for tabular data sources. This ensures that the app remains performant and capable of handling extensive datasets.

Discussion

30 comments
Sign in to comment
Mohor
Dec 19, 2021

A. SQL Server B. Common Data Service

Grazzz
Dec 6, 2021

I would have gone for A and B too. Explanation does not mention Azure data lakes..!?

No_DoubtOptions: AB
Apr 30, 2023

In exam option B will be "Microsoft Dataverse" Delegation is supported for certain tabular data sources only. If a data source supports delegation, its connector documentation outlines that support. For example, these tabular data sources are the most popular, and they support delegation: Power Apps delegable functions and operations for Microsoft Dataverse Power Apps delegable functions and operations for SharePoint Power Apps delegable functions and operations for SQL Server Power Apps delegable functions and operations for Salesforce

ViipiinTyagiOptions: AB
Jun 1, 2022

Correct Answer should be A and B

AlaChOptions: AB
Jun 9, 2022

A and B

ansrikanth1
Aug 5, 2022

Moderator/Admin - Answer explanation says A&B are the answer where as the actual answer showing is A&C, please correct..

emmet2021
Dec 2, 2021

Is the answer AB then?

_WMC_
Dec 28, 2021

The answer is AC. Azure Data Factory is an ETL tool and not 'delegatable'. Azure Table Storage is schemaless (meaning multiple entities can be stored in one table) and is therefore not delegatable.

_WMC_
Dec 28, 2021

Clearly I suck at proofreading my own comments. The answer is 'AB', *not* AC!

fihemal249Options: AB
May 23, 2022

View https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/delegation-overview

JainS
Dec 8, 2022

@ExamTopics, The justification, you had given is also saying SQL Server & Common Data Service. While you had marked SQL Server and Azure Data Factory. Any Specific Reason?

Shradz93
Feb 19, 2023

In explanations you are providing AB option and marking correct option as AC. What is the meaning to subscribe if you are team is that careless?

omar1988
Mar 4, 2024

man same proplem other sources dump questions saying different answers its really frustrating

AvinashGardas
Aug 19, 2024

so true man! WTF is wrong with them>?

CeliaZhou
Dec 3, 2021

So the answer should be A.SQL and B. Common Data Service

DS_CRM
Dec 14, 2021

A and B

cscssss
Jun 1, 2022

The last segment of each exam is restricted solely to users with Contributor Access. A. MONTH $ 16 .99 B. YEAR $ 23 .99

powerMasterOptions: AB
Sep 13, 2022

A,B its all About delegatiom

ProdamGarazh
Oct 12, 2024

Just fYI, Common Data Service (CDS) got rebranded into Microsoft Dataverse

joyce_00726
Dec 13, 2021

yes based on the documentation link provided

MohitRao
Apr 24, 2022

delegation can be done on tabular data https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/delegation-overview

Bukhari
Apr 29, 2022

Correct answers are AB.

AzureXin
May 17, 2022

This is clearly A, B. Thanks

MKap
Jul 19, 2022

Hi guys, A general question what does the answer in yellow "Selected answer: AB" mean?

Ami_Nou
Jul 24, 2022

It means it's a voting comment and they voted for AB

ppguruOptions: AB
Jul 30, 2022

Delegation is supported for certain tabular data sources only. If a data source supports delegation, its connector documentation outlines that support. For example, these tabular data sources are the most popular, and they support delegation: Power Apps delegable functions and operations for Microsoft Dataverse Power Apps delegable functions and operations for SharePoint Power Apps delegable functions and operations for SQL Server Power Apps delegable functions and operations for Salesforce reason 1--> Azure data factory is not mentioned in MS documentation reason 2 --> Azure is not an actual data (questions asks for data sources) source but ETL a service for scale-out serverless data integration and data transformation. https://docs.microsoft.com/en-gb/powerapps/maker/canvas-apps/delegation-overview

PBIAANFOption: B
Sep 10, 2022

100% AB

christianMaOptions: AB
Sep 11, 2022

should be A and B!

ClairFraserOptions: AB
Nov 24, 2022

see here: https://docs.microsoft.com/en-us/power-apps/maker/canvas-apps/delegation-overview

MuzeraOptions: AB
Jan 26, 2023

AB Of Course

jkaur
Sep 16, 2023

Should be CD.

jkaur
Sep 16, 2023

Should be AB

4e8b388Options: BD
Oct 24, 2024

I don't know why everyone omits Azure Table storage as a valid option? Azure Table Storage supports delegation for basic filtering and sorting operations. We don't expect something super complex in terms of sorting and filtering in the Canvas app from the users, right? SQL Server does not fully support delegation for all functions. Additionally Azure Table Storage is is designed for scalability and can handle large datasets, which is one of the conditions (large sets of records). In my opinion correct answers are BD.

5f14337Options: AB
Apr 20, 2025

C. Azure Data Factory - Not a data source for canvas apps. D. Azure Table Storage - Limited delegation support.