QlikView QlikView Certifications QSDA2019 Questions & Answers

• Question 21:

  A data architect needs to load large amounts of data from a database which is continuously updated New records are added, and existing records get updated and deleted. Each record has a LastModified field All existing records are exported into a QVD file. The data architect wants to load the records into Qlik Sense efficiently. Which steps should the data architect take to meet these requirements?

  A. 1. Use a partial load to load new and updated data from the database.

  2.

  Load the existing data from the QVD without the updated rows that have just been loaded from the database. Concatenate with the new and updated records.

  3.

  Use the Peek function to remove the deleted rows.

  B. 1. Load the new and updated data from the database

  2.

  Load the existing data from the QVD without the updated rows that have just been loaded from the database. Concatenate with the new and updated records.

  3.

  Load all records from the key field from the database and use an Inner Join on the previous table.

  C. 1. Load the existing data from the QVD.

  2.

  Load the new and updated data from the database without the rows that have just been loaded from the QVD. Concatenate with data from the QVD.

  3.

  Load all records from the key field from the database and use an Inner Join on the previous table.

  D. 1. Load the existing data from the QVD.

  2.

  Load new and updated data from the database. Concatenate with the table loaded from the QVD.

  3.

  Create a separate table for the deleted rows and use a WHERE NOT EXISTS to remove these

  records.

  Correct Answer: A

• Question 22:

  Refer to the exhibit.

  

  A clothing retailer wants to review their product pricing strategy. A data architect must classify each product into a price group. The price groups must be the same width by default and allow users to dynamically change the width of the bucket during analysis.

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

  A. IntervalMatch and use variables

  B. Nested IFs in a calculated dimension

  C. Class function in a calculated dimension

  D. Class function in the script and use variables

  Correct Answer: C

• Question 23:

  Refer to the exhibits.

  

  A music teacher needs to know which artists are eligible to enter this year's competition. The teacher needs to find only the artists who have a music grade rank above two and play more than one instrument. Which expression is needed for the Number of Instruments measure in the table?

  A. Count({$=2"}, Artist={"=Grade>2"}>}Instrument)

  B. Count({S=2"}, Grades={">2"}>}Instrument)

  C. Count({$=2"}, Artist={"=Grade>2"}>}Instrument)

  D. Count ({S=2M}, Grades={">2"}>}Instrument)

  Correct Answer: A

• Question 24:

  A data architect needs to create an app that combines employee data from the Sales system and the Human Resources (HR) system. These systems identify employees differently. Employees in the HR system are identified with an alphanumeric key. Employees in the Sales system are identified using an integer key The Human Resources manager creates a table which maps these keys to one another, called Associations. The resultant data model must meet the following requirements: Associations must be valid The model must be optimized for performance The option must support multiple tables added from both systems now and in the future

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

  A. APPLYMAP { 'Associations' , EmployeeKey) AS EmployeeKey;

  B. MAP EmployeeKey USING Associations;

  C. RENAME FIELDS USING Associations;

  D. MapSubString('Associations', EmployeeKey) AS EmployeeKey;

  Correct Answer: A

• Question 25:

  A data architect completes development of a new app with two data sources Both data sources will also be used by other apps in the future The sources have different data refresh frequencies: Source 1 Contains frequently updated data and must be refreshed hourly Source 2 Contains data that is transferred from a partner and must be refreshed weekly

  Tasks must be created to load the data sources and make sure that the new app uses the most current data The data will be stored in two QVDs.

  Which tasks should be created to meet these requirements?

  A. 1. ScheduleTask 1 to run hourly and refresh data from Source 1

  2.

  ScheduleTask 2 to run weekly and refresh data from Source 2

  3.

  Schedule a task for the app that is dependent on completion ofTasks 1 or 2 that loads the two QVDs

  B. 1. ScheduleTask 1 to run hourly and refresh data from Source 1

  2.

  ScheduleTask 2 that is dependent onTask 1 to refresh data from Source 2

  3.

  Schedule a task for the app that is dependent on completion ofTask 2 that loads the two QVDs

  C. 1. ScheduleTask 1 to run hourly and refresh data from Source 1

  2.

  ScheduleTask 2 that is dependent onTask 1 to refresh data from Source 2

  3.

  Schedule a task for the app that is dependent on completion ofTasks 1 and 2 that loads the two QVDs

  D. 1. ScheduleTask 1 to run hourly and refresh data from Source 1

  2.

  ScheduleTask 2 to run weekly and refresh data from Source 2

  3.

  Schedule a task for the app that is dependent on completion ofTask 2 that loads the two QVDs

  Correct Answer: D

• Question 26:

  Refer to the exhibits.

  

  A business analyst needs to see the currency conversion rate for any given date in a chart The currency conversion rate data comes from Qlik DataMarket and only contains a record when the rate changes An existing master calendar exists in the data model which contains a full set of dates.

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

  A. Outer Join the calendar with the currency conversion table Order by the date and use the Peek function to fill in blank values

  B. Use 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

  C. Use IntervalMatch to load the currency conversion rate between dates the conversion changed Inner Join the resultant table back into the master calendar

  D. Use IterNo and AutoGenerate to create a new calendar from max and mm dates of the currency conversion table Force concatenate with the master calendar

  Correct Answer: A

• Question 27:

  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 use Mapping Load

  D. ApplyMap with three parameters after the Mapping load

  Correct Answer: A

• Question 28:

  Refer to the exhibit.

  

  A business analyst reports that the 'CompanyAge' field does NOT display for users The data architect examines the LOAD script and wants to place the breakpoint in the script to check the field name. Which line number should the data architect use?

  A. 242 because field name appears in the output Panel of the debugger

  B. 251 because the field name appears in the Variable panel of the debugger

  C. 251 because the field name appears in the Qlik Log files

  D. 251 because the field name appears in the Output panel of the debugger

  Correct Answer: D

• Question 29:

  A data architect needs to upload data from ten different sources, but only if there are any changes after the

  last reload When data is updated, a new file is placed into a folder mapped to E:\373948870. The data

  connection points to this folder.

  The data architect plans a script which will:

  1.

  Verify that the file exists

  2.

  If the file exists, upload it. Otherwise, skip to the next piece of code. The script will repeat this subroutine for each source.

  When the script ends, all uploaded files will be removed with a batch procedure. Which option should the data architect use to meet these requirements?

  A. FilePath, IF, THEN, Drop

  B. FileSize, IF, THEN, END IF

  C. FilePath, FOR EACH, Peek, Drop

  D. FileExists, FOR EACH, IF

  Correct Answer: D

• Question 30:

  Refer to the exhibits.

  

  Executives need to see the total sales by region for the current year. The data architect inherits App1 from a former employee who tried to address this requirement. Two Excel spreadsheets, Region and Employee, are used as the data source. The data architect creates a table and identifies errors in the amount of sales per region.

  How should the data architect resolve the errors?

  A. In the data manager split the Region table and associate by EmployeelD

  B. In the data manager split the Region table and associate by Region.ID

  C. In the data load editor, concatenate the Region and Employee tables

  D. In the data manager, concatenate the Region table and associate by Region.ID

  Correct Answer: B