Welcome to ExamTopics
ExamTopics Logo
- Expert Verified, Online, Free.

Unlimited Access

Get Unlimited Contributor Access to the all ExamTopics Exams!
Take advantage of PDF Files for 1000+ Exams along with community discussions and pass IT Certification Exams Easily.

Exam QSBA2018 topic 1 question 19 discussion

Actual exam question from QlikView's QSBA2018
Question #: 19
Topic #: 1
[All QSBA2018 Questions]


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
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️
Reference:
https://mindmajix.com/snowflake-and-star-schema-in-qlikview

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
[Removed]
6 months, 3 weeks ago
Selected Answer: 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)
upvoted 1 times
...
peachman
8 months, 3 weeks ago
Selected Answer: 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
upvoted 1 times
...
elipsa
11 months, 1 week ago
Selected Answer: C
C. The OrderDate fields are different data types
upvoted 1 times
...
ELIKAINE
1 year, 2 months ago
Selected Answer: 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
upvoted 1 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...