Prepare TDA-C01 Exam Questions [2024] Recently Updated Questions
Give push to your success with TDA-C01 exam questions
Tableau TDA-C01, also known as Tableau Certified Data Analyst, is an industry-recognized certification exam offered by Tableau. TDA-C01 exam is designed to test the skills and knowledge of individuals who want to demonstrate their proficiency in using Tableau for data analysis. Tableau Certified Data Analyst certification is recognized globally and is a testament to an individual's ability to extract insights from data using Tableau's tools and functions.
Tableau TDA-C01 Certification Exam is a rigorous and comprehensive certification program for professionals who want to validate their skills in data analysis and visualization using the Tableau platform. Tableau Certified Data Analyst certification exam covers a wide range of topics and requires candidates to have a good understanding of data analysis concepts, data visualization best practices, and the Tableau platform. Tableau Certified Data Analyst certification is a valuable credential for professionals who want to advance their careers in data analysis and visualization and can provide a competitive edge in the job market.
NEW QUESTION # 40
You have the following chart that shows the cumulative of sales from various dates.
You want the months to appear as shown in the following chart.
What should you do?
- A. Convert the date to Exact Date
- B. Convert the date to Attribute
- C. Convert the date to Continuous
- D. Select Show Misting Values for the dale
Answer: A
Explanation:
To make the months appear as shown in the second chart, you need to convert the date to Continuous. A continuous date is a green pill that shows a range of values on an axis. A discrete date is a blue pill that shows individual values as headers. In this case, you want to show a continuous range of months on the x-axis, instead of discrete headers.
To convert the date to Continuous, you need to do the following steps:
Right-click on the date field on the Columns shelf and select Convert to Continuous from the menu. This will change the date pill from blue to green and show a continuous range of dates on the x-axis.
Right-click on the date field again and select Month (January 2017) from the menu. This will change the level of detail of the date to month and year, instead of day.
Optionally, you can format the date axis by right-clicking on it and selecting Format from the menu. You can change the scale, tick marks, labels, and other options.
The other options are not correct for this scenario. Converting the date to Exact Date will show every single date as a header, which will be too crowded and unreadable. Selecting Show Missing Values for the date will fill in any gaps in the data with null values, but it will not change how the months appear. Converting the date to Attribute will return only one value for each partition of data, which will not show any variation over time. Reference: https://help.tableau.com/current/pro/desktop/en-us/dates.htm https://help.tableau.com/current/pro/desktop/en-us/dates_continuous.htm https://help.tableau.com/current/pro/desktop/en-us/formatting.htm
NEW QUESTION # 41
in which three formats can you export a worksheet from the Worksheet menu? Choose three
- A. .pptx
- B. .csv
- C. .html
- D. .txt
- E. .xlsx
- F. .png
Answer: B,E,F
Explanation:
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 Explanation:
The three formats that you can export a worksheet from the Worksheet menu are:
NEW QUESTION # 42
You have the following chart that shows profits and discounts over time.
You need to combine the lines to appear as shown in the following chart.
What should you do?
- A. Convert Discount to Discrete
- B. Set Discount to Dual Axis
- C. Drag Discount to Color on the Marks card
- D. Drag Discount to the Columns shelf
Answer: B
Explanation:
To combine the lines to appear as shown in the second chart, you should set Discount to Dual Axis. Dual Axis is a feature that allows you to show two measures on two separate axes on one chart. You can create a dual axis by right-clicking on a measure on any shelf and selecting Dual Axis from the menu. This will create two axes on one chart and synchronize their scales.
In this case, you want to show Profit and Discount on two separate axes on one chart. You can right-click on Discount on any shelf and select Dual Axis from the menu. This will create a dual axis chart that shows Profit and Discount as two lines with different colors.
The other options are not correct for this scenario. Dragging Discount to Color on the Marks card will change the color of Profit based on Discount, but it will not show two lines. Converting Discount to Discrete will change Discount from a green pill to a blue pill, but it will not affect how it appears on the chart. Dragging Discount to Columns shelf will create two separate charts for Profit and Discount, but it will not combine them. Reference: https://help.tableau.com/current/pro/desktop/en-us/multiplemeasures.htm https://help.tableau.com/current/pro/desktop/en-us/multiplemeasures_dualaxes.htm
NEW QUESTION # 43
You have the following dashboard that contains two visualizations.
You want to show only visualization at time. Users must be able to switch between visualizations.
What should you me?
- A. Worksheet actions
- B. Dashboard actions
- C. A parameter and a calculated filed
- D. Showhide buttons
Answer: D
Explanation:
Showhide buttons are a feature that allows you to show or hide a layout container on a dashboard. You can use showhide buttons to create a toggle effect that switches between two visualizations. You need to place each visualization in a separate layout container and then add a showhide button for each container. You can customize the appearance and behavior of the buttons to suit your needs. 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_showhide.htm
NEW QUESTION # 44
You have a dataset that has four fields named Category. Profit Sates and Customer Name. You need to create the following visualization.
Answer:
Explanation:
Explanation:
Sales: B. Columns
Profit: D. Rows
Customer Name: C. Detail on the Marks card
Category: A. Color on the Marks card
To create the visualization, you need to drag Sales to Columns, Profit to Rows, Customer Name to Detail on the Marks card, and Category to Color on the Marks card. This will create a scatter plot that shows the relationship between Sales and Profit for each Customer Name, with different colors for each Category.
References: https://help.tableau.com/current/pro/desktop/en-us/buildmanual_shelves.htm
https://help.tableau.com/current/pro/desktop/en-us/buildexamples_scatter.htm
NEW QUESTION # 45
Open the link to Book1 found on the desktop. Open the Movie Durations worksheet.
Replace the existing data source with the Netflix_2019 data source.
Answer:
Explanation:
Send us your feedback on it
NEW QUESTION # 46
You want to create the following table in a view.
Which function should you use to create the Position column?
- A. FIRST
- B. RANK
- C. LAST
- D. INDKX
Answer: A
Explanation:
To create the Position column, you should use the FIRST () function. The FIRST () function returns the number of rows from the current row to the first row in the partition. For example, the first row in a partition will return 0, the second row will return -1, and so on. In this question, the partition is defined by the Segment field, and the table is sorted by the Sales field in descending order. Therefore, the Position column shows the offset of each row from the first row in each segment, based on the sales ranking. References:
Tableau Certified Data Analyst Exam Prep Guide, page 11, section "Creating Calculated Fields" Tableau Help: FIRST Function
NEW QUESTION # 47
You have the following data source in tableau Server.
You need to ensure that the data is updated every hour.
What should you select?
- A. New
- B. Connections
- C. Extract Refreshes
- D. Connected Workbooks
Answer: C
NEW QUESTION # 48
You have the following two datasets:
* A Microsoft Excel worksheet that has two columns named Employee Name and Department
* A Microsoft SQL Server table that has three columns named Employee Name. Pay Grade and Team Size.
You want to use Tableau Prep to join the two datasets.
Which three actions should you perform m order? (Place the three correct options in order.)
Answer:
Explanation:
1 - Specify Employee Name as the join key
2 - Open both data sources in Tableau Desktop
3 - Join both datasets and select the join type
NEW QUESTION # 49
You have the following dataset:
You want to create a parameter to dynamically filter the data to produce the following results.
Which two types of parameters can you use to produce the results? Choose two.
- A. Date
- B. String
- C. Boolean
- D. Integer
- E. Datetime
- F. Float
Answer: B,D
Explanation:
In the context of filtering data in Tableau, both string and integer parameters can be used to dynamically filter data. A string parameter can be used to filter text-based values, while an integer parameter is suitable for numerical values. In the provided dataset and result URLs, it appears that a unique identifier or key (which could be a string or integer) is being used to filter specific data entries. References: The information is based on the following sources:
An Introduction to Parameters in Tableau
Create Parameters - Tableau
NEW QUESTION # 50
You have the following dataset that contain null values in the Profits field.
You want the data to appear as shown in the following table.
Which two formulas achieve the goal? Choose two.
- A. IFNULL [(profits] ,0)
- B. IF [Profits] != null then [Profits] END
- C. ZN ([Profits])
- D. ISNULL ([Profits])
Answer: A,C
Explanation:
Both the ZN and IFNULL functions in Tableau can be used to replace NULL values with zeros. The ZN function converts NULL to zero directly, while the IFNULL function allows you to specify that NULL should be replaced with zero. Both will result in showing zero for any NULL values in the Profits field.
References: https://help.tableau.com/current/pro/desktop/en-us/functions_functions_logical.htm#IFNULL
https://help.tableau.com/current/pro/desktop/en-us/functions_functions_logical.htm#IF
https://help.tableau.com/current/pro/desktop/en-us/functions_functions_logical.htm#ZN
https://help.tableau.com/current/pro/desktop/en-us/functions_functions_logical.htm#ISNULL
NEW QUESTION # 51
Open the link to Book1 found on the desktop. Open the Movie Durations worksheet.
Replace the existing data source with the Netflix_2019 data source.
Answer:
Explanation:
check the steps below in explanation.
Explanation:
To replace the existing data source with the Netflix_2019 data source, you need to do the following steps:
Open the link to Book1 found on the desktop. This will open the Tableau workbook that contains the Movie Durations worksheet.
Click on the Movie Durations tab at the bottom of the workbook to open the worksheet. You will see a bar chart that shows the number of movies by duration for the existing data source.
Go to the Data Source tab at the bottom of the workbook to see the data source page. You will see a table that shows the fields and values from the existing data source.
Click on the drop-down arrow next to the data source name at the top of the page and select Replace Data Source from the menu. This will open a dialog box that allows you to replace your data source with another one.
Select Netflix_2019 from the list of available data sources and click OK. This will replace your existing data source with the Netflix_2019 data source and update your worksheet accordingly. You may need to fix any broken fields or calculations that result from the replacement.
References: https://help.tableau.com/current/pro/desktop/en-us/datasource_replace.htm
https://help.tableau.com/current/pro/desktop/en-us/datasource_replace_workbook.htm
NEW QUESTION # 52
You are the owner of an alert.
You receive an email notification that the alert was suspended From where can you resume the suspended alert?
- A. The Shared with Ma page
- B. The Data Source page of Tableau Desktop
- C. The Notification area of Tableau Prep
- D. The My Content area of Tableau web pages
Answer: A
NEW QUESTION # 53
You have the following two tables.
Table A is the primary table.
Which type of join is established when a blend is created by using the join key of Category?
- A. Left join
- B. Outer join
- C. Inner join
- D. Right join
Answer: A
NEW QUESTION # 54
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.
- A. The data source must be stored as a hyper file.
- B. The data must be extracted.
- C. The data source must use a live connection.
- D. The credentials must be embedded.
Answer: B,D
Explanation:
To schedule a refresh of the data, you need to ensure that Tableau Server or Tableau Online can access the database without prompting for credentials. This can be done by embedding the credentials in the workbook or the published data source. You also need to extract the data from the database and publish it as a separate data source or as part of the workbook. A live connection would not allow you to refresh the data on a schedule, as it would always query the database directly. A hyper file is a format for storing extracted data, but it is not a requirement for scheduling a refresh. References:
Tableau Certified Data Analyst Exam Prep Guide, page 10, section "Publishing and Scheduling Data Refreshes" Tableau Help: Embedding Database Credentials Tableau Help: Extract Your Data
NEW QUESTION # 55
You have the following tiled dashboard that has one sheet.
You want to replace fit sheet with Sheet2.
What should you do?
- A. Drag Sheet2 to the dashboard.
- B. From the context menu of Sheet3. select Remove Dashboard item
- C. Right-click Sheet2 and select Add to Dashboard.
- D. Select Sheets and click the Swap Sheet button next to Sheet2.
- E. From the context menu of Sheet3. select Deselect
Answer: C
NEW QUESTION # 56
You have the following dashboard.
When a user selects a only on the map the data on the bar chart must show only the data for the selected city.
The data in the bar chart must change only when the user selects a different city How should you configure the dashboard action? (Use the dropdowns in the Answers Area to select the correct options.)
Answer:
Explanation:
Explanation:
To configure the dashboard action, you should select Filter as the action type, Select as the run action on option, and All Fields as the target filters option. This will ensure that when a user selects a city on the map, the bar chart will show only the data for the selected city based on all fields in common between the two worksheets. The action will run only when the user selects a different city. References:
https://help.tableau.com/current/pro/desktop/en-us/actions.htm
https://help.tableau.com/current/pro/desktop/en-us/actions_filter.htm
NEW QUESTION # 57
You have a database that includes field named sales, City and Region.
You have the following chart that shows the number of sales made in different cities.
You want to dynamically show the corresponding region when users hover their mouse over any of the bars.
What should you do?
- A. Drag Region to Tooltip on the Marks card
- B. Edit the aliases for City.
- C. Right-click a bar in the chart select Mark Label and then select Always show.
- D. Right-click a in the chat, select Annotate and then select Mark.
Answer: D
NEW QUESTION # 58
You have the following line chart that shows the average sales by month.
Which month had the biggest increase in swage sales compared to me previous month in 2019?
- A. November
- B. October
- C. December
- D. August
Answer: B
NEW QUESTION # 59
You have the following box plot that shows the distribution of average profits made in every state by region.
Which region has the smallest distribution of profits?
- A. West
- B. Cast
- C. South
- D. Central
Answer: C
Explanation:
The box plot visualization displays the distribution of average profits by region. The distribution of profits is represented by the range of the box (interquartile range) and the whiskers (which often represent the total range excluding outliers). From the image provided, the South region has the smallest visible range within its box and the shortest whiskers, indicating the smallest distribution of average profits among the choices provided.
NEW QUESTION # 60
You are subscribed to several views.
You need to unsubscribe from the views.
What should you use?
- A. The Notifications area of Tableau Prep
- B. The Data Source page of Tableau Desktop
- C. The My Content area of Tableau web pages
- D. The Shared with Me page
Answer: C
Explanation:
To unsubscribe from the views, you should use the My Content area of Tableau web pages. This area allows you to manage your subscriptions, as well as your workbooks, views, and data sources. You can select the views you want to unsubscribe from, click Actions, and then click Unsubscribe. You can also change the subscription options, such as the schedule, the format, or the message. Reference:
Create a Subscription to a View or Workbook - Tableau
Tableau Certified Data Analyst Study Guide
NEW QUESTION # 61
You have the following line chart that shows the average sales by month.
Which month had the biggest increase in swage sales compared to me previous month in 2019?
- A. November
- B. December
- C. October
- D. August
Answer: A
Explanation:
Based on the line chart provided, each point on the line chart represents the average sales for a given month, and the percentage values indicate the change in average sales compared to the previous month. The month of November shows a significant increase from the month of October, indicated by a large upward spike on the chart and a high percentage increase.
NEW QUESTION # 62
You have the following visualization.
Answer:
Explanation:
Explanation:
NEW QUESTION # 63
You want to create the following table in a view.
Which function should you use to create the Position column?
- A. FIRST
- B. RANK
- C. LAST
- D. INDKX
Answer: A
Explanation:
To create the Position column, you should use the FIRST () function. The FIRST () function returns the number of rows from the current row to the first row in the partition. For example, the first row in a partition will return 0, the second row will return -1, and so on. In this question, the partition is defined by the Segment field, and the table is sorted by the Sales field in descending order. Therefore, the Position column shows the offset of each row from the first row in each segment, based on the sales ranking. Reference:
Tableau Certified Data Analyst Exam Prep Guide, page 11, section "Creating Calculated Fields" Tableau Help: FIRST Function
NEW QUESTION # 64
You have the following dataset.
Yon need to calculate the ranking shown in the Rank field.
How should you complete the formula? (Use the dropdowns in the Answer Area to select the correct options to complete the formula ?
Answer:
Explanation:
NEW QUESTION # 65
......
Tableau TDA-C01 certification is a valuable credential for individuals who want to advance their careers in data analysis. It demonstrates to employers that the candidate has a deep understanding of Tableau software and the skills necessary to use it to solve complex business problems. Additionally, the certification can help individuals stand out in a competitive job market and increase their earning potential.
Get TDA-C01 Actual Free Exam Q&As to Prepare Certification: https://www.passsureexam.com/TDA-C01-pass4sure-exam-dumps.html
TDA-C01 100% Guarantee Download TDA-C01 Exam PDF Q&A: https://drive.google.com/open?id=1UZDRz4AOHmGZixUEfB4BWsrT2-OgTJFR