QV12BA Dumps QV12BA Braindumps QV12BA Real Questions QV12BA Practice Test QV12BA dumps free


QlikView


QV12BA


QlikView 12 Business Analyst Certification


https://killexams.com/pass4sure/exam-detail/QV12BA


QUESTION: 43

How many dimensions and measures are required to create a scatter chart?


  1. One dimension and one measure

  2. One dimension and two measures

  3. Two dimensions and one measure

  4. Three dimensions and one measure


Answer: B


QUESTION: 44

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 )


  1. Update the straight table to a more summarized view

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

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

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

  5. 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)


Answer: C, E


QUESTION: 45

Which two objects are created with ONLY measures? (Select two.)

  1. Option



  2. Option



  3. Option



  4. Option


  5. Option



Answer: C, D


QUESTION: 46

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.)

  1. Text box

  2. Table box

  3. Gauge chart

  4. Mekko chart

  5. Statistics box


Answer: A, B


QUESTION: 47

A business analyst uses a QlikView application developed on a desktop with a screen resolution of 1280 x 800 During weekly meetings the analyst presents the application using a projector with a maximum screen resolution of 1280 x 720 At this resolution, vertical scroll bars are displayed Which setting can solve the problem?


  1. View > Turn on Projector View

  2. View > Fit Zoom to Window > Apply Zoom to All Sheets

  3. Settings > Document Properties > General Tab and check Disable Scroll Bars

  4. Settings > Sheet Properties > General Tab and check Fit to Projector Screen Resolution


Answer: D


QUESTION: 48

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?


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

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

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

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


Answer: B

QUESTION: 49

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


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

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

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

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

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


Answer: D, E


QUESTION: 50

A business analyst needs to calculate the average order value by country. Which two objects meet this requirement? (Select two.)


  1. List box

  2. Multi box

  3. Table box

  4. Statistics box

  5. Straight table


Answer: B, C