Welcome to ExamTopics
ExamTopics Logo
- Expert Verified, Online, Free.
Mail Us[email protected]
Menu
Qlikview Discussions
exam questions

Exam QSBA2018 All Questions

View all questions & answers for the QSBA2018 exam
Go to Exam

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: C 🗳️
by ELIKAINE at Jan. 28, 2023, 7:12 p.m.

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
Submit Cancel
[Removed]
1 year, 2 months 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
1 year, 4 months 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
1 year, 7 months ago
Selected Answer: C
C. The OrderDate fields are different data types
upvoted 1 times
...
ELIKAINE
1 year, 10 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
...

Get IT Certification

Unlock free, top-quality video courses on ExamTopics with a simple registration. Elevate your learning journey with our expertly curated content. Register now to access a diverse range of educational resources designed for your success. Start learning today with ExamTopics!

Start Learning for free
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