CertsTopics Logo

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

Qlik QSDA2022 Based on Real Exam Environment

Page: 2 / 3
Total 77 questions
Get QSDA2022 Full Access Download QSDA2022 PDF

Qlik Sense Data Architect Certification Exam - 2022 Questions and Answers

Question 5

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';

Question 6

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

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

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

Page: 2 / 3
Total 77 questions
Get QSDA2022 Full Access Download QSDA2022 PDF