QlikView BI Beginner Quiz

Posted on: | By: – Comments Off

QlikView BI Beginner Quiz




1
QlikView is based on one of the following technology

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
3
To Keep track of the selection

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
4
How many Sheets can be added to a QlikView applications

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
5
For making selection, which is the most common object in QlikView

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
9
Which Chart is the most appropriate to show the percentage distribution

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

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



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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
11
Which of the charts support Matirx form report

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
12
Ideal chart to view the Changin value of single dimension

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
13
Used for entering data interactively in Qlikview

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
15
Which option is used to extract data from existing QlikView file

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
17
If the structure of two table is exactly same, they automatically get

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
18
In a chart that displays ‘Sales per Quarter’, which is the dimension?

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
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

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



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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
23
Field that defines what access does the user have

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
24
A Person with following access can change everything in the document

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
25
Following function is used to calculate Month Year from a Date

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
26
Returns true if date lies inside the quarter containing basedate.

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
28
Operator is used to make two strings into one

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
29
End of statements in script is identified by

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

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



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

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
31
Which of the following is a Salient feature of Qlikview

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
33
Which of the following is NOT a Qlikview Visualization

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
42
Which is not a valid type of Bookmark ?

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
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.

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



 

Related Articles

Advanced Manufacturing Process Quiz

Web analytics, Adobe Analytics, Google Analytics Quiz

SailPoint Quiz