QlikView QSDA2024 Online Practice Questions and Exam Preparation

QlikView QSDA2024 Online Questions & Answers

• Question 1:

  A data architect needs to retrieve data from a REST API. The data architect needs to loop over a series of items that are being read using the REST connection. What should the data architect do?

  A. Recreate the SQL Statement with the correct parameters
  B. Use the REST Connector with pagination mechanism
  C. Use pagination of the REST Connector to create a template of the desired data
  D. Use With Connection to pass a parameter to the REST URL
  B. Use the REST Connector with pagination mechanism

• Question 2:

  Exhibit.

  

  While performing a data load from the source shown, the data architect notices it is NOT appropriate for the required analysis. The data architect runs the following script to resolve this issue:

  

  How many tables will this script create?

  A. 1
  B. 3
  C. 4
  D. 6
  D. 6

• Question 3:

  A data architect is validating that the script section, as shown in the exhibit, is working properly. They need to stop the script with a preview of the value used with the Load statement.

  

  Where should the data architect put the debugger breakpoint?

  A

• Question 4:

  Refer to the exhibit.

  

  A major healthcare organization requests a new app with the following requirements:

  1.Users can filter AdmissionDate and DischargeDate by all fields in the Master Calendar table

  2.Use an existing QVD file, which includes dates 20 years into the future

  3.Users should not be able to filter on dates that have no associated encounters

  Which approach should the data architect take to meet these requirements?

  A. 1. Load the Master Calendar and Encounters tables 2.Perform a Join Load on the Encounters table to the Resident master calendar and alias the date fields appropriately for the Admission Date 3.Perform a Join Load on the Encounters table to the Resident master calendar and alias the date fields appropriately for the Discharge Date
  B. 1. Load the master calendar 2.Create two mapping tables called AdmissionCalendar and DischargeCalendar from the Resident master calendar thatfeas all fields appropriately named 3.Load the Encounters table and use ApplyMap for the AdmissionDate and DischargeDate appropriately
  C. 1. Load the master calendar as AdmissionCalendar and alias the fields to reflect they are for Admission 2.Load the master calendar as DischargeCalendar and alias the fields to reflect they are for Discharge 3.Load the Encounters table
  D. 1. Load the Encounters table 2.Perform a Left Join Load on the Encounters table to the master calendar and alias the date fields appropriately for the Admission Date 3.Perform a Left Join Load on the Encounters table to the master calendar and alias the date fields appropriately for the Discharge Date
  C. 1. Load the master calendar as AdmissionCalendar and alias the fields to reflect they are for Admission 2.Load the master calendar as DischargeCalendar and alias the fields to reflect they are for Discharge 3.Load the Encounters table

• Question 5:

  A company needs to analyze daily sales data from different countries. They also need to measure customer satisfaction of products as reported on a social media website. Thirty (30) reports must be produced with an average of 20,000 rows each. This process is estimated to take about 3 hours.

  Which option should the data architect use to build this solution?

  A. Qlik REST Connector
  B. Microsoft SQL Server
  C. Qlik GeoAnalytics
  D. Mailbox IMAP
  A. Qlik REST Connector

• Question 6:

  A startup company is about have its Initial Public Offering (IPO) on the New York Stock Exchange.

  This startup company has used Qlik Sense for many years for data-based decision making for Sales and Marketing efforts, as well as for input into Financial Reporting. The startup's Qlik Sense applications use variables that have different

  values at different points in time.

  Due to the increased rigor required in record keeping for public companies, these variables must be clearly recorded in the script reload logs of the Qlik Sense applications. These logs are refreshed daily.

  The data architect wants to have the variables names, with their current values,writteninto the script reload logs. Which script statement should the data architect use?

  A. LogDetail
  B. Trace
  C. Tag
  D. REM
  B. Trace

• Question 7:

  A data architect executes the following script:

  Table_A:

  LOAD * INLINE [

  Field_1, Field_2, Field_3 01, AB, 10

  01, AC, 50

  02, AD, 75

  ];

  Join(Table_A)

  Table_B:

  LOAD * INLINE [

  Field_1, Field_4, Field_5 01, 30%, 500

  03, 60%, 1000

  ];

  What will be the result of Table.A?

  A

• Question 8:

  Refer to the exhibit.

  

  What does the expression sum< [orderMetAmount ]) return when all values in LineNo are selected?

  A. 1590
  B. 1490
  C. 690
  D. 1810
  B. 1490

• Question 9:

  Users of a published app report incomplete visualizations. The data architect checks the app multiple times and cannot replicate the error. The error affects only one team. Which is the most likely cause?

  A. A security rule has been applied to the sheet object.
  B. The affected users were NOT added to the Section Access table.
  C. Section access restricts too many records.
  D. An Omit field has been applied.
  C. Section access restricts too many records.

• Question 10:

  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 Customers table would be exported as:

  

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

  A. One loop and two IF statements
  B. One loop and one SELECT CASE statement
  C. Two loops and one IF statement
  D. Two loops without any conditional statements
  A. One loop and two IF statements