Which two objects are created with ONLY measures? (Select two.)
A)
B)
C)
D)
E)
- A . Exhibit A
- B . Exhibit B
- C . Exhibit C
- D . Exhibit D
- E . Exhibit E
Refer to the exhibit.
A business analyst creates a water fall chart to understand how an initial value is affected by a series of intermediate positive and negative values.
Which two actions must a business analyst perform to create the water fall chart shown? (Select two)
- A . Add five dimensions *
- B . Add five measures
- C . Check "Show as water fall" on the Style tab of the bar chart properties
- D . On the dimension limit properties sheet set limit to only show the first five values .
- E . Use the Bar Offset property with the correct expression
What are two ways to calculate the Sales for the ProductCategory. Shoes? {Select two)
- A . Money(Sum(<ProductCategory={ ‘ Shoes * }>SaIes))
- B . Money(Sum({<ProductCategory={‘Shoes*}>}Sales))
- C . Money(Sum(<?roductCategory={Shoes}>Sales))
- D . Money(Sum({<{ProductCategory > = ‘Shoes’>}Sales))
- E . Money(Sum({<?roductCategory={Shoes}>}Sales))
A customer needs to measure sales by assigned sales representative.
All 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?
- A . Composite dimension
- B . Slowly changing dimension
- C . Historical lookup dimension
- D . Interval matching dimension
An Invoices table has a DaysOverdue field A chart is required to analyze overdue invoices in 30 day intervals.
Which function should a business analyst use to meet this requirement?
- A . Aggr (DaysOverdue,30)
- B . Class(DaysOverdue, 30)
- C . GroupBy(DaysOverdue,30)
- D . IntervalMatch(DaysOverdue,30)
A business analyst needs to create a dashboard showing only numerical values. There is NO need to filter data or select any
dimensions.
Which three objects can the business analyst use? (Select three)
- A . Bar chart
- B . Grid chart
- C . Gauge chart
- D . Scatter chart
- E . Straight table
Refer to the exhibits.
Chart_1 has been transformed into Chart_2
Which action did the business analyst take to transform the chart?
- A . In the Dimensions tab. set ‘<S2>’ as the Line Style of the dimension
- B . In the Style tab. selected Dashed Line from the Style drop-down menu
- C . In the Expressions tab. set ‘<S2>’ as the Line Style of the expression
- D . In the Expressions tab. selected Dashed Line from the Style drop-down menu
Refer to the exhibit.
The Product Sales table shown represents the entire data set. A business analyst adds an expression in a document.
Next, the analyst selects Product Category = ‘Bikes’ and Product Subcategory = ‘Road Bikes’.
What is the result of the expression with these selections’?
- A . 0
- B . 910.000
- C . 40.000.000
- D . 85 000 000
A business analyst designs a sheet with a list of customers. The analyst wants to add a small image to show the company logo for each customer.
Which three objects meet this requirement? (Select three)
- A . List box
- B . Input box
- C . Muiti box
- D . Table box
- E . Statistics box
A business analyst has data for these fields
• Year
• Sales Amount
• Product Number
• Country
• Order Number
How many dimensions and measures exist?
- A . One dimension and four measures
- B . Two dimensions and three measures
- C . Three dimensions and two measures
- D . Four dimensions and one measure
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?
- A . In Document Properties, add the Lock All action to the OnOpen trigger
- B . In Sheet Properties of Sheet1 add the Lock Field action to the OnLeaveSheet trigger
- C . In Button Properties, add the Activate Sheet action for Sheet2 and the Lock All action
- D . In Button Properties, add the Activate Sheet action for Sheet2 and the Lock Field action
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?
- A . Grid chart
- B . Block chart
- C . Combo chart
- D . Radar chart
Refer to the exhibits.
A business analyst has an application showing sales performance. The analyst will enter an expression in the search box of a filter pane to show only Salesman who generate more than $200,000 in sales.
Which is the correct expression?
- A . =Sum(Sales) >200000
- B . =If(Sum(Sales)>200000, Salesman)
- C . =Firstname(Salesman=,Rob,, ‘Tom’, ‘Helen’, ‘Rock’, ‘Leif’)
- D . = If (WildMatch (Salesman, ‘Rob*’ , "Tom"’, ‘Helen* ‘, ‘Rock*’ , ‘Leif"’) , Sales)
Refer to the exhibit.
A data architect loads the three data sources without adjusting the load script.
What is the result?
- A . A data model with three tables and a synthetic key
- B . A data model with three tables with a circular reference
- C . A data model with two tables that load without warnings or errors
- D . A data model with three tables that load without warnings or errors
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?
- A . View > Resize Window > 1280 x 800
- B . View > Fit Zoom to Window > 1280 x 800
- C . Settings > User Preferences > Design Tab and select 1280 x 800
- D . Settings > User Preferences > Design Tab and select Display Grid Lines