Question 1

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 2

How the ATTR() is defined in Tableau?

Options :

A : IF MIN ([dimension]) = MAX ([dimension]) THEN MIN ([dimension]) ELSE "*" END

B : IF MIN ([dimension]) < MAX ([dimension]) THEN MAX ([dimension]) ELSE "*" END

C : IF MIN ([dimension]) = MAX ([dimension]) THEN MIN ([dimension]) ELSE MAX ([dimension]) END

D : IF MIN ([dimension]) = MAX ([dimension]) THEN MIN ([dimension]) ELSE NULL END

Answer: A

Question 3

Connect to the "WorldBank Data" and use the Development Indicators table. Create a country map of the Europe and Central Asia region. Find out which neighboring country of Romania is having a greater average GDP per capita than Romania?

Options :

A : Ukraine

B : Serbia

C : Hungary

D : Hungary

Answer: C

Question 4

In Tableau, the USERNAME() function is used to dynamically retrieve certain information during the session. What does the USERNAME() function return?

Options :

A : The full name of the user

B : The email address of the user

C : The current Tableau Server or Tableau Online username

D : The IP address of the user

Answer: A

Question 5

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

Higher Test Marks with Free Online Analytics-DA-201 Exam Practice

Buying Options: