← Back to exam page

QV-Developer-01 – QlikView 11 Developer Certification Examination (qv_developer_01)

Loading demo links...

Showing 7–9 of 9 questions

Question 7

A customer needs a better understanding of inventory trends over time. However, the source database contains only the current product inventory levels.

Which technique will take advantage of QlikView capabilities to meet the customer's needs?

Select an option, then click Submit answer.

  • ○

    using a QlikView script to store an accumulation of periodic snapshots to a table in the source database

  • ○

    using a QVD file to store an accumulation of periodic snapshots from the source database

  • ○

    using a QVX file to store an accumulation of periodic snapshots from the source database
  • ○

    using a QlikView script to store an accumulation of periodic snapshots to an XML file

Question 8

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?

Select an option, then click Submit answer.

  • ○

    qualify both tables and Unqualify all shared fields

  • ○

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

  • ○

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

  • ○

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

Question 9

A customer needs an application to reload in a short time period. The source tables are log files that are appended to on a daily basis.

Which performance tuning option should a developer use?

Select an option, then click Submit answer.

  • ○

    the QVD files to store the source tables

  • ○

    the Partial Reload command with the append option

  • ○

    the Load prefix Buffer with the incremental option

  • ○

    the Load prefix Buffer and set the Keep Outdated QVD Buffers in the Document Properties