Why Study with PlanetCert?
The Latest Questions
Practice questions and exam topics aligned with the current exam objectives.
Detailed Explanations
Go beyond the answer. Master the material with comprehensive learning and professional explanations for every concept.

AI-Powered Insights
Personalized preparation guidance that adapts to your performance and identifies weak spots automatically.
Exam Information
Official specifications published by QlikView
Exam Format
Registration
Validity
Skills this practice test covers
- Turn a business scenario into metrics, granularity and security requirements for a data model.
- Choose the connector and connection method that fit each data source.
- Design star or snowflake models and resolve circular references and other model issues.
- Write load scripts that handle nulls, blanks and dates correctly.
- Build incremental loads for the extract layer with QVD files.
- Test load scripts with the debugger and check the loaded data against its source.
Explore related topics
QSDA2024 exam content
5 domains · 18 topics · 200 of 204 questions sorted by domain
Identify Requirements20%31 questions
Before any script is written, the architect works out what the app must answer. Candidates read a scenario, find the stakeholders, and decide on metrics, granularity, slowly changing dimensions and the right level of security.
Skills tested
- Determine the primary requirements of business users from a scenario.
- Identify the stakeholders in a scenario and what each one needs from the app.
- Choose metrics and the levels of granularity and aggregation they need.
- Decide whether a dimension needs slowly changing dimension support.
- Set the level of security, for example row-level access with Section Access.
Questions by topic
- Determine the appropriate level of security.10
- Determine metrics and levels of granularity and aggregation.7
- Determine dimensionality and the need for slowly changing dimensionality support.6
- Determine primary requirements for business users.8
Data Connectivity8%18 questions
This small domain asks which data sources and connectors a solution needs, and how to create each connection. Questions compare connection types such as file-based, ODBC and REST connections.
Skills tested
- Pick the connector that fits each source, such as the Qlik ODBC Connector or the Qlik REST Connector.
- Create data connections with the right method for each source.
Questions by topic
- Determine the data sources and connectors needed.7
- Determine the appropriate method to create connections for data sources.11
Data Model Design28%54 questions
Here candidates shape the model itself. They decide which measures and attributes come from each source, choose a model type such as a star or snowflake schema, and optimize the structure for Qlik Sense.
Skills tested
- Determine the measures and attributes that each data source provides.
- Choose between a star schema, a snowflake schema, link tables and concatenated facts.
- Remove circular references and other issues that slow down or break an app.
- Build QVD layers so that data structures load efficiently.
Questions by topic
- Determine the correct method to optimize the data model for Qlik Sense.16
- Determine the correct method to implement data structures efficiently.21
- Identify the appropriate type of data model.14
- Determine dimensionality and the need for slowly changing dimensionality support.3
Data Transformations38%76 questions
The largest domain is load script work. Candidates build data content to match requirements, handle null and blank values, work with dates, document and organize scripts, and write incremental loads for the extract layer.
Skills tested
- Build data content in the load script, including inter-record functions such as Peek and Previous.
- Handle null and blank values with NullAsValue, NullAsNull or default values so that filters still work.
- Create a master calendar and other structures for date handling.
- Organize scripts into sections and subroutines, and document them with comments.
- Write incremental loads for the extract layer that detect inserted, updated and deleted records.
Questions by topic
- Determine the correct method to build data content based on requirements.32
- Analyze and evaluate null and blank data handling required to support filtering.5
- Determine the correct method for date handling techniques.10
- Determine the correct method to perform script organization and cleansing.18
- Determine the correct method to implement data structures efficiently.4
- Analyze relevant variables to build scripts for incremental loading for the extract layer.7
Validation6%21 questions
The last step proves that the scripts and the data are right. Candidates choose how to test a script, for example with the debugger, and how to check the data, for example with row counts.
Skills tested
- Test load scripts with the debugger and step-through execution.
- Validate loaded data with row counts and reconciliation against the source.
Questions by topic
- Determine the appropriate method to validate and test data.10
- Determine the appropriate method to validate and test scripts.11
Requirements
- No formal prerequisites: anyone can book the exam.
- Recommended: hands-on work on several production-quality Qlik Sense apps.
- Recommended: writing Qlik Sense load scripts and validating the data they produce.
- Recommended: a basic grasp of ETL and of building connectors to different data sources.
About the QSDA2024 exam
QSDA2024 tests whether a developer can turn a business request into a Qlik Sense data model that loads fast and gives correct answers. Data Transformations carries the most weight, so load script work leads the exam: building data content, handling nulls and blanks, dates, script organization and incremental loads. Requirements, data connections, model design and validation make up the rest. Passing earns the Qlik Sense Data Architect certification.
Data Transformations also has the most questions in the PlanetCert practice test, and many of them ask for the right way to build data content from a requirement. The explanations show what a script choice does to the data model, such as when a QVD load stays optimized or how NullAsValue changes filtering. Study Mode suits Data Model Design, where link tables, concatenated facts and star schemas are close choices. Brainy AI Assistant can trace an incremental load step by step or explain a Section Access table.
How to earn the certification
- Earns
- Qlik Sense Data ArchitectProfessional
How to prepare for QSDA2024
- 1
Load one source into three layers
Pull a sample source into an extract QVD, then a transform QVD, then the final app, the way a QVD layer works in production. Then rebuild the extract as an incremental load and check that no rows go missing.
- 2
Create a circular reference, then fix it
Load three tables that link in a loop and look at the result in the Data Model Viewer. Fix it once with a link table and once with concatenated facts, then compare the two models.
- 3
Write Section Access by hand
Build a Section Access table that gives two test users different rows of the same app. Open the app as each user to confirm what each one can see.
- 4
Practise nulls and calendars in script
Load data with nulls and blanks, try NullAsValue and default values, and watch how filters change. Then build a master calendar for the same data and comment every section of the script.
- 5
Spend the most time on transformations
Data Transformations carries the most weight, so give it the most practice. Take the QSDA2024 practice test by domain in Study Mode, then a timed full run, and ask Brainy AI Assistant about any unclear script answer.
Start a timed QSDA2024run
Who QSDA2024 is for
- Qlik Sense developers who write load scripts and build data models for production apps.
- Data architects and data engineers who design the QVD layers behind Qlik Sense.
- BI and ETL developers who move data from source systems into Qlik Sense.
Typical job titles: Qlik Sense developer · Data architect · BI developer · Data engineer · ETL developer · Analytics engineer
QSDA2024 glossary
17 terms from the exam objectives and the vendor's official material, each defined in a sentence.
- Binary load
- A script statement that copies the whole data model of another Qlik app into the current app.
- Concatenated facts
- Fact tables combined into one table with CONCATENATE, a common alternative to a link table.
- Data Load Editor
- The Qlik Sense editor where load scripts are written, debugged and run.
- Data Model Viewer
- The Qlik Sense view that shows the tables, fields and associations in an app's data model.
- Incremental Load
- A reload that reads only new or changed records from the source and combines them with data already stored in QVD files.
- Inter-record functions
- Script functions, such as Peek() and Previous(), that read values from earlier records during a load.
- Link tables
- Tables that connect several fact tables through a combined key, so the model avoids circular references.
- Master Calendar
- A separate calendar table built in the script, with one row per date and fields such as month and quarter.
- NullAsValue
- A script statement that turns nulls in chosen fields into a real value, so users can select them.
- Optimized QVD load
- A QVD read at full speed, which Qlik can do only when the script does not transform the data during the load.
- QVD Files
- Files that store one Qlik table in Qlik's native format, which reloads much faster than the original source.
- Script Debugger
- A tool in the Data Load Editor that runs a script step by step, with breakpoints, to find where it goes wrong.
- Section Access
- The part of a load script that controls which users can open an app and which rows of data each one sees.
- Slowly Changing Dimensions (SCD)
- Dimension values that change over time, such as a customer's region, and the methods that keep their history.
- Snowflake schema
- A star schema whose dimension tables are split into further related tables.
- Star schema
- A model with one central fact table joined directly to its dimension tables.
- Subroutines
- Reusable blocks of script code, defined with SUB and run with CALL.