What is causing these results?

Posted by: Pdfprep Category: QSBA2018 Tags: , ,

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?
A . OrderID should be the key field in the MasterCalendar
B . The logical model is NOT a star schema
C . The OrderDate fields are different data types
D . MasterCalendar should be associated to the OrderDetails table

Answer: B

Explanation:

Reference: https://mindmajix.com/snowflake-and-star-schema-in-qlikview

Leave a Reply

Your email address will not be published.