A data architect needs to load large amounts of data from a database that is continuously updated.

• New records are added, and existing records get updated and deleted.

• Each record has a LastModified field.

• All existing records are exported into a QVD file.

• The data architect wants to load the records into Qlik Sense efficiently.

Which steps should the data architect take to meet these requirements?

Exhibit.

A large electronics company re-assigns sales people once per year from one Department to another.

SPID is the Salesperson ID; the SPID for each individual sales person Name remains constant. The Department for a SPID may change; each change is stored in the Dynamic Dimension data.

Four tables need to be linked correctly: a transaction table, a dynamic salesperson dimension, a static salesperson dimension, and a department dimension.

Which script prefix should the data architect use?

Exhibit.

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?

Exhibit.

Refer to the exhibits.

The Orders table contains a list of orders and associated details. A data architect needs to replace the SupplierlD with the SupplierName using the second table as the source.

The output must be a single table.

Which script should the data architect use?

A)

B)

C)

D)

A data architect implements Section Access on an app to reduce the data for each user when the user logs in. Each user is allowed to see their specific territory only.

The app is set for a scheduled reload every three hours. Without Section Access added, the app loads successfully. When Section Access is added and the script runs, the app fails to load.

What is causing this issue?

A data architect wants reflect a value of the variable in the script log for tracking purposes. The variable is defined as:

Which statement should be used to track the variable's value?

A)

B)

C)

D)

Exhibit.

One of the data sources a data architect must add for a newly developed app is an Excel spreadsheet. The Region field only has 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 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 company generates l GB of ticketing data daily. The data is stored in multiple tables. Business users need to see trends of tickets processed for the past 2 years. Users very rarely access the transaction-level data for a specific date. Only the past 2 years of data must be loaded, which is 720 GB of data.

Which method should a data architect use to meet these requirements?

Exhibit

Refer to the exhibit.

The salesperson ID and the office to which the salesperson belongs is stored for each transaction. The data model also contains the current office for the salesperson. The current office of the salesperson and the office the salesperson was in when the transaction occurred must be visible. The current source table view of the model is shown. A data architect must resolve the synthetic key.

How should the data architect proceed?

The data architect has been tasked with building a sales reporting application.

• Part way through the year, the company realigned the sales territories

• Sales reps need to track both their overall performance, and their performance in their current territory

• Regional managers need to track performance for their region based on the date of the sale transaction

• There is a data table from HR that contains the Sales Rep ID, the manager, the region, and the start and end dates for that assignment

• Sales transactions have the salesperson in them, but not the manager or region.

What is the first step the data architect should take to build this data model to accurately reflect performance?

Exhibit.

Refer to the exhibit.

A data architect is provided with five tables. One table has Sales Information. The other four tables provide attributes that the end user will group and filter by.

There is only one Sales Person in each Region and only one Region per Customer.

Which data model is the most optimal for use in this situation?

A)

B)

C)

D)

Refer to the exhibit.

What does the expression sum< [orderMetAmount ]) return when all values in LineNo are selected?

Refer to the exhibit.

A company stores the employee data within a key composed of Country, UserlD, and Department. These fields are separated by a blank space. The UserlD field is composed of two characters that indicate the country followed by a unique code of two or three digits. A data architect wants to retrieve only that unique code.

Which function should the data architect use?

A)

B)

C)

D)

A data architect needs to develop three separate apps (Sales, Finance, and Operations). The three apps share numerous identical calculation expressions.

The goals include:

• Reducing duplicate script

• Saving time on expression modifications

• Increasing reusable Qlik developer assets.

The data architect creates a common script and stores it on a file server that Qlik Sense can access. How should the data architect complete the requirements?