1Z0-007 · Question #41
In which scenario would TOP N analysis be the best solution?
The correct answer is D. You want to rank the top three sales representatives who have sold the maximum number of products. If you want to rank the top three sales representatives who have sold the maximum number of products TOP-N query will be the best solution. TON-N queries use inline views and are handy for displaying a short list of table data, based on "greatest" or "least" criteria. Incorrect…
Question
In which scenario would TOP N analysis be the best solution?
Options
- AYou want to identify the most senior employee in the company.
- BYou want to find the manager supervising the largest number of employees.
- CYou want to identify the person who makes the highest salary for all employees.
- DYou want to rank the top three sales representatives who have sold the maximum number of products.
How the community answered
(36 responses)- A6% (2)
- B3% (1)
- C11% (4)
- D81% (29)
Explanation
If you want to rank the top three sales representatives who have sold the maximum number of products TOP-N query will be the best solution. TON-N queries use inline views and are handy for displaying a short list of table data, based on "greatest" or "least" criteria. Incorrect Answers A: To complete this request you don't need to use TOP-N query. B: It is not necessary to use TOP-N query in this case. C: To complete this request you don't need to use TOP-N query.
Topics
Community Discussion
No community discussion yet for this question.