Free QSDA2018 Questions for Qlik Sense Data Architect Certification Exam - June 2018 Release QSDA2018 Exam as PDF & Practice Test Engine
Refer to the exhibit.
A data architect has two tables that contain Sales and Target data for employees. The tables are loaded into Qlik Sense and are associated by EmployeelD.
The data architect creates a bar chart of total Sales vs. Target. The architect notices some values for Target are too high, and employees with NO sales should be excluded Which function should the data architecwise to resolve these issues?
A data architect has two tables that contain Sales and Target data for employees. The tables are loaded into Qlik Sense and are associated by EmployeelD.
The data architect creates a bar chart of total Sales vs. Target. The architect notices some values for Target are too high, and employees with NO sales should be excluded Which function should the data architecwise to resolve these issues?
Correct Answer: C
Vote an answer
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?
* 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?
Correct Answer: B
Vote an answer
Stock levels are stored online in a system that keeps information for the current period only.
What should the data architect do to enable analysis of the trends of the stock levels?
What should the data architect do to enable analysis of the trends of the stock levels?
Correct Answer: A
Vote an answer
Refer to the exhibit.
The data model shown has a synthetic key for information that contains actual sales and budget sales for a multi-national company As a business requirement, users must be able to drill down by department and country. Datajnust not be lost.
Due to data quality issues, some departments are NOT included in the Sales and Budget tables.
The data architect needs a method to eliminate synthetic keys that generates the fastest performing data model Which method should the data architect use?
The data model shown has a synthetic key for information that contains actual sales and budget sales for a multi-national company As a business requirement, users must be able to drill down by department and country. Datajnust not be lost.
Due to data quality issues, some departments are NOT included in the Sales and Budget tables.
The data architect needs a method to eliminate synthetic keys that generates the fastest performing data model Which method should the data architect use?
Correct Answer: B
Vote an answer
Refer to the exhibit.
A system creates log files and csv files daily and places these files in a folder. The log files are named automatically by the source system and change regularly. All csv files must be loaded into Qlik Sense for analysis.
Which method should be used to meet the requirements?
A)
B)
C)
D)
A system creates log files and csv files daily and places these files in a folder. The log files are named automatically by the source system and change regularly. All csv files must be loaded into Qlik Sense for analysis.
Which method should be used to meet the requirements?
A)
B)
C)
D)
Correct Answer: C
Vote an answer
Refer to the exhibit
A chart for monthly hospital admissions and discharges incorrectly displays the month and year values on the x-axis.
The date format for the source data field "Common Date" is M/D/YYYY This format was used in a calculated field named "Month-Year" in the data manager when the data model was first built.
Which expression should the data architect use to fix this issue?
A chart for monthly hospital admissions and discharges incorrectly displays the month and year values on the x-axis.
The date format for the source data field "Common Date" is M/D/YYYY This format was used in a calculated field named "Month-Year" in the data manager when the data model was first built.
Which expression should the data architect use to fix this issue?
Correct Answer: D
Vote an answer
0
0
0
10