QlikView QSDA2019 Online Practice Questions and Exam Preparation

QlikView QSDA2019 Online Questions & Answers

• Question 31:

  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
  A. Option A

• Question 32:

  Refer to the exhibit.

  

  USER1 has an app protected using this Section Access statement. Which countries can USER1 see in the app''

  A. Germany. Italy, United Kingdom, The Netherlands
  B. Italy, The Netherlands
  C. Italy, United Kingdom, The Netherlands
  D. Germany Italy, The Netherlands
  D. Germany Italy, The Netherlands

• Question 33:

  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. Add the line lib connect to 'QVD(abc_qservice/orderData.qvd) '; before the LOAD for the Order Data table
  B. Add the line lib connect to ' SQL (abc_qs9rvi.es) ` ;before the LOAD for the Order Detail table
  C. Give the data architect the Read rights on the data connections in the QMC
  D. Make the data architect the owner of the app in the QMC
  A. Add the line lib connect to 'QVD(abc_qservice/orderData.qvd) '; before the LOAD for the Order Data table

• Question 34:

  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
  A. Use the Rename function and a mapping load

• Question 35:

  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
  B. In the data manager split the Region table and associate by Region.ID

• Question 36:

  A data architect plans to build an app that contains geographically diverse data that must be specific to user run-time selections. The source contains transactional data. The app must have minimal impact on already limited server resources. Which approach should the data architect use?

  A. Loop and Reduce
  B. QVDs
  C. In-memory
  D. ODAG
  A. Loop and Reduce

• Question 37:

  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
  A. Option A

• Question 38:

  A data architect is using an Include statement to load the collection of variables from a TextFiles folder connection into an app. The data architect needs to load the data and generate an error if it fails. Which statement should the data architect use?

  A. $
  B. $(Must_Include=lib://TextFiles/Variables.txt);
  C. (Must_Include=lib://TextFiies/Variables.txt);
  D. (Includs=lib://TextFiles/Variables.txt);
  A. $

• Question 39:

  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
  A. Option A

• Question 40:

  A data architect needs to load data from two different databases. Additional data will be added from a folder that contains QVDs, text files, and Excel files. What is the minimum number of data connections required?

  A. Two
  B. Four
  C. Five
  D. Three
  A. Two