File Info
| Exam | Qlik Sense Data Architect Certification Exam |
| Number | QSDA2018 |
| File Name | QlikView.QSDA2018.CertKiller.2019-04-05.23q.tqb |
| Size | 3 MB |
| Posted | Apr 05, 2019 |
| Download | QlikView.QSDA2018.CertKiller.2019-04-05.23q.tqb |
How to open VCEX & EXAM Files?
Files with VCEX & EXAM extensions can be opened by ProfExam Simulator.
Coupon: MASTEREXAM
With discount: 20%
Demo Questions
Question 1
A healthcare organization needs an app to track patient encounters, patient lab orders, and patient medications.
- Encounters, lab orders, and medication data are maintained in three separate tables linked by PatientID
- PatientID values in all three tables are completely accurate
- Patients may have encounters without lab orders or medications
The data architect needs to make sure that the count of patient lab orders is correct.
Which method should the data architect to meet this requirement?
- Load all three tables, create a copy of PatientID in the lab orders table as LabPatientID, and use Count(Distinct LabPatientID)
- load all three tables and use Count(Distinct PatientID)
- load all three tables and use Count(PatientID)
- Load all three tables, create a copy of PatientID in the lab orders table as LabPatientID, and use count (LabPatientID)
Correct answer: D
Question 2
Refer to the exhibit.
A data architect needs to build a sales dashboard. Data is stored in a legacy database. The extracted data contains the date in the format, ‘YYYDDMM’. Due to the source date format, the dates are being loaded as numbers.
Which function should the data architect use to fix this issue?
- Timestamp
- Date
- Date#
- Timestamp#
Correct answer: C
Question 3
Refer to the exhibit.
The business analyst previews some data and notices different values for the United States in the Country field. The analyst must be able to report the total sales for the United States. The data architect must fix this issue in the LOAD script.
Which function should the data architect use to fix data quality issue?
- Switch
- ApplyMap
- Case
- Replace
Correct answer: B
Explanation:
Reference: https://community.qlik.com/t5/QlikView-App-Development/Help/td-p/921736 Reference: https://community.qlik.com/t5/QlikView-App-Development/Help/td-p/921736
