QlikView QlikView Certifications QSDA2022 Questions & Answers

• Question 41:

  Refer to the exhibits.

  

  A business analyst needs to see the currency conversion provided by a third party process, and only contains a record when the rate changes in a chart. The currency conversion rate data is

  An existing master calendar exists in the data model that contains a full set of dates.

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

  A. Utilize INTERVALMATCH to load the currency conversion rate between dates the conversation changed INNER JOIN the resultant table back into the master calendar

  B. OUTER JOIN the calendar with the currency conversion table ORDER BY the date and use the PEEK function to fill in blank values

  C. Leverage a FOR loop between the start date and end date of the master calendar Use the MATCH function to add the currency conversion rates to the master calendar

  D. Use ITERNO and AUTOGENERATE to create a new calendar from max and min dates of the currency conversion table

  Correct Answer: B

• Question 42:

  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: C

  Explanation: After migrating an app from QlikView to Qlik Sense, there may be some unconverted objects. In this case, the data architect should re-create the unconverted objects in order to ensure that the app works properly in Qlik Sense. The other options will not work, as saving the unconverted objects as extensions or master items will not ensure that the app works properly, and removing set analysis statements will not help either. qlik-sense-certification-exam-study-guide-en.pdf https://www.qlik.com/us/-/media/files/training/global-us/qlik-sense-certification-exam-study- guide-en.pdf?la=enandhash=9DA9DEBC7D27BF1CA8373E81F2614C85

  Talk to Experts Tuesday - Migrating from QlikView to Qlik Sense FAQ https://community.qlik.com/t5/Support-Knowledge-Base/Talk-to-Experts-Tuesday- Migrating-from-QlikView-to-Qlik-Sense/ta-p/1746935 Certifications and Qualifications | Qlik https://www.qlik.com/us/services/training/certifications-and-qualifications

• Question 43:

  The Marketing department is using some similar KPIs in different apps that need to be modified frequently according to the business needs. The KPIs are created using master items with the same expression.

  Which method should the data architect use to manage the modifications in all apps?

  A. Create a variable repository and load them using INCLUDE statements in the apps where needed

  B. Create a selection app with all the master items and use an on-demand app generation method.

  C. Create a core app with all the master items needed and use a BINARY load in the other apps.

  D. Create only a single app with all the master items needed and protect it with SECTION ACCESS.

  Correct Answer: A

  Explanation: This method allows the data architect to store the KPIs in a single repository and then use INCLUDE statements to load them into the other apps. This makes it easy to modify the KPIs in one place and have the changes

  reflected in all the apps.Source: Qlik A variable repository is a central location where all of the master items used in the apps can be stored and managed. By creating a variable repository and loading the master items into each app using

  INCLUDE statements, the data architect can make modifications to the master items in one place, and the changes will be automatically propagated to all of the apps that use the master items.

  This method allows for easy management of the master items and eliminates the need to make changes to each app individually, which can be time-consuming and prone to errors.

• Question 44:

  A data architect needs to develop a script to export tables from a model based upon rules from an independent file. The structure of the text file with the export rules is as follows:

  

  These rules govern which table in the model to export, what the target root filename should be, and the number of copies to export.

  The TableToExport values are already verified to exist in the model.

  In addition, the format will always be QVD, and the copies will be incrementally numbered.

  For example, the Customer table would be exported as:

  What is the minimum set of scripting strategies the data architect must use?

  A. Two loops without any conditional statement

  B. One loop and two IF statements

  C. Two loops and one IF statement

  D. One loop and one SELECT CASE statement

  Correct Answer: D

  Explanation: The data architect will need to use a single loop to iterate through the rows of the independent file containing the export rules. Within the loop, they will need to use a SELECT CASE statement to determine which table in the model to export based on the TableToExport value in the current row of the independent file. They can then use the StoreAsFilename value to determine the target root filename, and the NumberOfCopies value to determine the number of copies to export. This approach makes use of a single loop to iterate through the rows of the independent file, and a SELECT CASE statement to determine which table to export based on the TableToExport value in the current row. It is the most efficient way to accomplish the task with minimal scripting. You can find the Qlik scripting documentation for Store statement here:https://help.qlik.com/en-US/sense/June2020/Subsystems/Hub/Content/Scripting/ScriptPrefixes/Store.htmand SELECT CASE statement here:https://help.qlik.com/en- US/ sense/June2020/Subsystems/Hub/Content/Scripting/ScriptStatements/Select.htm

• Question 45:

  Multiple department fields in a dataset require a description A data architect needs to add the department descriptions or a default value when the department does NOT have a description Which strategy should the data architect use to meet these requirements?

  A. ApplyMap with two parameters after the Mapping load

  B. Left Join between tables and Description xlsx in every Department table

  C. Enter "Missing description" in the blank rows for Description xlsx then Mapping Load

  D. ApplyMap with three parameters after the Mapping load

  Correct Answer: D

  Explanation: This strategy involves using the ApplyMap function with three parameters after the Mapping load. This will allow the data architect to add the department descriptions or a default value when the department does not have a description.Source: Qlik

• Question 46:

  Refer to the exhibit.

  

  This table contains information about the number of admissions and discharges of patients in a hospital. The values can be positive or negative. The data architect needs to create an extra column that contains the number of patients that are currently in the hospital.

  Which script should the data architect use ?

  

  A. Option A

  B. Option B

  C. Option C

  D. Option D

  Correct Answer: A

• Question 47:

  Refer to the exhibits.

  

  While debugging an app, a developer loads data from an application layer QVD file.

  In the process of separating a concatenated key into two parts, some split results are missing data

  What should the data architect do?

  A. Utilize a combination of LEFT(), MID(), and RIGHT() functions to capture the key components

  B. In the SUBFIELD function, replace the `_' with a `|' or `_' character.

  C. Utilize a combination of LEFT(), MID(), and RIGHTO functions to capture the key components

  D. In the SUBFIELD function, replace the '- with a `|' or '-' character

  E. Instruct the developer of the QVD file to correct the generation of the ConcatKeyAlpha field

  F. Wrap an IF() function around the SUBFIELDQ functions to check and adapt to null values character

  G. Instruct the developer of the QVD file to correct the generation of the ConcatKeyAlpha field

  H. Wrap an IF() function around the SUBFIELD() functions to check and adapt to null values

  Correct Answer: D

• Question 48:

  A data architect is developing an app that will generate QVDs for multiple business analysts. The field naming conventions on the source data are NOT business friendly. For every table loaded, multiple fields will require a name change.

  An Excel file is maintained centrally that lists all source data field names and the appropriate names as they should appear in the QVDs

  Which strategy should the data architect use to meet these requirements?

  A. Use the Rename function and a mapping load

  B. Create master items using business-friendly names

  C. Use the Alias function and a mapping load

  D. Load in the Excel file as a data island and use the Peek function

  Correct Answer: A

  Explanation: The Rename function allows the data architect to rename fields from the source data to the names specified in the Excel file. The mapping load allows the data architect to load the mapping between the source field names and the business-friendly names from the Excel file. The other options, Create master items using business-friendly names, Use the Alias function and a mapping load, and Load in the Excel file as a data island and use the Peek function, are not valid strategies for meeting these requirements.

• Question 49:

  

  Refer to the exhibits.

  The first table, Mastersports, contains the master list of all sport names that need to be loaded into the app. The second table, TeamMembers, contains the teams and team members registered for specific sports.

  In a Qlik Sense app, a data architect is loading the two tables that need to be linked together based on the Sport field. The table format cannot be changed in the source.

  What should the data architect do in the data load editor?

  A. Apply a preceding LOAD from the TeamMembers table with the SUBFIELD function and rename the field to Sport

  B. Apply a preceding LOAD to the MasterSports table with the SUBFIELD function to create the Sport field

  C. Apply a FOR loop to load to the MasterSports table creating the values for the Sport field

  Correct Answer: C

• Question 50:

  A data architect needs to develop multiple apps for various departments. More departments are requesting apps over time The company uses specific requirements for the number interpretation variables (e.g., ThousandSep, DecimalSep) found at the beginning of a LOAD script.

  The data architect wants to reduce duplicate scripts but does not want to copy and paste the number interpretation variables each time new app is created. The data architect prefers to use the least amount of script in Qlik Sense.

  How should the data architect meet these requirements?

  A. Save the script for the number interpretation variables in a text file and use the CALL function to insert the variables.

  B. Create an Excel file with the number interpretation variables and use a FOR Next loop to load the variables into Qlik Sense

  C. Save the script for the number interpretation variables in a text file and INLUDE function to insert the variables

  D. Create an Excel file with the number interpretation variables and apply the variables to the app using a mapping table

  Correct Answer: C

  Explanation: This method involves saving the script for the number interpretation variables in a separate text file, and then using the INCLUDE function to insert the variables into each new app script that is created. This reduces the need to

  copy and paste the number interpretation variables each time a new app is created and allows the data architect to use the least amount of script in Qlik Sense.

  The INCLUDE function is a script statement that allows you to insert the contents of one script file into another script file. This can be used to insert common scripts, such as the number interpretation variables, into multiple app scripts.