Qlik QSDA2022 Quiz 1 Topic 7 Questions 1-5

Question: 1

A company has different departments. Executive and Sales should always be the first values in a Department filter pane. Which script must the data architect use to meet this requirement?

A)

q1_QSDA2022

B)

q1_QSDA2022

C)

q1_QSDA2022

D)

q1_QSDA2022

AOption A

BOption B

COption C

DOption D

Show Answer

Question: 2

A data architect of an organization that has implemented Qlik Sense on Windows needs to load large amounts of data from a database that is continuously updated

New records are added, and existing records get updated and deleted. Each record has a LastModified field.

All existing records are exported into a QVD file. The data architect wants to load the records into Qlik Sense efficiently.

Which steps should the data architect take to meet these requirements?

A1 Load the existing data from the QVD
2. Load the new and updated data from the database without the rows that have just been loaded from the QVD and concatenate with data from the QVD
3. Load all records from the key field from the database and use an INNER JOIN on the previous table

B1. Load the existing data from the QVD
2. Load new and updated data from the database Concatenate with the table loaded from the QVD.
3. Create a separate table for the deleted rows and use a WHERE NOT EXISTS to remove these records

C1. Use a partial LOAD to load new and updated data from the database.
2. Load the existing data from the QVD without the updated rows that have just been loaded from the database and concatenate with the new and updated records
3. Use the PEEK function to remove the deleted rows

D1 Load the new and updated data from the database.
2. Load the existing data from the QVD without the updated rows that have just been loaded from the database and concatenate with the new and updated records.
3. Load all records from the key field from the database and use an INNER JOIN on the previous table.

Show Answer

Question: 3

Refer to the exhibit.

q3_QSDA2022

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?

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

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

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

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

Show Answer

Question: 4

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:

q4_QSDA2022

It must be clear to the end user that this is geographic dat

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

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

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

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

DAdd the following to the end of the script:
TAG FIELD LocationName With 'Sgeodata1, 'Srelated'; TAG FIELD Point With 'Sgeodata', 'Srelated1;

EAdd the following to the end of the script:
TAG FIELD LocationName With 'Sgeoname', *@relates_Pt';
TAG FIELD Point With 'Sgeopoint*f 'Srelates Location', '$hidden';

Show Answer

Question: 5

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?

AUse where exists (ID, StorelD)

BUse where exists (ID)

CUse Concatenate before loading the Stores table

Show Answer

Qlik QSDA2022 Quiz:1 Topic:7 Questions:1-5