QlikView QlikView Certifications QSDA2019 Questions & Answers

• Question 31:

  Refer to the exhibit.

  

  A shipping company needs to track its shipments using Qlik Sense A data architect has the data in Excel as shown on the left Business rules state that if the ShipmentDate field is empty, it should be populated with the first valid previous date as shown on the right.

  Which script should the data architect use to meet this requirement?

  

  A. Option A

  B. Option B

  C. Option C

  D. Option D

  Correct Answer: A

• Question 32:

  A data architect executes the following script:

  

  What will Field_1 contain after this script is executed?

  A. Abcd, abcd

  B. abed

  C. Abed. abed. ABCD, ABCDABCD

  D. Abcd, abcd. ABCD

  Correct Answer: A

• Question 33:

  Refer to the exhibit.

  

  A. The UserAccess table contains seven fields Year Month, Hourr AccesslD. AccessDate. UserlD, and Duration (minutes) The table is only linked to Users on the UserlD field

  B. The UserAccess Table contains seven fields: Year, Month. Hour. AccessID, AccessDate. UserlD, and Duration (minutes) The table is linked to the Access table with the AccessID field and linked to Users on the UserlD field

  C. The UserAccess table contains seven fields AccessYear, AccessMonth, Hour AccesslD, AccessDate, UserlD, and Duration (minutes) The table is only linked to Users on the UserlD field

  D. The UserAccess table contains seven fields AccessYear. AccessMonth. Hour. AccesslD, AccessDate. UserlD. and Duration (minutes) The table is linked to the Access table on the AccesslD field and linked to Users on the UserlD field

  Correct Answer: D

• Question 34:

  A data architect creates a collection of large QVD files that propagate data into their apps This solution works well. However, a new app that uses a subset of the data in a QVD takes much longer than expected to reload The LOAD statement is

  

  Which two changes should be made to improve load performance? (Select two ) A)

  

  B)

  

  C)

  

  D)

  

  A. Option A

  B. Option B

  C. Option C

  D. Option D

  Correct Answer: A

• Question 35:

  Refer to the exhibit.

  

  A company has different departments Executive and Sales should always be the first values in a

  Department filter pane.

  Which script must the data architect use to meet this requirement?

  A)

  

  B)

  

  C)

  

  D)

  

  A. Option A

  B. Option B

  C. Option C

  D. Option D

  Correct Answer: C

• Question 36:

  A data architect builds a data model for a large user group. Some sheets will be published, and the app will

  allow users to create their own visualizations and analyze data. Some fields must NOT appear in any field

  list.

  How should a data architect meet these requirements?

  A. Use HidePrefix variable

  B. Add fields to master items

  C. Use security rules

  D. Use HideField variable

  Correct Answer: A

• Question 37:

  Refer to the exhibit.

  

  A data architect needs to analyze the number of orders by customer. The data is stored in two Excel files: Orders and Customers The data architect creates a bar chart, but the data is obviously incorrect.

  What should the data architect do to resolve this issue?

  A. Open the data manager, split the Customers table, and Concatenate Orders and Customers on the CustomerlD field

  B. Open the data manager split the Customers table, and associate on CustomerlD

  C. Open the data load editor, use CONCATENATE to concatenate Orders and Customers

  D. Open the data load editor, rename the CustomerlD field, and concatenate Orders and Customers

  Correct Answer: A

• Question 38:

  A data architect wants to combine data on present and historic sales performance. The historic data is

  stored in a de-normalized archive, and the present data is maintained in a database. The output must be

  contained in a single table.

  Which script should the data architect use?

  

  

  A. Option A

  B. Option B

  C. Option C

  D. Option D

  Correct Answer: A

• Question 39:

  A company decides to migrate all apps from QlikView to Qlik Sense. After converting an apps: there are several unconverted objects.

  What should the data architect do?

  A. Save the unconverted objects as extensions and import them into Qlik Sense

  B. Remove the set analysis statements from the unconverted objects

  C. Re-create the unconverted objects

  D. Save the unconverted objects as master items

  Correct Answer: A

• Question 40:

  Refer to the exhibit.

  

  A data architect needs to modify the script to ONLY load rows fromTabl e_B when Field_1 and Field_2 are the same as inTabl e_A. (For example, only the row containing A. 1. 456 should be loaded fromTabl e_B ) Which script should the data architect use?

  

  

  A. Option A

  B. Option B

  C. Option C

  D. Option D

  Correct Answer: D