Qlik QSDA2022 Exam Practice Test Instant Access

Question 1

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?

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

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

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

Answer : C

Question 2

Refer to the exhibit.

A data architect executes the script.

What will be the value of the first row for Field_1?

CNull

Answer : B

Question 3

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?

AFirstSortedValue (Salesperson, -Aggr (Sum(Sales) , Salesperson) )

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

CFirstSortedValue (DISTINCT Salesperson, -Aggr (Sum(Sales) , Salesperson) )

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

Answer : D

Question 4

Refer to the exhibit.

A data architect is loading two tables: Orders and Product. The Product table includes attributes and values for each ProductID such as Colour, Price, Category, and Description.

The business analyst can filter by the value of these attributes. For performance reasons, the Data Model will use two tables.

Which solution should the data architect apply in the Data Load Editor to build the ProductDetails table?

For performance reasons, the Data Model will use two tables a Load Editor to build the ProductDetails table?

AUse a For loop to concatenate all of the Products table and apply a Generic Load to the final concatenate table

BUse a For loop to apply a Generic load to the Product table and concatenate the generic tables together

CUse a Generic Load in the Product table and a For loop to left join each Generic table

Answer : C

Question 5

A data architect executes the following script:

What will be the result of Table A?

AOption A

BOption B

COption C

DOption D

Answer : D

Question 6

Refer to the exhibits.

A music teacher needs to know which artists are eligible to enter this year's competition.

The teacher needs to find only the artists who have a music grade rank above two and play more than one instrument.

Which expression is needed for the Number of Instruments measure in the table?

ACount({$<Artist={'=Count(Instrument)>=2'}, Artist={'=Grade>2'}>}Instrument)

BCount({S<Count(Instrument)={'>=2'}, Grades={'>2'}>}Instrument)

CCount({$<Instrument={'>=2'}, Artist={'=Grade>2'}>}Instrument)

DCount ({S<Artist={'=Count(Instrument)>=2M}, Grades={'>2'}>}Instrument)

Answer : A

The correct expression to use for the Number of Instruments measure in the table is Option A. This expression will count the number of instruments played by artists with a music grade rank greater than two.

https://www.mckinsey.com/capabilities/mckinsey-digital/our-insights/how-to-build-a-data-architecture-to-drive-innovation-today-and-tomorrow

How to build a data architecture to drive innovation--today and ...

https://www.mckinsey.com/capabilities/mckinsey-digital/our-insights/how-to-build-a-data-architecture-to-drive-innovation-today-and-tomorrow

https://journalofbigdata.springeropen.com/articles/10.1186/s40537-019-0217-0

Big data in healthcare: management, analysis and future prospects ...

https://journalofbigdata.springeropen.com/articles/10.1186/s40537-019-0217-0

https://www.ncbi.nlm.nih.gov/books/NBK551878/

Obtaining Data From Electronic Health Records - Tools and ...

https://www.ncbi.nlm.nih.gov/books/NBK551878/

Question 7

Refer to the exhibit.

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

How should the data architect resolve the synthetic key?

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

BCreate a composite key using OrdertD and LineNo

CRemove the LineNo field from both tables and use the AutoNumber function on the OrderlC field

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

Answer : D

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