Qlik Sense Business Analyst (QSBA)
Certification Exam Prep Questions and
Correct Answers
Density (data table metadata) - ANSWER Percent of non-null values in table (100%
density means no null)
Circular reference - ANSWER Multiple paths (keys) linking data tables together, such as
in a triangle
This is often due to similar field names, even when content is not the same
Synthetic key - ANSWER Composite keys that are created in Qlik Sense when two or
more data tables have two or more fields in common
This creates a synthesis of both fields, which should often be avoided. You can
break this key by going into the data manager. Most likely, only one key is needed
Subset ratio (data table metadata) - ANSWER Present distinct values in the
current table / total distinct values across all tables
Tells you a bit about the importance of a table
Table Editor view features (Data Manager) - ANSWER 1. Configure date fields
2. Edit associations
3. Add calculated fields
4. Unpivot a table
5. Configure custom associations
,6. Transform data
7. Force a concatenation and de-concatenation
Split values card (Data Manager) - ANSWER Split values based on where you would
like each field to be cut. Scroll over the position of the field and select "these positions"
Good for address fields and composite IDs
If you have a delimiter to split, then select the delimiter and choose 'all instances'
Replace card (Data Manager) - ANSWER Good for replacing different naming
conventions into one common name.
It's also good for creating custom groupings. You can use this to set nulls as well
This replaces the actual values in the field
You can see what transformations have occurred by looking at the field details option
Mixed values - ANSWER Values that contain text when a field has both text
and numeric
Case sensitivity (data load editor) - ANSWER Functions/expressions are not case
sensitive but field names are
Natural join - ANSWER Joins only the same column names
Data Load Editor - ANSWER Method of adding data via the data load script
Main section is auto-generated. You can apply data transformations here
,To add data automatically, click "Select data" icon to upload file
Connections to external databases - ANSWER When you establish a connection a
database, you can select "add connection string" to add it to your script. Only one
connection can be open at a time when executing a script
QVS - ANSWER Qlik Script File
Bookmark - ANSWER Save current selections, filters, and location in sheet for users
The developer can create bookmarks for common selections or groupings
Eliminating a field from filters (Set analysis) - ANSWER Year=
Greater than/less than (set analysis) - ANSWER Year = {">2019 <=2022"}
Using a variable (set analysis) - ANSWER Year = {$(vMaxYear)}
Mashup - ANSWER Web page or web application that uses content from more than one
source to create a single new service displayed in a single graphical interface.
Components
1. Qlik Sense application
2. Script (HTML, Javascript)
Exists in the Extensions side of the QMC
Method to remove a field as a map layer (test question) - ANSWER In associations
view, change data format from "geo data" to "general"
, Set analysis - ANSWER Aggregations based on defined conditions. Often used to
restrict or predefine a set of data in a chart. Created in the measures section of
the sheet view or, creating a master item, or defining a variable
Single vs double quotes (set analysis) - ANSWER Single quotes are for exact
match, while double quotes are for a search
Smart search - ANSWER Allows you to search globally from any sheet in an app.
Provides generated visualizations based on the search terms. You can also apply
a selection gives lists of matching items based on search terms
Spaces mean there are multiple search terms. Qlik will look for matches with one or
both of those words. Quotes means one term
Visual data preparation - ANSWER Data manager feature to see connections between
tables with AI recommendations
Green shows a strong match, while yellow and red are varying degrees. Size of
bubbles indicates number of table rows
Associative Insights - ANSWER Auto-generated insights based on the associations
and selections you have made
explore selections > generate insights
Default landing page - ANSWER Create a bookmark > set as default bookmark
Insight Advisor - ANSWER Generates insights and visualizations using data across the
entire data model
Certification Exam Prep Questions and
Correct Answers
Density (data table metadata) - ANSWER Percent of non-null values in table (100%
density means no null)
Circular reference - ANSWER Multiple paths (keys) linking data tables together, such as
in a triangle
This is often due to similar field names, even when content is not the same
Synthetic key - ANSWER Composite keys that are created in Qlik Sense when two or
more data tables have two or more fields in common
This creates a synthesis of both fields, which should often be avoided. You can
break this key by going into the data manager. Most likely, only one key is needed
Subset ratio (data table metadata) - ANSWER Present distinct values in the
current table / total distinct values across all tables
Tells you a bit about the importance of a table
Table Editor view features (Data Manager) - ANSWER 1. Configure date fields
2. Edit associations
3. Add calculated fields
4. Unpivot a table
5. Configure custom associations
,6. Transform data
7. Force a concatenation and de-concatenation
Split values card (Data Manager) - ANSWER Split values based on where you would
like each field to be cut. Scroll over the position of the field and select "these positions"
Good for address fields and composite IDs
If you have a delimiter to split, then select the delimiter and choose 'all instances'
Replace card (Data Manager) - ANSWER Good for replacing different naming
conventions into one common name.
It's also good for creating custom groupings. You can use this to set nulls as well
This replaces the actual values in the field
You can see what transformations have occurred by looking at the field details option
Mixed values - ANSWER Values that contain text when a field has both text
and numeric
Case sensitivity (data load editor) - ANSWER Functions/expressions are not case
sensitive but field names are
Natural join - ANSWER Joins only the same column names
Data Load Editor - ANSWER Method of adding data via the data load script
Main section is auto-generated. You can apply data transformations here
,To add data automatically, click "Select data" icon to upload file
Connections to external databases - ANSWER When you establish a connection a
database, you can select "add connection string" to add it to your script. Only one
connection can be open at a time when executing a script
QVS - ANSWER Qlik Script File
Bookmark - ANSWER Save current selections, filters, and location in sheet for users
The developer can create bookmarks for common selections or groupings
Eliminating a field from filters (Set analysis) - ANSWER Year=
Greater than/less than (set analysis) - ANSWER Year = {">2019 <=2022"}
Using a variable (set analysis) - ANSWER Year = {$(vMaxYear)}
Mashup - ANSWER Web page or web application that uses content from more than one
source to create a single new service displayed in a single graphical interface.
Components
1. Qlik Sense application
2. Script (HTML, Javascript)
Exists in the Extensions side of the QMC
Method to remove a field as a map layer (test question) - ANSWER In associations
view, change data format from "geo data" to "general"
, Set analysis - ANSWER Aggregations based on defined conditions. Often used to
restrict or predefine a set of data in a chart. Created in the measures section of
the sheet view or, creating a master item, or defining a variable
Single vs double quotes (set analysis) - ANSWER Single quotes are for exact
match, while double quotes are for a search
Smart search - ANSWER Allows you to search globally from any sheet in an app.
Provides generated visualizations based on the search terms. You can also apply
a selection gives lists of matching items based on search terms
Spaces mean there are multiple search terms. Qlik will look for matches with one or
both of those words. Quotes means one term
Visual data preparation - ANSWER Data manager feature to see connections between
tables with AI recommendations
Green shows a strong match, while yellow and red are varying degrees. Size of
bubbles indicates number of table rows
Associative Insights - ANSWER Auto-generated insights based on the associations
and selections you have made
explore selections > generate insights
Default landing page - ANSWER Create a bookmark > set as default bookmark
Insight Advisor - ANSWER Generates insights and visualizations using data across the
entire data model
