QlikView QSDA2022 Online Practice Questions and Exam Preparation

QlikView QSDA2022 Online Questions & Answers

• Question 51:

  Refer to the exhibit.

  

  What are the values of the variables vLoadStart and vLoadComplete after the script executes?

  A. vLoadStart; 'NOW{)' vLoadComplete: current system date and time when the script ended
  B. vLoadStart: system date when the app was opened vLoadComplete 'now()'
  C. vLoadStart: system date when the app was opened vLoadComplete: current system date and time when the script ended
  D. vLoadStart: current system date and time when the script started vLoadComplete: 'now()'
  D. vLoadStart: current system date and time when the script started vLoadComplete: 'now()'

  ---

  Explanation/Reference:

  vLoadStart variable is assigned the current system date and time when the script starts, and vLoadComplete variable is assigned the current system date and time when the script ends.

• Question 52:

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

• Question 53:

  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. Schedule Task 1 to run hourly and refresh data from Source 1 2. Schedule Task 2 to run weekly and refresh data from Source 2 3. Schedule a task for the app that is dependent on completion of Tasks 1 or 2 that loads the two QVDs
  B. 1. Schedule Task 1 to run hourly and refresh data from Source 1 2. Schedule Task 2 that is dependent on Task 1 to refresh data from Source 2 3. Schedule a task for the app that is dependent on completion of Task 2 that loads the two QVDs
  C. 1. Schedule Task 1 to run hourly and refresh data from Source 1 2. Schedule Task 2 that is dependent on Task 1 to refresh data from Source 2 3. Schedule a task for the app that is dependent on completion of Tasks 1 and 2 that loads the two QVDs
  D. 1. Schedule Task 1 to run hourly and refresh data from Source 1 2. Schedule Task 2 to run weekly and refresh data from Source 2 3. Schedule a task for the app that is dependent on completion of Task 2 that loads the two QVDs
  C. 1. Schedule Task 1 to run hourly and refresh data from Source 1 2. Schedule Task 2 that is dependent on Task 1 to refresh data from Source 2 3. Schedule a task for the app that is dependent on completion of Tasks 1 and 2 that loads the two QVDs

  ---

  Explanation/Reference:

  This option ensures that the data in the two data sources is always up-to- date by scheduling the data refresh tasks to run at the appropriate frequencies. Task 1 runs hourly to refresh data from Source 1, and Task 2 is dependent on Task 1 so that it runs only after Task 1 is completed. This ensures that the data from Source 2 is loaded only after the most current data from Source 1 is loaded.

• Question 54:

  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

  ---

  Explanation/Reference:

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

  A data architect needs to create an app to analyze 30-day re-admissions at a hospital.

  The medical record system does NOT calculate re-admission data The business rule to follow: if a patient is admitted to a hospital within 30 days after being discharged from a previous hospital stay, that event should be captured in the app with a flag called "30-day Re-admission" Data being used from the patient record includes hospital account ID, patient ID, admission dater and discharge date

  Which action should the data architect perform first to meet these requirements?

  A. Sequence patient records by hospital account ID and patient ID using the Peek function
  B. Sequence patient records by patient ID using the Peek function
  C. Calculate the days since previous discharge using admission date and discharge date
  D. Order patient records by patient ID and admission date
  D. Order patient records by patient ID and admission date

  ---

  Explanation/Reference:

• Question 56:

  A data architect is loading two tables into a data model from a SQL database. These tables are related on key fields CustomerlD and CustomerKey. Which script is valid to load the tables and maintain the correct association?

  

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

  ---

  Explanation/Reference:

• Question 57:

  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
  C. Italy, United Kingdom, The Netherlands

• Question 58:

  A data architect executes the following script:

  

  What will Field_1 contain after this script is executed?

  A. Abed, abed, ABCD
  B. abcd
  C. Abcd, abcd
  D. Abed, abed, ABCD, ABCDABCD
  A. Abed, abed, ABCD

• Question 59:

  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 A439926003 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. FileSize, IF, THEN, END IF
  B. FilePath, IF, THEN. Drop
  C. FileExists, FOR EACH, IF
  D. FilePath, FOR EACH, Peek, Drop
  A. FileSize, IF, THEN, END IF

  ---

  Explanation/Reference:

• Question 60:

  A data architect of an organization that has implemented Qlik Sense on Windows needs to load large amounts of data from a database that 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 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 and 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
  B. 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
  C. 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 and concatenate with the new and updated records 3. Use the PEEK function to remove the deleted rows
  D. 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 and 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.
  D. 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 and 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.