QlikView Intermediate Quiz

Posted on: | By: – Comments Off

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
2) What will be the output of following expression :
div(-4,-3)

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
3) Which of the following objects not supports action ?

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
4) The add prefix is relevant to which load .

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
5) Which chart is ideal for one dimension with multiple measurement?

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

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

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

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

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
10) Comparing QlikView associative join  with SQL joins … what does it resemble ?

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
11) Which of the following is NOT a control statement in QlikView ?

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

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

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
14) How many options are available for choosing Web Server while installing QlikView Server ?

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
15) What is the default port for Web Server ?

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

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

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

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
18) Which component sits on the Front End of deployment ?

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

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

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



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

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
22) Which of the following is not a color function in QlikView ?

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

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

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
25) What does the value 100 represent in Green(100) function ?

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
26) Which of the following function assumes implicit DISTINCT qualifier ?

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
27) Which of the following is the QlikTech’s proprietary Authentication mode?

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

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

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

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

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

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

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

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

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

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
37) How many main client types are to access documents from Server ?

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

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

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

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



 
40) What is the main precessing engine of QlikView?

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
41) For time dimension across quarters which is a good viz.

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
42) What is the native DB for QV in-memory in QV 12?

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

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

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

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

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

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

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

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

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

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

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
 
53) What is a preferred schema for QV?

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

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


Related Articles

Advanced Manufacturing Process Quiz

Web analytics, Adobe Analytics, Google Analytics Quiz

SailPoint Quiz