Good QSDA2024 Exam Dumps Save Your Preparation Time

1. A company's analytics team is migrating from QlikView to Qlik Sense. During the transition there is an opportunity to improve overall reporting.

Which set of criteria must the data architect consider while planning for the migration?

2. Refer to the exhibit.





A company stores the employee data within a key composed of Country, UserlD, and Department. These fields are separated by a blank space. The UserlD field is composed of two characters that indicate the country followed by a unique code of two or three digits. A data architect wants to retrieve only that unique code.

Which function should the data architect use?

A)





B)





C)





D)

3. A data architect needs to load data from two different databases. Additional data will be added from a folder that contains QVDs, text files, and Excel files.

What is the minimum number of data connections required?

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

Which script should the data architect use?

A)





B)





C)





D)

5. Exhibit.





Refer to the exhibits.

The Orders table contains a list of orders and associated details. A data architect needs to replace the SupplierlD with the SupplierName using the second table as the source.

The output must be a single table.

Which script should the data architect use?

A)





B)





C)





D)

6. Exhibit.





A data architect must load the two tables without creating a synthetic key. The data architect also must make sure expressions like Sum([Budgeted Sales]) are calculated correctly.

Which load script meets these requirements?

A)





B)





C)





D)

7. Users of a published app report incomplete visualizations. The data architect checks the app multiple times and cannot replicate the error. The error affects only one team.

Which is the most likely cause?

8. A data architect needs to acquire social media data for the past 10 years. The data architect needs to track all changes made to the source data, include all relevant fields, and reload the application four times a day.

What information does the data architect need?

9. Refer to the exhibit.





A data architect needs to load data from Customers.qvd and sort the Country field in ascending order.

Which method should be used?

10. A data architect needs to develop three separate apps (Sales, Finance, and Operations). The three apps share numerous identical calculation expressions.

The goals include:

• Reducing duplicate script

• Saving time on expression modifications

• Increasing reusable Qlik developer assets.

The data architect creates a common script and stores it on a file server that Qlik Sense can access.

How should the data architect complete the requirements?

11. Exhibit.





Refer to the exhibit.

A business analyst informs the data architect that not all analysis types over time show the expected data.

Instead they show very little data, if any.

Which Qlik script function should be used to resolve the issue in the data model?

12. A data architect inherits an app that takes too long to load and overruns the data load window.

The app pulls all records (new and historical) from three large databases. The reload process puts a heavy load on the source database servers. All of the data is required for analysis.

What should the data architect do?

13. The data architect has been tasked with building a sales reporting application.

• Part way through the year, the company realigned the sales territories

• Sales reps need to track both their overall performance, and their performance in their current territory

• Regional managers need to track performance for their region based on the date of the sale transaction

• There is a data table from HR that contains the Sales Rep ID, the manager, the region, and the start and end dates for that assignment

• Sales transactions have the salesperson in them, but not the manager or region.

What is the first step the data architect should take to build this data model to accurately reflect performance?

14. Refer to the exhibit.





A system creates log files and csv files daily and places these files in a folder. The log files are named automatically by the source system and change regularly. All csv files must be loaded into Qlik Sense for analysis.

Which method should be used to meet the requirements?

A)





B)





C)





D)

15. A data architect implements Section Access on an app to reduce the data for each user when the user logs in. Each user is allowed to see their specific territory only.

The app is set for a scheduled reload every three hours. Without Section Access added, the app loads successfully. When Section Access is added and the script runs, the app fails to load.

What is causing this issue?

A. The ACCESS Column in the Section Access table has been added in lowercase.

B. The service account running the task is not included in the Section Access table.

C. A user name listed in the Section Access table is spelled incorrectly.

D. The data architect does not have rights to reload the app.

16. Exhibit.





Refer to the exhibit.

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

How should the data architect resolve the synthetic key?

17. Refer to the exhibit





A large transport company (Company A) acquires a smaller rival (Company B).

Company A has been using Qlik Sense tor 6 years to track revenue per ship journey. Ship journeys with no revenue (such as journeys to shipyards for repair) always show revenue of $0.

Company A wants to combine its data set with the data set of the acquired Company B.

Company B's ship journey data shows $0 revenue in one of the following ways:

• A NULL value

• A value with one or more blank spaces (ASCII char code 32)

The data architect wants to conform the Company B data to the Company A standard, specifically regarding the use of an explicit $0 for journeys without revenue.

Which script line should the data architect use?

A)





B)





C)





D)

18. 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:





How many tables will this script create?

19. Exhibit.





A large electronics company re-assigns sales people once per year from one Department to another.

SPID is the Salesperson ID; the SPID for each individual sales person Name remains constant. The Department for a SPID may change; each change is stored in the Dynamic Dimension data.

Four tables need to be linked correctly: a transaction table, a dynamic salesperson dimension, a static salesperson dimension, and a department dimension.

Which script prefix should the data architect use?

20. A data architect executes the following script:





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