CertsTopics Logo

Weekend Sale Special - Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: top65certs

Changed QV12BA Exam Questions

Page: 2 / 2
Total 50 questions
Get QV12BA Full Access Download QV12BA PDF

QlikView 12 Business Analyst Certification Exam Questions and Answers

Question 5

A customer needs to measure sales by assigned sales representative

All previous and current sales representative assignments must be included so that sales representatives receive credit for sales activities on both previous and current sales.

Which type of dimension is described by the sales representative assigned to the client?

Options:

A.

Composite dimension

B.

Slowly changing dimension

C.

Historical lookup dimension

D.

Interval matching dimension

Question 6

An Invoices table has a DaysOverdue field A chart is required to analyze overdue invoices in 30 day intervals Which function should a business analyst use to meet this requirement?

Options:

A.

Aggr (DaysOverdue,30)

B.

Class(DaysOverdue, 30)

C.

GroupBy(DaysOverdue,30)

D.

IntervalMatch(DaysOverdue,30)

Question 7

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?

Options:

A.

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

B.

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

C.

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

D.

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

Page: 2 / 2
Total 50 questions
Get QV12BA Full Access Download QV12BA PDF