Qlik Sense Business Analyst (QSBA) exam
Prep Test 2| Questions With Answers
What two types of files can you load map data from? - ANSWER .KML or excel
file containing point or area data
Where in Qlik Sense do you go to add map data? - ANSWER Add data from files
and attach files
Do you add map data to a map chart as an expression a dimension, or both? -
ANSWER dimension
What is the maximum number of points that can be displayed for performance reasons
on a map? - ANSWER 3333
Can you load a data set that contains the names of cities only? - ANSWER Yes,
the map object will include countries and cities
Can you load a data set that contains country names only? - ANSWER Yes, the map
will only include pictures of the countries with no cities
If only the city or country name is in the loaded data, what data will be automatically
created? - ANSWER Longitude and latitude data in a single field
Distribution charts show - ANSWER how quantitative data is distributed along an axis
, How many variables can a distribution chart handle? - ANSWER 1 or 2
What chart do you use if you have 2 variables, such as sales and margin by product
category? - ANSWER Scatter Chart
When can you use a bar or histogram chart? - ANSWER When you have one variable
and few data points
Where can you find all the tables in an application? - ANSWER Under tables in the Data
Manager
What are the 3 items that can be used in an expression in a calculated field? -
ANSWER Functions
Fields
Operators
Can you refer to fields in other tables when adding a calculated field expression? -
ANSWER No, you can only use the fields in the table you are editing.
When adding two or more excel spreadsheets, what button do you push to check
association issues? - ANSWER Prepare
Where do data load warnings show up in the data manger UI? - ANSWER The
associated button at the bottom of the screen. Click button to show recommendations
and make corrections.
Where can you check table associations. - ANSWER The data model viewer under
associations
If two identical tables are identical when loaded: - ANSWER auto concatenation
will make one table with only the rows from one table
Prep Test 2| Questions With Answers
What two types of files can you load map data from? - ANSWER .KML or excel
file containing point or area data
Where in Qlik Sense do you go to add map data? - ANSWER Add data from files
and attach files
Do you add map data to a map chart as an expression a dimension, or both? -
ANSWER dimension
What is the maximum number of points that can be displayed for performance reasons
on a map? - ANSWER 3333
Can you load a data set that contains the names of cities only? - ANSWER Yes,
the map object will include countries and cities
Can you load a data set that contains country names only? - ANSWER Yes, the map
will only include pictures of the countries with no cities
If only the city or country name is in the loaded data, what data will be automatically
created? - ANSWER Longitude and latitude data in a single field
Distribution charts show - ANSWER how quantitative data is distributed along an axis
, How many variables can a distribution chart handle? - ANSWER 1 or 2
What chart do you use if you have 2 variables, such as sales and margin by product
category? - ANSWER Scatter Chart
When can you use a bar or histogram chart? - ANSWER When you have one variable
and few data points
Where can you find all the tables in an application? - ANSWER Under tables in the Data
Manager
What are the 3 items that can be used in an expression in a calculated field? -
ANSWER Functions
Fields
Operators
Can you refer to fields in other tables when adding a calculated field expression? -
ANSWER No, you can only use the fields in the table you are editing.
When adding two or more excel spreadsheets, what button do you push to check
association issues? - ANSWER Prepare
Where do data load warnings show up in the data manger UI? - ANSWER The
associated button at the bottom of the screen. Click button to show recommendations
and make corrections.
Where can you check table associations. - ANSWER The data model viewer under
associations
If two identical tables are identical when loaded: - ANSWER auto concatenation
will make one table with only the rows from one table
