Note! Following QSDA2019 Exam is Retired now. Please select the alternative replacement for your Exam Certification. The new exam code is QSDA2021

QSDA2019 Exam Dumps - Qlik Sense Data Architect Certification Exam - February 2021 Release

Question # 4

Refer to the exhibit.

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?

Add the line lib connect to 'QVD(abc_qservice/orderData.qvd) '; before the LOADforthe OrderData table

Add the line lib connect to ' SQL (abc_qs9rvi.es) â€˜ ;before the LOAD for the OrderDetail table

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

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

Full Access

Question # 5

A company decides to migrate all apps from QlikView to Qlik Sense. After converting an apps: there are several unconverted objects What should the data architect do?

Save the unconverted objects as extensions and import them into Qlik Sense

Remove the set analysis statements from the unconverted objects

Re-create the unconverted objects

Save the unconverted objects as master items

Full Access

Question # 6

Refer to the exhibit.

A business department is forecasting revenue within an Excel spreadsheet.

A data architect needs to include this forecast into the existing data model, and without losing any data.

Which two sets of steps will meet these requirements? (Select two.)

1. Load the Excel spreadsheet using the data load editor

2. Use the Unpivot function

3 Use the Sum function to group the forecast by date

4 Connect to the existing data model

1. Load the Excel spreadsheet using the data load editor

2 Use the Crosstable function to unpivot the table

3 Create a composite key out of the date and region

4 Connect the new table to the data model

1 Load the Excel spreadsheet using the data load editor

2. Change the sort order by date

3. Create a composite key out of the forecast and region 4 Connect to the existing data model

1 Load the Excel spreadsheet into the data manager

2. Use the Unpivot function

3. Create a composite key from the date and region

4. Connect the new table to the data model

1 Load the Excel spreadsheet using the data manager

2 Rename the ForecastDate field to Date 3. Disable the Region

4 Connect to the existing data model

Full Access

Question # 7

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?

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

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

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

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

Full Access