Qlik Qlik Sense Data Architect QSDA2018 Questions & Answers

• Question 21:

  Refer to the exhibits.

  

  A data architect must load the two tables without creating a synthetic key. The data architect also must make sure expressions like Sum ([Budgeted Sales]) are calculated correctly.

  Which load script meets these requirements?

  

  A.

  

  B. C.

  

  D.

  Correct Answer: B

• Question 22:

  Sales managers need to see an overview of historical performance and highlight the current year's metrics.

  App requirements:

  Display the current year's total sales

  Total sales displayed must respond to the user's selections

  Which variables should a data architect create to meet these requirements?

  

  A. B. C. D.

  Correct Answer: A

• Question 23:

  A data architect has a QVD file that contains data from many countries. The data architect must write a script that loads only data from France, and make sure the reload occurs as fast as possible.

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

  

  A. B. C.

  

  D.

  Correct Answer: A

• Question 24:

  The data model from an existing Qlik Sense app needs to be reused in another Qlik Sense app. Which load strategy should a data architect use to transfer this data in the most efficient way?

  A. Generic load

  B. Preceding load

  C. Binary load

  D. QVD load

  Correct Answer: C

• Question 25:

  Refer to the exhibit.

  

  A system creates log files and csv files daily and places these files in a folder. The log files are named automatically by the source system and charge regularly. All csv files must be loaded into Qlik Sense for analysis.

  Which method should be used to meet the requirements?

  

  A. B. C. D.

  Correct Answer: D

• Question 26:

  Refer to the exhibit.

  

  A data architect loads order data for a global sales organization. The Order Details contains 100 million rows. The data architect must load only the data for the North America division.

  Which WHERE clause should the data architect use in the Order Details LOAD script?

  A. WHERE Division = `North America";

  B. WHERE Exists(OrderNum);

  C. WHERE OrderNum = [Order Header].[OrderNum];

  D. WHERE Exists(`North America');

  Correct Answer: B

• Question 27:

  Refer to the exhibit.

  

  A data architect needs to build a Project Management dashboard. The ProjectStatus table lists all indexes in the fields. Descriptions for the indexes are stored in a single Master table.

  To build the dashboard, all descriptions should be in a single table:

  

  Which function should the data architect use to meet this requirement?

  A. Join

  B. PurgeChar

  C. ApplyMap

  D. Keep

  Correct Answer: C

• Question 28:

  Stocks levels are stored online in a system that keeps information for the current period only.

  What should the data architect do to enable analysis of the trends of the stock levels?

  A. Use On-Demand App Generation (ODAG) to create new apps from the selected period

  B. Capture the periodic information in an incremental QVD file for use in an app

  C. Create an app for each period as it changes and use document chaining

  D. Create an app for each period and use a binary load task to create a single app

  Correct Answer: B

• Question 29:

  Payroll managers need access to the payroll system to complete a quarterly report. A username and password is required to access the payroll system through an ODBC connection. Only the system administrator should have access to the credentials and make updates as needed. Each payroll manager who access the app should only see their own employees.

  Which two actions are required to set up the appropriate security? (Choose two.)

  A. Make sure that the administrator creates appropriate sync rules to access the payroll system

  B. Apply the correct section access to restrict data visibility

  C. Make sure that the administrator applies security rules to the correct stream to restrict data visibility

  D. Apply security rules to the app to restrict data visibility

  E. Make sure that the administrator applies the correct security rules to the ODBC connection

  Correct Answer: BE

• Question 30:

  Refer to the exhibit.

  

  How should the account that runs the Qlik Sense Services be configured in the Section Access table?

  A. ADMIN, QLIK_SERVICES,

  B. ADMIN, DOMAIN/QLIK_SERVICES,

  C. ADMIN, QLIK_SERVICES,*

  D. ADMIN, DOMAIN\QLIK_SERVICES,*

  Correct Answer: C