QUESTION 26
A data architect needs to develop multiple apps for various departments.
More departments are requesting apps over time The company uses specific requirementsfor the number interpretation variables (e.g., ThousandSep, DecimalSep) found at the beginning of a LOAD script.
The data architect wants to reduce duplicate scripts but does not want to copy and paste the number interpretation variables each time new appis created. The data architect prefers to use the least amount of script in Qlik Sense.
How should the data architect meet these requirements?

QUESTION 27
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?

QUESTION 28
Refer to the exhibit.

A data architect has a data model that includes historical order fulfillment centers. The order fulfillment centers occasionally changed location. The history of order fulfillment must be tracked on a per center, per location basis.
Which scripting function should the data architect use to meet this data modeling requirement?

QUESTION 29
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.)

QUESTION 30
Refer to the exhibit.

A data architect must classify each product into a price group. The price groups must be the same width by default and allow users to dynamically change the width of the bucket duringanalysis.
Which feature should the data architect use to meet these requirements?

QUESTION 31
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)

QUESTION 32
Refer to the exhibit.

This table contains information about the number of admissions and discharges of patients in a hospital. The values can be positive or negative. The data architect needs to create an extra column that contains the number of patients that are currently in the hospital.
Which script should the data architect use ?
A)

B)

C)

D)

QUESTION 33
A data architect completes development of a new app with two data sources Both data sources will also be used by other apps in the future The sources have different data refresh frequencies
* Source 1 Contains frequently updated data and must be refreshed hourly
* Source 2 Contains data that is transferred from a partner and must be refreshed weekly Tasks must be created to load the data sources and make sure that the new app uses the most current data The data will be stored in two QVDs Which tasks should be created to meet these requirements’?

QUESTION 34
Users of a published app report incomplete visualizations. The data architect checks the app multiple timesand cannot replicate the error. The error affects only one team.
What is the most likely cause?

QUESTION 35
A human resources (HR) team manager is due to go on leave. The manager needs to assign permissions to colleague to help the HR team publish apps. Which action(s) should the manager assign to the colleague before going on leave?

QUESTION 36
Refer to the exhibit.

A data architect executes the script.
What will be the value of the first row for Field_1?

QUESTION 37
Refer to the exhibit.

The data architect needs to create a KPI that displays the average amount of orders per customer. This aggregated field should be added to the existing orders table Which script should the data architect use?
A)

B)

C)

D)

QUESTION 38
A data architect needs to develop a script to export tables from a model based upon rules from an independent file. Thestructure of the text file with the export rules is as follows:

These rules govern which table in the model to export, what the target root filename should be, and the number of copies to export.
The TableToExport values are already verified to existin the model.
In addition, the format will always be QVD, and the copies will be incrementally numbered.
For example, the Customer table would be exported as:
What is the minimum set of scripting strategies the data architect must use?

QUESTION 39
Refer to the exhibit.

A customer needs to load forecast data from an Excel file.
Which preceding load statement should the data architect use to load the data?

QUESTION 40
A data architect needs to upload different data sources. To properly handle null values, the data architect decides to set all of these values to “Missing Value”.
Which syntax should the data architect use?

QUESTION 41
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 toimprove performance? (Select two.)

QUESTION 42
A data architect needs to arrange data to create an app with a map where multiple location points consolidate into hexagonal areas based on postal codes The areas will be color coded based on the number of vendors in thelocation.
Which GeoAnalytics operation should the data architect use?

QUESTION 43
A data architect needs to add the UnitCost field from the ProductCost table in the Dim_Products Table.
Which script code should the data architect use?

QUESTION 44

On executing a load script of an app, the country field needs to be normalized. The developer uses a mapping table to address the issue.
What should the data architect do?

QUESTION 45
A data architect wants to combine data on present and historic sales performance.
The historic data is stored in a de-normalized archive, and the present data is maintained in a database.
The output must be contained in a single table.
Which script should the data architect use?