QlikView QSDA2022 Online Practice Questions and Exam Preparation

QlikView QSDA2022 Online Questions & Answers

• Question 1:

  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:

  Explanation/Reference:

• Question 2:

  A data architect needs to build an Order Fulfillment app. The business requires front-end performance is optimized.

  The OrderDate and ShipmentDate are located in different tables.

  The user needs to identify the data type and must be able to:

  Show trends for orders and shipments

  Use a single filter for both date fields Analyze data over fiscal periods Which steps should the data architect take to build the data model?

  A. 1. Create a link table with master calendar fields 2. Create a single filter using fields from the master calendar
  B. 1. Load the Shipments and Orders table via the data manager 2. Create a single filter using fields from the Orders table
  C. 1. Create a master calendar and join into the Shipments and Orders table 2. Create a single filter using fields from the Shipments table
  D. 1. Create a master calendar table as a data island 2. Create a single filter using fields from the master calendar
  A. 1. Create a link table with master calendar fields 2. Create a single filter using fields from the master calendar

  ---

  explanation:

  Explanation/Reference:

• Question 3:

  

  Refer io the exhibit.

  A data architect needs to modify the script to ONLY load rows from Table_B when Field_1 and Field_2 are the same as in Table_A. (For example, only the row containing A, 1, 456 should be loaded from Table_B.)

  Which script should the data architect use?

  

  

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

  ---

  explanation:

  Explanation/Reference:

• Question 4:

  Refer to the exhibit.

  

  A customer needs to load forecast data from an Excel file. Which preceding load statement should the data architect use to load the data?

  

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

  ---

  explanation:

  Explanation/Reference:

• Question 5:

  Refer to the exhibit.

  

  A data architect loads sales data and creates a table which shows only customers who made purchases in 2018 and 2019. The data architect applies the following set analysis expression on the sales measure. Count<{})>} Customer ID)

  Which option shows the resulting table after the expression is applied?

  

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

  ---

  explanation:

  Explanation/Reference:

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

• Question 7:

  A data architect executes the following script:

  

  What will be the result of Table A?

  

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

  ---

  explanation:

  Explanation/Reference:

• Question 8:

  

  The Section Access security table for an app is shown. User ABC\PPP opens a Qlik Sense app with a table using the field called LEVEL on one of the table columns. What is the result?

  A. The user gets a "Field not found" error.
  B. The table is removed from the user interface.
  C. The user gets an "incomplete visualization" error
  D. The table is displayed without the LEVEL column.
  C. The user gets an "incomplete visualization" error

• Question 9:

  Refer to the exhibit.

  

  A data architect is loading the tables and a synthetic key is generated.

  How should the data architect resolve the synthetic key?

  A. Create a composite key using OrderlD and LineNo
  B. Remove the LineNo field from Shipments and use the AutoNumber function on the OrderlD field
  C. Remove the LineNo field from both tables and use the AutoNumber function on the OrderlD field
  D. Create a composite key using OrderlD and LineNo, and remove OrderlD and LineNo from Shipments
  A. Create a composite key using OrderlD and LineNo

  ---

  explanation:

  Explanation/Reference:

  This is the recommended approach to resolving synthetic keys, as it allows you to maintain the integrity of the data by combining two or more fields into a single key. The composite key can then be used to join the two tables together, ensuring that the data is consistent and accurate.

• Question 10:

  A customer has a dataset that contains latitude and longitude data for service points around the country. The data is retrieved using the following statement:

  

  It must be clear to the end user that this is geographic data. Drag and drop, map-based visualization of this data is required. Which two steps should the data architect take to support this data? (Select two.)

  A. Define Location as a master item, and set the tag to Sgeodata
  B. Add GeoProject{' Point' , LatandLong) AS Point to the preceding load
  C. Add GeoKakePoint (Lat, Long} as Point to Location's preceding load
  D. Add the following to the end of the script: TAG FIELD LocationName With 'Sgeodata1, 'Srelated'; TAG FIELD Point With 'Sgeodata', 'Srelated1;
  E. Add the following to the end of the script: TAG FIELD LocationName With 'Sgeoname', @relates_Pt'; TAG FIELD Point With 'Sgeopoint*f 'Srelates Location', '$hidden';
  B. Add GeoProject{' Point' , LatandLong) AS Point to the preceding load
  E. Add the following to the end of the script: TAG FIELD LocationName With 'Sgeoname', @relates_Pt'; TAG FIELD Point With 'Sgeopoint*f 'Srelates Location', '$hidden';

  ---

  explanation:

  Explanation/Reference: