Latest Qlik QSDA2022 Actual Free Exam Questions & Community Discussion, Page 2

Question #9

Refer to the exhibit.

A data architect is loading the tables and a synth key is generated.
How should the data architect resolve the synthetic key?

A. Create a composite key using OrdertD and LineNo

B. Remove the LineNo field from both tables and use the AutoNumberfunction on the OrderlC field

C. Remove the LineNo field from Shipments and use the AutoNumber function on the

D. Create a composite key using OrderlD and LineNo. and remove OrderlD and LineNo from Shipments

Discussion 0

Correct Answer: D Vote an answer

Question #10

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 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 OrderDateand ShipmentDate

B. 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 andOrderDetails
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 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

D. 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 theOrderDetails table
4. Concatenate Orders and OrderDetails
5. Create a link table using the MasterCalendar table and create a concatenated field between OrderDate and ShipmentDate

Discussion 0

Correct Answer: C Vote an answer

Question #11

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. Join the Transactions 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. Create a bridge table between the Departments and Salespeople tables to resolve the many-to-many relationship

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

Discussion 0

Correct Answer: C Vote an answer

Question #12

A data architect needs to create an app to analyze 30-day re-admissions at a hospital.
* The medical record system does NOT calculate re-admission data
* The business rule to follow: if a patient is admitted to a hospital within 30 days after being discharged from a previous hospital stay, that event should be captured in the app with a flag called "30-day Re-admission"
* Data being used from the patient record includes hospital account ID, patient ID, admission dater and discharge date Which action should the data architect perform first to meet these requirements?

A. Sequence patient records by patient ID using the Peek function

B. Calculate the days since previous discharge using admission date and discharge date

C. Order patient records by patient ID and admission date

D. Sequence patient records by hospital account ID and patient ID using the Peek function

Discussion 0

Correct Answer: C Vote an answer

Question #13

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 aQVD 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. 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

B. 1. Load the existing data from the QVD
2. Load new andupdated 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 Load the new and updated data fromthe 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 onthe previous table.

D. 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

Discussion 0

Correct Answer: C Vote an answer

Question #14

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)

B)

C)

D)

A. Option B

B. Option D

C. Option C

D. Option A

Discussion 0

Correct Answer: C Vote an answer

Question #15

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.

Discussion 0

Correct Answer: A Vote an answer

Question #16

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 architectuse to meet these requirements?

A. FilePath, FOR EACH, Peek, Drop

B. FilePath, IF, THEN. Drop

C. FileSize, IF, THEN, END IF

D. FileExists, FOR EACH, IF

Discussion 0

Correct Answer: C Vote an answer

Qlik QSDA2022 Actual Free Exam Questions & Community Discussion

Download Free Qlik QSDA2022 Demo