Qlik Sense Data Architect Certification Exam - June 2018 Release Sample Questions:

1. A health system needs to analyze patient admissions and discharges in a chart with a common date axis that looks like the chart below.

The initial data table (InpatientEncounters) contains a patient admission date and a discharge date for each patient encounter. The data architect will use set analysis to calculate the number of admissions and discharges in the chart.

The data architect needs to design a data model with a minimum number of tables. Which tables should the data architect create to meet these requirements?

A) DateLink, AdmissionCalendar. and DischargeCalendar
B) AdmissionCalendar, DischargeCalendar, and CommonCalendar
C) DateLink and CommonCalendar
D) AdmissionCalendar and DischargeCalendar

2. A data architect uses the Qlik GeoAnalytics connector to determine the closest airports to cities in an existing app. The built-in location servicetjenerates data for the airport locations The data load editor runs the script and sees a circular reference and a synthetic key How should the data architect fix these issues'?

A) Concatenate the airport table and the existing tables into one master table.
B) When selecting an operation in the Qlik GeoAnalytics connector, change the CRS to 'None".
C) When choosing which data to load, uncheck the non-unique field in the new data tables.
D) When selecting an operation in the Qlik GeoAnalytics connector, select Only load distinct .

3.


Refer to the exhibits
Business analysts report data issues in the Value field of a table since the latest reload of the data What is causrng this issue?

A) Null values in the source data
B) Some categories do NOT exist in the Category table
C) Hyphen characters (' -') in the source data
D) Pre-aggregated data is being used

4. Refer to the exhibit.

A fashion retail company needs to analyze data about product inventory. The company needs to filter by attributes by such as color, material, and size.
Which strategy should a data architect use to meet these requirements?

A) Use crosstable in the load statement to unpivot
B) Use the hierarchy load statement to expand hierarchy levels
C) Turn data rows into fields by using a generic load
D) Loop through the table to transpose fields

5. 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) Date(InMonth([Conmon Date]),'MMM-YYYY')
B) Date([Common Date],'MMM-YYYY')
C) Date (MonthsStart ([Common Dace]),'MMM-YYYY'
D) Date(MonthStart([Common Date]), *MMM-YYYY')

Solutions: