ExamTopics Logo
Mail Us[email protected]
Menu
Qlikview Discussions
exam questions

Exam QSDA2018 All Questions

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

Exam QSDA2018 topic 1 question 11 discussion

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

Refer to the exhibit.

A major healthcare organization requests a new app with the following requirements:
✑ Users can filter AdmissionDate and DischargeDate by all fields in the master Calendar table
✑ Use an existing QVD file, which includes dates 20 years into the future
✑ Users should not be able to filter on dates that have no associated encounters
Which approach should the data architect take to meet these requirements?

  • A. 1. Load the Encounters table 2. Perform a Left Join Load on the Encounters table to the master calendar and alias the date fields appropriately for the Admission Date 3. Perform a Left Join Load on the Encounters table to the master calendar and alias the date fields appropriately for the Discharge Date
  • B. 1. Load the master calendar 2. Create two mapping tables called AdmissionCalendar and DischargeCalendar from the Resident master calendar that has all fields appropriately named 3. Load the Encounters and use ApplyMap for the AdmissionDate and DischangeDate appropriately.
  • C. 1. Load the Master Calendar and Encounters tables. 2. Perform a Join Load on the Encounters table to the Resident master calendar and alias the date fields appropriately for the Admission Date 3. Perform a Join Load on the Encounters table to the Resident master calendar and alias the date fields appropriately for the Discharge Date
  • D. 1. Load the master calendar as AdmissionCalendar and alias the fields to reflect they are for Admission 2. Load the master calendar as Discharge Calendar and alias the fields to reflect they are for Discharge 3. Load the Encounters table
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️
by thebruuu at Jan. 3, 2025, 11:53 p.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
thebruuu
1 week, 4 days ago
Selected Answer: A
B is wrong as ApplyMap in Qlik is used for mapping a specific field value to another value or returning a default value when there is no match. However, it doesn't generate or map entire tables or create a full set of fields from the master calendar for each encounter date.
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
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago