Qlik QSDA2024 Dumps (V10.03) – Delivering Exceptional Solutions for You Preparing for the Challenging Qlik Sense Data Architect 2024 Exam

1. A data architect receives an error while running script.

What will happen to the existing data model?

2. Refer to the exhibit.

A data architect needs to build a dashboard that displays the aggregated sates for each sales representative. All aggregations on the data must be performed in the script.

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

A)

B)

C)

D)

3. Refer to the exhibit.

What does the expression sum< [orderMetAmount ]) return when all values in LineNo are selected?

4. A data architect needs to retrieve data from a REST API. The data architect needs to loop over a series of items that are being read using the REST connection.

What should the data architect do?

5. Refer to the exhibit.

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. The script runs successfully but the resulting table is not correct.

What should the data architect do?

6. A data architect executes the following script:

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

7. Create a separate table for the deleted rows and use a WHERE NOT EXISTS to remove these records.

8. Exhibit.

Refer to the exhibit.

The data architect needs to build a model that contains Sales and Budget data for each customer.

Some customers have Sales without a Budget, and other customers have a Budget with no Sales.

During loading, the data architect resolves a synthetic key by creating the composite key.

For validation, the data architect creates a table that contains Customer, Month, Sales, and Budget columns.

What will the data architect see when selecting a month?

9. A data architect wants reflect a value of the variable in the script log for tracking purposes.

The variable is defined as:

Which statement should be used to track the variable's value?

A)

B)

C)

D)

10. Use Derive statement with the MasterCalendar table and apply the derive fields to OrderDate and ShipmentDate

11. If the file exists, upload it Otherwise, skip to the next piece of code.

The script will repeat this subroutine for each source.

When the script ends, all uploaded files will be removed with a batch procedure.

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

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

13. A startup company is about have its Initial Public Offering (IPO) on the New York Stock Exchange.

This startup company has used Qlik Sense for many years for data-based decision making for Sales and Marketing efforts, as well as for input into Financial Reporting. The startup's Qlik Sense applications use variables that have different values at different points in time.

Due to the increased rigor required in record keeping for public companies, these variables must be clearly recorded in the script reload logs of the Qlik Sense applications. These logs are refreshed daily.

The data architect wants to have the variables names, with their current values, written into the script reload logs.

Which script statement should the data architect use?

14. A data architect needs to develop a script to export tables from a model based upon rules from an independent file.

The structure of the text file with the export rules is as follows:

These rules govern which table in the model to export, what the target root filename should be, and the number of copies to export.

The TableToExport values are already verified to exist in the model.

In addition, the format will always be QVD, and the copies will be incrementally numbered.

For example, the Customers table would be exported as:

What is the minimum set of scripting strategies the data architect must use?

15. Exhibit.

A chart for monthly hospital admissions and discharges incorrectly displays the month and year values on the x-axis.

The date format for the source data field "Common Date" is M/D/YYYY. This format was used in a calculated field named "Month-Year" in the data manager when the data model was first built.

Which expression should the data architect use to fix this issue?

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

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

19. Exhibit.

One of the data sources a data architect must add for a newly developed app is an Excel spreadsheet. The Region field only has values for the first record for the region. The data architect must perform a transformation so that each row contains the correct Region.

Which function should the data architect implement to resolve this issue?

20. 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)