Free QlikView 12 Business Analyst Certification Exam QV12BA Exam Practice Test

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 displayedWhich setting can solve the problem?

• View > Turn on Projector View
• View > Fit Zoom to Window > Apply Zoom to All Sheets
• Settings > Document Properties > General Tab and check Disable Scroll Bars
• Settings > Sheet Properties > General Tab and check Fit to Projector Screen Resolution

A business analyst needs to sort the values for the Product dimension explicitly as "Planes", then "Trains", then "Automobiles" The analyst needs a highly optimized solution to provide the best performance for an application with between 900 million and 1 billion recordsWhich solution should the analyst use?

• Use the Ord function in the user interface to sort in a custom order
• Build nested IF statements in the user interface to assign numeric values, then sort numerically
• Create a new calculated dimension in the Ul named ProductSort, then sort the Product field by the new ProductSort field
• Assign a numeric value to the Product values using the DUAL function during the data load, then sort numerically in the Ul

A business analyst has data for these fieldsYearSales AmountProduct NumberCountryOrder NumberWhich three KPIs may be calculated? (Select three.)

• Average Sales Per Year
• Total Sales by Country
• Total Sales by Customer
• Average Order Sales Amount
• Total Customer Count by Country

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

Which three options can be used to change the background on a bar chart? (Select three )

• Color
• Image
• Multicolored
• Dynamic Image
• Persistent Colors

A business analyst has data for these fieldsYearSales AmountProduct NumberCountryOrder NumberHow many dimensions and measures exist?

• One dimension and four measures
• Two dimensions and three measures
• Three dimensions and two measures
• Four dimensions and one measure

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)

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>

A customer needs to measure sales by assigned sales representativeAll 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?

• Composite dimension
• Slowly changing dimension
• Historical lookup dimension
• Interval matching dimension

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

• List box
• Multi box
• Table box
• Statistics box
• Straight table