Question 1

Add an exponential trendline to the chart and find out how many regions are above the trend line?

Options :

A : 3

B : 4

C : 5

D : 6

Answer: B

Question 2

You have the following map.You need the map to appear as shown in the following visualization. What should you do?

Options :

A : Change the mark type to Density

B : Drag Location to Size on the Marks card

C : Change the mark type to Map

D : Drag Population to Size on the Marks card

E : Change the opacity to 75%

Answer: A

Question 3

You need the top 10 values to appear in a different color. The lop 10 values must be colored dynamically. What should you do?

Options :

A : Select the lop 10 bars, create a set. and then drag the set to Color on the Marks card.

B : Create a group field that groups the top 10 values into one group and the rest of the values into another group. Drag the group field to Color on the Marks card.

C : Select the top 10 bars, and then change the color by selecting Color on the Marks card.

D : Create a set that has a top 10 condition, and then drag the set to Color on the Marks card.

Answer: D

Question 4

You have a dataset that contains sates data. The following is a sample of the data. TDA-C01-page52-image60 You need to return a value of true if a month has sales greater than $50 000. otherwise the formula must returna value of false.Which two formulas achieve the goal Choose two

Options :

A : SUM{[Sales]) IN (50000)

B : IIF(SUM< [Sales] ) >50000, TRUE, FALSE)

C : MAX< [Sales], 50000)

D : [Sales]> 50000

Answer: B,D

Question 5

Create a Fixed LOD calculation to determine the sales for each region and name it 'Regional Sales'. Add this calculation to the view. What is the value of 'Regional Sales' for Florida?

Options :

A : 501,240

B : 725,458

C : 678,781

D : 391,722

Answer: D

Free Analytics-DA-201 Mock Exam – Practice Online Confidently

Buying Options: