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 ?
- Home Edition
- Personal Edition
- Local Edition
- Enterprise Edition
2) Which is the most basic sheet object ?
- List Box
- Table Box
- Current Selection Box
- Multi Box
3) When we make selection in QlikView document what will be the color of selected Cell?
- White
- Grey
- Green
- Brown
4) Which object keeps track of your selections ?
- Current Selections Box
- Selection Box
- Status Bar
- Table Box
5) Which Tab will be used to change the number format of List Box?
- General
- Layout
- Caption
- Number
6) What are Hierarchic Groups in field groups called ?
- Drill-Down
- Cyclic
- Drill
- Cyclic Drill
7) Which statement is required to load data from files in the script ?
- Load
- Reload
- Fetch
- Get
8) From where QlikView document can retrieve the data ?
- One or Several sources
- One Source only
- QVD Only
- Inline Table Only
9) Which of the following is an example of a relative path ?
- C:
- D:\App
- ..\App\Data
- E:\App\Data
10) Which option from Data Tab in Script Editor is required to load a text file into QlikView ?
- Table Files
- QlikView File
- Web File
- Field Data
11) Which statement is used to create QVD file ?
- Save
- Dump
- Store
- Allocate
12) Which is a native QlikView format and can only be written to and read by QlikView ?
- QVD
- QVS
- QVP
- CSV
13) What is the shortcut for the Table Viewer dialog ?
- Ctrl+L
- Ctrl+R
- Ctrl+E
- Ctrl+T
14) Which statement should follow after the access section is defined in the script?
- Section Authentication
- Section Application
- Section Application
- Section Authorization
15) How many different type of QlikView Server are available ?
- 1
- 2
- 3
- 4
16) How many different type of CALs are available ?
- 1
- 2
- 3
- 4
17) QMC stands for :
- QlikView Managed Console
- QlikView Management Console
- Quick Managed Console
- Quick Management Console
18) DSC stands for :
- Daily Services Controlling
- Daily Source Contents
- Directory Service Connectors
- Directory Source Connectors
19) Which of the following is not the component of tradtional DWH?
- OLAP CUBE
- ODS
- ETL
- Data Mart
20) Which of the following is classified as bad aesthetic in designing a app in qlik view?
- Cluttered
- Crisp
- Aligned
- Light colour choices
21) Which object is useful tool for showing several object types in a limited space ?
- Chart
- Statistics Box
- Text Object
- Container
22) In Bar Chart properties which Tab is used to limit the number of bars ?
- Dimensions
- Dimension Limits
- Presentation
- Style
23) In the Pivot Table properties which tab is used to showing partial sums?
- Expressions
- Sort
- Presentation
- Visual Cues
24) Which chart is ideal to view the changing value of a single measurement when changing selections ?
- Gauge Chart
- Bar Chart
- Line Chart
- Combo Chart
25) Which sheet object is used to shows several fields simultaneously in a very compact way ?
- Table Box
- List Box
- Multi Box
- Input Box
26) When we lock selection in QlikView document what will be the color of locked Cell?
- White
- Grey
- Green
- Blue
27) Which chart is ideal for comparison of similar measurements ?
- Line Chart
- Bar Chart
- Pivot Table
- Gauge Chart
28) Which chart is ideal for comparison of high-level groups ?
- Pie Chart
- Block Chart
- Radar Chart
- Line Chart
29) Which of the following is limitation of Pivot Table ?
- Can’t do sorting
- Can’t do partial sum
- Can’t do grouping
- Can’t change the background color of cell
30) Which statement can be preceded by the Load statement defining what directory to look for the files in ?
- Directory
- Files
- Table
- Folder
31) Which tab contains security settings for the QlikView script ?
- Data
- Functions
- Variables
- Settings
32) How many minimum fields need to have in the Load statement dealing with hierarchy table ?
- 1
- 2
- 3
- 0
33) How many different view/(s) is/are available in Table Viewer ?
- 1
- 2
- 3
- 4
34) What does identifier 1 represents in Set Analysis ?
- An Empty Set
- Full set of all the records in the application
- The records of the current selection
- The Previous Selection
35) Which of the following is not a basic Aggregation Functions ?
- Sum(expression)
- Min(expression [,rank])
- MinString(expression)
- Max(expression [,rank])
36) What will be the output of index( ‘abcdefg’, ‘cd’ )
- 1
- 2
- 3
- 4
37) In how many way/(s) security mechanism in QlikView can be set up ?
- 1
- 2
- 3
- 4
38) Which of the following is not QlikView Publisher capabilities ?
- Reload
- Reduce
- Distribute
- In-Memory analytics engine
39) Where we can find the information of all QV Services and their status in QMC?
- Status -> Services
- System -> Services
- Setup -> Services
- Users -> Services
40) Where we can find the detailed information about QlikView System in QMC ?
- System -> About
- Status -> About
- About -> System
- Setup -> About
41) Which of the following is not true about dimensional modelling?
- Simpler schemas
- Less Normalized
- Confuses end users
- Understood by end users
42) Which of the following does not drive the decision of usage of QVD file?
- Large number of database rows and load times are significant
- Does not require a frequent load
- Desire to reduce impact on your operational system
- Re-usability of data sources. I.e. multiple QlikView applications using the same
- QVD as a data source.
43) In a list box which Sort By type means that the values are sorted according to their logical state (selected, optional, excluded) ?
- State
- Frequency
- Load Order
- Text
44) Which object is used for entering data in a variable ?
- Input Box
- List Box
- Table Box
- Multi Box
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 ?
- User Preferences
- Document Properties
- Sheet Properties
- Object Properties
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 ?
- Subset Ratio
- Information Ratio
- Information Density
- Subset Information
47) Which function returns the contents of the fieldname in the record specified by row in the internal table tablename
- previous(expression )
- peek(fieldname [ , row [ , tablename ] ] )
- FieldValue(fieldname , n )
- FieldIndex(fieldname , value )
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.
- MinString(expression )
- MaxString(expression )
- FirstValue(expression)
- LastValue(expression)
49) What Sum({$} Sales) returns when used in expression ?
- Returns total sales within the application, disregarding selection but not the dimension.
- Returns Sales for the current selection.
- Returns Sales of the previous selection.
- Returns Sales of the next selection.
50) In the LEF file for QlikView Server License what is the Product level mentioned for QlikView Server ?
- 3
- 10
- 30
- 43
51) What type of security is implemented while communicating between QlikView Server and Windows Client?
- HTTPS/SSL
- Tunneling via HTTP
- 128 bit (RSA algorithm)
- 56 bit
52) License Lease is available on the following server edition:
- QlikView Test Server
- QlikView Extranet Server
- Qlikview Information Access Server
- QlikView Small Business Server
53) In which of the following cases one should use radar chart?
- Comparison of high level groups (one or two measurements)
- Comparison for multimeasurements
- performance trends
- comparison of similar measurements
54) In which of the following cases one should not use guage chart?
- Percentage margins
- Percentage quota achieved
- YTD vs Last YTD
- compare 2 dimesions