QlikView QlikView Certifications QSDA2022 Questions & Answers

• Question 1:

  A company has a stream with multiple apps One of the apps is a multi-regional sales app.

  A data architect must set up security for users to access the stream, enter the app, and view specific sheets and data.

  Which features should the data architect use to meet these requirements?

  A. Section access and set analysis

  B. QMC security rules and section access

  C. QMC security rules and custom properties

  D. Section access and sheet properties

  Correct Answer: B

• Question 2:

  

  Refer to the exhibit

  A data architect is working on an app that contains orders, invoices, and shipping data. There are three different date fields within the data:

  *

  OrderDate

  *

  InvoiceDate

  *

  ShippingDate

  The business analyst needs to replicate the chart above to show Order and Shipping amounts on the same Month axis.

  What should the data architect do?

  A.

  Create a Month field for each of the three dates in the fact table and use that in the chart

  B.

  Load the key field and the three date fields into a concatenated bridge table that contains KeyField and Date

  C.

  Left Join the three date fields onto one bridge table using the key field containing KeyField and Date

  Correct Answer: B

• Question 3:

  A data architect executes the following script.

  

  Which values does the OrderDate field contain after executing the script?

  A. 20210131, 2020/01/31, 31/01/2019, 0

  B. 20210131,2020/01/31,31/01/2019

  C. 20210131, 2020/01/31, 31/01/2019, 9999

  D. 20210131, 2020/01/31, 31/01/2019, 31/12/20

  Correct Answer: D

• Question 4:

  Refer to the exhibits.

  

  Some business users created an app by using the Add data functionality and loading two Excel files Orders and Customers.

  The app is used to analyze the number of orders by customer. When the users create a bar chart to review the figures, the data shown is incorrect.

  What should the data architect do to resolve this issue?

  A. Open the data manager, split the Customers table, and associate both tables on CustomerlD field

  B. Open the data manager, split the Customers table, and JOIN Orders and Customers on the CustomerlD field

  C. Open the data load editor and use JOIN instead of concatenate to combine Orders and Customers by CustomerlD

  D. Open the data load editor and apply a NOCONCATENATE function in the LOAD statement on the Orders table

  Correct Answer: C

• Question 5:

  Refer to the exhibit.

  

  A data architect is working with an app and creates some visualizations to check the data. Some visualizations show issues in the data set.

  *

  The Sales by Country table shows a total OrderValue of 18,300 sales while the KPI shows a total OrderValue of 20,600.

  *

  The Sales monthly trend bar chart does not work with the Month field. Which two data issues should the data architect fix in the app? (Select two.)

  A.

  The Month field does not exist in the Orders table and needs to be incorporated in the table using he Calendar table.

  B.

  In the Orders table, some CustomerlD values are null because there are orders with no customer and needs to be incorporated in the table using the Calendar table, null because there are orders with no customer

  C.

  In the Orders table, some values in the CustomerlD field do not exist in the Customers table.

  D.

  The OrderDate field values in the Calendar table do not match with the values in the OrderDate field from the Orders table

  Correct Answer: CD

• Question 6:

  Refer to the exhibit.

  

  Refer to the exhibits.

  While using an app, the users report that some Sales Reps do NOT have personal details, like Division or Address Number A data architect has been called in to investigate.

  The data architect uses the data model viewer to determine the relationship between the SalesRepMaster and CustomerMaster tables.

  What is the cause of the issue?

  A. 26 values for Sales Rep are null in CustomerMaster

  B. 40.7% of the Sales Rep have CustomerMaster information

  C. 59.3% of the Sales Rep have CustomerMaster information

  D. Density is 100% while Total Distinct and Present Distinct are NOT the same

  Correct Answer: D

  Explanation: When using the data model viewer to investigate the relationship between the SalesRepMaster and CustomerMaster tables, the data architect would look at the density of the relationship. Density is a measure of how well the key

  fields of a table match the key fields of another table. A density of 100% means that all key fields in one table have a match in the other table.

  When the density is 100% but the total distinct and present distinct values for the key fields of the related tables do not match, it means that some of the key fields in one table do not have a match in the other table, this is the cause of the

  issue.

• Question 7:

  A data architect needs to upload different data sources. To properly handle null values, the data architect decides to set all of these values to "Missing Value". Which syntax should the data architect use?

  A. NullAsValue*; Set NullValues = 'Missing Value';

  B. NullasNull *; Set NullValues = 'Missing Value';

  C. NullasNull *; Set NullValue = 'Missing Value';

  D. NullAsValue*; Set NullValue = 'Missing Value';

  Correct Answer: A

  Explanation: This syntax will set all null values to "Missing Value" in the data sources. The other options are not valid syntax and will not achieve the desired result.

• Question 8:

  

  On executing a load script of an app, the country field needs to be normalized. The developer uses a mapping table to address the issue. What should the data architect do?

  A. Use a LEFT JOIN instead of the APPLYMAP

  B. Use LOAD DISTINCT on the mapping table

  C. Create two different mapping tables

  D. Review the values of the source mapping table

  Correct Answer: D

• Question 9:

  Refer to the exhibit.

  

  A business analyst reports that the 'CompanyAge' field does NOT display for users The data architect examines the LOAD script and wants to place the breakpoint in the script to check the field name.

  Which line number should the data architect use?

  A. 242 because field name appears in the output Panel of the debugger

  B. 251 because the field name appears in the Variable panel of the debugger

  C. 251 because the field name appears in the Qlik Log files

  D. 251 because the field name appears in the Output panel of the debugger

  Correct Answer: D

• Question 10:

  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

  Correct Answer: C

  Explanation: 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.