Free Qlik QSDA2019 Exam Dumps Questions & Answers

Refer to the exhibit.

A clothing retailer wants to review their product pricing strategy.
A data architect must classify each product into a price group. The price groups must be the same width by default and allow users to dynamically change the width of the bucket during analysis.
Which feature should the data architect use to meet these requirements?

• A.Class function in a calculated dimension
• B.IntervalMatch and use variables
• C.Nested IFs in a calculated dimension
• D.Class function in the script and use variables

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?

• A.FirstSortedValue {Salesperson, -Aggr (Sum{Sales), Salesperson))
• B.Concat(DISTINCT IF{Aggr{Rank{Sum(Sales),1),Salesperson)=1, Salesperson) , ' ')
• C.Concat(DISTINCT IF{Aggr{Rank{Sum(Sales),4),Salesperson)=1,Salesperson),' ')
• D.FirstSortedValue{DISTINCT Salesperson,-Aggr{Sum(Sales),Salesperson))

Refer to the exhibits.

Executives need to see the total sales by region for the current year. The data architect inherits App1 from a former employee who tried to address this requirement. Two Excel spreadsheets, Region and Employee, are used as the data source. The data architect creates a table and identifies errors in the amount of sales per region.
How should the data architect resolve the errors?

• A.In the data manager split the Region table and associate by Region.ID
• B.In the data manager split the Region table and associate by EmployeelD
• C.In the data load editor, concatenate the Region and Employee tables
• D.In the data manager, concatenate the Region table and associate by Region.ID

A data architect needs to load large amounts of data from a database which 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?

• A.1. 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.
• B.1. 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. 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.
• C.1. 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. Concatenate with the new and updated records.
  3. Use the Peek function to remove the deleted rows.
• D.1. 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. 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.

A data architect needs to efficiently prepare a data model for a meeting in an hour.
The data source to be used contains five date fields. The app needs to display sales trends and compare the current year to date (CYTD) to last year to date (LYTD). The app is NOT going to be published. It will only be used for this meeting and a single user's ad-hoc analysis.
What should the data architect do to meet these requirements?

• A.Create five master calendars
• B.Create a canonical calendar
• C.Load a calendar island
• D.Use the data manager