QlikView BI Beginner Quiz

QlikView BI Beginner Quiz




1
QlikView is based on one of the following technology

  1. OLAP
  2. MOLAP
  3. In-Memory
  4. RDBMS

Answer : A

 
2
In QlikView main way of making queries is

  1. Writing Queries
  2. Selection of Field Values
  3. Passing parameters from Command Prompt
  4. Through Table Box

Answer : B

 
3
To Keep track of the selection

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

Answer : D

 
4
How many Sheets can be added to a QlikView applications

  1. 5
  2. 4
  3. 10
  4. Unlimited

Answer : D

 
5
For making selection, which is the most common object in QlikView

  1. Chart
  2. Table Box
  3. List Box
  4. Statistics Box

Answer : C

 
6
What is been used to save and use selections later on in the application

  1. Current Selection Box
  2. List Box
  3. Bookmark
  4. Lock

Answer : C

 
7
How can you see the total occurences of a list box value in the data

  1. Statistics Box
  2. Show Frequency
  3. Sort
  4. Table Box

Answer : B

 
8
Which Chart is the most appropriate to show the trend over the period

  1. Radar Chart
  2. Bar chart
  3. Line Chart
  4. Gauge Chart

Answer : C

 
9
Which Chart is the most appropriate to show the percentage distribution

  1. Line Chart
  2. Bar chart
  3. Pie Chart
  4. Combo Chart

Answer : C




10
Which option allows users to change the chart type within the same chart

  1. Export to Excel
  2. Fast Type Change
  3. Size to data
  4. Sort

Answer : B

 
11
Which of the charts support Matirx form report

  1. Bar Chart
  2. Straight Table
  3. Pivot Table
  4. Table Box

Answer : C

 
12
Ideal chart to view the Changin value of single dimension

  1. Bar Chart
  2. Gauge Chart
  3. Mekko Chart
  4. Radar Chart

Answer : B

 
13
Used for entering data interactively in Qlikview

  1. List Box
  2. Input Box
  3. Selection box
  4. Table Box

Answer : B

 
14
Which option is used to extract data from a Excel, csv or any other data file in Script Editor

  1. Connect
  2. Select
  3. Table Files
  4. QlikView Files

Answer : C

 
15
Which option is used to extract data from existing QlikView file

  1. Connect
  2. Select
  3. Table Files
  4. QlikView Files

Answer : D

 
16
Two Field to be associated in QlikView requires

  1. Same data in the field
  2. Same names of the fields
  3. Same data format
  4. Different Names but same data

Answer : B

 
17
If the structure of two table is exactly same, they automatically get

  1. Joined
  2. Concatenated
  3. Link
  4. Remains same

Answer : B

 
18
In a chart that displays ‘Sales per Quarter’, which is the dimension?

  1. Sales
  2. Month
  3. Period
  4. Quarter

Answer : D

 
19
How is a list box enabled to display multiple columns?

  1. Check Multiple Column Property
  2. Uncheck Single Column Property
  3. Use Pivot in List Box
  4. All of the Above

Answer : B




20
Select the best answer for the following question: Which are the possible modes for a mini chart?

  1. Sparkline
  2. Combo Chart
  3. Line Chart
  4. Pie Chart

Answer : A

 
21
Through this user can add data by typing directly into script

  1. Load from File
  2. Load Table
  3. Load InLine
  4. Select Database

Answer : C

 
22
Which group is used to group fields which are non-hierarchical

  1. Drill-Down
  2. MultiBox
  3. Cyclic Drill-Down
  4. All of the Above

Answer : C

 
23
Field that defines what access does the user have

  1. NTNAME
  2. SERIAL
  3. PASSWORD
  4. ACCESS

Answer : D

 
24
A Person with following access can change everything in the document

  1. USER
  2. ADMIN
  3. ACCESS
  4. Anonymous

Answer : B

 
25
Following function is used to calculate Month Year from a Date

  1. Monthname
  2. Month
  3. MonthYear
  4. YearMonth

Answer : A

 
26
Returns true if date lies inside the quarter containing basedate.

  1. InMonth
  2. InQuarter
  3. InYear
  4. InWeek

Answer : B

 
27
can be used in QlikView to perform commands or actions, e.g. export data to files, launch other applications or execute macros

  1. List Box
  2. Chart
  3. Buttons
  4. Table Box

Answer : C

 
28
Operator is used to make two strings into one

  1. +
  2. $
  3. &
  4. &&

Answer : C

 
29
End of statements in script is identified by

  1. comma
  2. semi-colon
  3. colon
  4. Exclaimation

Answer : B




30
command assigns the variable the text to the right of the equal sign

  1. Set
  2. Let
  3. Get
  4. Assign

Answer : A

 
31
Which of the following is a Salient feature of Qlikview

  1. In-Memory BI
  2. Data Discovery
  3. Mobile BI
  4. All

Answer : D

 
32
Which of the following Qlikview component is used for distributing QV documents

  1. Qlikview Accesspoint
  2. Qlikview Desktop
  3. Qlikview Publisher
  4. Qlikview Dashboard

Answer : C

 
33
Which of the following is NOT a Qlikview Visualization

  1. List Box
  2. Scatter Chart
  3. Heat Map
  4. Combo Chart

Answer : C

 
34

Which of the following is the resultant table of the below statement for 2 tables A and B.
Statement: Table A left Keep Table B
Table A
Id Name
1 Raj
2 Ram
3 Sham
4 ArifTable B
Id Emp_No
1 1001
3 1003
5 1004
  1. 1 table with the following records
    Id Name Emp_No
    1 Raj 1001
    2 Ram –
    3 Sham 1003
    4 Arif –
  2. 1 table with the following records
    Id Name
    1 Raj
    2 Ram
    3 Sham
    4 Arif
  3. 2 tables with the following records
    Table A
    Id Name
    1 Raj
    2 Ram
    3 Sham
    4 Arif
    Table B
    Id Name Emp_No
    1 Raj 1001
    2 Ram –
    3 Sham 1003
    4 Arif –
    5 – 1005
  4. 2 tables with the following records
    Table A
    Id Name
    1 Raj
    2 Ram
    3 Sham
    4 Arif
    Table B
    Id Emp_No
    1 1001
    3 1003

Answer : D

 
35
What is the resultant of Table A Right Join Table B

  1. Only 1 table with Table B’s records
  2. 2 Tables Table B and Table A with only matching records that exist in Table B
  3. One Table with all the records in Table B and the corresponding matching records from Table A
  4. Right Join is not possible in Qlikview

Answer : C

 
36
What is the meaning of Resident Load

  1. Loading the table at the end of the script
  2. Loading a table from an already loaded table
  3. Loading a table from QVD
  4. Loading a table from SQL table directly

Answer : B

 
37
How is synthetic key field identified in a Data Model

  1. A field which has $ sign in front of it
  2. A field which is in Bold font
  3. A field connected with dotted line
  4. A key which has # in front of it

Answer : A

 
38
Which of the below chart is used to show a metric value without dimensions

  1. Bar Chart
  2. Gauge Chart
  3. Google Map
  4. Mekko Chart

Answer : B

 
39
Which of the below charts is preferred to use with time dimension

  1. Line Chart
  2. Scatter Chart
  3. Bar Graph
  4. Pie Chart

Answer : A

 
40
Which of the following is False about circular reference

  1. Inconsistencies in data relations
  2. Is shown using Dotted Line
  3. Dashboard works well with circular reference
  4. All of the above

Answer : C

 
41
Which statement is not TRUE for bar chart ?

  1. This is the most basic chart type.
  2. Each x-axis value corresponds to a bar.
  3. The bar height corresponds to its numerical y-axis value.
  4. NONE

Answer : D

 
42
Which is not a valid type of Bookmark ?

  1. Document bookmarks
  2. User bookmarks
  3. Client bookmarks
  4. Personal Server bookmarks

Answer : C

 
43
Which will be best visualization for depicting Single Dimension and multiple measures ?

  1. Pivot Table
  2. Straight Table
  3. Table Box
  4. Gauge Chart

Answer : B

 
44
Which of the following Charts will be best used for YES/NO analysis ?

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

Answer : C

 
45
Which is not true for QVD files ?

  1. It contains one table.
  2. It composed of a well formatted HTML header.
  3. It is a proprietary database for Qlikview.
  4. It will be used in incremental load.

Answer : B