QlikView Expert Quiz

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



1) How the data from commercial database systems is loaded into QlikView ?

1. via Microsoft OLE DB/ ODBC interface.
2. via XAML
3. via HTML
4. via SOAP

Show Answer

 
 
2) Which files are used to extract and store data into and from QlikView ?

1. QVD
2. QVP
3. QTP
4. QDV

Show Answer

 
 
3) How data can be  entered directly into the Edit Script window ?

1. Resident Table
2. Mapping Table
3. Buffer Table
4. Inline Table

Show Answer

 
 
4) Which chart is ideal for multi dimension with one or more measurement?

1. Pie Chart
2. Pivot Table
3. Straight Table
4. Grid Chart

Show Answer

 
 
5) What will be expected result of following :
Set vA = Evaluate(1+2);
Set vB = $(vA);

1. vA= Evaluate(1+2)
2. vB = 3
3. vA=3
4. vB=3
5. vA= Evaluate(1+2)
6. vB= Evaluate(1+2)
7. vA= Evaluate(1+2)
8. vB = $(vA)

Show Answer

 
 
6) What will be the result of the following expression:
=Sum(’10’+1)

1. 11
2. Error in Expression: Sum takes 1 parameter
3. NULL
4. 1

Show Answer

 
 
7) In how many ways users are  assigned the access levels ?

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

Show Answer

 
 
8) What mod( 7,2 ) will return ?

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

Show Answer

 
 
9) What is the process called by which it is verified that someone is who they claim they are ?

1. Authentication
2. Authorization
3. Impersonation
4. Ticketing

Show Answer

 
 
10) Which of the following is not correct about Binary Load ?

1. The binary statement is used for loading the data from another QlikView document
2. Binary Load does not load the layout information
3. Binary Load, loads the variables.
4. Only one binary statement is allowed in the script.

Show Answer

 
 
11) Which prefix is used to  Load or Select (SQL) statement  for loading just a set maximum number of records from the data source, regardless of its length ?

1. Top
2. First
3. Max
4. Next

Show Answer

 
 
12) What does $_1 represent in the Set Expression ?

1. Set Identifier
2. Set Modifier
3. Set Operator
4. Set Dollar Expression

Show Answer

 
 
13) What will happen when you click on “Clear License” button under QMC Licenses Tab > QlikView Server License

1. Only License Key will removed but you still have the Named User CAL(s) and Document User CAL(s).
2. CALs will removed but you still have the License Key
3. Both License Key and CALs will remove.
4. QlikView Server Instance will be removed.

Show Answer

 
 
14) Which version of .NET Framework is essential to Install QlikView Server 11.2 ?

3. .NET Framework 3.0
4. .NET Framework 3.5
5. .NET Framework 4.0
6. .NET Framework 2.0

Show Answer

 
15) What will be the name of the anonymous user account for the QlikView Server installed on a machine named “Wipro” ?

1. IQVS_Guest
2. QVS_Wipro
3. IQVS_Wipro
4. IQVS_Annonymous

Show Answer

 
 
16) Which of the following takes a user’s Windows Authentication information and  present to them all of the documents that they have access to ?

1. Access Point
2. IE Plugin
3. AJAX ZFC
4. Publisher

Show Answer

 
 
17) Which of the following is not true about relational modelling?

1. Less normalized
2. Complex schemas
3. Efficient data storage
4. confuses end users

Show Answer

 
 
18) In which of the following cases designer should not use line chart?

1. Performance trends
2. compare 2 dimensions
3. Amount over time
4. None of the above

Show Answer

 
 
19) In which of the following cases one should use pie chart?

1. Visual distribution measurments – yes or no analysis
2. multicross dimension measures
3. map chart
4. 3D measurement chart

Show Answer

 
 
20) In which of the following cases one should not use block chart?

1. KPI overview – cycle group dimesnion with sales, qty, margin etc
2. sort in any columns (no grouping)
3. performance trends
4. None of the above

Show Answer

 
 
21) In which of the following cases desingner should use pivot chart?

1. dimension across table – annual sales by month
2. ratio of measurements – percentages
3. two measures – currency amount and quantity
4. comparison of similar measurments

Show Answer

 
 
22) How data can be  entered directly into the Edit Script window ?

1. Resident Table
2. Mapping Table
3. Buffer Table
4. Inline Table

Show Answer

 
 
23) Which chart is ideal for multi dimension with one or more measurement?

1. Pie Chart
2. Pivot Table
3. Straight Table
4. Grid Chart

Show Answer

 
 
24) When do you see perfect key in QlikView ?

1. When information density is 100%.
2. Key field with 100% unique values
3. When key field is linked to more than 1 table(s)
4. Second key field in the same table is called perfect key.

Show Answer

 
 
25) Where do you use/see “Global Grouping Mode” in QlikView?

1. Document Properties -> Groups -> Group Setting
2. “Global Grouping Mode” is used in the QlikView Script while using ‘Groupby’ clause
3. Dimension Limits Tab
4. General Tab

Show Answer

 
 
26) How to secure QVD files to prevent from reading/reloading by anyone who has QlikView Desktop Edition?

1. Store Section Access Table in the QVD file.
2. Using QlikView Publisher
3. Using DMS authorization
4. Read/Write permission at Operating System Level.

Show Answer

 
 
27) What happens when we disable the ‘Sort Indicator’ option under ‘Presentation Tab’  for the Straight Table in QlikView ?

1. QlikView will hide the Sort Indicator icon next to the column header and you can’t sort anymore by double clicking on column header.
2. QlikView will hide the Sort Indicator icon next to the column header but you can still sort  by double clicking on column header.
3. QlikView will show the Sort Indicator icon next to the column header but you can’t sort anymore by double clicking on column header.
4. QlikView will show the Sort Indicator icon next to the column header and you can sort  by double clicking on column header.

Show Answer

 
 
28) What is the result of the following expression in QlikView?
index( ‘abcdbabcd’, ‘b’, -3 )

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

Show Answer

 
 
29) Which information is displays by the system field $FieldNo

1. The numbers in this list box represent the number of fields in different tables.
2. This list box shows the number of rows in the tables.
3. This list box shows the position of the fields in the tables.
4. This list box shows the number of fields in the tables.

Show Answer

 
 
30) What  happens when you select “Country” on a chart object which has a missing node in the drill down group/hierarchy?
Eg: Drill down group fields:{Region,Country,State,City}
Field values: {Asia,India,NULL,Delhi}

1. QlikView shows a message about missing node (i.e. State)
2. Nothing happens when you click on the chart because of the NULL values.
3. QlikView jumps directly to City(i.e. Delhi)
4. Can’t create a group with a missing node.(i.e. with NULL value)

Show Answer

 
31) What does ‘/’ represent in Set Operations ?

1. Exclusion
2. Divisor
3. Quotient
4. Symmetric Difference

Show Answer

 
 
32) Which ScriptError value corresponds to “General ODBC error” ?

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

Show Answer

 
 
33) What the following statement signifies:
set ErrorMode=0;
 

1. The script execution will halt and the user will be prompted for action (non-batch mode).
2. QlikView will simply ignore the failure and continue script execution at the next script statement
3. QlikView will trigger an “Execution of script failed…” error message immediately on failure, without prompting the user for action beforehand.
4. Syntax Error

Show Answer

 
 
34) Which of the following syntax is used to drop the field from the data model and thus from memory at any time during script execution?

1. Drop Field only.
2. Drop Fields only.
3. Both Drop Field and Drop Fields.
4. Delete Field.

Show Answer

 
 
35) What will be the output of following expression where
vMyVar = ‘\\121.12.13.34\Folder_01\Folder_02\Folder_03′ ?
SubField(vMyVar,’\’,-1)

1. Folder_01
2. Folder_02
3. Folder_03
4. 12.13.34

Show Answer

 
 
36) Which of the following in Set Analysis is equivalent to a WHERE clause in SQL ?

1. Set Identifier
2. Set Operator
3. Set Modifier
4. P() and E()

Show Answer

 
 
37) Which of the following service is used when IIS is used as a web server to handle the management calls ?

1. QVWS
2. QSS
3. DSC
4. QDS

Show Answer

 
 
38) Which of the following is related to QVPX protocol ?

1. XML
2. Encrypted
3. Binary
4. Uses Port 4747

Show Answer

 
 
39) What is the default port for QlikView Management Console?

1. 4782
2. 4774
3. 4780
4. 4747

Show Answer

 
 
40) What will Ceil (15.3333, 0.25,2) return?

1. 15
2. 10
3. 1
4. None of the above

Show Answer

 
 
41) What is BI BUS?

1. Communnication within applications
2. Travelling
3. SSL
4. None of the above

Show Answer

 
 
42) Calculation behavior of minimized chart object in QlikView …

1. QV Engine calculates even when the chart is minimized.
2. QV Engine performs – All at once calculation at document level
3. QV engine doesn’t perform any calculation n this chart.
4. Except captions and show conditions everything else is not calculated in the chart.

Show Answer

 
 
43) What happens when Data is loaded from QVD file without “(qvd)”  format suffix?
E.g.: Load * from MyQvd.qvd;

1. Loads all the records.
2. Load fails.
3. Loads only 1 record.
4. Loads only XML header.

Show Answer

 
 
44) What will happen when we don’t set the “NullValue” variable while using “NullAsValue” statement in QlikView Script ?

1. NullAsValue will replace the NULL values with ‘-‘ (Hyphen)
2. NullAsValue will replace the NULL values with ‘NULL’ (Text)
3. NullAsValue will replace the NULL values with ” (Empty String)
4. NullAsValue will not replace the NULL values

Show Answer

 
 
45) Which of the following QlikView script will be disregarded while using normal reload (Ctrl+R) ?

1. Replace Load * from Emp.csv;
2. Replace Only Load * from Emp.csv;
3. Replace Partial Load * from Emp.csv;
4. Partial Only Load * from Emp.csv;

Show Answer

 
 
46) Which of the following communications are not encrypted in QlikView?

1. QVWS to QVS
2. IIS to QVS
3. Browser to Web Server
4. QVS through QVP

Show Answer

 
 
47) Which of the CAL type can be transferred across multiple instances of QlikView Servers?

1. Named CAL
2. Session CAL
3. Both Named and Session CAL
4. CALs are not transferable between different instances of QlikView Server.

Show Answer

 
 
48) When can we have User Documents and Source Documents available in QMC under Documents Tab ?

1. When Only QlikView Server license is enabled.
2. When Only QlikView Publisher license is enabled.
3. When both QlikView Server and Publisher license is enabled.
4. When IIS as Web Server is enabled.

Show Answer

 
 
49) For which component in QMC ,the Load Balancing is configured ?

1. QlikView Server
2. QlikView Publisher
3. QlikView Web Server
4. Directory Service Connectors

Show Answer

 
 
50) Which of the following statement does not support the fact that “Qlik View is not SQL Schema”

1. QlikView builds a smaller and more reporting friendly schema from the transactional database
2. Schema is persistent and reacts as a whole to user
3. SQL take large schema and queries a subset of tables
4. Query results are dependent on each other in Qv while independent in SQL

Show Answer

 
 
51) QlikView operates in which mode?

1. Synchronous
2. Assynchronous
3. Hybrid
4. None of the above

Show Answer