QlikView QSDA2024 Practice Exams
Last updated on Apr 05,2025 - Exam Code: QSDA2024
- Exam Name: Qlik Sense Data Architect Certification Exam - 2024
- Certification Provider: QlikView
- Latest update: Apr 05,2025
Exhibit.
Refer to the exhibit.
A data architect is loading two tables into a data model from a SQL database. These tables are related on key fields CustomerlD and Customer Key.
Which script should the data architect use?
A)
B)
C)
D)
- A . Option A
- B . Option B
- C . Option C
- D . Option D
Exhibit.
Refer to the exhibit.
A data architect is loading two tables into a data model from a SQL database. These tables are related on key fields CustomerlD and Customer Key.
Which script should the data architect use?
A)
B)
C)
D)
- A . Option A
- B . Option B
- C . Option C
- D . Option D
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?
- 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 Budaets records for the selected month. Sales column can contain null or non-null values
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?
- 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
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)
- A . Option A
- B . Option B
- C . Option C
- D . Option D
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)
- A . Option A
- B . Option B
- C . Option C
- D . Option D
Refer to the exhibit.
What does the expression sum< [orderMetAmount ]) return when all values in LineNo are selected?
- A . 1590
- B . 1490
- C . 690
- D . 1810
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?
- 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.
A data architect executes the following script:
Which values does the OrderDate field contain after executing the script?
- A . 20210131, 2020/01/31, 31/01/2019
- B . 20210131, 2020/01/31, 31/01/2019, 9999
- C . 20210131, 2020/01/31, 31/01/2019, 0
- D . 20210131, 2020/01/31, 31/01/2019, 31/12/2022
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?
- A . A field with social media source, a set of key fields to sort out updated records, configure reload task to load four times a day
- B . A field with record creation time, a secondary key field to remove deleted records, configure reload task to load four times a day
- C . A field with ModificationTime, a primary key field to sort out updated records, insert and append records, update records
- D . A field with ModificationTime, a primary key field to sort out updated records, insert and update records, remove records