QSDA2024 Practice Exam Questions and Answers

A.  

Option A

B.  

Option B

C.  

Option C

D.  

Option D

A.  

Macro on server

B.  

Execute server script

C.  

Include script function

D.  

Call batch file

A.  

FilePath, FOR EACH, Peek, Drop

B.  

FileSize, IF, THEN, END IF

C.  

FilePath, IF, THEN, Drop

D.  

FileExists, FOR EACH, IF

A.  

Insert a Group By clause into the LOAD statement for the CustTemp table after the FROM clause

B.  

Move the Country field to the first position in the field list in the LOAD statement

C.  

Perform a Resident LOAD of the CustTemp table and insert an Order By clause in this table

D.  

Insert an Order By clause after the FROM clause in the CustTemp table

A.  

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. Left join Orders and OrderDetails

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

B.  

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

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

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

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 the OrderDetails table

4. Left join Orders and OrderDetails

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

A.  

A field with social media source, a set of key fields to sort out updated records, configure reload task to load four times a day

B.  

A field with record creation time, a secondary key field to remove deleted records, configure reload task to load four times a day

C.  

A field with ModificationTime, a primary key field to sort out updated records, insert and append records, update records

D.  

A field with ModificationTime, a primary key field to sort out updated records, insert and update records, remove records

A.  

Remove the LineNo field from Shipments and use the AutoNumber function on the OrderlD field

B.  

Remove the LineNo field from both tables and use the AutoNumber function on the OrderlD field

C.  

Create a composite key using OrderlD and UneNo

D.  

Create a composite key using OrderlD and LineNo, and remove OrderlD and LineNo from Shipments

A.  

Customer Names and Sales records for the selected month, Budgets column can contain null or non-null values

B.  

All Customer Names for both Sales and Budget records for the selected month

C.  

Customer Names and Sales records for the selected month but with only non-null values in Budget column

D.  

Customer Names and Budaets records for the selected month. Sales column can contain null or non-null values

A.  

Application size, application theme, storytelling, data model, IT use case

B.  

User sessions, source data architecture, compatibility, data model, business use case

C.  

QlikView archival, source data architecture, load script, data model, business use case

D.  

Application metadata, application theme, user sessions, load script, IT use case

A.  

Qlik REST Connector

B.  

Microsoft SQL Server

C.  

Qlik GeoAnalytics

D.  

Mailbox IMAP