Exam QSBA2018 All QuestionsBrowse all questions from this exam
Go to Exam
Question 19

Refer to the exhibit.

A business analyst is testing an existing app that returns unexpected results.

✑ Using the selection tool, the business analyst observes the following behavior.

✑ Select a CompanyName and the associated OrderID records are white

✑ Select a Year and all OrderID records are gray

✑ Select an OrderID and the Quarter values are all gray, but the CompanyNames are white

✑ Select a ProductID and the associated ShipperName and OrderDates are white, but the Year is gray

What is causing these results?

    Correct Answer: C

    The issue described, where selections in one field result in unexpected behaviors in associated fields, suggests a problem with the join conditions or relationships between the tables. Specifically, the grey fields indicating no selection possible based on the filter point to a mismatch when joining on date fields. This typically occurs when the date fields in the tables are of different data types or have differing formats, preventing proper joins. Therefore, the most likely cause of the unexpected results is that the OrderDate fields are different data types.

Discussion
[Removed]Option: C

C: The OrderDate fields are different data types Coloring of the filds is here the key. Grey means no selection possible based on the filter. This happes everytime when selecting a date dimension -> problem araises when joning the date fields: format doesn't match (different data types)

peachmanOption: C

A) Incorrect because OrderID is not a Date field B) Incorrect you can join on dates and the joins are fine C) Correct the date formats must not be in sync, so there is no Join being made (you could check this by checking the join rate in the data model viewer on the column) D ) incorrect just isnt this

elipsaOption: C

C. The OrderDate fields are different data types

ELIKAINEOption: C

Select a Year and all OrderID records are gray, están directamente relacionadas y se ven en gris, pues quiere decir que ORDERDATE de cada tabla es diferente, está mezclando churras con merinas