Online QSDA2021 Exam Dumps Help You Build Confidence

1. On executing a load script of an app, the country field needs to be normalized. The developer uses a mapping table to address the issue.





What should the data architect do?

2. Create a single filter using fields from the master calendar

3. A data architect needs to load Table_A from an Excel file and sort the data by Field_2.

Which script should the data architect use?

A)





B)





C)





D)

4. Refer to the exhibit.





While performing a data load from the source shown, the data architect notices it is NOT appropriate for the required analysis.

The data architect runs the following script to resolve this issue:

5. A global retailer has a large database in which millions of sales transactions are added per hour.

Each regional sales manager should only see details for customers in their region. After filtering based on criteria such as region, gender, and income level, sales managers should be able to see the most current detailed transactions.

What should a data architect do to meet these requirements?

6. A data architect wants to combine data on presentand historic sales performance. The historic data is stored in a de-normalized archive, and the present data is maintained in a database. The output must be contained in a single table.

Which script should the data architect use?

A)





B)





C)





D)

7. A data architect is creating an app using three tables.





After executing the script, a warning displays.

Which two steps should the data architect do to resolve this warning? (Select two.)

8. Refer to the exhibits.





A business analyst needs to see the currency conversion provided by a third party process, and only contains a record when the rate changes in a chart. The currency conversion rate data is An existing master calendar exists in the datamodel that contains a full set of dates.

Which technique should the data architectuse to meet this requirement?

9. A data architect needs to create an app that combines employee data from the Sales system and the Human Resources (HR) system.

These systems identify employees differently Employees in the HR system are identified with an alpha-numeric key Employees in the Sales system are identified using an integer key.

The Human Resources manager creates a table that maps these keys to another, called Associations.

The resultant data model must meet the following requirements:

• Associations must be valid

• The model must be optimized for performance

• The option must support multiple tables added

Which solution should the data architect use to meet these requirements?

10. Concatenate Orders and OrderDetails

11. A data architect executes the following script.





Which values does the OrderDate field contain after executing the script?

12. Adata 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?

13. A data architect needs to revise an existing app.

The number of data rows has grown rapidly recently. While the app is in production, users are becoming increasingly unhappy about the response times when they make selections

Which two methods should be used to improve performance? (Select two.)

14. 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?

15. Refer to the exhibit.





A data architect executes the script.

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

16. Refer to the exhibit.





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?

17. A data architect needs to develop multiple apps for various departments. More departments are requesting apps over time The company uses specific requirements for the number interpretation variables (e.g., ThousandSep, DecimalSep) found at the beginning of a LOAD script.

The data architect wants to reduce duplicate scripts but does not want to copy and paste the number interpretation variables each time new app is created.The data architect prefers to use the least amount of script in Qlik Sense.

How should the data architect meet these requirements?