Top Courses in IT & Software 728x90

Monday 8 February 2016

best qlikview interview questions and answers


QlikView Interview Questions:

What is Circular loops?  Difference between Join and Concatenate?
What is Synthetic key, is it good or bad having?  What is No Concatenate?
What P() and E() in Set analysis?    Optimized and un-optimized QVD Load Situations?
What is Comparative analysis?  Explain 3 tier architecture implementation while
deploying QlikView application?
What is Mekko chart and what is the difference
between bar and Mekko chart?
Briefly explain how does QlikView storage the data
internally?  


What is the difference between Pivot, Straight and
Table box?
What are the restrictions of Binary Load?
How you connect to Database?  How are NULLS implemented in QlikView?      
What are the various data sources for QlikView?  How do you optimize QlikView Application? (What
tools are used and where do you start?)
What is partial reloading?  What is the difference between Subset ratio &
Information Density?
How you refresh you dashboards periodically?  What is your role in your project
What are the different types of CALs available?  What is your daily activity in your project
What are the various joins available in QlikView?  Difference between Star & Snowflake schema
How you use Macros in QlikView?  What is Peek, Previous, Apply map, Interval Match
How you optimize QlikView dashboards?  What is the difference between Pick and Match
What care should be taken while designing a data
model?
What is Fuzzy search
How you test your Dashboard?  How many charts are you used till now
Types of authorization in QlikView?  
  
What’s your role in your project?  How many dimensions are used in Guage Chart?
What’s your daily activity in your project?  What is set analysis?
Requirement Gathering  Best data modelling techniques?
Tell me about your project?  You have any knowledge about QV server and
Publisher?
What is the major KPI s in your project?  What is Incremental Load?
What is Dashboard?  Have you Create Ad hoc reports in your project
And how?
What type of architecture are you using in your
project?
Any knowledge about Data Island?
What type of schema are you using in your project
and why?
DMS authorization?
Difference between Star & Snowflake schema?  Section Access?
What is Peek, Previous, Apply map, Interval
Match?
Conditional enabling?
What’s is the difference between Pick and Match?  Difference between join and keep?
What is Fuzzy search?  Difference between Concatenate and join?
How many charts are you used till now?  String Functions?
Have you used macros in your project and why?  Binary Load, Preceding Load, Partial Load?
What’s the difference between QV versions?  How many ways you can maintain to store the
QVD's?
Have you used Alternate states and why?  
  
QlikView Architecture :  QlikView Scripting :
Optimized and un-optimized QVD Load Situations?  What is the difference between ODBC, OLE DB &
JDBC?
Explain 3 tier architecture implementation while
deploying QlikView application?
What is the use of Crosstable prefix in QlikView
Load Script?
Briefly explain how does QlikView storage the data
internally?
What is Mapping Load & ApplyMap() ?
What are the restrictions of Binary Load?  Synthetic Keys in QlikView and how & when to
avoid them?
How are NULLS implemented in QlikView?  Different flavours of Joins in QlikView?
How do you optimize QlikView Application? (What
tools are used and where do you start?)
What is the difference between Join & Keep?
What is the difference between Subset ratio and
Information Density?
How do you use Having clause (SQL Equivalent)
along with Groupby in QlikView?
  Explain IntervalMatch function in QlikView?
QlikView Security :  Explain Concatenation, No Concatenation & Auto
Concatenation?
Describe Section Access architecture?  Explain how to implement Incremental Load?
What is the difference between Authentication &
Authorization in QlikView? And how to implement
them?
What is Circular Loop and how do you avoid it?
What is the difference between File System
Security vs Section Access?
Explain Exists() function in QlikView and when do
you use this function?
Explain “Strict Exclusion” while implementing
Section Access and what are the implications of
not using this option?
What is Generic Load in QlikView?
How do you implement Section Access on
hierarchy based data?
QlikView Expression Language / UI :
  Explain Aggr Function?
QlikView Server & Publisher :  What is the use of FirstSortValue in QlikView?
What are the multiple protocols defined for client
communication with QVS?
What are Set Modifiers and Set Identifiers?
Explain different communication encryptions for
Windows Client & AJAX Client?
What is P() & E() and where do you use them?
What is the use of Anonymous User Account in
QVS?
What is the difference between ValueList() and
ValueLoop()?
What are the different types of CALs and explain
them?
What is Partial Reload? and why do you use
“ONLY” Qualifier?
What are the different editions of QlikView
Server?
What is the difference between Cyclic Group &
Drilldown Group?
  Explain alternate states and where do you use
them?
  
  
  
General :  
Difference between Star Schema & Snow Flake
Schema?

Difference between RDBMS & Associative
Database?

Ragged Hierarchies in Data warehousing  
Explain EAV data modelling technique?  
What are slowly changing dimensions?  


Reference:
http://community.qlik.com/thread/103074


0 comments:

Post a Comment

Note: only a member of this blog may post a comment.