QlikView Beginner Quiz

Posted on: | By: – Comments Off

QlikView Beginner Quiz




QlikView Beginner Quiz contains set of 60 QlikView MCQ Questions With Answers which will help you to clear beginner level quiz.



1) Which Edition of QlikView standalone can be used for free ?

  1. Home Edition
  2. Personal Edition
  3. Local Edition
  4. Enterprise Edition

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
2) Which is the most basic sheet object ?

  1. List Box
  2. Table Box
  3. Current Selection Box
  4. Multi Box

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
3) When we make selection in QlikView document what will be the color of selected Cell?

  1. White
  2. Grey
  3. Green
  4. Brown

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
4) Which object keeps track of your selections ?

  1. Current Selections Box
  2. Selection Box
  3. Status Bar
  4. Table Box

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
5) Which Tab will be used to change the number format of List Box?

  1. General
  2. Layout
  3. Caption
  4. Number

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
 
6) What are Hierarchic Groups in field groups called ?

  1. Drill-Down
  2. Cyclic
  3. Drill
  4. Cyclic Drill

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
7) Which statement is required to load data from files in the script ?

  1. Load
  2. Reload
  3. Fetch
  4. Get

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
8) From where  QlikView document can retrieve the  data ?

  1. One or Several sources
  2. One Source only
  3. QVD Only
  4. Inline Table Only

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
9) Which of the following is an example of a relative path ?

  1. C:
  2. D:\App
  3. ..\App\Data
  4. E:\App\Data

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
10) Which option from Data Tab in Script Editor is required to load a text file into QlikView ?

  1. Table Files
  2. QlikView File
  3. Web File
  4. Field Data

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]



 
11) Which statement is used to create QVD file ?

  1. Save
  2. Dump
  3. Store
  4. Allocate

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
12) Which is  a native QlikView format and can only be written to and read by QlikView ?

  1. QVD
  2. QVS
  3. QVP
  4. CSV

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
13) What is the shortcut for the Table Viewer dialog ?

  1. Ctrl+L
  2. Ctrl+R
  3. Ctrl+E
  4. Ctrl+T

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
 
14) Which statement should follow  after the access section is defined in the script?

  1. Section Authentication
  2. Section Application
  3. Section Application
  4. Section Authorization

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
15) How many different type of QlikView Server are available ?

  1. 1
  2. 2
  3. 3
  4. 4

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
 
16) How many different type of CALs are available ?

  1. 1
  2. 2
  3. 3
  4. 4

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
 
17) QMC stands for :

  1. QlikView Managed Console
  2. QlikView Management Console
  3. Quick Managed Console
  4. Quick Management Console

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
18) DSC stands for :

  1. Daily Services Controlling
  2. Daily Source Contents
  3. Directory Service Connectors
  4. Directory Source Connectors

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
19) Which of the following is not the component of tradtional DWH?

  1. OLAP CUBE
  2. ODS
  3. ETL
  4. Data Mart

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
20) Which of the following is classified as bad aesthetic in designing a app in qlik view?

  1. Cluttered
  2. Crisp
  3. Aligned
  4. Light colour choices

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
21) Which object is  useful tool for showing several object types in a limited space ?

  1. Chart
  2. Statistics Box
  3. Text Object
  4. Container

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
 
22) In Bar Chart properties which Tab is used to limit the number of bars ?

  1. Dimensions
  2. Dimension Limits
  3. Presentation
  4. Style

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
23) In the Pivot Table properties which tab is used to showing partial sums?

  1. Expressions
  2. Sort
  3. Presentation
  4. Visual Cues

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
24) Which chart is ideal to view the changing value of a single measurement when changing selections ?

  1. Gauge Chart
  2. Bar Chart
  3. Line Chart
  4. Combo Chart

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
25) Which sheet object is used to shows several fields simultaneously in a very compact way ?

  1. Table Box
  2. List Box
  3. Multi Box
  4. Input Box

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]



 
26) When we lock selection in QlikView document what will be the color of locked Cell?

  1. White
  2. Grey
  3. Green
  4. Blue

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
 
27) Which chart is ideal for comparison of similar measurements ?

  1. Line Chart
  2. Bar Chart
  3. Pivot Table
  4. Gauge Chart

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
28) Which chart is ideal for comparison of high-level groups ?

  1. Pie Chart
  2. Block Chart
  3. Radar Chart
  4. Line Chart

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
29) Which of the following is limitation of Pivot Table ?

  1. Can’t do sorting
  2. Can’t do partial sum
  3. Can’t do grouping
  4. Can’t change the background color of cell

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
30) Which statement can be preceded by the  Load statement  defining what directory to look for the files in ?

  1. Directory
  2. Files
  3. Table
  4. Folder

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
31) Which tab contains security settings for the QlikView script ?

  1. Data
  2. Functions
  3. Variables
  4. Settings

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
 
32) How many minimum fields need to have in the Load statement dealing with hierarchy table ?
 

  1. 1
  2. 2
  3. 3
  4. 0

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
33) How many different view/(s) is/are available in Table Viewer ?

  1. 1
  2. 2
  3. 3
  4. 4

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
34) What does identifier 1 represents in Set Analysis ?

  1. An Empty Set
  2. Full set of all the records in the application
  3. The records of the current selection
  4. The Previous Selection

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
35) Which of the following is not a basic Aggregation Functions ?

  1. Sum(expression)
  2. Min(expression [,rank])
  3. MinString(expression)
  4. Max(expression [,rank])

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
36) What will be the output of index( ‘abcdefg’, ‘cd’ )

  1. 1
  2. 2
  3. 3
  4. 4

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
37) In how many way/(s)  security mechanism in QlikView can be set up ?

  1. 1
  2. 2
  3. 3
  4. 4

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
38) Which of the following is not QlikView Publisher capabilities ?

  1. Reload
  2. Reduce
  3. Distribute
  4. In-Memory analytics engine

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 



39) Where we can find the information of all QV Services and their status in QMC?

  1. Status -> Services
  2. System -> Services
  3. Setup -> Services
  4. Users -> Services

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
40) Where we can find the detailed information about QlikView System in QMC ?

  1. System -> About
  2. Status -> About
  3. About -> System
  4. Setup -> About

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
41) Which of the following is not true about dimensional modelling?

  1. Simpler schemas
  2. Less Normalized
  3. Confuses end users
  4. Understood by end users

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
42) Which of the following does not drive the decision of usage of QVD file?

  1. Large number of database rows and load times are significant
  2. Does not require a frequent load
  3. Desire to reduce impact on your operational system
  4. Re-usability of data sources. I.e. multiple QlikView applications using the same
  5. QVD as a data source.

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
43) In a list box which Sort By type means that the values are sorted according to their logical state (selected, optional, excluded) ?

  1. State
  2. Frequency
  3. Load Order
  4. Text

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
44) Which object is used for entering data in a variable ?

  1. Input Box
  2. List Box
  3. Table Box
  4. Multi Box

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
45) Which of the Setting menu option is used to specify the maximum number of distinct selected values to be shown in the Current Selections windows ?

  1. User Preferences
  2. Document Properties
  3. Sheet Properties
  4. Object Properties

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
46) What is the number of records that have values (i.e. not NULL) in this field as compared to the total number of records in the table is called ?

  1. Subset Ratio
  2. Information Ratio
  3. Information Density
  4. Subset Information

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
47) Which function returns the contents of the fieldname in the record specified by row in the internal table tablename

  1. previous(expression )
  2. peek(fieldname [ , row [ , tablename ] ] )
  3. FieldValue(fieldname , n )
  4. FieldIndex(fieldname , value )

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
48) Which function returns the first text value of expression over a number of records, as defined by a group by clause. If no
text value is found, NULL is returned.

  1. MinString(expression )
  2. MaxString(expression )
  3. FirstValue(expression)
  4. LastValue(expression)

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
49) What Sum({$}  Sales) returns when used in expression ?

  1. Returns total sales within the application, disregarding selection but not the dimension.
  2. Returns Sales for the current selection.
  3. Returns Sales of the previous selection.
  4. Returns Sales of the next selection.

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
50) In the LEF file for QlikView Server License what is the Product level mentioned for QlikView Server ?

  1. 3
  2. 10
  3. 30
  4. 43

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
51) What type of security is implemented while communicating between QlikView Server and Windows Client?

  1. HTTPS/SSL
  2. Tunneling via HTTP
  3. 128 bit (RSA algorithm)
  4. 56 bit

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
52) License Lease is available on the following server edition:

  1. QlikView Test Server
  2. QlikView Extranet Server
  3. Qlikview Information Access Server
  4. QlikView Small Business Server

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
 
53) In which of the following cases one should use radar chart?

  1. Comparison of high level groups (one or two measurements)
  2. Comparison for multimeasurements
  3. performance trends
  4. comparison of similar measurements

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
54) In which of the following cases one should not use guage chart?

  1. Percentage margins
  2. Percentage quota achieved
  3. YTD vs Last YTD
  4. compare 2 dimesions

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]



 
 

Related Articles

Advanced Manufacturing Process Quiz

Web analytics, Adobe Analytics, Google Analytics Quiz

SailPoint Quiz