Qlik Sense Business Analyst Certification; Questions With Complete Solutions

Qlik Sense Business Analyst Certification; Questions
With Complete Solutions

QVD Right Ans - Qlik Data File

Can only be written to and extracted by Qlik Sense

Advantages include:
- Optimized loads and compression (10x to 100x) speed compared to CSV
- Incremental loading or snapshotting where needed
- Consolidated data from multiple sources

QVF Right Ans - Qlik Sense application file

Data loading methods Right Ans - 1. data catalog
2. data load editor
3. data manager

Data Catalog Right Ans - Collection of existing data on the app

Loading data with field names Right Ans - Select "embedded field names"
during load preview

Data profiling Right Ans - Par of the Data Manager

When enabled, it will use AI to determine best associations and auto-generate
date/geolocation data

Concatenating tables Right Ans - By default, Qlik Sense will concatenate
tables with the same exact column names

You can undo this in the data manager (tables view) or by adding a script line
NoConcatenate

Box plot Right Ans - 1-2 dimensions, 1 measure

Distribution of measure in the form of a box and whiskers chart

,Qlik DataTransfer Right Ans - Solution that pushes on-prem data to the
cloud in the Qlik SaaS. Qlik can watch the offline folders for updates, re-upload
the data, and apps will automatically update on the platform

Preceding (Stacked) load statements Right Ans - Since you cannot
reference calculated fields in the data load editor unless they have already
been loaded, you need to stack the statements

LOAD ReferenceDate, Age( ReferenceDate, BirthDate ) as Age;

LOAD *, Date(FromDate + IterNo() - 1 ) as ReferenceDate

IF statements Right Ans - If(condition, True, Else)

if you don't include an Else value at the end of the statement, the else
condition will return as Null

Bucketing card (Data manager) Right Ans - Bucketing values will include
the lower bound and exclude the upper bound

You can edit bucket ranges and names in the table editor

Load data to create the new field

Bucketing creates dimensions from measures

Viewing data table metadata Right Ans - Go to data model viewer > click
the table header > view info on number of rows, fields, and keys

Click the table itself shows the number of nulls, distinct values, density, and
subset ratio

Density (data table metadata) Right Ans - Percent of non-null values in
table (100% density means no null)

Circular reference Right Ans - 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 Right Ans - 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) Right Ans - 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) Right Ans - 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) Right Ans - 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) Right Ans - 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