Exam QSBA2018 All QuestionsBrowse all questions from this exam
Question 28

Refer to the exhibit.

A business analyst must provide a visualization to show the trends of the number of orders generated per employee. The Customer must be searchable.

EmployeeID, EmployeeName, OrderID, and CustomerID will be included in the load.

Which additional fields must be loaded to meet this requirement?

    Correct Answer: C

    In order to show the trends of the number of orders generated per employee, the key requirement is to have a time component, which is provided by the OrderDate field. Additionally, since the Customer must be searchable, the Customer field is also necessary. Thus, the required fields are OrderDate and Customer.

Discussion
turchinadOption: C

C: OrderDate, Customer

[Removed]Option: C

C: OrderDate, Customer 1. Key word: TREND of the numebr of orders generated per employee trend means over time -> Order Date has to be part of the answer 2. Customer must be searchable -> Customer must be part of the answer as well