QlikView BI Beginner Quiz
1
QlikView is based on one of the following technology
- OLAP
- MOLAP
- In-Memory
- RDBMS
2
In QlikView main way of making queries is
- Writing Queries
- Selection of Field Values
- Passing parameters from Command Prompt
- Through Table Box
3
To Keep track of the selection
- List Box
- Statistics Box
- Table Box
- Current Selection Box
4
How many Sheets can be added to a QlikView applications
- 5
- 4
- 10
- Unlimited
5
For making selection, which is the most common object in QlikView
- Chart
- Table Box
- List Box
- Statistics Box
6
What is been used to save and use selections later on in the application
- Current Selection Box
- List Box
- Bookmark
- Lock
7
How can you see the total occurences of a list box value in the data
- Statistics Box
- Show Frequency
- Sort
- Table Box
8
Which Chart is the most appropriate to show the trend over the period
- Radar Chart
- Bar chart
- Line Chart
- Gauge Chart
9
Which Chart is the most appropriate to show the percentage distribution
- Line Chart
- Bar chart
- Pie Chart
- Combo Chart
10
Which option allows users to change the chart type within the same chart
- Export to Excel
- Fast Type Change
- Size to data
- Sort
11
Which of the charts support Matirx form report
- Bar Chart
- Straight Table
- Pivot Table
- Table Box
12
Ideal chart to view the Changin value of single dimension
- Bar Chart
- Gauge Chart
- Mekko Chart
- Radar Chart
13
Used for entering data interactively in Qlikview
- List Box
- Input Box
- Selection box
- Table Box
14
Which option is used to extract data from a Excel, csv or any other data file in Script Editor
- Connect
- Select
- Table Files
- QlikView Files
15
Which option is used to extract data from existing QlikView file
- Connect
- Select
- Table Files
- QlikView Files
16
Two Field to be associated in QlikView requires
- Same data in the field
- Same names of the fields
- Same data format
- Different Names but same data
17
If the structure of two table is exactly same, they automatically get
- Joined
- Concatenated
- Link
- Remains same
18
In a chart that displays ‘Sales per Quarter’, which is the dimension?
- Sales
- Month
- Period
- Quarter
19
How is a list box enabled to display multiple columns?
- Check Multiple Column Property
- Uncheck Single Column Property
- Use Pivot in List Box
- All of the Above
20
Select the best answer for the following question: Which are the possible modes for a mini chart?
- Sparkline
- Combo Chart
- Line Chart
- Pie Chart
21
Through this user can add data by typing directly into script
- Load from File
- Load Table
- Load InLine
- Select Database
22
Which group is used to group fields which are non-hierarchical
- Drill-Down
- MultiBox
- Cyclic Drill-Down
- All of the Above
23
Field that defines what access does the user have
- NTNAME
- SERIAL
- PASSWORD
- ACCESS
24
A Person with following access can change everything in the document
- USER
- ADMIN
- ACCESS
- Anonymous
25
Following function is used to calculate Month Year from a Date
- Monthname
- Month
- MonthYear
- YearMonth
26
Returns true if date lies inside the quarter containing basedate.
- InMonth
- InQuarter
- InYear
- InWeek
27
can be used in QlikView to perform commands or actions, e.g. export data to files, launch other applications or execute macros
- List Box
- Chart
- Buttons
- Table Box
28
Operator is used to make two strings into one
- +
- $
- &
- &&
29
End of statements in script is identified by
- comma
- semi-colon
- colon
- Exclaimation
30
command assigns the variable the text to the right of the equal sign
- Set
- Let
- Get
- Assign
31
Which of the following is a Salient feature of Qlikview
- In-Memory BI
- Data Discovery
- Mobile BI
- All
32
Which of the following Qlikview component is used for distributing QV documents
- Qlikview Accesspoint
- Qlikview Desktop
- Qlikview Publisher
- Qlikview Dashboard
33
Which of the following is NOT a Qlikview Visualization
- List Box
- Scatter Chart
- Heat Map
- Combo Chart
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 table with the following records
Id Name Emp_No
1 Raj 1001
2 Ram –
3 Sham 1003
4 Arif – -
1 table with the following records
Id Name
1 Raj
2 Ram
3 Sham
4 Arif -
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 -
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
35
What is the resultant of Table A Right Join Table B
- Only 1 table with Table B’s records
- 2 Tables Table B and Table A with only matching records that exist in Table B
- One Table with all the records in Table B and the corresponding matching records from Table A
- Right Join is not possible in Qlikview
36
What is the meaning of Resident Load
- Loading the table at the end of the script
- Loading a table from an already loaded table
- Loading a table from QVD
- Loading a table from SQL table directly
37
How is synthetic key field identified in a Data Model
- A field which has $ sign in front of it
- A field which is in Bold font
- A field connected with dotted line
- A key which has # in front of it
38
Which of the below chart is used to show a metric value without dimensions
- Bar Chart
- Gauge Chart
- Google Map
- Mekko Chart
39
Which of the below charts is preferred to use with time dimension
- Line Chart
- Scatter Chart
- Bar Graph
- Pie Chart
40
Which of the following is False about circular reference
- Inconsistencies in data relations
- Is shown using Dotted Line
- Dashboard works well with circular reference
- All of the above
41
Which statement is not TRUE for bar chart ?
- This is the most basic chart type.
- Each x-axis value corresponds to a bar.
- The bar height corresponds to its numerical y-axis value.
- NONE
42
Which is not a valid type of Bookmark ?
- Document bookmarks
- User bookmarks
- Client bookmarks
- Personal Server bookmarks
43
Which will be best visualization for depicting Single Dimension and multiple measures ?
- Pivot Table
- Straight Table
- Table Box
- Gauge Chart
44
Which of the following Charts will be best used for YES/NO analysis ?
- Bar Chart
- Line Chart
- Pie Chart
- Block Chart
45
Which is not true for QVD files ?
- It contains one table.
- It composed of a well formatted HTML header.
- It is a proprietary database for Qlikview.
- It will be used in incremental load.