Question 1

Using the Sales Analysis Dashboard, create a filter action that will trigger once you select any state in Sales by State View, and it should update the Profit Vs Sales view. Find out using trend lines in the Profit Vs Sales view, how much does profit increase for each dollar of sales for the California state?

Options :

A : 0.180067

B : 0.133134

C : 0.294316

D : 0.167531

Answer: B

Question 2

Connect to the "Global Superstore" data source and use the Orders table. Find out the percentage of total sales in all the categories in 2015 by customers who have purchased any product in the Phones sub-category in 2014? Use Customer ID.

Options :

A : 4.90%

B : 5.03%

C : 4.53%

D : 3.45%

Answer: D

Question 3

In table calculations, partitioning fields define the direction of the calculation.

Options :

A : TRUE

B : FALSE

Answer: B

Question 4

Connect to the "Significant Volcano Eruption" data source. How many volcano eruptions took place in Luzon island of the Philippines in the 21st century in the first six months of each year?

Options :

A : 1

B : 2

C : 3

D : 4

Answer: C

Question 5

Connect to the "Kiva Loans - India" data source, find out which sector has the highest distribution of loan amount using interquartile ranges?

Options :

A : Education

B : Entertainment

C : Retail

D : Wholesale

Answer: D

Free TDA-C01 Mock Exam – Practice Online Confidently

Buying Options: