Free QlikView QV_Developer_01 Practice Test & Real Exam Questions

Exam Code/Number: QV_Developer_01
Exam Name/Title: QlikView 11 Developer Certification Examination
Certification Provider: QlikView
Corresponding Certification: QlikView Certification

Exam Questions: 70
Updated On: Oct 03, 2026

Question #15

Refer to the exhibit to the right.

A customer has aggregated budgets for products by year and month. Actual data is stored at a more detailed transaction level and so a one-to-many relationship exists between the Budgets to Actuals table.
Budgets have been assigned for all months of the current year, but there are only transactions up to the current month of October. There are transactions for products that were not assigned budgets.
How can a developer remove the synthetic key automatically generated by QlikView and be able to analyze budgets and actuals by product, month, and year?

A. load the Actuals table, and when loading the Budgets table, use Outer Join to join the BudgetAmount field to the Actuals table

B. load the Actuals table, and when loading the Budgets table, use the Concatenate function to append the Budgets table to the Actuals table

C. load the Actuals table, and when loading the Budgets table, rename fields Year and Month to BudgetYear and BudgetMonth

D. create a concatenated key of Product-Year-Month in both the Budgets and Actuals table and comment out the individual fields in the Budgets table

Discussion 0

Correct Answer: B Vote an answer

Explanation: Only visible for Pass4Leader members. You can sign-up / login (it's free).

Question #16

Refer to the exhibit below.

A QlikView report does not match the legacy report it was designed to replace. The purpose of the report is to count the number of customers per year and in total.
Why is there a difference between the Total row values in the two reports?

A. The legacy report totals the number of customers correctly, while the QlikView report is dropping records.

B. The legacy report calculates the total customer occurrences, while the QlikView report calculates the customer ranking.

C. The legacy report calculates the total customer occurrences, while the QlikView report counts only distinct customers.

D. The legacy report totals the number of customers correctly, while the QlikView total row is set to Sum of rows.

Discussion 0

Correct Answer: C Vote an answer

Question #17

Refer to the exhibit below.

Schema A displayed in the exhibit has been transformed into Schema B.
How can the before and after schemas be described?

A. The snowflake schema has been transformed into a normalized schema.

B. The star schema has been transformed into a normalized schema.

C. The star schema has been transformed into a de-normalized schema.

D. The snowflake schema has been transformed into a de-normalized schema.

Discussion 0

Correct Answer: D Vote an answer

Question #18

A customer has an Actual Sales fact table aggregated at the transactional level and a
Budgeted Sales fact table aggregated at the monthly level. The tables share many of the same dimensional fields.

How can a developer form the data model?

A. left join the Budgeted Sales table onto the fact table using Month as the key

B. qualify both tables and Unqualify all shared fields

C. create a link table containing the dimensional fields then link each fact table using a concatenated key

D. concatenate Load the Budgeted Sales table into the Actual Sales table loading shared fields as NULL

Discussion 0

Correct Answer: C Vote an answer

Question #19

A designer needs to create a chart displaying the number of patients currently checked into a hospital by age group.
What is the appropriate Dimension for the chart?

A. number of patients

B. age group

C. hospital

D. checked-in status

Discussion 0

Correct Answer: B Vote an answer

Question #20

Which statement describes a required field characteristics that will ensure QlikView associations across multiple tables?

A. The number of distinct values in each field must be the same.

B. The field formats (such as numeric or string) must be the same in the original data sources.

C. The fields must be defined as primary or foreign keys in the original data sources.

D. The fields must be aliased to the same name when loading into QlikView.

Discussion 0

Correct Answer: D Vote an answer

Question #21

A project to develop a QlikView application for a customer requires splitting developers into two teams.
One team will focus on developing source database query knowledge to create a reusable data layer. There are several application-specific business rules for this project. The customer needs to incrementally accumulate history for the QlikView application over time.
The second team will focus on developing the presentation layer. This team also has data modeling and scripting expertise, but does not have source database query knowledge.
Which data loading strategy should the developers use on the project?

A. create the presentation layer QVW and connect directly to the source data and apply the business rules in the script

B. create QVDs of the source data and load them into the presentation layer QVW and apply the business rules in the script

C. create QVDs of the source data, apply the business rules and store a second layer of QVDs, and then load these QVDs into the presentation layer QVW

D. create a series of QVWs that apply the business rules and then binary load them into the presentation layer QVW

Discussion 0

Correct Answer: C Vote an answer

Download Free QlikView QV_Developer_01 Demo

Simply submit your e-mail address below to get started with our free demo of your QlikView QV_Developer_01 exam.