QlikView QSDA2024 Exam - Questions and Answers

Question 1

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?

A. Remove the LineNo field from Shipments and use the AutoNumber function on the OrderID field
B. Remove the LineNo field from both tables and use the AutoNumber function on the OrderID field
C. Create a composite key using OrderID and LineNo
D. Create a composite key using OrderID and LineNo, and remove OrderID and LineNo from Shipments

Answer : C

Question 2

Users of a published app report incomplete visualizations. The data architect checks the app multiple times and cannot replicate the error. The error affect only one team.
Which is the most likely cause?

A. A security rule has been applied to the sheet object.
B. The affected users were NOT added to the Section Access table.
C. Section access restricts too many records.
D. An Omit field has been applied.

Answer : B

Question 3

Refer to the exhibit.

A company stores the employee data within a key composed of Country, UserID, and Department. These fields are separated by a blank space. The UserID 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. RIGHT(SUBFIELD(Key, ' ', 2),3)
B. LEFT(SUBFIELD(Key, ' ', 2),2)
C. MID(SUBFIELD(Key, ' ', 2),3)
D. LTRIM(SUBFIELD (Key, ' ', 2),2)

Answer : C

Question 4

A data architect needs to load large amounts of data from a database that 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 the new and updated data from the database without the rows that have just been loaded from the QVD and 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.
B. 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 and concatenate with the new and updated records.
3. Use the PEEK function to remove the deleted rows.
C. 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 and 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.
D. 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.

Answer : D

Question 5

Refer to the exhibit.

A large transport company (Company A) acquires a smaller rival (Company B).
Company A has been using Qlik Sense for 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. money ( replace(Revenue, chr(32), 0) ) AS [Revenue Conformed]
B. if (len (trim(Revenue) ) < 1,="" money(0),="" revenue="" )="" as="" [revenue="" conformed]="" 1, ="" money(0),="" revenue="" )="" as="" [revenue="" />
C. money ( replace(Revenue, Null(), 0) ) AS [Revenue Conformed]
D. replace(Revenue, chr(32), money(0) ) AS [Revenue Conformed]

Answer : B

Question 6

Refer to the exhibit.

A major healthcare organization requests a new app with the following requirements:
• Users can filter AdmissionDate and DischargeDate by all fields in the Master Calendar table
• Use an existing QVD file, which includes dates 20 years into the future
• Users should not be able to filter on dates that have no associated encounters
Which approach should the data architect take to meet these requirements?

A. 1. Load the Master Calendar and Encounters tables
2. Perform a Join Load on the Encounters table to the Resident master calendar and alias the date fields appropriately for the Admission Date
3. Perform a Join Load on the Encounters table to the Resident master calendar and alias the date fields appropriately for the Discharge Date
B. 1. Load the master calendar
2. Create two mapping tables called AdmissionCalendar and DischargeCalendar from the Resident master calendar that has all fields appropriately named
3. Load the Encounters table and use ApplyMap for the AdmissionDate and DischargeDate appropriately
C. 1. Load the master calendar as AdmissionCalendar and alias the fields to reflect they are for Admission
2. Load the master calendar as DischargeCalendar and alias the fields to reflect they are for Discharge
3. Load the Encounters table
D. 1. Load the Encounters table
2. Perform a Left Join Load on the Encounters table to the master calendar and alias the date fields appropriately for the Admission Date
3. Perform a Left Join Load on the Encounters table to the master calendar and alias the date fields appropriately for the Discharge Date

Answer : C

Question 7

Refer to the exhibit.

A data architect is validating that the script section, as shown in the exhibit, is working properly. They need to stop the script with a preview of the value used with the Load statement.
Where should the data architect put the debugger breakpoint?

A.
B.
C.
D.

Answer : A

Question 8

Sales managers need to see an overview of historical performance and highlight the current year's metrics.
The app has the following requirements:
• Display the current year's total sales
• Total sales displayed must respond to the user's selections
Which variables should a data architect create to meet these requirements?

A. Create the variable, vCurrentYear, in the data load editor. Then create a master item, currentYTDSales, in the assets panel.
B. Create the variables, vCurrentYear and vCurrentYTDSales, in the data load editor.
C. Create the variables, vCurrentYear and vCurrentYTDSales, in the data load editor.
D. Create the variable, vCurrentYear, in the data load editor. Then create a master item, currentYTDSales, in the assets panel.

Answer : A

Question 9

Refer to the 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?

A. Date(MonthStart([Common Date]),'MMM-YYYY')
B. Date([Common Date],'MMM-YYYY')
C. Date(MonthsStart([Common Date]),'MMM-YYYY')
D. Date(InMonth([Common Date]),'MMM-YYYY')

Answer : A

Question 10

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?

A. Customer Names and Sales records for the selected month, Budgets column can contain null or non-null values
B. All Customer Names for both Sales and Budget records for the selected month
C. Customer Names and Sales records for the selected month but with only non-null values in Budget column
D. Customer Names and Budgets records for the selected month, Sales column can contain null or non-null values

Answer : A

Question 11

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?

A. Application size, application theme, storytelling, data model, IT use case
B. User sessions, source data architecture, compatibility, data model, business use case
C. QlikView archival, source data architecture, load script, data model, business use case
D. Application metadata, application theme, user sessions, load script, IT use case

Answer : C

Question 12

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?

A. LogDetail
B. Trace
C. Tag
D. REM

Answer : B

Question 13

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:
Shapes:

GENERIC LOAD -
Object,
"Attribute",

Value -
FROM [lib://Data/products.xlsx]
(ooxml, embedded labels, table is Shapes);
How many tables will this script create?

A. 1
B. 3
C. 4
D. 6

Answer : B

Question 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:
TableToExport, StoreAsFilename, NumberOfCopies

Customers, Clients,3 -

Orders, SalesOrders,1 -

Regions, Countries,2 -
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:

Clients1.qvd -

Clients2.qvd -

Clients3.qvd -
What is the minimum set of scripting strategies the data architect must use?

A. One loop and two IF statements
B. One loop and one SELECT CASE statement
C. Two loops and one IF statement
D. Two loops without any conditional statements

Answer : D

Question 15

A data architect executes the following script:
Table_A:
LOAD * INLINE [

Field_1, Field_2, Field_3 -
01, AB, 10
01, AC, 50
02, AD, 75
];
Join(Table_A)
Table_B:
LOAD * INLINE [

Field_1, Field_4, Field_5 -
01, 30%, 500
03, 60%, 1000
];
What will be the result of Table_A?