Free Tableau Certified Data Analyst Exam TDA-C01 Exam Practice Test

You plan to create a visualization that has a dual axis chart. The dual axis chart will contain a shape chart and a line chart will use the same measure named Population on the axis.You need to configure be shapes to be much larger than the line.What should you do?

• Duplicate Population Drag the duplicate to the second Marks card and configure the see of the marks independently
• Create a custom shape that is larger than the default shape and add the shape to the Shapes folder in My Repository
• For the second axis select Shape on the Marks card From Select Shape Palette select Custom and then select Reset
• Change Population to a discrete dimension

You want to show the cumulative total of each year for every state.Which quick table calculation should you use?

• VTD Growth
• Running Total
• Year Over Year Growth
• YTD Total

In a dataset, you have a string field named Name that contains unnecessary semicolons.Which function should you use to remove the semicolons from the Name field?

• TRIM
• CONTAINS
• REPLACE
• SPLIT

You plan to create a Tableau subscription for several users.Which two formats can you use? Choose two.

• PDF
• Image
• Microsoft Excel
• Microsoft PowerPoint

You publish a dashboard that uses an extract. The extract refreshes every Monday at 10:00.You need to ensure that the extract also refreshes on the last day of the month at 18:00.What should you do?

• From Tableau Server, select Schedules, find the schedule of the extract, and change the frequency to the last day of the month.
• From Tableau Server, select Schedules, and change the priority of the existing schedule.
• From Tableau Server, select the workbook, select Refresh Extracts, and then add a new extract refresh.
• From Tableau Desktop, open the Publish Workbook dialog box and configure the schedule.

You have two tables named Employeelnfo and DepartmentInfo. Employeelnfo contains four fields named Full Name, Department ID, Start Date, and Salary.DepartmentInfo contains four fields named Department Name, Size, Department ID, and VP.You want to combine the tables to meet the following requirements:. Each record in Employeelnfo must be retained in the combined table.. The records must contain the Department Name, Size, and VP fields.* Every record must have a full name.Which type of join should you use?

• Inner
• Left
• Full outer
• Union

in which three formats can you export a worksheet from the Worksheet menu? Choose three

• .png
• .html
• .xlsx
• .txt
• .pptx
• .csv A) .png C) .xlsx F) .csv The Worksheet menu is a menu that appears at the top of the Tableau window when you are working on a worksheet. It contains various options and commands that you can use to work with your worksheet, such as formatting, sorting, filtering, and exporting. The Export option is a sub-menu that allows you to export your worksheet to different formats, such as image, data, or cross tab. You can access the Export option by clicking on Worksheet > Export from the menu. The .png format is an image format that you can use to export a worksheet as an image file. An image file is a file that contains a picture of your worksheet, such as a chart or a table. You can use an image file to share your worksheet with others or insert it into other documents or applications. You can export a worksheet as an image file by selecting Worksheet > Export > Image from the menu. This will open a dialog box where you can choose a file name, location, and resolution for your image. The .xlsx format is an Excel format that you can use to export a worksheet as an Excel workbook. An Excel workbook is a file that contains one or more worksheets in a spreadsheet application, such as Microsoft Excel. You can use an Excel workbook to work with your data in Excel or import it into other applications or databases. You can export a worksheet as an Excel workbook by selecting Worksheet > Export > Data from the menu. This will open a dialog box where you can choose a file name and location for your workbook. The .csv format is a comma-separated values format that you can use to export a worksheet as a text file with values separated by commas. A text file is a file that contains plain text without any formatting or graphics. You can use a text file to store or transfer your data in a simple and universal format. You can export a worksheet as a text file by selecting Worksheet > Export > Crosstab to Excel from the menu. This will open a dialog box where you can choose a file name and location for your text file. The other options are not correct for this scenario. The .html format is a web page format that you can use to export a dashboard or a story as a web page file. A web page file is a file that contains HTML code that defines the structure and content of a web page. You can use a web page file to view your dashboard or story in a web browser or embed it into other web pages or applications. However, you cannot export a worksheet as a web page file from the Worksheet menu. You have to use the Dashboard menu or the Story menu instead. The .txt format is another text format that you can use to export data as a text file with values separated by tabs. However, you cannot export data as a .txt file from the Worksheet menu. You have to use the Data Source menu instead. The .pptx format is a PowerPoint format that you can use to export one or more worksheets as PowerPoint slides. A PowerPoint slide is a page that contains graphics and text that are part of a presentation in Microsoft PowerPoint. You can use PowerPoint slides to present your worksheets to others or insert them into other presentations or documents. However, you cannot export worksheets as PowerPoint slides from the Worksheet menu. You have to use the File menu instead. Reference: https://help.tableau.com/current/pro/desktop/en-us/export.htm https://help.tableau.com/current/pro/desktop/en-us/export_image.htm https://help.tableau.com/current/pro/desktop/en-us/export_data.htm https://help.tableau.com/current/pro/desktop/en-us/export_crosstab.htm https://help.tableau.com/current/pro/desktop/en-us/export_web.htm https://help.tableau.com/current/pro/desktop/en-us/export_datasource.htm https://help.tableau.com/current/pro/desktop/en-us/export_powerpoint.htm

You have a Tableau workbook that contain three worksheets named Sheet1 Sheet2 and Sheet3.You create several filters.From the Data Source page you plan to add data source fillersWhen type of filter will appear in the Edit Data Source Filters dialog box?

• A table calculation filter used on Sheet
• A top N condition filer on a dimension in Sheet 1 and Sheet2
• A context filler on a dimension m Sheet3
• A dimension filter on all the sheets

You have the following: Overall Rank and Rank are calculated fields that use the RANK function.You filter out the sub-category where [Ovorall Rank] - 1.For which three the sub-categories will the value of Rank change? Choose three.

• Furnishings
• Tables
• Chairs
• Accessories
• Copiers
• Machines G Phones
• Bookcases

You create a parameter named Choose Region fiat contains values from a field named Region.You want users to be able to use the Choose Region parameter to interact with a chart by logging between different regionsWhat should you do next?

• Add Region to me Fitters card
• Add the [Region] = [choose Region) formula to the Filters card
• Add the Choose Region parameter to the Pages card
• Set the Choose Region parameter to Single Value (list)