Exam QSBA2018 All QuestionsBrowse all questions from this exam
Question 20

A company has customers in 16 countries. The majority of the customers are in Germany.

A business analyst creates a filter pane for Country, and wants `Germany` listed first. The rest of the countries should be listed in alphabetical order.

Which method should the business analyst use to meet this requirement?

    Correct Answer: A

    To meet the requirement of having 'Germany' listed first and the rest of the countries in alphabetical order, the business analyst should use the custom sorting option in the chart properties panel. By editing the sheet, selecting the chart, and customizing the sort order, they can manually place 'Germany' at the top and then arrange the remaining countries alphabetically. Custom sorting allows precise control over the order of listed items, which is essential for this specific requirement.

Discussion
peachmanOption: C

A) Incorrect because you cannot have the option on the chart to 'sort by Germany' B) Incorrect because it will get Germany to the top but it wont have the rest in alphabetical order C) Correct, can you manually choose an order in the profiling card (or just code it) D) incorrect, cannot change anything from the 'Column header'

elipsaOption: C

C. In the data manager, edit the table, select Country, then select Order from the data profiling card