Qlik Sense Data Architect Certification - June 2018 Release: QSDA2018

A data architect uses the Qlik GeoAnalytics connector to determine the closest airports to cities in an existing app. The built location generates 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. When selecting an operation in the Qlik GeoAnalytics connector, select Only load distinct.

B. When choosing which data to load, uncheck the non-unique field in the new data tables.

C. Concatenate the airport table and the existing tables into one master tables.

D. When selecting an operation in the Qlik GeoAnalytics connector, change the CRS to "None".

Refer to the exhibit.

A QlikView app was converted to a Qlik Sense app using the Dev Hub converter.

The new Qlik Sense app was reloaded without editing the script or the server settings, which created a

script error.

What should a data architect do to resolve the issue?

A. Delete the Qualify statement

B. Add fields to the Qualify statement

C. Use a folder connection

D. Check the QVDs

Refer to the exhibits.

The two tables have been loaded by the script shown. This script creates a synthetic key, which is not desired. The Dept code in the Employee table is incorrect for EmpID=3. The data architect must change line 27 to create a single table in the data model that is accurate.

Which LOAD statement should the data architect use?

A. JOIN LOAD EmpID, ManagerID, Level

B. KEEP LOAD EmpID, ManagerID, Level

C. JOIN LOAD *

D. CONCATENATE LOAD EmpID, ManagerID, Level