Quality TDA-C01 PDF Dumps - TDA-C01 Exam Questions
Most UptoDate Tableau TDA-C01 Exam Dumps PDF 2024
Tableau TDA-C01 certification exam is designed for individuals who want to demonstrate their proficiency in using Tableau for data analysis. Tableau Certified Data Analyst certification is ideal for data analysts, business analysts, and other professionals who work with data and want to enhance their skills in manipulating data, creating visualizations, and communicating insights effectively. Tableau Certified Data Analyst certification is recognized globally and is highly valued by employers.
NEW QUESTION # 33
You have the following dataset.
Which Level of Detail (LOD) expression should you use to calculate tie grand total of all the regions?
- A. {FIXED: TOTAL (Sales)}
- B. {FIXED: [Region] SUM Sales}
- C. {Fixed: [Region]: TOTAL Sales}
- D. {FIXED: SUM Sales}
Answer: C
NEW QUESTION # 34
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. December
- B. November
- C. August
- D. October
Answer: B
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 # 35
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. Select Show Misting Values for the dale
- B. Convert the date to Attribute
- C. Convert the date to Exact Date
- D. Convert the date to Continuous
Answer: D
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 # 36
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?
- A. From Tableau Server, select Schedules, find the schedule of the extract, and change the frequency to the last day of the month.
- B. From Tableau Server, select the workbook, select Refresh Extracts, and then add a new extract refresh.
- C. From Tableau Desktop, open the Publish Workbook dialog box and configure the schedule.
- D. From Tableau Server, select Schedules, and change the priority of the existing schedule.
Answer: B
Explanation:
To ensure that the extract also refreshes on the last day of the month at 18:00, you need to add a new extract refresh task to the workbook on Tableau Server. You can do this by selecting the workbook, selecting Refresh Extracts, and then choosing Schedule a Refresh. You can then select an existing schedule that matches your desired frequency and time, or create a new schedule with a custom frequency and time. This will add a new extract refresh task to the workbook, in addition to the existing one that refreshes every Monday at 10:00. You can also modify or delete the extract refresh tasks as needed. References:
Tableau Certified Data Analyst Exam Prep Guide, page 10, section "Publishing and Scheduling Data Refreshes" Tableau Help: Refresh Data on a Schedule Tableau Help: Manage Refresh Tasks
NEW QUESTION # 37
You want to create the following dashboard.
The dashboard will contain two sheets that will connect to the same data source. The top sheet will be configured to filter the bottom sheet.
When you click a category on the top sheet, the sheets must resize as shown in the following exhibit.
How should you lay out the objects on the dashboard?
- A. Drag a horizontal container to the dashboard and add both sheets to the container. Set the Fit to Standard.
- B. Drag a blank object to the dashboard and add both sheets to the dashboard. Set Fit to Entire view.
- C. Drag a vertical container to the dashboard and add both sheets to the container. Set Fit to Entire view.
- D. Add both sheets to the dashboard. Set Fit to Fix width.
Answer: C
Explanation:
To create the dashboard as shown in the image, you need to use a vertical layout container that will adjust the height of the sheets according to the window size. You also need to set the Fit to Entire view option for both sheets so that they will resize proportionally when you click a category on the top sheet. This way, you can achieve the desired effect of having the bottom sheet expand to fill the space left by the top sheet when it filters out some categories. Reference:
Size and Lay Out Your Dashboard - Tableau
Create a Dashboard - Tableau
Format Dashboard Layout in Tableau - GeeksforGeeks
NEW QUESTION # 38
You have the following tiled dashboard that has one sheet.
You want to replace the sheet with Sheet2.
What should you do?
- A. From the context menu of Sheet3. select Remove Dashboard item
- B. From the context menu of Sheet3. select Deselect
- C. Drag Sheet2 to the dashboard.
- D. Select Sheet3 and click the Swap Sheet button next to Sheet2.
- E. Right-click Sheet2 and select Add to Dashboard.
Answer: C
Explanation:
In Tableau, to replace a sheet on a dashboard, you can simply drag the desired sheet (Sheet2 in this case) from the sheets list onto the dashboard area where the current sheet (Sheet3) resides. This action will replace the existing sheet with the new one. Right-clicking and adding to the dashboard adds an additional sheet rather than replacing, and the context menu options mentioned in the other choices are not the standard methods for replacing sheets within a dashboard.
NEW QUESTION # 39
Open the link to Book1 found on the desktop. Open the Histogram worksheet and use the Superstone data source.
Create a histogram on the Quantity field by using bin size of 3.
- A. Send us your feedback on it.
- B. Send us your
Answer: A
NEW QUESTION # 40
You want to add a draft watermark to a dashboard as shown in the following exhibit.
Which type of object should you use?
- A. Horizontal
- B. Image
- C. Sheet
- D. Web page
Answer: D
NEW QUESTION # 41
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.
Answer:
Explanation:
check the steps below in explanation
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 # 42
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. Select Show Misting Values for the dale
- B. Convert the date to Attribute
- C. Convert the date to Exact Date
- D. Convert the date to Continuous
Answer: D
NEW QUESTION # 43
You have a dataset that has four fields named Category. Profit Sates and Customer Name. You need to create the following visualization.
Answer:
Explanation:
NEW QUESTION # 44
You publish a dashboard tut uses an attract. 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?
- A. From Tableau Server. select Schedules find the schedule of the extract, and change the frequency to the Last day of the month
- B. From Tableau Desktop, open the Publish Workbook dialog box and configure the schedule.
- C. From Tableau Server select the workbook select Refresh Extracts and then add a new extract refresh
- D. From Tableau Server. select Schedules and change the priority of the existing schedule
Answer: C
Explanation:
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
NEW QUESTION # 45
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 regions What should you do next?
- A. Set the Choose Region parameter to Single Value (list)
- B. Add the Choose Region parameter to the Pages card
- C. Add Region to me Fitters card
- D. Add the [Region] = [choose Region) formula to the Filters card
Answer: D
Explanation:
To use the Choose Region parameter to interact with a chart by toggling between different regions, you should add the [Region] = [Choose Region] formula to the Filters card. This formula will create a boolean filter that returns TRUE if the value in the Region field matches the value in the Choose Region parameter, and FALSE otherwise. You can add this formula to the Filters card by right-clicking on it and selecting Add Filter from the menu. Then you can select Condition from the dialog box and enter the formula in the text box. This will filter the chart to show only the data for the selected region.
The other options are not correct for this scenario. Adding Region to the Filters card will create a categorical filter that shows a list of values from the Region field, but it will not use the Choose Region parameter. Adding the Choose Region parameter to the Pages card will create a page control that allows you to cycle through different values of the parameter, but it will not filter the chart. Setting the Choose Region parameter to Single Value (list) will change how the parameter control appears on the worksheet, but it will not affect how it interacts with the chart. Reference: https://help.tableau.com/current/pro/desktop/en-us/parameters.htm https://help.tableau.com/current/pro/desktop/en-us/filtering.htm https://help.tableau.com/current/pro/desktop/en-us/filtering_condition.htm
NEW QUESTION # 46
You have a data source that contains the following columns.
You want to sort customers based on the most expensive orders.
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 # 47
You have the following visualization.
Answer:
Explanation:
NEW QUESTION # 48
You want to connect a Tableau workbook to a dataset in a Microsoft Excel spreadsheet.
What should you do from Tableau Desktop?
- A. From the File menu select New
- B. From the Data menu select New Data Source
- C. From the File menu select Import Workbook
- D. From the Data menu select Replace Data Source
Answer: B
NEW QUESTION # 49
You have a sales dataset that contains the following fields.
You need to analyze the average revenue per product in different regions over time.
Which two fields should be measures? Choose two.
- A. Revenue
- B. Customer Region
- C. Quantity
- D. Order Date
- E. Product Name
Answer: A,C
Explanation:
To analyze the average revenue per product in different regions over time, you need to use two fields that contain numeric, quantitative values that you can measure and aggregate. Quantity and Revenue are both measures that fit this criterion. You can multiply Quantity and Revenue to get the total sales for each product, and then divide by the number of products to get the average revenue. You can also use these measures to create charts and tables that show the trends and comparisons over time and across regions. References:
Dimensions and Measures, Blue and Green - Tableau
Tableau Certified Data Analyst Study Guide
NEW QUESTION # 50
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 # 51
You have a dataset that contains people and the awards they have won.
Which formula should you use to get the number of different types of awards that have been won?
- A. COUNTD {(NAME])
- B. COVAR({Award})
- C. INDEX()
- D. MAX {(Award})
- E. COUNTD({Award})
Answer: E
Explanation:
To get the number of different types of awards that have been won, you should use the formula COUNTD({Award}). This formula will return the count of distinct values in the Award field, which are the different types of awards that have been won.
The other options are not correct for this scenario. COVAR({Award}) is not a valid function in Tableau.
MAX({Award}) will return the maximum value in the Award field, which may not be a type of award.
INDEX() will return the index or rank of each row in a partition, which is not related to the types of awards.
References: https://help.tableau.com/current/pro/desktop/en-us/functions_functions_aggregate.htm#COUNTD
https://help.tableau.com/current/pro/desktop/en-us/functions_functions_tablecalculation.htm#INDEX The COUNTD function in Tableau calculates the number of distinct (unique) items in a field. When looking to get the number of different types of awards that have been won, the COUNTD([Award]) function will count each unique award name only once, regardless of how many times it appears in the dataset. This will return the total number of unique award types.
NEW QUESTION # 52
You need to change the values of a dimension without creating a new field.
What should you do?
- A. Rename the fields
- B. Transforms the fields
- C. Create aliases
- D. Create groups
Answer: C
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 # 53
Open the link to Book1 found on the desktop. Open Disciplines worksheet.
Filter the table to show the Top 10 NOC based on the number of medals won.
Answer:
Explanation:
check the steps below in explanation
Explanation:
To filter the table to show the Top 10 NOC based on the number of medals won, 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 Disciplines worksheet.
Click on the Disciplines tab at the bottom of the workbook to open the worksheet. You will see a table that shows the NOC, discipline, and medals for each country.
Drag Medals from the Measures pane to the Filters shelf. This will open a dialog box that allows you to filter by different criteria.
Select Top from the dialog box. This will show you options to filter by the top or bottom values of a field.
Enter 10 in the text box next to By field. This will filter by the top 10 values of Medals.
Select NOC from the drop-down list next to By field. This will filter by the top 10 values of NOC based on Medals.
Click OK to apply the filter. You will see that the table now shows only 10 rows, one for each NOC with the highest number of medals.
NEW QUESTION # 54
......
100% Free Tableau Certified TDA-C01 Dumps PDF Demo Cert Guide Cover: https://www.surepassexams.com/TDA-C01-exam-bootcamp.html
PDF Exam Material 2024 Realistic TDA-C01 Dumps Questions: https://drive.google.com/open?id=1ZxRHXQzSKM6eojouY3_4lr7caR-okWxG