New Year Special Limited Time Flat 70% Discount offer - Ends in 0d 00h 00m 00s - Coupon code: 70spcl

Activedumpsnet Logo
  1. Home
  2. Qlik
  3. Qlik Sense Data Architect
  4. QSDA2022 - Qlik Sense Data Architect Certification Exam-2022

Qlik QSDA2022 Qlik Sense Data Architect Certification Exam-2022 Exam Practice Test

Page: 1 / 8
Total 77 questions
Get QSDA2022 Full Access Download QSDA2022 PDF

Qlik Sense Data Architect Certification Exam-2022 Questions and Answers

Question 1

A data architect executes the following script:

Question # 1

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

Question 2

A data architect is using an Include statement to load the collection of variables from a TextFiles folder connection into an app. The data architect needs to load the data and generate an error if it fails.

Which statement should the data architect use?

Options:

A.

$

B.

$(Must_Include=lib://TextFiles/Variables.txt);

C.

(Must_Include=lib://TextFiies/Variables.txt);

D.

(Includs=lib://TextFiles/Variables.txt);

Question 3

Refer to the exhibits.

Question # 3

A business analyst needs to see the currency conversion provided by a third party process, and only contains a record when the rate changes in a chart. The currency conversion rate data is

An existing master calendar exists in the data model that contains a full set of dates.

Which technique should the data architect use to meet this requirement?

Options:

A.

Utilize INTERVALMATCH to load the currency conversion rate between dates the conversation changed

INNER JOIN the resultant table back into the master calendar

B.

OUTER JOIN the calendar with the currency conversion table

ORDER BY the date and use the PEEK function to fill in blank values

C.

Leverage a FOR loop between the start date and end date of the master calendar

Use the MATCH function to add the currency conversion rates to the master calendar

D.

Use ITERNO and AUTOGENERATE to create a new calendar from max and min dates of the currency conversion table

Question 4

The Marketing department is using some similar KPIs in different apps that need to be modified frequently according to the business needs. The KPIs are created using master items with the same expression.

Which method should the data architect use to manage the modifications in all apps?

Options:

A.

Create a variable repository and load them using INCLUDE statements in the apps where needed

B.

Create a selection app with all the master items and use an on-demand app generation method.

C.

Create a core app with all the master items needed and use a BINARY load in the other apps.

D.

Create only a single app with all the master items needed and protect it with SECTION ACCESS.

Question 5

Question # 5

A data architect is creating an app using three tables. After executing the script, a warning displays

Which two steps should the data architect do to resolve this warning? (Select two.)

Options:

A.

Remove the rename statement (line 24) in the ProductPriceList table leaving the Product field name as is.

B.

Rename the Category field in the ProductPriceLis table to PnceCategory (line 24).

C.

Move the preceding Load statement in line 10 between table name (line 23) and Load statement (line 24).

D.

insert "Join (ProductDetails)" in front of the Load statement in line 24 to combine ProductPriceList with ProductDetails

Question 6

Question # 6

Refer to the exhibit

A data architect develops an app for Coffee4all, a coffee company with stores located throughout Europe

The script runs successfully, but the Stores table does not have any values.

What should the data architect do?

Options:

A.

Use where exists (ID, StorelD)

B.

Use where exists (ID)

C.

Use Concatenate before loading the Stores table

Question 7

A data architect needs to upload different data sources. To properly handle null values, the data architect decides to set all of these values to "Missing Value".

Which syntax should the data architect use?

Options:

A.

NullAsValue*; Set NullValues = 'Missing Value';

B.

NullasNull *;

Set NullValues = 'Missing Value';

C.

NullasNull *;

Set NullValue = 'Missing Value';

D.

NullAsValue*;

Set NullValue = 'Missing Value';

Question 8

Question # 8

The Section Access security table for an app is shown. User ABC\PPP opens a Qlik Sense app with a table using the field called LEVEL on one of the table columns.

What is the result?

Options:

A.

The user gets a "Field not found" error.

B.

The table is removed from the user interface.

C.

The user gets an "incomplete visualization" error

D.

The table is displayed without the LEVEL column.

Question 9

Question # 9

Refer to the exhibits.

The first table, Mastersports, contains the master list of all sport names that need to be loaded into the app. The second table, TeamMembers, contains the teams and team members registered for specific sports.

In a Qlik Sense app, a data architect is loading the two tables that need to be linked together based on the Sport field. The table format cannot be changed in the source.

What should the data architect do in the data load editor?

Options:

A.

Apply a preceding LOAD from the TeamMembers table with the SUBFIELD function and rename the field to Sport

B.

Apply a preceding LOAD to the MasterSports table with the SUBFIELD function to create the Sport field

C.

Apply a FOR loop to load to the MasterSports table creating the values for the Sport field

Question 10

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)

Question # 10

B)

Question # 10

C)

Question # 10

D)

Question # 10

Options:

A.

Option A

B.

Option B

C.

Option C

D.

Option D

Question 11

A data architect builds a data model for a large user group. Some sheets will be published, and the app will allow users to create their own visualizations and analyze data. Some fields must NOT appear in any field list.

How should a data architect meet these requirements?

Options:

A.

Use HidePrefix variable

B.

Add fields to master items

C.

Use security rules

D.

Use HideField variable

Load More QSDA2022 Questions 
Page: 1 / 8
Total 77 questions
Get QSDA2022 Full Access Download QSDA2022 PDF