QSDA2022 Online Practice Questions and Answers

A data architect executes the following script.

Which values does the OrderDate field contain after executing the script?

A. 20210131, 2020/01/31, 31/01/2019, 0

B. 20210131,2020/01/31,31/01/2019

C. 20210131, 2020/01/31, 31/01/2019, 9999

D. 20210131, 2020/01/31, 31/01/2019, 31/12/20

Refer to the exhibits.

Some business users created an app by using the Add data functionality and loading two Excel files Orders and Customers.

The app is used to analyze the number of orders by customer. When the users create a bar chart to review the figures, the data shown is incorrect.

What should the data architect do to resolve this issue?

A. Open the data manager, split the Customers table, and associate both tables on CustomerlD field

B. Open the data manager, split the Customers table, and JOIN Orders and Customers on the CustomerlD field

C. Open the data load editor and use JOIN instead of concatenate to combine Orders and Customers by CustomerlD

D. Open the data load editor and apply a NOCONCATENATE function in the LOAD statement on the Orders table

Refer to the exhibit.

A data architect is working with an app and creates some visualizations to check the data. Some visualizations show issues in the data set.

*

The Sales by Country table shows a total OrderValue of 18,300 sales while the KPI shows a total OrderValue of 20,600.

*

The Sales monthly trend bar chart does not work with the Month field. Which two data issues should the data architect fix in the app? (Select two.)

A.

The Month field does not exist in the Orders table and needs to be incorporated in the table using he Calendar table.

B.

In the Orders table, some CustomerlD values are null because there are orders with no customer and needs to be incorporated in the table using the Calendar table, null because there are orders with no customer

C.

In the Orders table, some values in the CustomerlD field do not exist in the Customers table.

D.

The OrderDate field values in the Calendar table do not match with the values in the OrderDate field from the Orders table

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?

A. Use where exists (ID, StorelD)

B. Use where exists (ID)

C. Use Concatenate before loading the Stores table

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. Option A

B. Option B

C. Option C

D. Option D

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?

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

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

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

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

Refer to the exhibit.

While performing a data load from the source shown, the data architect notices it is NOT appropriate for the required analysis. The data architect runs the following script to resolve this issue:

A. 3

B. 1

C. 6

D. 4

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 Human Resources Director needs an app to analyze organizational structure. The Directory is particularly interested in the longest levels of line management. Two table loads are required. Both use the same basic structure.

Which two table load prefixes are needed?

A. HierarchyLevel(EmployeelD, ManagerlD Name Level, '/', Structure) HierarchyBelongsTo(EmployeelD, ManagerlD, Name ManagerlD, Manager, Depth)

B. HierarchyBelongsTo(ManagerlD, Manager, ManagerlD, ManagerlD, Manager Level) Hierarchy(EmployeelD, ManagerlD, Name. Manager Name, Structure `/' Depth)

C. Hierarchy(EmployeelD. ManagerlD Name, Manager Name, Structure V, Depth) HierarchyLevelEmployeelD, ManagerlD, Name, Manager, Name, Structure, Depth `/')

D. HierarchyBelongs.To(EmployeeID, ManagerlD, Name ManagerlD, Manager, Depth)

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