QSBA2018 Exam QuestionsBrowse all questions from this exam

QSBA2018 — 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?

Show Answer
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

2 comments
Sign in to comment
turchinadOption: C
Oct 6, 2023

C: OrderDate, Customer

[Removed]Option: C
Sep 5, 2023

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