A company has a stream with multiple apps One of the apps is a multi-regional sales app.

A data architect must set up security for users to access the stream, enter the app, and view specific sheets and data.

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

A. Section access and set analysis

B. QMC security rules and section access

C. QMC security rules and custom properties

D. Section access and sheet properties

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?

A. 242 because field name appears in the output Panel of the debugger

B. 251 because the field name appears in the Variable panel of the debugger

C. 251 because the field name appears in the Qlik Log files

D. 251 because the field name appears in the Output panel of the debugger

Refer to the exhibit.

A data architect is working on a Qlik Sense app the business has created to analyze the company orders and shipments. To understand the table structure, the business has given the following summary:

Every order creates a unique orderlD and an order date in the Orders table An order can contain one or more order lines one for each product ID in the order details table Products in the order are shipped (shipment date) as soon as tliey are ready and can be shipped separately The dates need to be analyzed separately by Year Month, and Quarter

The data architect realizes the data model has issues that must be fixed.

Which steps should the data architect perform?

A. 1. Create a key with OrderlD and ProductID in the OrderDetails table and in the Orders table

2.

Delete the ShipmentID in the Shipments table

3.

Delete the ProductID and OrderlD in the OrderDetails table

4.

Concatenate Orders and OrderDetails

5.

Create a link table using the MasterCalendar table and create a concatenated field between OrderDate and ShipmentDate

B. 1. Create a key with OrderlD and ProductID in the OrderDeta Is table and in the Shipments table

2.

Delete the ShipmentID in the Orders table

3.

Delete the ProductID and OrderlD in the Shipmi

4.

Left join Orders and OrderDetails

5.

Use Derive statement with the MasterCalendar table and apply the derive fields to OrderDate and ShipmentDate

C. 1. Create a key with OrderlD and ProductID in the OrderDetails tab e and in the Orders table

2.

Delete the ShipmentID in the Shipments table

3.

Delete the ProductID and OrderlD in the OrderDetails

4.

Left join Orders and OrderDetails

5.

Use Derive statement with the MasterCalendar table and apply the derive fields to OrderDate and ShipmentDate

D. 1. Create a key with OrderlD and ProductID in the OrderDetails table and in the Shipments table

2. Delete the ShipmentID in the Orders table

3 Delete the ProductID and OrderlD in the Shipments table

4. Concatenate Orders and OrderDetails

Refer to the exhibit.

A data architect executes the script.

What will be the value of the first row for Field_1?

A. A

B. D

C. Null

D. 4

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?

A. $

B. $(Must_Include=lib://TextFiles/Variables.txt);

C. (Must_Include=lib://TextFiies/Variables.txt);

D. (Includs=lib://TextFiles/Variables.txt);

Refer to the exhibits.

While debugging an app, a developer loads data from an application layer QVD file.

In the process of separating a concatenated key into two parts, some split results are missing data

What should the data architect do?

A. Utilize a combination of LEFT(), MID(), and RIGHT() functions to capture the key components

B. In the SUBFIELD function, replace the `_' with a `|' or `_' character.

C. Utilize a combination of LEFT(), MID(), and RIGHTO functions to capture the key components

D. In the SUBFIELD function, replace the '- with a `|' or '-' character

E. Instruct the developer of the QVD file to correct the generation of the ConcatKeyAlpha field

F. Wrap an IF() function around the SUBFIELDQ functions to check and adapt to null values character

G. Instruct the developer of the QVD file to correct the generation of the ConcatKeyAlpha field

H. Wrap an IF() function around the SUBFIELD() functions to check and adapt to null values

A data architect of an organization that has implemented Qlik Sense on Windows 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?

A. 1 Load the existing data from the QVD

2.

Load the new and updated data from the database without the rows that have just been loaded from the QVD and concatenate with data from the QVD

3.

Load all records from the key field from the database and use an INNER JOIN on the previous table

B. 1. Load the existing data from the QVD

2.

Load new and updated data from the database Concatenate with the table loaded from the QVD.

3.

Create a separate table for the deleted rows and use a WHERE NOT EXISTS to remove these records

C. 1. Use a partial LOAD to load new and updated data from the database.

2.

Load the existing data from the QVD without the updated rows that have just been loaded from the database and concatenate with the new and updated records

3.

Use the PEEK function to remove the deleted rows

D. 1 Load the new and updated data from the database.

2.

Load the existing data from the QVD without the updated rows that have just been loaded from the database and concatenate with the new and updated records.

3.

Load all records from the key field from the database and use an INNER JOIN on the previous table.

A data architect needs to load data from two different databases Additional data will be added from a folder that contains QVDs. text files, and Excel files. What is the minimum number of data connections required?

A. Two

B. Five

C. Four

D. Three

Refer to the exhibit.

A data architect loads sales data and creates a table which shows only customers who made purchases in 2018 and 2019. The data architect applies the following set analysis expression on the sales measure. Count<{})>} Customer ID)

Which option shows the resulting table after the expression is applied?

A. Option A

B. Option B

C. Option C

D. Option D

Refer io the exhibit.

A data architect needs to modify the script to ONLY load rows from Table_B when Field_1 and Field_2 are the same as in Table_A. (For example, only the row containing A, 1, 456 should be loaded from Table_B.)

Which script should the data architect use?

A. Option A

B. Option B

C. Option C

D. Option D