CertsTopics Logo

Pre-Summer Special - Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: top65certs

Free and Premium Qlik QSDA2019 Dumps Questions Answers

Page: 1 / 2
Total 1 questions
Get QSDA2019 Full Access Download QSDA2019 PDF

Qlik Sense Data Architect Certification Exam - February 2021 Release Questions and Answers

Question 1

Refer to the exhibit.

A data architect needs to analyze the number of orders by customer. The data is stored in two Excel files: Orders and Customers The data architect creates a bar chart, but the data is obviously incorrect. What should the data architect do to resolve this issue?

Options:

A.

Open the data manager, split the Customers table, and Concatenate Orders and Customers on the CustomerlD field

B.

Open the data manager split the Customers table, and associate on CustomerlD

C.

Open the data load editor, use CONCATENATE to concatenate Orders and Customers

D.

Open the data load editor, rename the CustomerlD field, and concatenate Orders and Customers

Buy Now
Question 2

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 3

Refer to the exhibit.

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 4

A data architect needs to write the expression for a measure on a KPI to show the sales person with the highest sales. The sort order of the values of the fields is unknown. When two or more sales people have sold the same amount, the expression should return all of those sales people.

Which expression should the data architect use?

Options:

A.

Concat(DISTINCT IF{Aggr{Rank{Sum(Sales),4),Salesperson)=1,Salesperson),' ')

B.

FirstSortedValue{DISTINCT Salesperson,-Aggr{Sum(Sales),Salesperson))

C.

Concat(DISTINCT IF{Aggr{Rank{Sum(Sales),1),Salesperson)=1, Salesperson) , ' ')

D.

FirstSortedValue {Salesperson, -Aggr (Sum{Sales), Salesperson))

Question 5

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.

Four

C.

Five

D.

Three

Question 6

A data architect completes development of a new app with two data sources Both data sources will also be used by other apps in the future The sources have different data refresh frequencies

• Source 1 Contains frequently updated data and must be refreshed hourly

• Source 2 Contains data that is transferred from a partner and must be refreshed weekly

Tasks must be created to load the data sources and make sure that the new app uses the most current data The data will be stored in two QVDs Which tasks should be created to meet these requirements'?

Options:

A.

1 Schedule Task 1 to run hourly and refresh data from Source 1

2 Schedule Task 2 to run weekly and refresh data from Source 2

3. Schedule a task for the app that is dependent on completion of Tasks 1 or 2 that loads the two QVDs

B.

1. Schedule Task 1 to run hourly and refresh data from Source 1

2 Schedule Task 2 that is dependent on Task 1 to refresh data from Source 2

3. Schedule a task for the app that is dependent on completion of Task 2 that loads the two QVDs

C.

1. Schedule Task 1 to run hourly and refresh data from Source 1

2 Schedule Task 2 that is dependent on Task 1 to refresh data from Source 2

3 Schedule a task for the app that is dependent on completion of Tasks 1 and 2 that loads the two QVDs

D.

1 Schedule Task 1 to run hourly and refresh data from Source 1

2 Schedule Task 2 to run weekly and refresh data from Source 2

3. Schedule a task for the app that is dependent on completion of Task 2 that loads the two QVDs

Question 7

A customer has a dataset that contains latitude and longitude data for service points around the country. The data is retrieved using the following statement:

It must be clear to the end user that this is geographic data. Drag and drop, map-based visualization of this data is required. Which two steps should the data architect take to support this data?(Select two.)

Options:

A.

Define Location as a master item, and set the tag to Sgeodata

B.

Add GeoProject{' Point' , Lat&Long) AS Point to the preceding load

C.

Add GeoKakePoint (Lat, Long} as Point to Location's preceding load

D.

Add the following to the end of the script:

TAG FIELD LocationName With 'Sgeodata1, 'Srelated'; TAG FIELD Point With 'Sgeodata', 'Srelated1;

E.

Add the following to the end of the script:

TAG FIELD LocationName With 'Sgeoname', •@relates_Pt';

TAG FIELD Point With 'Sgeopoint*f 'Srelates Location', '$hidden';

Exam Detail
Vendor: Qlik
Certification: Qlik Other Certification
Exam Code: QSDA2019
Exam Name: Qlik Sense Data Architect Certification Exam - February 2021 Release
Last Update: Mar 13, 2025
QSDA2019 Question Answers
Page: 1 / 2
Total 1 questions
Get QSDA2019 Full Access Download QSDA2019 PDF