Q1. 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?
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.
Correct Answer: D
Q2. A business analyst wants to display several dimensions and key performance indicators (KPI) in one object Aggregations must be done in this object. The user must be able to change the sorting of the dimensions and KPIs quickly and easily. Which object meets these requirements?
A.Pivot table without automatic pivoting
B. Bar chart with groups of dimension and expression
C. Table box without drop-down selection
D. Straight table with interactive sorting
Correct Answer: A
Q3. A business analyst will compare sales growth between this year and last year by country. The analyst is given the sales values and must calculate the growth. Which two charts can be used? (Select two.)
A.Table box with country as dimension and sales per year as expression
B. Bar chart with country and year as dimensions and sales as expression
C. Gauge chart with country as dimension and sales per year as expression
D. Pivot table with country and year as dimensions and sales as expression
E. Funnel chart with country and year as dimensions and sales as expression
Correct Answer: D, E
Q4. How many dimensions and measures are required to create a scatter chart?
A.One dimension and one measure
B. One dimension and two measures
C. Two dimensions and one measure
D. Three dimensions and one measure
Correct Answer: B
$ 39
Reviews
There are no reviews yet.