Exam QSBA2018 All QuestionsBrowse all questions from this exam
Question 22

Refer to the exhibits.

A business analyst must improve the first chart shown to make it look like the second chart.

Which two actions should the business analyst take to meet this requirements? (Choose two.)

    Correct Answer: A, C

    The first chart needs to be modified to use only one measure for Total Sales instead of separate measures for each year, and to add Year as an additional dimension. This resolves the need to represent different years within the same axis and allows the chart to correctly stack and compare sales across different years.

Discussion
peachmanOptions: AC

A & C: Correct because you need to use just the sales measure & make sure the chart knows to 'stack' the years by adding that as a Dim to the timeline. B: Incorrect because you need to stack the chart, you still need it to overlap D: Incorrect because you dont need to change the 'Continuous chart' prop as it appears correct already E: Incorrect because: the area element of the chart is already present so doesnt need changing

elipsaOptions: AC

A. Replace the three measures with one measure that calculated Total Sales C. Add Year as an additional dimension

ELIKAINEOptions: AC

There are 3 measures in the 1º chart and 1 measure in the 2º. The Year Dimension is added as a additional dimension