QlikView QSDA2022 Online Practice Questions and Exam Preparation

QlikView QSDA2022 Online Questions & Answers

• Question 41:

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

  ---

  Explanation/Reference:

• Question 42:

  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';
  A. NullAsValue*; Set NullValues = 'Missing Value';

  ---

  Explanation/Reference:

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

  

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

  Multiple department fields in a dataset require a description A data architect needs to add the department descriptions or a default value when the department does NOT have a description Which strategy should the data architect use to meet these requirements?

  A. ApplyMap with two parameters after the Mapping load
  B. Left Join between tables and Description xlsx in every Department table
  C. Enter "Missing description" in the blank rows for Description xlsx then Mapping Load
  D. ApplyMap with three parameters after the Mapping load
  D. ApplyMap with three parameters after the Mapping load

  ---

  Explanation/Reference:

  This strategy involves using the ApplyMap function with three parameters after the Mapping load. This will allow the data architect to add the department descriptions or a default value when the department does not have a description.Source: Qlik

• Question 45:

  A table is generated resulting from the following script

  

  When the data architect selects a date, some, but NOT all, orders for that date are shown How should the data architect modify the script to show all orders for the selected date? A)

  

  B)

  

  C)

  

  D)

  

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

• Question 46:

  

  Refer to the exhibits.

  The first table, Mastersports, contains the master list of all sport names that need to be loaded into the app. The second table, TeamMembers, contains the teams and team members registered for specific sports.

  In a Qlik Sense app, a data architect is loading the two tables that need to be linked together based on the Sport field. The table format cannot be changed in the source.

  What should the data architect do in the data load editor?

  A. Apply a preceding LOAD from the TeamMembers table with the SUBFIELD function and rename the field to Sport
  B. Apply a preceding LOAD to the MasterSports table with the SUBFIELD function to create the Sport field
  C. Apply a FOR loop to load to the MasterSports table creating the values for the Sport field
  C. Apply a FOR loop to load to the MasterSports table creating the values for the Sport field

• Question 47:

  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
  B. QMC security rules and section access

• Question 48:

  A data architect needs to arrange data to create an app with a map where multiple location points consolidate into hexagonal areas based on postal codes

  The areas will be color coded based on the number of vendors in the location.

  Which GeoAnalytics operation should the data architect use?

  A. Binning
  B. Intersect
  C. AddressLookup
  D. Simplify
  A. Binning

  ---

  Explanation/Reference:

  Binning is a GeoAnalytics operation that can be used to arrange data into hexagonal areas based on postal codes. The areas can then be color coded based on the number of vendors in the location.Source: Qlik Binning is a GeoAnalytics operation that allows data points to be grouped into hexagonal areas based on a geographic field, such as postal codes. The data architect can use binning to group the location points by postal code and then color code the resulting hexagonal areas based on the number of vendors in each location. This operation is useful for visualizing spatial data and identifying patterns or trends in the data.

• Question 49:

  

  A company has different departments. Executive and Sales should always be the first values in a Department filter pane. Which script must the data architect use to meet this requirement?

  

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

  ---

  Explanation/Reference:

• Question 50:

  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/Reference: