QlikView QSDA2022 Online Practice Questions and Exam Preparation

QlikView QSDA2022 Online Questions & Answers

• Question 61:

  The Marketing department is using some similar KPIs in different apps that need to be modified frequently according to the business needs. The KPIs are created using master items with the same expression.

  Which method should the data architect use to manage the modifications in all apps?

  A. Create a variable repository and load them using INCLUDE statements in the apps where needed
  B. Create a selection app with all the master items and use an on-demand app generation method.
  C. Create a core app with all the master items needed and use a BINARY load in the other apps.
  D. Create only a single app with all the master items needed and protect it with SECTION ACCESS.
  A. Create a variable repository and load them using INCLUDE statements in the apps where needed

  ---

  Explanation/Reference:

  This method allows the data architect to store the KPIs in a single repository and then use INCLUDE statements to load them into the other apps. This makes it easy to modify the KPIs in one place and have the changes

  reflected in all the apps.Source: Qlik A variable repository is a central location where all of the master items used in the apps can be stored and managed. By creating a variable repository and loading the master items into each app using

  INCLUDE statements, the data architect can make modifications to the master items in one place, and the changes will be automatically propagated to all of the apps that use the master items.

  This method allows for easy management of the master items and eliminates the need to make changes to each app individually, which can be time-consuming and prone to errors.

• Question 62:

  A data architect is building a model to show trends in visualizations across seven date fields. The seven date fields reside in different tables. The data architect must efficiently build this data model.

  Requirements:

  A single date selector

  Show all dates, even those with NO activity

  Minimize the impact on server resources and p

  Which two solutions should the data architect use? (Select two.)

  A. Canonical calendar
  B. Generic load
  C. Data island
  D. Multiple calendars
  E. Link table
  A. Canonical calendar
  E. Link table

  ---

  Explanation/Reference:

  A canonical calendar should be used to create a single date selector that can be used to show all dates, even those with no activity. A link table should be used to join the seven date fields from different tables, which will minimize the impact on server resources and performance.Source: Qlik

• Question 63:

  Refer to the exhibit.

  

  An existing app on Qlik Sense Enterprise is duplicated and transferred to a data architect to add some additional data When trying to manually reload the original script, the data architect receives an error What should be done to make sure the script runs correctly?

  A. Add the line lib connect to 'QVD(abc_qservice/orderData.qvd) '; before the LOAD for the Order Data table
  B. Add the line lib connect to ' SQL (abc_qs9rvi.es) ` ;before the LOAD for the Order Detail table
  C. Give the data architect the Read rights on the data connections in the QMC
  D. Make the data architect the owner of the app in the QMC
  C. Give the data architect the Read rights on the data connections in the QMC

• Question 64:

  A data architect is using an Include statement to load the collection of variables from a TextFiles folder connection into an app. The data architect needs to load the data and generate an error if it fails. Which statement should the data architect use?

  A. $
  B. $(Must_Include=lib://TextFiles/Variables.txt);
  C. (Must_Include=lib://TextFiies/Variables.txt);
  D. (Includs=lib://TextFiles/Variables.txt);
  B. $(Must_Include=lib://TextFiles/Variables.txt);

  ---

  Explanation/Reference:

  The MustInclude statement provides an error if the include fails and is used when including files in Qlik Sense. The other statements do not provide an error if the include fails. qlik-sense-certification-exam-study-guide-en.pdf https://www.qlik.com/us/-/media/files/training/global-us/qlik-sense-certification-exam-study- guide-en.pdf?la=enandhash=9DA9DEBC7D27BF1CA8373E81F2614C85 Talk to Experts Tuesday - Migrating from QlikView to Qlik Sense FAQ https://community.qlik.com/t5/Support-Knowledge-Base/Talk-to-Experts-Tuesday- Migrating-from-QlikView-to-Qlik-Sense/ta-p/1746935 Certifications and Qualifications | Qlik

  https://www.qlik.com/us/services/training/certifications-and-qualifications The $(Must_Include) statement is used to load a file or a set of files and generate an error if the load fails. The "Must_Include" function will stop the script execution if the file is not found or cannot be loaded. The correct syntax for using the "Must_Include" statement is $(Must_Include=lib://TextFiles/Variables.txt);

• Question 65:

  

  A data architect is creating an app using three tables. After executing the script, a warning displays Which two steps should the data architect do to resolve this warning? (Select two.)

  A. Remove the rename statement (line 24) in the ProductPriceList table leaving the Product field name as is.
  B. Rename the Category field in the ProductPriceLis table to PnceCategory (line 24).
  C. Move the preceding Load statement in line 10 between table name (line 23) and Load statement (line 24).
  D. insert "Join (ProductDetails)" in front of the Load statement in line 24 to combine ProductPriceList with ProductDetails
  B. Rename the Category field in the ProductPriceLis table to PnceCategory (line 24).

• Question 66:

  A data architect needs to write the expression for a measure on a KPI to show the sales person with the highest sales The sort order of the values of the fields is unknown When two or more sales people have sold the same amount, the expression should return all of those sales people

  Which expression should the data architect use?

  A. FirstSortedValue (Salesperson, -Aggr (Sum(Sales) , Salesperson) )
  B. Concat(DISTINCT IF (Aggr (Rank (Sum (Sales) , 4) , Salesperson) =1, Salesperson) , ' ')
  C. FirstSortedValue (DISTINCT Salesperson, -Aggr (Sum(Sales) , Salesperson) )
  D. Concat (DISTINCT IF (Aggr (Rank (Sum (Sales) , 1) , Salesperson) =1, Salesperson) , ' ')
  D. Concat (DISTINCT IF (Aggr (Rank (Sum (Sales) , 1) , Salesperson) =1, Salesperson) , ' ')

• Question 67:

  Refer to the exhibit.

  

  While performing a data load from the source shown, the data architect notices it is NOT appropriate for the required analysis. The data architect runs the following script to resolve this issue:

  

  A. 3
  B. 1
  C. 6
  D. 4
  D. 4

• Question 68:

  A global retailer has a large database in which millions of sales transactions are added per hour.

  Each regional sales manager should only see details for customers in their region. After filtering based on criteria such as region, gender, and income level, sales managers should be able to see the most current detailed transactions.

  What should a data architect do to meet these requirements?

  A. Create an app for each sales manager with Qlik GeoAnalytics
  B. Use section access and include a service account in the table
  C. Use On-Demand App Generation (ODAG) and section access
  D. Use section access to restrict sales manager access by region
  D. Use section access to restrict sales manager access by region

• Question 69:

  A data architect needs to revise an existing app.

  The number of data rows has grown rapidly recently. While the app is in production, users are becoming increasingly unhappy about the response times when they make selections Which two methods should be used to improve performance? (Select two.)

  A. Use dynamic script generation with variables
  B. Denormalize the schema
  C. Make sure any Ul variables are preceded by '='
  D. Use flags in the data model to simplify set analysis
  E. Create master items for all complex expressions
  A. Use dynamic script generation with variables
  D. Use flags in the data model to simplify set analysis

• Question 70:

  Refer to the exhibit.

  

  A global sales organization operates in three regions: AMERICAS, EMEA: and APAC. Each region stores its sales transactions in a separate database in which the employees update customer data through a third-party app. The data is

  extracted into three QVDs.

  A data architect sets up a two-tier architecture for the data load. The data architect needs to add the region to the data model.

  Which technique should the data architect use to create the Region field?

  A. Create a Region field in the SalesTransaction table and populate using fixed region values while loading from each source
  B. Create a Region field in the Employee table and populate using the LTrim function on the EmployeelD
  C. Create a Region field in the Employee table and populate using the SubField function on the EmployeelD
  D. Create a Region field in the SalesTransaction table and create a mapping table based on the Country field in the Customer table
  A. Create a Region field in the SalesTransaction table and populate using fixed region values while loading from each source