Qlik QSDA2019 Qlik Sense Data Architect Exam Practice Test

A data architect builds a data model for a large user group. Some sheets will be published, and the app will allow users to create their own visualizations and analyze dat

a. Some fields must NOT appear in any field list.

How should a data architect meet these requirements?

Refer to the exhibits.

Executives need to see the total sales by region for the current year. The data architect inherits App1 from a former employee who tried to address this requirement. Two Excel spreadsheets, Region and Employee, are used as the data source. The data architect creates a table and identifies errors in the amount of sales per region.

How should the data architect resolve the errors?

Refer to the exhibit.

A shipping company needs to track its shipments using Qlik Sense A data architect has the data in Excel as shown on the left Business rules state that if the ShipmentDate field is empty, it should be populated with the first valid previous date as shown on the right. Which script should the data architect use to meet this requirement?

A)

B)

C)

D)

Refer to the exhibit.

A business analyst reports that the 'CompanyAge' field does NOT display for users The data architect examines the LOAD script and wants to place the breakpoint in the script to check the field name.

Which line number should the data architect use?

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?

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 company needs to analyze sales data based on the exchange rate of the different countries every day About 30 reports must be produced with an average of 20r000 rows each. This process is estimated to take about three hours.

Reports will be in Excel and distributed to business users according to defined security rules

Which two products should the data architect use to build this solution? (Select two.)