Online Access Free QV12BA Practice Test

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

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

Refer to the exhibit

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

What will be the result?

• A.The Interval table will be associated with the Transactions table on the TimePeriods field, and with the TransactionTime table by a synthetic table
• B.The TransactionTime table will be joined with the Interval table
• C.The Interval table will be associated with the Transactions table on the TransactionTime field and with the TimePeriods table by a synthetic table
• D.The Interval table will be joined with the Transactions table

A business analyst has data for these fields
* Year
* Sales Amount
* Product Number
* Country
* Order Number
How many dimensions and measures exist?

• A.Three dimensions and two measures
• B.Two dimensions and three measures
• C.One dimension and four measures
• D.Four dimensions and one measure

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?

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

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

• A.Money(Sum({<{ProductCategory > = 'Shoes'>}Sales))
• B.Money(Sum({<?roductCategory={Shoes}>}Sales) )
• C.Money(Sum(<ProductCategory={ ' Shoes * }>SaIes) )
• D.Money(Sum({<ProductCategory={'Shoes*}>}Sales))
• E.Money(Sum(<?roductCategory={Shoes}>Sales))