QV12BA QlikView 12 Business Analyst Certification Exam Dumps

test2022-11-09T06:49:04+00:00

By test QV12BA QlikView 12 Business Analyst Certification Exam Dumps 0 Comments

QV12BA QlikView 12 Business Analyst Certification Exam Dumps are valuable for your preparation which test your skills in Gather and Interpret Requirements,Identify and Analyze Data Sources and Design and Develop the QlikView Application User Interface. The QlikView Business Analyst Certification Exam measures your knowledge of interface design of QlikView applications. You are guaranteed to pass your QV12BA exam if you study well in QV12BA QlikView 12 Business Analyst Certification Exam Dumps.

Try free QV12BA practice exam below.

Page 1 of 2

1. A business analyst creates a document with sales data for different regions, products, and salespeople. The analyst needs to create an object that will show the percentage of the total sales when one or more values are selected.

Which two objects can the analyst use to meet these requirements? (Select two.)

Text box

Table box

Gauge chart

Mekko chart

Statistics box

2. A business analyst has a ProductCode field that contains the value 'AB1980T60'.

Which is the correct expression to extract all the numbers from this string?

=Right(ProductCode,7) - "T"

=SubField(Num# (ProductCode))

=KeepChar(ProductCode,* 016S9')

=Mid(ProductCode,3,4) + Mid(9,2>

3. Refer to the exhibit

A customer has loaded the two tables and then added the script:

What will be the result?

The Interval table will be joined with the Transactions table

The TransactionTime table will be joined with the Interval table

The Interval table will be associated with the Transactions table on the TransactionTime field and with the TimePeriods table by a synthetic table

The Interval table will be associated with the Transactions table on the TimePeriods field, and with the TransactionTime table by a synthetic table

4. 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?

In the load script, sort the InvoiceDetail table by Invoicel

Add if (Peek(invoiceiD)=invoiceiD, 0,1) as Distinctlnvoicel

Change the expression to Sum(DistinctinvoiceiD)

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

In the load script, sort the InvoiceDetail table by Invoicel

Add if (?eek(invoiceiD)=invoiceiD, 1,0) as Distinctlnvoicel

Change the expression to Sum (DistinctlnvoicelD)

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

5. A business analyst needs to visualize the sales of products by product category, product sub-category, and product name. The analyst would like to see the relative sales by product hierarchy without using a drill-down dimension.

Which chart type should the analyst use?

Grid chart

Block chart

Combo chart

Radar chart

6. A customer specified that the QlikView application should be designed to fit a screen resolution of 1280 x 800 as a standard.

Which option will assist a business analyst while creating the user interface?

View > Resize Window > 1280 x 800

View > Fit Zoom to Window > 1280 x 800

Settings > User Preferences > Design Tab and select 1280 x 800

Settings > User Preferences > Design Tab and select Display Grid Lines

7. Refer to the exhibit.

The Sales table shown represents the entire data set A business analyst adds an expression in a document:

Next, the analyst selects Year = '2010' and RegionID = '2.

What is the result of the expression with these selections?

250

750

850

650

8. A data model contains 1 billion records and a straight table renders all of the data at the most granular level. The business users do NOT need all of the detailed information. The business analyst needs to improve the rendering time of the straight table.

Which two approaches should the analyst use? (Select two)

Update the straight table to a more summarized view

Replace all table fields with only one field which concatenates the values of all previous table fields

Remove all master dimensions and master measures, and replace with distinct expressions in each visualization

Specify a specific sort order in the output of the straight table using a field not found in the straight table columns

Set up a calculation condition to only show the straight table if filtered down to a much smaller number of rows (e.g., 100k rows)

9. What are two ways to calculate the Sales for the ProductCategory. Shoes? {Select two)

Money(Sum(<ProductCategory={ ' Shoes * }>SaIes))

Money(Sum({<ProductCategory={'Shoes*}>}Sales))

Money(Sum(<?roductCategory={Shoes}>Sales))

Money(Sum({<{ProductCategory > = 'Shoes'>}Sales))

Money(Sum({<?roductCategory={Shoes}>}Sales))

10. Refer to the exhibit

A business analyst needs to present the actual sales of the current year in a KPI on a dashboard. The expression in the Text field is NOT working

Which two changes will correct the expression? (Select two)

Remove the $ sign before Year

Remove the $ sign between {and (

Add single quotes around the whole expression

Change Representation from Text to Expression

Add a = sign at the beginning of the expression

Page 2 of 2

11. Refer to the exhibits.

A business analyst needs to modify Chart_A so that it looks like Chart_B when users hover a mouse over it.

Which two actions should the business analyst take to meet this requirement? (Select two.)

In the Dimensions tab, check Show All Values

In the Expressions tab, check Text as Pop-up

In the Presentation tab, check Pop-up Labels

In the Expressions tab, check Values on Data Points

In the Presentation tab, check Show Numbers in Legend

12. A business analyst wants to represent the relationship between two key performance indicators <KPI) over time. The value ranges of the KPIs differ widely and the relative scale between each KPI is NOT required to be maintained.

How should the business analyst meet these requirements?

Create a bar chart with a logarithmic scale

Create a table chart with rounding function

Create a combo chart with two different scales

Create a matrix chart with two different symbols

13. A customer needs to see sales data by month, with a rolling six month average of margin percent for any selected twelve month period.

Which chart will meet these requirements?

A combo chart of sales as bars and rolling six month average margin percent as a line by Month Year

A pie chart of sales by Month Year and a line chart of rolling six month average margin percent by MonthYear

A bar chart of sales by month by year and a straight table of rolling six month average margin percent by MonthYear

A trellis chart of bar charts as sales by month by year and a pivot table of rolling six month average margin percent by month by year