New Year Biggest Discount Flat 70% Offer - Ends in 0d 00h 00m 00s - Coupon code: 70diswrap

DumpsWrap Logo

Qlik QSDA2022 Dumps

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 plans to build an app that contains geographically diverse data that must be specific to user run-time selections. The source contains transactional data. The app must have minimal impact on already limited server resources.

Which approach should the data architect use?

Options:

A.

Loop and Reduce

B.

QVDs

C.

In-memory

D.

ODAG

Question 2

Refer to the exhibit.

as

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

Question 3

Refer to the exhibits.

as

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 theconversation 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

Refer to the exhibit.

as

A business analyst reports that the 'CompanyAge' field does NOT display for users The data architect examines the LOAD script and wants to place the breakpoint in the script to check the field name.

Which line number should the data architect use?

Options:

A.

242 because field name appears in the output Panel of the debugger

B.

251 because the field name appears in the Variable panel of the debugger

C.

251 because the field name appears in the Qlik Log files

D.

251 because the field name appears in the Output panel of the debugger

Question 5

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

Question 6

Refer to the exhibit.

A data architect is loading two tables into a data model from a SQL database These tables are related on key fields CustomerlD and CustomerKey.

Which script is valid to load the tables and maintain the correct association?

A)

as

B)

as

C)

as

D)

as

Options:

A.

Option A

B.

Option B

C.

Option C

D.

Option D

Question 7

as

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?

Options:

A.

Create a bridge table between the Departments 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.

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

D.

Join the Transactions and Salespeople tables to resolve the many-to-many relationship

Question 8

Refer to the exhibit.

as

Which changes on the database will the script capture?

Options:

A.

Insert and Remove rows

B.

Insert. Update, and Remove rows

C.

Insert and Update rows

D.

Update and Remove rows

Question 9

A dataarchitect 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

Question 10

Refer to the exhibit.

as

A data architect is loading the tables and a synth key is generated.

How should the data architect resolve the synthetic key?

Options:

A.

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

B.

Create a composite key using OrdertD and LineNo

C.

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

D.

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

Question 11

A data architect needs to develop multiple apps for various departments. More departments are requesting apps over time The company uses specific requirementsfor the number interpretation variables (e.g., ThousandSep, DecimalSep) found at the beginning of a LOAD script.

The data architect wants to reduce duplicate scripts but does not want to copy and paste the number interpretation variables each time new appis created. The data architect prefers to use the least amount of script in Qlik Sense.

How should the data architect meet these requirements?

Options:

A.

Save the script for the number interpretation variables in a text file and use the CALL function to insert the variables.

B.

Create an Excel file with the number interpretation variables and use a FOR Next loop to load the variables into Qlik Sense

C.

Save the script for the number interpretation variables in a text file and INLUDE function to insert the variables

D.

Create an Excel file with the number interpretation variables and apply the variables to the app using a mapping table

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