Winter Sale Special Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: v4s65

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

Go to page:
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?

A.

FileSize, IF, THEN, END IF

B.

FilePath, IF, THEN. Drop

C.

FileExists, FOR EACH, IF

D.

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?

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

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?

A)

B)

C)

D)

A.

Option A

B.

Option B

C.

Option C

D.

Option D

Full Access
Go to page: