Home » Microsoft » PL-400 v.2 » Which two data sources should you recommend?
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.
A. SQL Server
B. Common Data Service
C. Azure Data Factory
D. Azure Table Storage
Correct Answer: AC
Explanation/Reference:
When you are creating reports from large data sources (perhaps millions of records), you want to minimize network traffic.
Working with large data sets requires using data sources and formulas that can be delegated. It’s the only way to keep your app performing well and ensure users can access all the information they need. Delegation is supported for certain tabular data sources only.
These tabular data sources are the most popular, and they support delegation:
Common Data Service
SharePoint
SQL Server
Reference: https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/delegation-overview