QlikView Intermediate Quiz

1) Which of the following QlikView chart is appropriate to show the composition element ?

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

Show Answer

 
 
2) What will be the output of following expression :
div(-4,-3)

1. -1
2. 1
3. 0
4. NULL

Show Answer

 
 
3) Which of the following objects not supports action ?

1. Text object
2. Button
3. Slider/Calendar object
4. line/arrow objects

Show Answer

 
 
4) The add prefix is relevant to which load .

1. Binary Load
2. Mapping Load
3. Partial Reload
4. Inline Load

Show Answer

 
 
5) Which chart is ideal for one dimension with multiple measurement?

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

Show Answer

 
 
6) Which sheet object is ideal  for displaying explanatory text or pictures or for creating multi-colored sheet areas ?

1. List Box
2. Multi Box
3. Text Object
4. Bar Chart

Show Answer

 
 
7) Which of the following expression when used as a part of the field list in a load or select statement, the text string “India” will be loaded as field value into the QlikView field “Country” ?
 

1. ‘India’ as Country
2. Country as ‘India’
3. ‘India’ Country
4. Country India

Show Answer

 
 
8) How many times the following script executes the Load statement :
FOR Each a in 1,3,7,’xyz’
LOAD * FROM file$(a).csv;
NEXT

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

Show Answer

 
 
9) Consider the following expression :
Let T=now( );
What will be value for $(T) ?
 

1. value of the current time
2. value of the current date
3. Error
4. now()

Show Answer

 
 
10) Comparing QlikView associative join  with SQL joins … what does it resemble ?

1. Outer Join
2. Left Join
3. Right Join
4. Inner Join

Show Answer

 
 
11) Which of the following is NOT a control statement in QlikView ?

1. For … Next
2. Exit Script
3. Store
4. Call

Show Answer

 
 
12) Which prefix is used in QlikView to transform the cross tab data and to create the desired fields ideal for consumption ?
 

1. CrossTable
2. Cross Table
3. Transform
4. Cross Transform

Show Answer

 
 
13) Which option from Data Tab in Script Editor is required to load a QVD file into QlikView ?

1. Table Files
2. QlikView File
3. Web File
4. Field Data

Show Answer

 
 
14) How many options are available for choosing Web Server while installing QlikView Server ?

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

Show Answer

 
 
15) What is the default port for Web Server ?

1. 8080
2. 80
3. 8800
4. 8008

Show Answer

 
 
16) SSL stands for :

1. Secure Socket Layer
2. Sure Socket Layer
3. Secure Socket Level
4. Secure Service Layer

Show Answer

 
 
17) How many number of application an user can access having Named CAL?

1. 1
2. 2
3. All the application hosted on Server
4. 4

Show Answer

 
 
18) Which component sits on the Front End of deployment ?

1. QlikView Server
2. QlikView Publisher
3. Directory Service Connectors
4. Distribution Services

Show Answer

 
 
19) Which of the following is not true about Inline tables in Qlik View?

1. Used to create tables that do not reside in any of your data sources
2. Inline tables can be manupulated or changed by Enterprise user outside the application
3. the creation of
4. Quarters, sorting dates uses inline tables
5. if used within an application, they can only be
6. manipulated/changed by the Enterprise user

Show Answer

 



20) Which of the following can be classified as good aesthetics while desining Qlik View app?

1. Dark colours
2. inconsistent object placment
3. Objects placed off the screen
4. Uncluttered

Show Answer

 
 
21) In which of the following cases designer should not use bar chart?

1. Performance trends
2. Actual vs Budget
3. Amount over time
4. Top N – category values

Show Answer

 
 
22) Which of the following is not a color function in QlikView ?

1. QlikTechGreen()
2. QlikTechGray()
3. Argb()
4. Colormaphue()

Show Answer

 
 
23) Which of the following function doesn’t count records excluded by where clause while executing the Load Script ?

1. RecNo()
2. RowNo()
3. IterNo()
4. AutoNumber()

Show Answer

 
 
24) What will happen when Hidden Script in QlikView is used ?

1. Script Execution Window and Application Log file will not show the Script.
2. Script Execution Window will not show the script but Application Log file show the Script.
3. Script Execution Window will show the script but Application Log file will not show the Script.
4. Both Script Execution Window and Application Log file will show the Script. However we can’t access Edit Script without password.

Show Answer

 
 
25) What does the value 100 represent in Green(100) function ?

1. Hex Code
2. Opacity
3. RGB Code
4. Darkest shade of Green.

Show Answer

 
 
26) Which of the following function assumes implicit DISTINCT qualifier ?

1. FirstSortedValue()
2. Aggr()
3. Count()
4. Concat()

Show Answer

 
 
27) Which of the following is the QlikTech’s proprietary Authentication mode?

1. Active Directory
2. SiteMinder
3. DMS
4. None

Show Answer

 
 
28) When does the mapping table gets dropped ?

1. At the end of the script execution.
2. After the ApplyMap function is used.
3. Immediately after the next Load statement where mapping table is used.
4. Whenever Drop Table is used.

Show Answer

 
 
29) After execution of the following script:
SET DecimalSep=’,’;
LET X = 7/2;
What will be the value of $(#X) ?

1. 3,5
2. 5
3. 3#5
4. NULL

Show Answer

 
 
30) Which prefix is used to include external files, such as image or sound files, or objects connected to a field value, to be stored in the qvw file ?

1. Buffer
2. Bundle
3. Include
4. Must_Include

Show Answer

 
 
31) When a directory statement is generated automatically in the Edit Script dialog ?
 

1. if Absolute Paths is enabled
2. if Relative Paths is enabled
3. if Relative Paths is disabled
4. If Use FTP is enabled

Show Answer

 
 
32) Which statement is used  to run other programs during the re-execution of the QlikView script ?

1. Run
2. Execute
3. Call
4. SQLExecute

Show Answer

 
 
33) How we can made an exit script statement conditional ?
 

1. By the optional use of when or unless clause.
2. By the optional use of when clause only.
3. By the optional use of unless clause only.
4. By the optional use of when and unless clause.

Show Answer

 
 
34) Which statement is used to write a string to the Script Execution Progress window and to the script log file ?

1. Write
2. Debug
3. Trace
4. Print

Show Answer

 
 
35) What are the Steps to configure folder in QlikView Server ?

1. System -> Setup -> QlikView Server -> Folders
2. System -> Setup -> QlikView Web Server -> Folders
3. System -> Setup -> QlikView Publisher -> Folders
4. System -> Setup -> QlikView Server -> General

Show Answer

 
 
36) What are the Steps to enable license for QlikView Server ?

1. System -> Setup -> QlikView Server ->QlikView Server License
2. System -> Licenses -> QlikView Server ->QlikView Server License
3. System -> Publisher -> QlikView Server ->QlikView Server License
4. System -> Licenses -> QlikView Publisher ->QlikView Server License

Show Answer

 
 
37) How many main client types are to access documents from Server ?

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

Show Answer

 
 
38) In which of the following cases one should not use scatter chart?

1. 3D measurement charts – amounts, quantity and number of customers
2. Map chart – sales on geographical map
3. percebtage margin
4. None

Show Answer

 
 
39) In which of the following cases one should use grid chart?

1. Quota achieved
2. Multi cross dimension measures – amount over region and product over time
3. yes or no analysis
4. one or two measurment – sales and profit

Show Answer

 
40) What is the main precessing engine of QlikView?

1. QIX
2. QVX
3. QVW
4. QWW

Show Answer

 
 
41) For time dimension across quarters which is a good viz.

1. Line Chart
2. Bar Chart
3. Spider Chart
4. Box Plot

Show Answer

 
 
42) What is the native DB for QV in-memory in QV 12?

1. Postgre
2. Hadoop
3. SQL Server
4. Oracle

Show Answer

 
 
43) What is the encryption Algorithm of ODBC Connection String ?

1. AES 256 bits
2. Triple DES 168 bits
3. RSA 128 Bit
4. No Encryption but Base64 Scrambling.

Show Answer

 
 
44) What is the difference between Transpose() and Crosstable() in QlikView?

1. They are same; In QlikView we call Transpose as Crosstable
2. They work differently; Both of them are part of QlikView transformation layer.
3. Transpose is not part of QlikView bit it’s Excel feature.
4. Transpose is opposite of Crosstable

Show Answer

 
 
45) Which of the following is the valid script statements(s) to remove the Circular Reference Issue ?

1. Drop Circular Reference [Table Name]
2. Loosen Table [Table Name]
3. Drop Synthetic Keys [Table Name]
4. Unmap Loosen Table [Table Name]

Show Answer

 
 
46) Which of the following keyword provides a way of displaying the table comments (metadata) from databases or spreadsheets ?

1. Comment Table
2. Help Table
3. Connect Table
4. Meta Table

Show Answer

 
 
47) What happened to the  connection  when a new connect statement  executed or when the script execution is finished?

1. Syntax Error
2. Need to terminate the connection explicitly.
3. The connection will be automatically terminated
4. Reload will fail.

Show Answer

 
 
48) In which section of the script there will be no effect of the force statement ?

1. Access Section
2. Application Section
3. Binary Load
4. Mapping Load

Show Answer

 
 
49) What sum( {1-$} Sales ) returns ?
 

1. Returns Sales for the current selection.
2. Returns Sales of the previous selection.
3. Returns Sales of everything excluded by the current selection.
4. Returns total sales within the application.

Show Answer

 
 
50) What are the steps to assign a category to the QlikView document ?

1. System -> User Document -> Select Particular Document -> Document Information
2. Document -> User Document -> Select Particular Document -> Document Information
3. Document -> System-> Select Particular Document -> Document Information
4. Document -> Setup -> Select Particular Document ->Document Information

Show Answer

 
 
51) Where we can find the information about Active Users in QMC ?

1. System -> QVS Statistics -> Select QV Server -> Active Users
2. Status -> QVS Statistics -> Select QV Server -> Active Users
3. Users -> QVS Statistics -> Select QV Server -> Active Users
4. Setup -> QVS Statistics -> Select QV Server -> Active Users

Show Answer

 
 
52) Where in QMC we can set the Working Set ?

1. Documents -> Setup -> QlikView Server -> Performance -> Working Set
2. Users -> Setup -> QlikView Server -> Performance -> Working Set
3. Status -> Setup -> QlikView Server -> Performance -> Working Set
4. System -> Setup -> QlikView Server -> Performance -> Working Set

Show Answer

 
 
53) What is a preferred schema for QV?

1. Star
2. Snow Flake
3. Constellation
4. Cow

Show Answer