Question 1

Connect to the "Significant Volcano Eruption" data source. How many volcano eruptions took place within 30 miles of the Black Peak volcano in the Alaska Peninsula?

Options :

A : 0

B : 1

C : 2

D : 3

Answer: A

Question 2

What is the default join type when you blend two data sources?

Options :

A : Inner join

B : Outer join

C : Left outer join

D : Right join

Answer: C

Question 3

You want to create the following dashboard.The dashboard will contain two sheets that will connect to the same data source. The top sheet will be configured to filter the bottom sheet. When you click a category on the top sheet, the sheets must resize as shown in the following exhibit.How should you lay out the objects on the dashboard?

Options :

A : Drag a horizontal container to the dashboard and add both sheets to the container. Set the Fit to Standard.

B : Add both sheets to the dashboard. Set Fit to Fix width.

C : Drag a blank object to the dashboard and add both sheets to the dashboard. Set Fit to Entire view.

D : Drag a vertical container to the dashboard and add both sheets to the container. Set Fit to Entire view.

Answer: D

Question 4

You need to create a calculated field to filter your data based on Year-to-Date (YTD) sales. Following the steps below, which calculation should you use to filter for YTD sales, and how would you apply it to your dashboard?Go to Analysis > Create Calculated Field.Name the field YTD Sales.Use a calculation that filters the current year's sales up to today's date.Apply this calculated field as a filter by dragging it onto the filter shelf and selecting "True".What is the correct calculation to filter the data for YTD sales?

Options :

A : DATETRUNC("year", [Order Date]) = DATETRUNC("year", TODAY())

B : DATETRUNC("month", [Order Date]) = DATETRUNC("month", TODAY())

C : DATETRUNC("year", [Order Date]) = DATETRUNC("year", NOW())

D : YEAR([Order Date]) = YEAR(NOW())

Answer: A

Question 5

I want to add an annotation to the top-right hand part of my scattergraph.I can right-hand click on the viz, and select Annotate. There are then 3 options.Which of these is NOT one of these 3 Annotate options?

Options :

A : Annotate - Mark

B : Annotate - Point

C : Annotate - Line

D : Annotate - Area

Answer: C

Confidently Practice Online with Free Analytics-DA-201 Exam Cram

Buying Options: