1. Home
  2. Qlik
  3. Qlik Sense Data Architect
  4. QSDA2022
  5. Qlik Sense Data Architect Certification Exam-2022 Questions and Answers

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

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

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

Questions # 2:

Refer to the exhibit.

Question # 2

A business department is forecasting revenue within an Excel spreadsheet.

A data architect needs to include this forecast into the existing data model, and without losing any data.

Which two sets of steps will meet these requirements? (Select two.)

Options:
A.

1. Load the Excel spreadsheet using the data load editor

2. Use the Unpivot function

3 Use the Sum function to group the forecast by date

4 Connect to the existing data model

B.

1. Load the Excel spreadsheet using the data load editor

2 Use the Crosstable function to unpivot the table

3 Create a composite key out of the date and region

4 Connect the new table to the data model

C.

1 Load the Excel spreadsheet using the data load editor

2. Change the sort order by date

3. Create a composite key out of the forecast and region 4 Connect to the existing data model

D.

1 Load the Excel spreadsheet into the data manager

2. Use the Unpivot function

3. Create a composite key from the date and region

4. Connect the new table to the data model

1 Load the Excel spreadsheet using the data manager

2 Rename the ForecastDate field to Date 3. Disable the Region

4 Connect to the existing data model

Questions # 3:

A data architect executes the following script.

Question # 3

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

Options:
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

Questions # 4:

Refer to the exhibit.

Question # 4

An existing app on Qlik Sense Enterprise is duplicated and transferred to a data architect to add some additional data When trying to manually reload the original script, the data architect receives an error

What should be done to make sure the script runs correctly?

Options:
A.

Add the line lib connect to 'QVD(abc_qservice/orderData.qvd) '; before the LOAD for the Order Data table

B.

Add the line lib connect to ' SQL (abc_qs9rvi.es) ‘ ;before the LOAD for the Order Detail table

C.

Give the data architect the Read rights on the data connections in the QMC

D.

Make the data architect the owner of the app in the QMC

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

Question # 6

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

Options:
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

Questions # 7:

A company decides to migrate all apps from QlikView to Qlik Sense. After converting an apps: there are several unconverted objects What should the data architect do?

Options:
A.

Save the unconverted objects as extensions and import them into Qlik Sense

B.

Remove the set analysis statements from the unconverted objects

C.

Re-create the unconverted objects

D.

Save the unconverted objects as master items

Questions # 8:

A data architect needs to build an Order Fulfillment app. The business requires front-end performance is optimized.

The OrderDate and ShipmentDate are located in different tables.

The user needs to identify the data type and must be able to:

• Show trends for orders and shipments

• Use a single filter for both date fields

• Analyze data over fiscal periods

Which steps should the data architect take to build the data model?

Options:
A.

1. Create a link table with master calendar fields

2. Create a single filter using fields from the master calendar

B.

1. Load the Shipments and Orders table via the data manager

2. Create a single filter using fields from the Orders table

C.

1. Create a master calendar and join into the Shipments and Orders table

2. Create a single filter using fields from the Shipments table

D.

1. Create a master calendar table as a data island

2. Create a single filter using fields from the master calendar

Questions # 9:

A data architect executes the following script:

Question # 9

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 # 10:

Refer to the exhibit.

Question # 10

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)

Question # 10

B)

Question # 10

C)

Question # 10

D)

Question # 10

Options:
A.

Option A

B.

Option B

C.

Option C

D.

Option D

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