QSDA2018 Online Practice Questions and Answers

A data architect uses the Qlik GeoAnalytics connector to determine the closest airports to cities in an existing app. The built location generates data for the airport locations. The data load editor runs the script and sees a circular reference and a synthetic key.

How should the data architect fix these issues?

A. When selecting an operation in the Qlik GeoAnalytics connector, select Only load distinct.

B. When choosing which data to load, uncheck the non-unique field in the new data tables.

C. Concatenate the airport table and the existing tables into one master tables.

D. When selecting an operation in the Qlik GeoAnalytics connector, change the CRS to "None".

Refer to the exhibit.

A QlikView app was converted to a Qlik Sense app using the Dev Hub converter.

The new Qlik Sense app was reloaded without editing the script or the server settings, which created a

script error.

What should a data architect do to resolve the issue?

A. Delete the Qualify statement

B. Add fields to the Qualify statement

C. Use a folder connection

D. Check the QVDs

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

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

Refer to the exhibit.

One of the data sources a data architect must add for a newly developed app is an Excel spreadsheet. The Region field only was values for the first record for the region. The data architect must perform a transformation so that each row contains the correct Region.

Which function should the data architect implement to resolve this issue?

A. CrossTable

B. IntervalMatch

C. Above

D. Previous

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

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.

Refer to the exhibit.

Each order can have multiple products. The data architect needs to make sure the Amount can be analyzed by order Type and product Category.

The Order Number field data always contains the order Type in the first three characters. Product, Product Category, and Sales Channel data are available in an Excel spreadsheet called "Categories" in the file PaperProducts.xlsx.

Which way can the data architect use to make additions to the existing script and meet the requirements?

A. B.

C.

D.

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 `SQL (abc_qservice)'; before the LOAD for the OrderDetail table.

B. Give the data architect the Read rights on the data connections in the QMC.

C. Make the data architect the owner of the app in the QMC.

D. Add the LIB CONNECT TO `QVD (abc_qservice/OrderData.qvd)'; before the LOAD for the OrderData table.

Refer to the exhibit.

A chart for monthly hospital admissions and discharges incorrectly displays the month and year values on the x-axis. The date format for the source data field "Common date" is M/D/YYYY. This format was used in a calculated field named "Month-Year" in the data manager when the data model was first built.

Which expression should the data architect use to fix this issue?

A. Date (MonthsStart ([Common Date]), `MMM-YYY')

B. Date (MonthStart ([Common Date]), `MMM-YYY')

C. Date ([Common Date], `MMM-YYY')

D. Date (InMonth([Common Date]), MMM-YYYY')