QlikView QlikView Certifications QSDA2022 Questions & Answers

• Question 71:

  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

  Correct Answer: D

• Question 72:

  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

  Correct Answer: D

• Question 73:

  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

  Correct Answer: D

• Question 74:

  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

  Correct Answer: D

• Question 75:

  

  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

  Correct Answer: B

• Question 76:

  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

  Correct Answer: A

• Question 77:

  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

  Correct Answer: C