Question 1

You have the following tiled dashboard that has one sheet. TDA-C01-page52-image8 You want to replace the sheet with Sheet2.What should you do?

Options :

A : Right-click Sheet2 and select Add to Dashboard.

B : Select Sheets and click the Swap Sheet button next to Sheet2.

C : From the context menu of Sheet3. select Remove Dashboard item

D : Drag Sheet2 to the dashboard.

E : From the context menu of Sheet3. select Deselect

Answer: D

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 have the following chart that sorts states by the number of products each state has purchased.Which formula should you use to include a number with the position of each state within each region?

Options :

A : FIRST ()

B : INDEX ()

C : WINDOW_SUM(SUM ([Quantity]))

D : LOOKUP (SUM ([Quantity]))

Answer: B

Question 4

I have two spreadsheets (Data1 and Data2) which are in the same Excel worksheet.Both spreadsheets have a column "ActivityID".First of all:In the Data Source, I open the Excel workbook.I then drag Data1 into the table canvas.How do I create a blend between Data1 and Data2, and then create a viz?

Options :

A : Drag Data2 on top of or just underneath Data1.Go to Sheet 1 and create your viz, using your data source.

B : Double-click on Data1 in the table canvas.Drag Data2 to the right of Data1.Go to Sheet 1 and create your viz, using your data source.

C : Create a new Data Source.In the new Data Source, drag Data2 into the table canvas.Go to Sheet 1 and create your viz, using the two data sources.

D : Drag Data2 to the right of Data1.Go to Sheet 1 and create your viz, using your data source.

Answer: C

Question 5

Connect to the "Global Superstore" data source and use the Orders table. Find out the customers who placed their first order in 2013 and what is the total sales value of these customers in the same year?

Options :

A : $414,302

B : $2,263,137

C : $483,269

D : $2,385,198

Answer: B