1. Home
  2. Qlik
  3. Qlik Sense Data Architect
  4. QSDA2021
  5. Qlik Sense Data Architect Certification Exam - February 2021 Release Questions and Answers

Pass the Qlik Qlik Sense Data Architect QSDA2021 Questions and answers with CertsForce

 Qlik Exams      Go to Exam Detail      Get Premium Access
Viewing page 1 out of 2 pages
Viewing questions 1-10 out of questions
Questions # 1:

A data architect needs to load Table_A from an Excel file and sort the data by Field_2.

Which script should the data architect use?

A)

Question # 1

B)

Question # 1

C)

Question # 1

D)

Question # 1

Options:
A.

Option A

B.

Option B

C.

Option C

D.

Option D

Questions # 2:

Refer to the exhibit.

Question # 2

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?

Options:
A.

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

B.

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

C.

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

D.

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

Questions # 3:

Question # 3

A company has different departments. Executive and Sales should always be the first values in aDepartment filter pane. Which script must the data architect use to meet this requirement?

A)

Question # 3

B)

Question # 3

C)

Question # 3

D)

Question # 3

Options:
A.

Option A

B.

Option B

C.

Option C

D.

Option D

Questions # 4:

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

Options:
A.

Canonical calendar

B.

Generic load

C.

Data island

D.

Multiple calendars

E.

Link table

Questions # 5:

Question # 5

Refer to the exhibit

A data architect is working on an app that contains orders, invoices, and shipping data. There are three different date fields within the data:

* OrderDate

* InvoiceDate

* ShippingDate

The business analyst needs to replicate the chart above to show Order and Shipping amounts on the same Month axis.

What should the data architect do?

Options:
A.

Create a Month field for each of the three dates in the fact table and use that in the chart

B.

Load the key field and the three date fields into a concatenated bridge table that contains KeyField and Date

C.

Left Join the three date fields onto one bridge table using the key field containing KeyField and Date

Questions # 6:

Refer to the exhibits.

Question # 6

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?

Options:
A.

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

B.

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?

C.

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

D.

In the SUBFIELD function, replace the '- with a ‘|’ or '-’ character

E.

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

F.

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

G.

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

Questions # 7:

Multiple department fields in a dataset require a description

A data architect needs to add the department descriptions or a default value when the department does NOT have a description

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

Options:
A.

ApplyMap with two parameters after the Mapping load

B.

Left Join between tables and Description xlsx in every Department table

C.

Enter "Missing description" in the blank rows for Description xlsx then Mapping Load

D.

ApplyMap with three parameters after the Mapping load

Questions # 8:

A data architect executes the following script:

Question # 8

What will Field_1 contain after this script is executed?

Options:
A.

Abed, abed, ABCD

B.

abcd

C.

Abcd, abcd

D.

Abed, abed, ABCD, ABCDABCD

Questions # 9:

Refer to the exhibit.

Question # 9

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:

Question # 9

Options:
A.

3

B.

1

C.

6

D.

4

Questions # 10:

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?

Options:
A.

Two

B.

Five

C.

Four

D.

Three

Viewing page 1 out of 2 pages
Viewing questions 1-10 out of questions