QSDA2022 Exam Dumps - Qlik Sense Data Architect Certification Exam - 2022

Question # 4

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 data. Some fields must NOT appear in any field list.

How should a data architect meet these requirements?

Use HidePrefix variable

Add fields to master items

Use security rules

Use HideField variable

Full Access

Question # 5

A data architect is building a model to show trends in visualizations across seven date fields. The seven date fields reside in different tables. The data architect must efficiently build this data model.

Requirements:

â€¢ A single date selector

â€¢ Show all dates, even those with NO activity

â€¢ Minimize the impact on server resources and p

Which two solutions should the data architect use? (Select two.)

Canonical calendar

Generic load

Data island

Multiple calendars

Link table

Full Access

Question # 6

Refer to the exhibit

A data architect develops an app for Coffee4all, a coffee company with stores located throughout Europe

The script runs successfully, but the Stores table does not have any values.

What should the data architect do?

Use where exists (ID, StorelD)

Use where exists (ID)

Use Concatenate before loading the Stores table

Full Access

Question # 7

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?

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

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

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

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

Full Access

Question # 8

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?

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

In the SUBFIELD function, replace the â€˜_â€™ with a â€˜|â€™ or â€˜_â€™ character.

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?

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

In the SUBFIELD function, replace the '- with a â€˜|â€™ or '-â€™ character

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

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

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

Full Access

Question # 9

A data architect needs to upload data from ten different sources, but only if there are any changes after the last reload When data is updated, a new file is placed into a folder mapped to E A439926003 The data connection points to this folder.

The data architect plans a script which will:

1. Verify that the file exists

2. If the file exists, upload it Otherwise, skip to the next piece of code

The script will repeat this subroutine for each source. When the script ends, all uploaded files will be removed with a batch procedure.

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

FileSize, IF, THEN, END IF

FilePath, IF, THEN. Drop

FileExists, FOR EACH, IF

FilePath, FOR EACH, Peek, Drop

Full Access

Question # 10

Refer to the exhibits.

An app is built to analyze salesperson performance by department. Departments are unique within the Departments table, but Salespeople often move between departments. A strict business rule states that a salesperson must be associated with ONLY one department at all times.

The data architect creates a summary of department performance and notices the values are incorrect. The total sales KPI shows the correct result.

How should the data architect modify the data model to correct this issue?

Create a bridge table between the Departments and Salespeople tables to resolve the many-to-many relationship

Create a bridge table between the Transactions and Salespeople tables to resolve the many-to-many relationship

Join the Departments and Salespeople tables to resolve the many-to-many relationship

Join the Transactions and Salespeople tables to resolve the many-to-many relationship

Full Access

Question # 11

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?