QUESTION: 17

Refer to the exhibit

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

What will be the result?

The Interval table will be joined with the Transactions table
The TransactionTime table will be joined with the Interval table
The Interval table will be associated with the Transactions table on the TransactionTime field and with the TimePeriods table by a synthetic table
The Interval table will be associated with the Transactions table on the TimePeriods field, and with the TransactionTime table by a synthetic table

Answer(s): C

QUESTION: 18

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

Answer(s): D

Reveal Solution Next Question

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'?

0
910.000
40.000.000
85 000 000

Answer(s): B

Reveal Solution Next Question

QUESTION: 20

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?

Composite dimension
Slowly changing dimension
Historical lookup dimension
Interval matching dimension

Answer(s): C

Reveal Solution Next Question

Free QV12BA Exam Braindumps (page: 5)

QUESTION: 17

QUESTION: 18

QUESTION: 19

QUESTION: 20