nerdexam
Microsoft

PL-400 · Question #390

You are creating a FetchXML query. The query must return data from a table and return filtered data from a related table. You need to configure the FetchXML query. Which two elements should you use?…

The correct answer is B. link-entity D. condition. FetchXML uses link-entity (B) to perform a JOIN to a related table, equivalent to a SQL JOIN - it specifies the related table name, the linking attributes, and the join type. The condition element (D) is used inside either the main entity or the link-entity to apply filter…

Submitted by yousef_jo· Apr 18, 2026

Question

You are creating a FetchXML query. The query must return data from a table and return filtered data from a related table. You need to configure the FetchXML query. Which two elements should you use? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

Options

  • Aattribute
  • Blink-entity
  • Calias
  • Dcondition

How the community answered

(49 responses)
  • A
    14% (7)
  • B
    80% (39)
  • C
    6% (3)

Explanation

FetchXML uses link-entity (B) to perform a JOIN to a related table, equivalent to a SQL JOIN - it specifies the related table name, the linking attributes, and the join type. The condition element (D) is used inside either the main entity or the link-entity to apply filter criteria (equivalent to a SQL WHERE clause), which is what 'filtered data from a related table' requires. The attribute element (A) specifies which columns to return but does not handle filtering. The alias element (C) renames output columns and is optional. Together, link-entity and condition are the two structural elements needed to join and filter a related table in FetchXML.

Community Discussion

No community discussion yet for this question.

Full PL-400 Practice