Latest QlikView Interview Questions – Examine Your Skills
1. Latest QlikView Interview Questions
In our last tutorial, we discussed all basic to intermediate level of QlikView interview questions in part 1, part 2 and part 3. In this part of the latest QlikView Interview Questions, we are trying to cover most advance and scenario based interview questions for QlikView.
Latest QlikView Interview Questions is mainly for professional and experienced. These questions help you to prepare a QlikView interview.
So, let’s start Latest QlikView Interview Questions.
2. Best Latest QlikView Interview Questions with Answers
These are the latest qlikview interview questions for experienced.
Q.1. What do you mean by Set Analysis?
The set analysis is a way of sorting and arranging data into different sets in sheet objects like charts or tables. The name set analysis is given because it provides with ways to add context to the data and analyze a data set by segregating and structuring the data and pre-defining it into tables and charts.
Q.2. What are Modifiers in Set Analysis?
Modifiers are part of the whole set expression and are used to modify the selected data set in a certain way. The modifiers are used to specify fields from the data tables from which data is to be chosen for set analysis. The modifier expression is written in <> brackets and can have more than one fields.
Q.3. What are the three types of Concatenation?
Three types of concatenation are:
- Automatic Concatenation
- Forced Concatenation
- No Concatenation
Q.4. What is the difference between Join and Keep?
Using Join two tables are permanently merged into one and are stored into QlikView’s memory as one joined table. Whereas Keep is used when the user wants to keep the two tables separately in the memory and join them virtually by linking them only from the intersection (same values region) points in the two tables.
Q.5. How is Join different from Concatenate?
Join combines two tables in such a way that all the repeating values i.e. those values which are same in both the tables are reduced to only one set of such values in the final (joined) table. Whereas, Concatenate does not make any such reduction and joins two tables as it is, with the same field values repeating themselves in the concatenated table. The repeated values will be displayed in the concatenated table which is not so with join as it eliminated one set of repeating values keeping only the set from one table of the two.
Q.6. Which Join type will be in use it gives the outcome of only those records which were common in both the tables?
Q.7. What is a Master Calendar?
A Master Calendar can be so created that it can be linked to any of the databases present in QlikView. Whenever some entries are made in those databases in fields having time or date, creating a Master Calendar and linking it with that particular database or fact table will give you all the details of time and date like week, quarter, weekday etc.
Q.8. What additional date fields can you add using a Master Calendar?
Day, Weekday, Week, Month, Year, Quarter.
Q.9. What causes Circular References?
Q.10. What are the ways to resolve circular reference?
Rename, Concatenate and Link Tables.
Latest QlikView Interview Questions for Beginners – Q. 3, 4, 6, 7, 8
Latest QlikView Interview Questions for Experienced – Q. 1, 2, 5, 9, 10
Q.11. What are the three certifications available in QlikView?
QlikView Data Architect, QlikView Business Analyst, QlikView System Administrator
Q.12. What are some of the new features added in QlikView version of November 2017?
Analytical connections, web client improvements, XLSX format exporting, BNF script reloading, KML support.
Q.13. What is a LEF?
LEF stands for License Enabler File. For QlikView Server upgradation, a maintenance contract is required. The end/expiry date, active period and current Maintenance Contract details are stored in the License Enabler File (LEF).
Q.14. Name some important directories that you need to take a back-up of while upgradation and restoring process?
Log files, configuration files, custom files, certifications and license, QlikView Publisher Repository database files, program files and program data.
Q.15. What is silent installation?
Silent Installation is installing a program to your device with minimum or no user interaction. It is different from the typical installer because during that you are asked for confirmations and permissions on several steps while the program is being installed such installations are known as attended Installation as opposed to silent installation where the user is not asked for confirmations and permissions to proceed with the installation’s next steps.
Q.16. What is QlikView Server Load Sharing?
In server load sharing, a file irrespective of its physical location can assign to any server that is a part of the server cluster. This process manages data load and network traffic by distributing data load between servers and assigning different server for different data files so that the data load gets evenly distributed between the servers in a cluster.
Q.17. What do you understand by QlikView Distribution Service?
QlikView Distribution Service is a part of the QlikView Publisher component which use in distributing source documents created by QlikView Developer to the server sitting at the front end where they transform and used as user documents.
Q.18. Explain QlikView’s Publisher Repository.
The QlikView Management Console (QMC) assigns Reload and Distribution tasks for the QlikView Documents. The information related to this assigning of tasks and additional settings stores as a separate set of XML files and the folder is called QlikView Publisher Repository (QVPR).
Q.19. What is the role of QlikView Web Server in QlikView’s architecture?
The most important role of QlikView Web Server in the QlikView architecture is to act as a middleman between the QlikView Server and the client. The data traffic coming from QlikView Server is directed to the QlikView Web Server component (QVWS or Microsoft IIS) at some point before reaching the user access points.
Q.20. What is the function of the Directory Service Connector?
QlikView Directory Service Connector is a service which searches and fetches user information from a variety of sources. Sources like Open Database Connectivity (ODBC), Active Directory, E-directory, Lightweight Directory Access Protocol (LDAP) are used to retrieve user details.
Latest QlikView Interview Questions for Beginners – Q. 13, 14, 15, 16, 18, 20
Latest QlikView Interview Questions for Experienced – Q. 11, 12, 17, 19
Q.21. How are all the components of QlikView’s architecture managed?
QlikView Management Service (QMS) is the ultimate management platform in QlikView. All the management tasks of different QlikView services and the communications between them is handled by QMS. There are two management outlets, the QlikView Management Console and QlikView Management APIs (Application Programming Interface) for users.
Q.22. What is SNMP?
SNMP stands for Simple Network Management Protocol which is a protocol used for managing, controlling and monitoring the devices/nodes within a network. SNMP collects all the important information about the network or nodes and provides useful real-time data/information on the working of the network.
Q.23. Which protocols are used in sending commands in QlikView?
Commonly used protocols are User Datagram Protocol (UDP) and TCP/IP.
Q.24. What are the three main tasks performed on a QlikView document?
Reload, Reduce and Distribute
Q.25. List the types of data files that can be loaded into QlikView.
- Text Files, also known as Flat files (CSV, TSV etc.,)
- Webpages (HTML)
- Log Files
- Excel (Xls and Xlsx)
- Inline Data
- QlikView (QVW)
- Fixed Record file
Q.26. What is the difference between QVD, QVW and QVX files?
QVW: Stands for QlikView Worksheet which are the application files containing your reports/dashboard data/script/data model and connection strings.
QVD: Stands for QlikView Data. Such files are a patent to QlikView and can only be read in QlikView. QVD files stores data in a simple format (without GUI) fetched from the database. Processing QVD files is around 10 times faster than processing data from traditional files.
QVX: Stands for QlikView Data Exchange. QVX files are used you wish to make your own connector that could connect to QlikView files. One of the efficient and optimize way to fetch data from the database. It is a much preferred and efficient way to retrieve data from the databases if you are not using ODBC/OLEDB.
Q.27. List some common ports used by QlikView services.
4747, 4774, 4720, 4750, 4730, 4735, 4780, 443, 80 and a few more.
Q.28. What is Backus-Naur Formalism?
Backus-Naur Form is a metalanguage. Metalanguages are the languages which are used to explain other natural or computer languages. Any metalanguage follows a specific notation technique or meta syntax through which rules of a language are defined and explained. BNF is used to explain the scripting language in QlikView.
Q.29. What is the Aggregation Function?
Aggregation functions are applied on entire data set and covers the data being evaluated as a whole/aggregate and returns result accordingly. Some commonly used aggregate functions are Sum, Average, Mix, Max, Text Count etc.
Q.30. How is the scope of aggregation defined?
By defining aggregation scope, it is meant selecting such data values or records are relevant to our purpose of analysis. Aggregation is only applied over the relevant data hence defining the scope for analyzing data.
Latest QlikView Interview Questions for Beginners – Q. 21, 23, 24, 25, 27, 29
Latest QlikView Interview Questions for Experienced – Q. 22, 26, 28, 30
So, this was all about Latest QlikView Interview Questions.
Hence, we hope you like our latest Qlikview interview questions and answers. Refer our latest article part 5. Still confusion? Feel free to ask in the comment box.
QlikView Interview Question Part – 5