Qlik Exam QV12BA Topic 6 Question 42 Discussion

Actual exam question for Qlik's QV12BA exam

Question #: 42
Topic #: 6

Two of the tables in the QlikView data model are InvoiceHeader (one million rows) and InvoiceDetail (nine million rows) InvoicelD links the two Invoice tables.

This expression is used several times in the QlikView application, count (distinct invoiceiT)

How can a business analyst optimize this expression for use in the application?

AIn the load script, sort the InvoiceDetail table by InvoicelD. Add if (Peek(invoiceiD)=invoiceiD, 0,1) as DistinctlnvoicelD. Change the expression to Sum(DistinctinvoiceiD)

BIn the load script, add I as DistinctlnvoicelD to the InvoiceDetail table. Change the expression to Sum(DistinctlnvoicelD)

CIn the load script, sort the InvoiceDetail table by InvoicelD. Add if (?eek(invoiceiD)=invoiceiD, 1,0) as DistinctlnvoicelD. Change the expression to Sum (DistinctlnvoicelD)

DIn the load script, add l as DistinctlnvoicelD to the InvoiceHeader table Change the expression to Sum(DistinctlnvoicelD)A.

Show Suggested Answer

Suggested Answer: D

by Salome at Jul 30, 2022, 07:26 AM

Limited Time Offer

25%

Off

Get Premium QV12BA Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!