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

You are the owner of an alert.You receive an email notification that the alert was suspendedFrom where can you resume the suspended alert?

• The Data Source page of Tableau Desktop
• The Notification area of Tableau Prep
• The My Content area of Tableau web pages
• The Shared with Ma page

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 want to add a comment to March 2020 as shown in the following visualization.You have the following sets in a Tableau workbook* Top N Customers* Customers of 2020* Top N Products* Sellers of 2020Which two sets can you combine? Choose two

• Sellers of 2020
• Customers of 2020
• Top N Products
• Top N Customers

You create a worksheet named Sales by Region and hide the tide of the worksheet. You print the worksheet as a PDF and notice that the worksheet title appears. You need to prevent the title from appearing when you print the worksheet as a PDF. Which settings should configure from the File menu in Tableau Desktop?

• Page Setup
• Print
• Export As PowerPoint
• Share
• Export As Version

You need to change the values of a dimension without creating a new field.What should you do?

• Rename the fields
• Create aliases
• Create groups
• Transforms the fields

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 want to connect a Tableau workbook to a dataset in a Microsoft Excel spreadsheet.What should you do from Tableau Desktop?

• From the Data menu select New Data Source
• From the Data menu select Replace Data Source
• From the File menu select Import Workbook
• From the File menu select New

You have a dashboard that contains a parameter named Start Date.You need to create an extract from a Microsoft Excel file. The extract must be filtered based on Start Date.What should you do?

• Create a data source based on the Excel worksheet and create a calculated field based on Start Date. Add the calculated field to the extract filter.
• Create a custom SOL query to define the data source and create a calculated field based on Start Date. Add the calculated field to the extract filter.
• Create a custom SOL query that references Stan Date in the WHERE clause.
• Create a data source based on the Excel worksheet and create a calculated field based on Start Date. From the Data pane, add the calculated field to the data source filter

You have a workbook that connects to a database. The database requires authentication.You plan to publish the workbook and schedule a daily refresh of the data.Which two conditions must be met to schedule the refresh? Choose two.

• The credentials must be embedded.
• The data source must be stored as a hyper file.
• The data source must use a live connection.
• The data must be extracted.

From Tableau Desktop you sign in lo a Tableau Server site.What appears in the list of available data sources when you search for a published data source?

• All the data sources published to the site
• All the data sources published to the Tableau Server
• All the data sources published to the site within the folders to which you have access
• All the data sources published to the Tableau Server within the folders to which you have access