QlikView QSDA2024 Online Practice Questions and Exam Preparation

QlikView QSDA2024 Online Questions & Answers

• Question 1:

  A data architect wants reflect a value of the variable in the script log for tracking purposes. The variable is defined as:

  

  Which statement should be used to track the variable's value?

  

  A. Option A
  B. Option B
  C. Option C
  D. Option D
  B. Option B

• Question 2:

  One of the data sources a data architect must add for a newly developed app is an Excel spreadsheet. The Region field only has values for the first record for the region. The data architect must perform a transformation so that each row contains the correct Region.

  

  Which function should the data architect implement to resolve this issue?

  A. Previous
  B. CrossTable
  C. Above
  D. IntervalMatch
  A. Previous

• Question 3:

  Refer to the exhibit.

  

  A data architect wants to transform the input data set to the output data set. Which prefix to the Qlik Sense LOAD command should the data architect use?

  A. Hierarchy Be longsTo
  B. Peek
  C. Generic
  D. PivotTable
  C. Generic

• Question 4:

  A company generates l GB of ticketing data daily. The data is stored in multiple tables. Business users need to see trends of tickets processed for the past 2 years. Users very rarely access the transaction-level data for a specific date. Only the past 2 years of data must be loaded, which is 720 GB of data.

  Which method should a data architect use to meet these requirements?

  A. Load only 2 years of data in an aggregated app and create a separate transaction app for occasional use
  B. Load only 2 years of data and use best practices in scripting and visualization to calculate and display aggregated data
  C. Load only aggregated data for 2 years and use On-Demand App Generation (ODAG) for transaction data
  D. Load only aggregated data for 2 years and apply filters on a sheet for transaction data
  C. Load only aggregated data for 2 years and use On-Demand App Generation (ODAG) for transaction data

• Question 5:

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

  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. Four
  B. Two
  C. Three
  D. Five
  B. Two

• Question 7:

  Sales managers need to see an overview of historical performance and highlight the current year's metrics. The app has the following requirements:

  1.Display the current year's total sales

  2.Total sales displayed must respond to the user's selections Which variables should a data architect create to meet these requirements?

  

  A. Option A
  B. Option B
  C. Option C
  D. Option D
  C. Option C

• Question 8:

  Refer to the exhibit.

  

  A data architect needs to build a dashboard that displays the aggregated sates for each sales representative. All aggregations on the data must be performed in the script. Which script should the data architect use to meet these requirements?

  

  

  A. Option A
  B. Option B
  C. Option C
  D. Option D
  C. Option C

• Question 9:

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

  A data architect inherits an app that takes too long to load and overruns the data load window.

  The app pulls all records (new and historical) from three large databases. The reload process puts a heavy load on the source database servers. All of the data is required for analysis.

  What should the data architect do?

  A. Make sure the individual reload tasks in the QMC are not running in parallel
  B. Implement Direct Discovery with partial load
  C. Implement incremental load on each database using QVD files
  D. Implement ODAG to split out the app into smaller chunks
  C. Implement incremental load on each database using QVD files