hardMultiple Choice
PL-900 Practice Question: Refer to the exhibit
Exhibit
Refer to the exhibit.
{
"dataverse": {
"tables": [
{
"name": "cr5f3_orders",
"columns": [
{"name": "cr5f3_ordernumber", "type": "string"},
{"name": "cr5f3_total", "type": "money"}
]
}
]
}
}Refer to the exhibit. A Power Pages site configuration defines a custom table. The site needs to display a list of orders sorted by the total in descending order. What must be done?
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
Set the 'Sort Column' property of the list component to 'cr5f3_total' and direction to descending.
The list component in Power Pages can be configured with a default sort order using the 'Sort Column' property. The exhibit shows a table definition; the sort order is not set here. Adding an index is unnecessary for sorting in a list view. Changing the column data type or using C# code is not relevant.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Write a custom C# plugin to sort the data.
Why it's wrong here
A plugin runs server-side on Dataverse events and cannot control how a Power Pages list renders its ordering. Plugins are tempting because they handle complex business logic on record changes, which would be correct if the requirement were validation or calculated values rather than display sorting.
- ✗
Change the column data type to integer for sorting.
Why it's wrong here
Changing the column to integer alters the stored data type, not the list's sort configuration, and totals may require decimals. It is tempting because integer columns sort predictably, which would matter if the column were text and sorting alphabetically instead of numerically.
- ✗
Add an index on the cr5f3_total column in Dataverse.
Why it's wrong here
An index speeds up query execution but does not set the sort order a Power Pages list displays. Indexing is tempting because it is the correct Dataverse action when large tables cause slow filtered queries, not when the requirement is simply ordering displayed results.
- ✓
Set the 'Sort Column' property of the list component to 'cr5f3_total' and direction to descending.
Why this is correct
Setting the list component's Sort Column to the logical name 'cr5f3_total' with descending direction satisfies the stem's ordering constraint directly, since Power Pages lists sort server-side using the table's column logical name rather than display name. This returns orders highest total first without client-side scripting or custom views.
Go deeper
Related to this question
About these practice questions
This PL-900 question is part of Courseiva's 701-question bank — original exam-style content with full explanations and wrong-answer analysis, never real exam questions or exam dumps. Learn why practice questions differ from exam dumps →
JA
Written by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
This PL-900 practice question is part of Courseiva's free Microsoft certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the PL-900 exam.