Question 1

True or False:When relating tables, the fields that define the relationships must have the same data type.

Options :

A :

True

B :

False

Answer: A

Question 2

When you want to first apply a filter and THEN show the Top N or Bottom N elements, which of the following filters would you use?

Options :

A : Data source Filter

B : Extract Filter

C : Context Filter

D : None of the these

Answer: C

Question 3

Using the CoffeeChain table, create a Dual Axis chart showing the Sales (Bar chart) and Profit (Line Chart) for each Product type. What was the Profit for the Herbal Tea product type in 2013?

Options :

A :

68,620

B :

74,683

C :

37,455

D :

46,493

Answer: C

Question 4

Which of the following options best describe measures?

Options :

A : They are categorical, qualitative

B : They are categorical, quantitative

C : They are numerical, qualitative

D : They are numerical, quantitative

Answer: D

Question 5

Which aggregation is available without requiring a table calculation or calculated field?

Options :

A : Running total

B : Standard deviation

C : Standard deviation

D : Percent of total

Answer: B

Free Desktop-Specialist Mock Exam – Practice Online Confidently

Buying Options: