Tableau Tableau Certifications TDA-C01 Questions & Answers

• Question 91:

  HOTSPOT

  You have a table that contains four columns named Order Date, Country, Sales, and Profit.

  You need to add a column that shows the day of the week for each row. For example, orders placed on August 31, 2022, will show a day of

  Wednesday.

  How should you complete the formula? (Use the dropdowns in the Answer Area to select the correct options to complete the formula.)

  Hot Area:

  

  Correct Answer:

  

  To add a column that shows the day of the week for each row, you should complete the formula as follows: DATENAME ( `weekday' , [Order Date]) The DATENAME function in Tableau returns the name of a specified part of a date or datetime value, such as the year, month, or day. It takes two arguments: the date part and the date. In this question, you want to return the name of the weekday, such as Monday, Tuesday, or Wednesday, for each order date. Therefore, you need to use `weekday' as the date part and [Order Date] as the date. The formula will return a string value that represents the name of the weekday for each order date. References: Tableau Help: DATENAME Function Tableau Help: Date Functions

  To add a column that shows the day of the week for each row, you should complete the formula as follows: DATENAME ( `weekday' , [Order Date]) The DATENAME function in Tableau returns the name of a specified part of a date or datetime value, such as the year, month, or day. It takes two arguments: the date part and the date. In this question, you want to return the name of the weekday, such as Monday, Tuesday, or Wednesday, for each order date. Therefore, you need to use `weekday' as the date part and [Order Date] as the date. The formula will return a string value that represents the name of the weekday for each order date. References: Tableau Help: DATENAME Function Tableau Help: Date Functions

• Question 92:

  HOTSPOT

  You have the following worksheet.

  

  You want to create a table calculation that shows sales growth over each year.

  How should you complete the formula? (Use the dropdowns in the Answer Area to select the correct options to complete the formula.)

  Hot Area:

  

  Correct Answer:

  

  There are different ways to create a table calculation that shows sales growth over each year, but one possible answer is:

  SUM([Sales])

  LOOKUP(SUM([Sales]), -1)

  PREVIOUS_VALUE(0)

  To calculate the sales growth over each year, you need to compare the current year's sales with the previous year's sales and divide the difference by the previous year's sales. You can use the SUM, LOOKUP, and PREVIOUS_VALUE

  functions to achieve this. The SUM function returns the total sales for each year. The LOOKUP function returns the value of an expression in a target row, specified as a relative offset from the current row. The PREVIOUS_VALUE function

  returns the value of the expression in the previous row, or a specified value if there is no previous row. The formula for the table calculation is:

  (SUM([Sales]) - LOOKUP(SUM([Sales]), -1)) / PREVIOUS_VALUE(0) This formula subtracts the sales of the previous year (LOOKUP(SUM([Sales]), -1)) from the sales of the current year (SUM([Sales])) and divides the result by the sales of

  the previous year. If there is no previous year, the formula uses 0 as the denominator (PREVIOUS_VALUE(0)) to avoid division by zero errors.

  References:

  Tableau Certified Data Analyst Exam Prep Guide, page 11, section "Creating Calculated Fields"

  Tableau Help: SUM Function

  Tableau Help: LOOKUP Function

  Tableau Help: PREVIOUS_VALUE Function

• Question 93:

  HOTSPOT

  You receive a tab-delimited data file name sales.tsv.

  You need to connect to the file.

  Which option should you select in Tableau Desktop?

  Hot Area:

  

  Correct Answer:

  

• Question 94:

  HOTSPOT

  You have a Tableau Prep flow that joins a dataset named Global Indicators to a dataset named Price Indices.

  In which step can you transform rows of monthly data into rows of yearly data''

  Hot Area:

  

  Correct Answer:

  

• Question 95:

  HOTSPOT

  You have a blank dashboard.

  You want to add two sheets to the dashboard. The sheets must support the Show/Hide button.

  To which two objects can you add the sheets? (Click the two appropriate Options in the Answer Area.)

  Hot Area:

  

  Correct Answer:

  

  To add two sheets to the dashboard that support the Show/Hide button, you can add them to either a horizontal or a vertical container. A container is an object that can hold one or more sheets or other objects and allow you to arrange them in a layout. A Show/Hide button is a feature that lets you hide or show a container and its contents on the dashboard. You can add a Show/Hide button to any container, whether it is tiled or floating, by using the drop-down menu of the container and selecting "Add Show/Hide Button." You can also customize the appearance and behavior of the button. To add a horizontal or a vertical container to the dashboard, you can drag them from the Objects pane to the dashboard. A horizontal container will arrange the sheets or objects horizontally, while a vertical container will arrange them vertically. You can then drag the sheets you want to add from the Sheets pane to the container. You can resize and reorder the sheets or objects within the container by using the handles and arrows. The other objects in the Answer Area, such as text, image, web page, blank, navigation, download, and extension, do not support the Show/Hide button. They are either static elements that cannot hold other objects, or dynamic elements that require user interaction or external sources. You can add them to the dashboard as well, but they will not have the same functionality as a container with a Show/Hide button. References: Add Show/Hide Buttons - Tableau Layout Containers - Tableau

• Question 96:

  HOTSPOT

  You have a dashboard than contains two sheets named Sheet 1 and Sheet 2.

  You want to add an object to the dashboard that users can click to switch to a different dashboard in the workbook.

  Which object should you add to the dashboard?

  Hot Area:

  

  Correct Answer:

  

  Explanation: The object that you should add to the dashboard to allow users to switch to a different dashboard in the workbook is Navigation.

  Navigation objects are used to create links between dashboards or sheets in a workbook. You can add a navigation object to a dashboard by dragging it from the list of objects and dropping it on the dashboard. You can then configure the

  navigation object to specify the destination dashboard or sheet that you want users to navigate to when they click on it. You can learn more about navigation objects and how to use them in this article:

  https://help.tableau.com/current/pro/desktop/en-us/dashboards_navigation.htm

• Question 97:

  HOTSPOT

  You have a dashboard that is configured for desktop browsers.

  You want to customize a layout for mobile users.

  Which option should you select first? (Click the appropriate Option in the Answer Area.)

  Hot Area:

  

  Correct Answer:

  

  To customize a layout for mobile users, you should select the Device Preview option first. This option will allow you to see how your dashboard will look on different types of devices, such as phones, tablets, or desktops. You can also choose different models and orientations to preview different screen sizes and resolutions. From the Device Preview mode, you can add, edit, or delete device layouts for each device type. You can also adjust the size, position, and formatting of the dashboard elements for each device layout. References: Create Dashboard Layouts for Different Device Types - Tableau Tableau Certified Data Analyst Study Guide