Qlik QSDA2018 問題集

質問 1：
The data model from an existing Qlik Sense app needs to be reused in another Qlik Sense app.
Which load strategy should a data architect use to transfer this data in the most efficient way?
A. Binary load
B. QVD load
C. Preceding load
D. Generic load
正解：A

質問 2：
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?
A. Load all three tables and use Count(PatientlD)
B. Load all three tables, create a copy of PatientID in the lab orders table as LabPatientID, and use Count(Distinct LabPatientID)
C. Load all three tables, create a copy of PatientID in the lab orders table as LabPatientID, and use Count(LabPatientlD)
D. Load all three tables and use Count{Distinct PatientID)
正解：B

質問 3：
The data model from an existing Qlik Sense app needs to be reused in another Qlik Sense app.
Which load strategy should a data architect use to transfer this data in the most efficient way?
A. Binary load
B. QVD load
C. Preceding load
D. Generic load
正解：A

質問 4：
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. When choosing which data to load, uncheck the non-unique field in the new data tables.
B. Concatenate the airport table and the existing tables into one master table.
C. When selecting an operation in the Qlik GeoAnalytics connector, select Only load distinct .
D. When selecting an operation in the Qlik GeoAnalytics connector, change the CRS to 'None".
正解：D

質問 5：
Refer to the exhibit.

A global company recently released an app that uses much more memory than similar apps have used When reviewing data in the data manager, the data architect observes that several fields use Globally Unique Identifiers (GUIDs). There is one key field. Other fields are used for different KPIs to count the number records. The data architect must reduce the memory used as much as possible. Which steps should a data architect take to meet these requirements?
A. 1 Use the AutoNumber function to convert the linking GUIDs to numbers
2 Replace the non-key GUID fields with a flag, and use them to get a unique count for KPIs
B. 1. Use the IterNoQ function to convert the linking GUIDs to numbers
2 Replace the non-linking GUID fields with RowNo() to create an Index field and use to get a unique count for KPI
C. 1 Replace the non-key field GUIDs with RowNoQ to maintain a field that can be used to get a unique count 2. Split the linking GUID fields into five sections using the SubField function to reduce the uniqueness
D. 1 Use the AutoNumber function to convert the linking GUIDs to numbers
2. Use Indexing for non-key GUID fields to create an Index field and use to get a unique count for KPIs
正解：B