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

1. 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 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
C) 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
D) 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

2.
Refer to the exhibit.
A data architect meeds to resolve a synthetic key and make sure that users can see the unique department name and hospital name for each order Which action should the data architect take?

A) Remove HospitallD from the LOAD statement for the Orders table
B) Remove Departments from the LOAD statement for the Orders table
C) Remove the Departments table from the LOAD script
D) Remove the Hospitals table from the LOAD script

3. 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 issue1?

A) Check the QVDs
B) Use a folder connection
C) Add fields to the Qualify statement
D) Delete the Qualify statement

4. Refer to the exhibit.

An existing app on Qlik Sense Enterprise is duplicated and transferred to a data architect to add some additional data When trying to manually reload the original script, the data architect receives an error.
What should be done to make sure the script runs correctly?

A) Give the data architect the Read rights on the data connections in the QMC.
B) Make the data architect the owner of the app in the QMC.
C) Add the line lib connect to ' ovd (abc_qservice/0EderData. qvd)'; before the LOAD for the OrderData table
D) Add the line lib connect to ' sql (abc_qservice) *; before the LOAD for the OrderDetail table

5. A data architect must br*ak down a 13-character ShipmentID code in the following format, #-###-##-##-#.
Separate fields must be created from the numeric values separated by the hyphen (-). The data architect must extract five sub-fields (ShipmentLoc, Quantity. CategorylD. StoreLoc. and Division) from the 13-character code How should the data architect meet this requirement?

A) In the data load editor, load the ShipmentID field and apply the PurgeChar(ShipmentlD,'-') function
B) In the data load editor, load the ShipmentID field and apply the KeepCharQ and Trim() functions
C) In the data manager, use the data profiling card to split the ShipmentID by the'-' character
D) In the data manager, use the data profiling card to replace the'-' characters in the ShipmentID

Solutions: