QlikView QlikView Certifications QSDA2019 Questions & Answers

• Question 41:

  A data architect needs to efficiently prepare a data model for a meeting in an hour. The data source to be used contains five date fields. The app needs to display sales trends and compare the current year to date (CYTD) to last year to date (LYTD). The app is NOT going to be published. It will only be used for this meeting and a single user's ad-hoc analysis. What should the data architect do to meet these requirements?

  A. Create a canonical calendar

  B. Load a calendar island

  C. Use the data manager

  D. Create five master calendars

  Correct Answer: C

• Question 42:

  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

• Question 43:

  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

  Correct Answer: A

• Question 44:

  Refer to the exhibit.

  

  USER1 has an app protected using this Section Access statement. Which countries can USER1 see in the app''

  A. Germany. Italy, United Kingdom, The Netherlands

  B. Italy, The Netherlands

  C. Italy, United Kingdom, The Netherlands

  D. Germany Italy, The Netherlands

  Correct Answer: D

• Question 45:

  Users of a published app report incomplete visualizations. The data architect checks the app multiple times

  and cannot replicate the error. The error affects only one team.

  What is the most likely cause?

  A. An Omit field has been applied

  B. A security rule has been applied to the sheet object

  C. Section access restricts too many records

  D. The affected users were NOT added to the Section Access table

  Correct Answer: A

• Question 46:

  A data architect needs to load Table_A from an Excel file and sort the data by Field_2. Which script should the data architect use?

  

  

  A. Option A

  B. Option B

  C. Option C

  D. Option D

  Correct Answer: C

• Question 47:

  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

  Correct Answer: A

• Question 48:

  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. Concat(DISTINCT IF{Aggr{Rank{Sum(Sales),4),Salesperson)=1,Salesperson),' ')

  B. FirstSortedValue{DISTINCT Salesperson,-Aggr{Sum(Sales),Salesperson))

  C. Concat(DISTINCT IF{Aggr{Rank{Sum(Sales),1),Salesperson)=1, Salesperson) , ' ')

  D. FirstSortedValue {Salesperson, -Aggr (Sum{Sales), Salesperson))

  Correct Answer: A

• Question 49:

  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

  Correct Answer: C

• Question 50:

  Refer to the exhibit.

  

  The data architect needs to build a model that contains Sales and Budget data for each customer. Some

  customers have Sales without a Budget, and other customers have a Budget with no Sales During loading,

  the data architect resolves a synthetic key by creating the composite key For validation, the data architect

  creates a table containing Customer, Month. Sales, and Budget columns.

  What does the data architect see when selecting a month?

  A. All Customers, all Budget and all Sales records

  B. Customer and Sales records for that month, but missing values for Budget

  C. Customer and Budget records for that month, but missing values for Sales

  D. Customer, Sales, and Budget records for that month

  Correct Answer: C