Q: 5
HOTSPOT You need to correct the portal query issues. Which code should you use? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. 
Your Answer
Discussion
Seen similar in the official guide, you'd use $select for picking columns, $orderby for sorting.
Yeah, that's right. $select for new registrations, $orderby for all registered users
GET [ORG URI]/api/data/v9.1/accounts?$select=name,sport for new registrations, $orderby=name,sport for all registered users. $select picks fields, $orderby sorts the records. Pretty sure that's what they want unless they were asking for date-based filtering.
$filter is tempting but that's for filtering rows, not picking columns. Here it's $select for fields, $orderby for sorting. Trap question.
Nah, $filter is a trap here. $select is just for the fields (name, sport), and $orderby=name,sport is correct syntax for sorting. Saw a similar question in practice, so pretty sure that's it.
Not $filter-$select just picks fields, not records. $orderby=name,sport is valid sorting. Trap is mixing up field selection with filtering.
$select for new registrations, $orderby=name,sport for all registered users. If we had to filter rows, $filter would flip things.
GET [ORGANIZATION URI]/api/data/v9.1/accounts?$select=name,sport for new registrations, $orderby=name,sport for all registered users. Saw a similar one in practice sets.
Nah, $filter is a trap here. It's $select for limiting fields and $orderby for sorting.
Yeah, $select for fields and $orderby for sorting.
Be respectful. No spam.