Online Access Free QV12BA Exam Questions

Refer to the exhibit.

A data architect loads the three data sources without adjusting the load script. What is the result?

• A.A data model with three tables that load without warnings or errors
• B.A data model with two tables that load without warnings or errors
• C.A data model with three tables and a synthetic key
• D.A data model with three tables with a circular reference

Refer to the exhibits.

Table_1 has been transformed into Table_2. Which action did the business analyst take to transform the table?

• A.In the Presentation tab checked Totals on Last Row
• B.In the Dimension Limits tab, checked Show Total
• C.In the Presentation tab. checked Show Partial Sums
• D.In the Presentation tab. checked Subtotals at Top

A business analyst needs to analyze average sales by product number and country by year. Which measure(s) should the business analyst use?

• A.Product Number and Average Sales
• B.Average Sales
• C.Year
• D.Average Sales and Year

A business analyst wants to display sales by country region, city and customers. All the dimensions needs to be shown. Which chart can display a hierarchy without a drill-down dimension?

• A.Straight table with dimension limit
• B.Pivot table with allow pivoting
• C.Radar chart with style option stacked
• D.Line chart with style option fill

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 (?eek(invoiceiD)=invoiceiD, 1,0) as DistinctlnvoicelD. Change the expression to Sum (DistinctlnvoicelD)
• B.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)
• C.In the load script, add l as DistinctlnvoicelD to the InvoiceHeader table Change the expression to Sum(DistinctlnvoicelD)A.
• D.In the load script, add I as DistinctlnvoicelD to the InvoiceDetail table. Change the expression to Sum(DistinctlnvoicelD)