Qlik Sense Business Analyst Certification (2018) — Question 3

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?

Answer options

• 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ג€.

Correct answer: D

Explanation

The correct answer is D because changing the CRS to 'None' can help eliminate circular references and synthetic keys by not enforcing a coordinate reference system that could cause conflicts. The other options either do not address the root cause of the issue or may lead to data integrity problems rather than resolving the circular reference and synthetic key problems.