MCQs on Loading and Connecting Data | Qlikview MCQ Questions

Master data loading and connections in QlikView with these targeted questions on importing Excel and CSV files, writing load scripts, database connections, and basic data profiling techniques.

Loading Data from Excel and CSV

1. Which file format is commonly used for loading structured data into QlikView?
   a) PDF
   b) CSV
   c) PNG
   d) MP4
2. What is the default file delimiter in a CSV file?
   a) Semicolon (;)
   b) Colon (:)
   c) Comma (,)
   d) Pipe (|)
3. Which step is necessary before loading an Excel file into QlikView?
   a) Converting it to XML
   b) Mapping column headers
   c) Saving it in .qvd format
   d) Specifying the sheet name in the script
4. What does the “File Wizard” in QlikView help with?
   a) Data extraction from databases
   b) Selecting and previewing data from files
   c) Creating visualizations automatically
   d) Writing advanced SQL queries
5. How does QlikView handle missing values in a CSV file during data load?
   a) Removes the entire row
   b) Converts them to zero
   c) Leaves them as nulls
   d) Fills them with the average value
6. Which of the following operations can QlikView perform when loading Excel data?
   a) Normalize data
   b) Apply filters during load
   c) Create dashboards
   d) Modify column types automatically
7. What does the “First Row as Field Names” option do when loading Excel data?
   a) Excludes the first row from loading
   b) Uses the first row to define column headers
   c) Converts the first row into a new table
   d) Splits the file into two datasets
8. When loading a CSV file, how can you handle different delimiters in QlikView?
   a) Change the delimiter in the File Wizard
   b) Modify the file structure
   c) Convert the file to Excel format
   d) Remove delimiters entirely
9. Which feature allows you to load multiple Excel sheets into QlikView?
   a) Crosstable Wizard
   b) File Loop
   c) Sheet Selector
   d) Load Script Editor
10. What is a common reason to preprocess Excel data before loading it into QlikView?
    a) To minimize data load time
    b) To avoid using the Data Load Editor
    c) To apply visual styles
    d) To bypass database connections

Introduction to QlikView Data Load Script

11. What is the primary function of a load script in QlikView?
    a) Designing dashboards
    b) Defining data extraction and transformations
    c) Setting up database connections
    d) Applying visualization themes
12. How do you comment a single line in a QlikView load script?
    a) //
    b) #
    c) /* */
    d) %
13. Which keyword in a QlikView load script is used to rename columns?
    a) AS
    b) RENAME
    c) CHANGE
    d) UPDATE
14. What does the “LOAD” statement do in QlikView scripts?
    a) Connects to the database
    b) Defines the fields and data source to be loaded
    c) Applies filters to the data
    d) Creates a new dashboard sheet
15. Which syntax is correct for loading data from an inline table in QlikView?
    a) INLINE [data];
    b) LOAD INLINE [data];
    c) INLINE LOAD [data];
    d) LOAD INLINE FROM [data];
16. How do you concatenate two tables in QlikView load script?
    a) JOIN
    b) UNION
    c) CONCATENATE
    d) APPEND
17. What is the purpose of the “RESIDENT” keyword in QlikView scripts?
    a) To connect to an external database
    b) To load data from an existing table in memory
    c) To rename columns dynamically
    d) To create calculated fields
18. How do you ensure distinct rows are loaded in QlikView?
    a) Use the DISTINCT keyword
    b) Apply filters in the Data Manager
    c) Remove duplicates after data load
    d) Use a WHERE clause
19. What is the benefit of using variables in QlikView load scripts?
    a) To enhance dashboard interactivity
    b) To simplify script maintenance and reusability
    c) To connect to external data sources
    d) To minimize memory usage
20. What is the purpose of a QVD file in QlikView?
    a) To compress and store dashboards
    b) To facilitate faster data reloads
    c) To create calculated fields
    d) To apply security to scripts

Connecting to Databases (ODBC/OLEDB)

21. What is ODBC primarily used for in QlikView?
    a) Importing visual themes
    b) Managing data models
    c) Connecting to relational databases
    d) Automating script execution
22. Which of the following is required to establish an OLEDB connection?
    a) QVD file
    b) SQL Server Management Studio
    c) Connection string
    d) REST API credentials
23. What is a major advantage of using ODBC over OLEDB in QlikView?
    a) Simpler connection setup
    b) Better query performance
    c) Compatibility with non-relational databases
    d) Enhanced security features
24. In QlikView, how can you test a database connection before loading data?
    a) By running the script without a LOAD statement
    b) By using the “Test Connection” button
    c) By creating a small table in the dashboard
    d) By using trial-and-error methods
25. What type of data sources can QlikView connect to using ODBC/OLEDB?
    a) Only cloud databases
    b) Relational databases, like SQL Server or Oracle
    c) Only local files
    d) Only unstructured data
26. What does the SQL SELECT statement in QlikView scripts do?
    a) Retrieves data from external databases
    b) Creates calculated fields
    c) Filters data in the dashboard
    d) Defines relationships between tables
27. What is required for setting up an ODBC connection in QlikView?
    a) A QVW file
    b) Database drivers installed on the system
    c) An exported Excel file
    d) REST API integration
28. Which tool can assist in creating OLEDB connection strings for QlikView?
    a) Connection Wizard
    b) Database Manager
    c) Script Editor
    d) Table Viewer

Basic Data Profiling

29. What is the purpose of data profiling in QlikView?
    a) To optimize visualizations
    b) To analyze and clean source data before modeling
    c) To create hierarchical structures
    d) To import data into QVD files
30. Which feature helps identify duplicate records during data profiling in QlikView?
    a) DISTINCT keyword in scripts
    b) Table Viewer
    c) Data Load Editor
    d) Data Validation tool

Answer Key