Apr 02, 2024 Updated TDA-C01 Dumps Questions For Tableau Exam
Best Value Available Preparation Guide for TDA-C01 Exam
Tableau TDA-C01: Tableau Certified Data Analyst exam is a certification exam that evaluates an individual's ability to use Tableau to analyze data and create visualizations. It is designed to test a candidate's skills and knowledge in using Tableau Desktop, Tableau Prep, and Tableau Server to connect, transform, and analyze data.
NEW QUESTION # 30
You have the following dataset.
You plan to create a dashboard that will be filtered to show only data that is relevant to a specific Tableau user based on the Tableau_User_Name field You need to create a boolean calculated field to place on the data source finer Which formula should you use for the filter?
- A. USERNAME()=(Tableau_USER_NAME)
- B. ISFULLNAMETableu_USER_NAME))=USERNAME()
- C. NAME Tableau-USER-NAME)
- D. NAMEUSERNAME()
Answer: A
Explanation:
To create a boolean calculated field to place on the data source filter, you should use the formula USERNAME() = [Tableau_user]. This formula will return TRUE if the current Tableau user name matches the value in the Tableau_user field, and FALSE otherwise. You can use this formula as a data source filter by dragging it to the Filters shelf and selecting TRUE from the menu. This will filter the data to show only the rows that are relevant to the specific Tableau user.
The other options are not correct for this scenario. NAME([Tableau_user]) is not a valid function in Tableau. ISFULLNAME([Tableau_user]) = USERNAME() is not a valid expression in Tableau. 'S' + STR([Sales]/1000) is not a boolean expression, but a string expression that converts sales to thousands with a prefix of "S". Reference: https://help.tableau.com/current/pro/desktop/en-us/filtering_datasource.htm https://help.tableau.com/current/pro/desktop/en-us/functions_functions_logical.htm#USERNAME https://help.tableau.com/current/pro/desktop/en-us/calculations_calculatedfields.htm
NEW QUESTION # 31
Open the link to Book1 found on the desktop. Open the sales dashboard.
Add the Sales by State sheet in a Show/Hide button to the right side of the dashboard.
- A. Send us your feedback on it.
- B. Send us your
Answer: A
NEW QUESTION # 32
You need to change the values of a dimension without creating a new field.
What should you do?
- A. Transforms the fields
- B. Rename the fields
- C. Create groups
- D. Create aliases
Answer: D
Explanation:
You can create aliases for the members of a dimension by right-clicking the dimension in the Data pane or in the view and selecting Aliases. This changes how the values are displayed in the view, but not the underlying data. For example, you can create an alias for "Central" as "Midwest".
NEW QUESTION # 33
You conned to a Microsoft SQL Server database
You need to create a custom SQL query that retrieves rows from a table named Students Only students m the city of Berlin must be returned How should you complete the query? (Drag the appropriate Options to the Answer Area and drop into the correct locations.)
Answer:
Explanation:
NEW QUESTION # 34
You have the following visualization.
The Last() calculation is set to compute using Table (across)
Which value will appear in the crosstab for the Consumer segment of the year 2018 if you change compute to use Oder Dale?
- A. 0
- B. 1
- C. 2
- D. 3
Answer: C
NEW QUESTION # 35
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''
Answer:
Explanation:
NEW QUESTION # 36
You have the following dataset in Microsoft Excel.
You are using interpreter to cleans the dataset. Data interpreter provides the following results.
How many rows of data will be ingested into Tableau as values?
- A. 0
- B. 1
- C. 2
- D. 3
Answer: B
Explanation:
Data interpreter is a feature that helps you clean and structure your data in Excel before importing it into Tableau. It detects and removes any headers, footers, subtotals, or other elements that are not part of the actual data. It also splits any merged cells and fills in any missing values. In this case, data interpreter provides the following results:
It removes the first three rows and the last two rows that contain headers and footers.
It splits the merged cells in column A and fills in the missing values with "Fiction" or "Non-Fiction".
It does not remove or change any other rows or cells.
Therefore, the number of rows of data that will be ingested into Tableau as values is 17, which is the number of rows left after removing the headers and footers. Reference: https://help.tableau.com/current/pro/desktop/en-us/importing_cleaning_up_data.htm https://help.tableau.com/current/pro/desktop/en-us/importing_data_interpreter.htm
NEW QUESTION # 37
You have two data sources that use the same schema One data source contains order data from 2019 and the other data source contains order data from 2020.
You have a worksheet that shows the orders from 2019.
You need to configure the worksheet to show the orders from 2020 without reloading the data.
Which option should you select?
Answer:
Explanation:
Explanation:
Replace Data Source
Replace Data Source is a feature that allows you to replace one data source with another one that has the same or similar fields and structure. It updates all the worksheets that use the original data source with the new one, without reloading the data. In this case, you want to replace the data source that contains order data from 2019 with the one that contains order data from 2020.
To replace the data source, you need to do the following steps:
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 original 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 the data source that contains order data from 2020 from the list of available data sources and click OK. This will replace your original data source with the new one 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 # 38
Open the link to Book1 found on the desktop. Open the sales dashboard.
Add the Sales by State sheet in a Show/Hide button to the right side of the dashboard.
Answer:
Explanation:
check the steps below in explanation.
Explanation:
To add the Sales by State sheet in a Show/Hide button to the right side of the dashboard, 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 sales dashboard.
Click on the sales dashboard tab at the bottom of the workbook to open the dashboard. You will see a dashboard that shows various charts and filters related to sales data.
Drag Sales by State from the Sheets pane to the right side of the dashboard. This will add the sheet as a floating element on the dashboard. You can resize and position it as you like.
Right-click on Sales by State and select Add Show/Hide Button from the menu. This will add a button that allows you to show or hide the sheet on the dashboard. You can customize the appearance and behavior of the button by clicking on it and using the options on the Marks card.
Optionally, you can drag a vertical layout container from the Objects pane to the right side of the dashboard and place Sales by State and its button inside it. This will help you organize your dashboard elements and align them neatly.
References: https://help.tableau.com/current/pro/desktop/en-us/dashboards.htm
https://help.tableau.com/current/pro/desktop/en-us/dashboards_showhide.htm
https://help.tableau.com/current/pro/desktop/en-us/dashboards_create_layouts.htm
NEW QUESTION # 39
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 2020
Which two sets can you combine? Choose two
- A. Sellers of 2020
- B. Customers of 2020
- C. Top N Products
- D. Top N Customers
Answer: B,D
Explanation:
To combine two sets, they must have at least one dimension in common. In this case, Customers of 2020 and Top N Customers both have Customer Name as a dimension, so they can be combined using set operations such as union, intersection, or difference. Sellers of 2020 and Top N Products have different dimensions (Seller Name and Product Name), so they cannot be combined. Reference: https://help.tableau.com/current/pro/desktop/en-us/sets.htm https://help.tableau.com/current/pro/desktop/en-us/sets_create.htm#combine-sets
NEW QUESTION # 40
You have a data set that contains three columns named Sales, Profit, and Quantity.
You need to build the following scatter plot.
Answer:
Explanation:
Explanation:
To build the scatter plot shown in the image, you need to place the Profit measure on the Rows shelf and the Sales measure on the Columns shelf. This will create a Cartesian chart with Profit as the y-axis and Sales as the x-axis. Then, you need to change the mark type to Circle on the Marks card. This will display the data points as circles that vary in size according to the Quantity measure. You can also add color or shape encoding to the marks to show additional dimensions or measures in the view. References:
Build a Scatter Plot
Understanding and Using Scatter Plots
Scatter plot in Tableau
NEW QUESTION # 41
Open the link to Book1 found on the desktop. Open the CategoryPercentage worksheet.
Modify the bar chart show the percentage of sales for each Subcategory within every Category. The total percentage for every Category must be 100%.
- A. Send us your feedback on it.
- B. Send us your
Answer: A
NEW QUESTION # 42
Open the link to Book1 found on the desktop. Open SalesVSProfit worksheet.
Add a distribution band on Profit to show the standard deviation from- 1 to 1.
- A. check the steps below in explanation
Answer: A
Explanation:
To add a distribution band on Profit to show the standard deviation from -1 to 1, 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 SalesVSProfit worksheet.
Click on the SalesVSProfit tab at the bottom of the workbook to open the worksheet. You will see a scatter plot that shows the relationship between Sales and Profit for each Sub-Category.
Click on the Analytics tab on the left side of the workbook to open the Analytics pane. You will see a list of analytical objects that you can drag and drop onto your worksheet.
Drag Distribution Band from the Analytics pane to Profit on the Rows shelf. This will add a distribution band on Profit that shows the average and confidence interval for each Sub-Category.
Click on the Edit button on the distribution band to open the Edit Distribution Band dialog box. You will see options to customize your distribution band.
Change the Band From value to -1 and the Band To value to 1. This will change the distribution band to show the standard deviation from -1 to 1, which means one standard deviation below and above the average.
Click OK to apply the changes. You will see that the distribution band now shows a narrower range of values for Profit.
NEW QUESTION # 43
You have the following visualization.
Answer:
Explanation:
NEW QUESTION # 44
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 # 45
Open the link to Book1 found on the desktop. Use the Superstore data source.
Split the Customer Name field into two fields named First Name and Last Name.
Answer:
Explanation:
Send us your feedback on it
NEW QUESTION # 46
......
Tableau TDA-C01 (Tableau Certified Data Analyst) Certification Exam is a globally recognized certification that demonstrates one's ability to analyze and visualize data using Tableau software. Tableau Certified Data Analyst certification is designed for data analysts who want to enhance their skills in data analysis, data visualization, and data storytelling. The TDA-C01 exam is administered by Tableau and is intended to validate the candidate's proficiency in using Tableau Desktop and Tableau Prep Builder to connect, clean, analyze, and visualize data.
Full TDA-C01 Practice Test and 100 Unique Questions, Get it Now!: https://exam-labs.exam4tests.com/TDA-C01-pdf-braindumps.html