Nest 0 Cart
Nest Account
Popular Exams
All Categories...
Nest
Nest 0
Contact
Log In / Sign Up
Copyright 2024 © store. All rights reserved.
Home QlikView QV-Developer-01

QlikView QV-Developer-01 Exam Practice Questions (P. 5)

  • Full Access (70 questions)
  • Six months of Premium Access
  • Access to one million comments
  • Seamless ChatGPT Integration
  • Ability to download PDF files
  • Anki Flashcard files for revision
  • No Captcha & No AdSense
  • Advanced Exam Configuration
Get Contributor Access
Question #21
A customer needs to analyze Products by Product Grouping. The relationship between Product and Product Group is undefined in the original data source.
How can the Product Grouping be defined within the QlikView script?
  1. A
    by using Input Box to enter the lookup table
  2. B
    by using AutoGenerate to load the lookup table
  3. C
    by generating a lookup table using the Inline wizard
  4. D
    by loading the lookup table using an Include statement

Correct Answer:
C

Question #22
A customer has sales data containing a fact table, Sales and dimension tables, Customer, Item, and Vendor.
After loading the data, the Entity Relationship Diagram (ERD) has a synthetic table containing the fields Name and Address from the Vendor and Customer tables.
How can a developer eliminate the synthetic keys and appropriately link the data?
  1. A
    qualify all tables
  2. B
    alias all primary key fields
  3. C
    left join the Customer data onto the Sales table
  4. D
    qualify all tables and then unqualify all key fields

Correct Answer:
D

Question #23
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?
  1. A
    qualify both tables and Unqualify all shared fields
  2. B
    left join the Budgeted Sales table onto the fact table using Month as the key
  3. C
    concatenate Load the Budgeted Sales table into the Actual Sales table loading shared fields as NULL
  4. D
    create a link table containing the dimensional fields then link each fact table using a concatenated key

Correct Answer:
D

Question #24
Refer to the exhibit to the right.

Which technique should be used by a developer to eliminate the circular reference in the data model displayed in the exhibit?
  1. A
    qualify all the fields in the data model ending with 'ID'
  2. B
    qualify the fields Name, Address, City, and Country in the Shippers and Suppliers tables
  3. C
    rename the fields ShipperID in the Shippers table and SupplierID in the Suppliers table
  4. D
    rename the fields OrderID in the OrderDetails table and SupplierID in the Products table

Correct Answer:
B

Question #25
A customer has 30 target values that are used to evaluate the quality of an organization's facilities. At least half the target values are changed monthly by the business users.
What is the most efficient way for the developer to store, access, and maintain the target values?
  1. A
    save the target names and values in an external file, load them into a QlikView table, and use a FOR loop to assign the values to variables
  2. B
    manually create a variable for each value in Expression Overview and maintain them in Expression Overview
  3. C
    create a Variables tab in the load script and use 30 LET statements to assign the values to variables
  4. D
    embed the target values into each expression in which they are required

Correct Answer:
A

Previous Questions Next Questions

All Pages