Tableau TDA-C01 Practice Test - Questions Answers

To refresh an extract on Tableau Server, you need to select the workbook, select Refresh Extracts, and then add a new extract refresh. You can specify the frequency and time of the refresh, as well as any custom options. You can have multiple extract refreshes for the same workbook with different schedules.

Reference: https://help.tableau.com/current/server/en-us/refresh_extracts.htm https://help.tableau.com/current/server/en-us/refresh_extracts_add.htm

A .hyper file is an extract file that contains a snapshot of data from a data source. It is a compressed and optimized file format that can be used to improve the performance and portability of dashboards and workbooks. A .twb file is a workbook file that contains the visualization and connection information, but not the data itself. A .csv file is a comma-separated values file that contains plain text data. A .mdb file is a Microsoft Access database file that contains tables, queries, forms, and other objects.

Reference: https://help.tableau.com/current/pro/desktop/en-us/save_savework_packagedworkbooks.htm https://help.tableau.com/current/pro/desktop/en-us/extracting_data.htm https://help.tableau.com/current/pro/desktop/en-us/examples_csv.htm https://support.microsoft.com/en-us/office/introduction-to-access-database-files-9f9a0f8c-9a3c-4a0b-8e6c-6d1f1f7c2b7e

To replace a sheet on a tiled dashboard, you can simply drag the new sheet from the Sheets pane to the dashboard and drop it over the existing sheet. This will replace the old sheet with the new one and keep the same size and position. Alternatively, you can right-click on the old sheet and select Replace Data Source, then choose the new sheet from the list.

Reference: https://help.tableau.com/current/pro/desktop/en-us/dashboards_organize_floating_layoutcontainers.htm https://help.tableau.com/current/pro/desktop/en-us/dashboards_replace_datasource.htm

To find the month that had the biggest increase in average sales compared to the previous month in 2019, you need to compare the slopes of the line segments between each pair of months. The steeper the slope, the greater the increase. Based on the line chart, October had the steepest slope, meaning it had the biggest increase in average sales compared to September in 2019.

Reference: https://help.tableau.com/current/pro/desktop/en-us/buildexamples_line.htm https://www.mathsisfun.com/algebra/line-equation-slope.html

To resume a suspended alert, you need to go to the My Content area of Tableau web pages, where you can see all the alerts that you own or subscribe to. You can click on the alert name and then select Resume from the menu. You can also edit or delete the alert from there.

Reference: https://help.tableau.com/current/pro/desktop/en-us/alerts.htm https://help.tableau.com/current/pro/desktop/en-us/alerts_manage.htm

To identify which elements are floating on a dashboard, you can look for a gray border around them when you select them. Alternatively, you can open the Layout pane and see which elements have a pin icon next to them. The pin icon indicates that the element is floating and can be moved freely on the dashboard. Based on these criteria, the state filter and the color legend are floating elements on the dashboard.

Reference: https://help.tableau.com/current/pro/desktop/en-us/dashboards_organize_floating_layoutcontainers.htm https://help.tableau.com/current/pro/desktop/en-us/dashboards_create_layouts.htm

To show the corresponding region when users hover their mouse over any of the bars, you need to drag Region to Tooltip on the Marks card. This will add Region as a field in the tooltip text that appears when users hover over a mark. You can also customize the tooltip text by editing it in the Tooltip dialog box.

Reference: https://help.tableau.com/current/pro/desktop/en-us/buildmanual_shelves.htm https://help.tableau.com/current/pro/desktop/en-us/formatting_tooltips.htm

To connect a Tableau workbook to a dataset in a Microsoft Excel spreadsheet, you need to select New Data Source from the Data menu. This will open the Connect pane, where you can choose Microsoft Excel as your data source and browse for your spreadsheet file. You can then drag and drop your sheets or tables to join or union them in the data source page.

Reference: https://help.tableau.com/current/pro/desktop/en-us/connect_basic.htm https://help.tableau.com/current/pro/desktop/en-us/connect_excel.htm