Free QlikView 12 Business Analyst Certification Exam QV12BA Exam Practice Test

A business analyst creates a document with two sheets, Sheetl and Sheet2 The analyst needs to add a button on Sheetl. which will open Sheet2 and lock atl fields.How should the analyst create this trigger?

• In Document Properties, add the Lock All action to the OnOpen trigger
• In Sheet Properties of Sheet1 add the Lock Field action to the OnLeaveSheet trigger
• In Button Properties, add the Activate Sheet action for Sheet2 and the Lock All action
• In Button Properties, add the Activate Sheet action for Sheet2 and the Lock Field action

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 customer needs to display sales by quarter by year by gender in a single chart. Which chart type should the business analyst use?

• Pie chart with a 3D style
• Block chart with a 3D style
• Line chart with Stacked style
• Grid chart with pie chart style

For a gauge, in which two places in the chart properties can expressions be entered? (Select two )

• Auto Minimize of the object
• Show Condition of the object
• X and Y position of the object
• Calculation Condition of the object
• Number of major/minor units for the scale

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 thedimensions and KPIs quickly and easily. Which object meets these requirements?

• Pivot table without automatic pivoting
• Bar chart with groups of dimension and expression
• Table box without drop-down selection
• Straight table with interactive sorting

A business analyst needs to open another GlikView document by trigger Which two options can be used to perform this task? (Select two.)

• Text box trigger
• Field event trigger
• Line object trigger
• Activate sheet trigger
• Variable event trigger

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

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

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?

• Pivot table with allow pivoting
• Line chart with style option fill
• Straight table with dimension limit
• Radar chart with style option stacked

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