Skip to Content

PL-400: Which Query Method is Best for Aggregated Results Across Multiple Dataverse Tables?

By: Author Alex Lim

Posted on

Categories Exam

How to Use FetchExpression for Advanced Queries with Aggregation in Dataverse?

Table of Contents

Question

You are creating an integration with Dataverse using the Organization service.

You need to run queries against multiple Dataverse tables and return aggregated results.

Which query method should you use?

Select only one answer.

A. LINQ
B. QueryExpression
C. FetchExpression
D. QueryByAttribute

Answer

C. FetchExpression

Explanation

This item tests the candidate’s knowledge of performing operations with the Organization service.

FetchExpression uses the FetchXML query language and can group results into aggregated values. QueryExpression and QueryByAttribute do not support aggregations and can only return lists of table rows. The implementation of LINQ only provides a limited set of LINQ’s capabilities and does not support aggregations.

Microsoft Power Platform Developer PL-400 certification exam practice question and answer (Q&A) dump with detail explanation and reference available free, helpful to pass the Microsoft Power Platform Developer PL-400 exam and earn Microsoft Power Platform Developer PL-400 certification.