Get Started: TDA-C01 Exam [2024] Dumps Tableau PDF Questions
TDA-C01 Premium Exam Engine pdf Download
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.
The TDA-C01 certification is recognized by employers worldwide as a benchmark for excellence in data analysis. It demonstrates that an individual has the knowledge and skills to use Tableau products to analyze data and create actionable insights. Certified professionals can expect to earn higher salaries and have more job opportunities than non-certified professionals. Tableau Certified Data Analyst certification also provides a pathway to higher-level Tableau certifications, such as the Tableau Certified Associate and the Tableau Certified Professional.
Tableau TDA-C01 (Tableau Certified Data Analyst) Certification Exam is an industry-recognized certification program offered by Tableau, one of the leading data visualization software providers in the world. Tableau Certified Data Analyst certification is designed for professionals who want to validate their skills in data analysis using Tableau, and it is aimed at data analysts, business analysts, and other professionals who want to demonstrate their proficiency in data visualization and analysis.
NEW QUESTION # 25
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: SUM Sales}
- B. {FIXED: TOTAL (Sales)}
- C. {Fixed: [Region]: TOTAL Sales}
- D. {FIXED: [Region] SUM Sales}
Answer: B
Explanation:
To calculate the grand total of all the regions, you need to use a Level of Detail (LOD) expression that ignores any dimensions in the view and returns the total sum of sales. The FIXED keyword allows you to specify the level of detail for the calculation, and the TOTAL function returns the sum of all values in the expression. Therefore, the correct LOD expression is {FIXED: TOTAL (Sales)}. Reference: https://help.tableau.com/current/pro/desktop/en-us/calculations_calculatedfields_lod.htm https://help.tableau.com/current/pro/desktop/en-us/functions_functions_tablecalculation.htm#TOTAL
NEW QUESTION # 26
You need to change the values of a dimension without creating a new field.
What should you do?
- A. Create groups
- B. Create aliases
- C. Rename the fields
- D. Transforms the fields
Answer: B
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 # 27
You have the Mowing two tables that contains data about the books in a library.
Both tables are incomplete so there are books missing from the tables.
You need to combine the tables. The solution must ensure that all the data is retained Which type of join should you use?
- A. Full outer join
- B. left join
- C. Right join
- D. Inner join
Answer: D
NEW QUESTION # 28
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 fillers
When type of filter will appear in the Edit Data Source Filters dialog box?
- A. A table calculation filter used on Sheet
- B. A context filler on a dimension m Sheet3
- C. A top N condition filer on a dimension in Sheet 1 and Sheet2
- D. A dimension Maw on all the sheets
Answer: C
NEW QUESTION # 29
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. ISNULL ([Profits])
- B. IF [Profits] != null then [Profits] END
- C. IFNULL [(profits] ,0)
- D. 2N ([Profits])
- E. IFNULL([Profits],0)
Answer: C,D
Explanation:
The IFNULL function is a logical function that returns the first argument if it is not null, and the second argument if it is null. In this case, the first argument is [Profits], which is the field that contains null values. The second argument is 0, which is the value that you want to replace null values with. The function will return [Profits] if it is not null, and 0 if it is null.
The IF statement is a logical statement that returns a value or performs an action if a condition is true, and optionally returns another value or performs another action if the condition is false. In this case, the condition is [Profits] != null, which means that [Profits] is not null. The statement will return [Profits] if the condition is true, and nothing if the condition is false. The END keyword marks the end of the statement.
The other options are not correct for this scenario. The ZN function is a logical function that returns zero if a value or expression is null, and returns the value or expression itself if it is not null. However, it only works with numeric values or expressions, and [Profits] may not be numeric in this case. The ISNULL function is a logical function that returns TRUE if a value or expression is null, and FALSE otherwise. It does not replace null values with another value. Reference: 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 Explanation:
The two formulas that will make the data appear as shown in the second table are:
NEW QUESTION # 30
You have the following dataset.
You need to create the following worksheet.
The table must show either profit or sales based on the selection from the Parameter 1 menu.
Which three actions should you perform in orders
(Place the three correct options in order Use the arrows to move Options lo Answer Area Use Answer Area arrows to reorder the options)
Answer:
Explanation:
1 - Create a parameter that has list string values of profit and sales. Select Show Parameter
2 - Create a calculated field that uses the following formula:....
3 - Drag the calculated field to Detail on the Marks card and add tRegion to the Columns sheif.
NEW QUESTION # 31
You have a dashboard that contains confidential information about patients health. The data needs to always be up to date tor a team of healthcare workers How should you share me dashboard with the healthcare workers?
- A. Publish the dashboard to Tableau Public
- B. Export the dashboard as a .twbx
- C. Print the dashboard to PDF
- D. Publish aw dashboard to Tableau Server
Answer: C
NEW QUESTION # 32
Open the Link to Book1 found on the desktop. Open Map worksheet and use Superstore data source.
Create a filed map to show the distribution of total Sales by State across the United States.
- A. check the steps below in explanation
Answer: A
Explanation:
To create a filled map to show the distribution of total Sales by State across the United States, you need to do the following steps:
Open the link to Book1 found on the desktop. This will open the Tableau workbook that uses the Superstore data source.
Click on the Map tab at the bottom of the workbook to open the Map worksheet. You will see a blank worksheet with no marks.
Drag State from the Dimensions pane to Detail on the Marks card. This will create a map that shows each state as a mark. You may need to zoom in or out to see the whole map.
Drag Sales from the Measures pane to Color on the Marks card. This will create a filled map that shows the distribution of total Sales by State across the United States. The color legend will show you the range of values and colors for Sales.
Optionally, you can adjust the color scheme, transparency, size, and borders of the marks by clicking on the Color menu on the Marks card. You can also add labels, tooltips, or filters to enhance your map.
NEW QUESTION # 33
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. Drag Discount to Color on the Marks card
- B. Set Discount to Dual Axis
- C. Drag Discount to the Columns shelf
- D. Convert Discount to Discrete
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. References: 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 # 34
You connect to a database server by using Tableau Prep. The database server has a data role named Role1.
You have the following field in the data.
You need to apply the Role1 data role to the Material field.
Which two actions should you perform? Choose two.
- A. From the More actions menu of Materials, filter the selected values.
- B. From the More actions menu of Materials, select Valid in the Show values section.
- C. From the More actions menu of Materials, select Group Values, and then select Spelling.
- D. For the data type of the Material field, select Custom, and then select Role1.
Answer: C,D
Explanation:
To apply a custom data role to a field, you need to select the data type of the field and then choose the data role from the list of available roles. This will validate the values in the field against the data role and mark any invalid values with a red exclamation mark. To fix the invalid values, you can use the Group Values option and select the Spelling algorithm, which will group values that are close in spelling and replace them with the most frequent value in the group. This will help you standardize the values in the Material field and match them with the Role1 data role. References: The information is based on the following sources:
Use Data Roles to Validate your Data - Tableau
New in Tableau Prep: Automatically identify data quality issues with Data Roles
NEW QUESTION # 35
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?
- A. All the data sources published to the site
- B. All the data sources published to the Tableau Server
- C. All the data sources published to the site within the folders to which you have access
- D. All the data sources published to the Tableau Server within the folders to which you have access
Answer: C
Explanation:
When you sign in to a Tableau Server site from Tableau Desktop and search for a published data source, you will see all the data sources published to the site within the folders to which you have access. You will not see data sources published to other sites or folders that you do not have permission to view. You can also filter your search by project, owner, or tag. Reference: https://help.tableau.com/current/pro/desktop/en-us/connect_basic.htm https://help.tableau.com/current/pro/desktop/en-us/connect_tableauserver.htm
NEW QUESTION # 36
You have the following dataset.
You need to create the following worksheet.
The table must show either profit or sales based on the selection from the Parameter 1 menu.
Which three actions should you perform in orders
(Place the three correct options in order Use the arrows to move Options lo Answer Area Use Answer Area arrows to reorder the options)
Answer:
Explanation:
1 - Create a parameter that has list string values of profit and sales. Select Show Parameter.
2 - Create a calculated field that uses the following formula,,,,,,
3 - Drag the calculated field to Detail on the Marks card and add Region to the Columns sheif.
NEW QUESTION # 37
You create the following story that contains two story point.
You want to change the story point format to show the current story point number out of the total number of story points.
Which Layout option should you use?
- A. Arrows only
- B. Caption boxes
- C. Dots
- D. Numbers
Answer: D
Explanation:
To change the story point format to show the current story point number out of the total number of story points, you should use the Numbers option in the Layout tab. This option will display the story points as numbers in a horizontal or vertical sequence, such as 1/2, 2/2. You can also choose to show or hide the next and previous arrows for navigation. The Numbers option will help you indicate the progress and order of your story points more clearly than the other options. References:
Creating a Story - Tableau
New in 9.0: Formatting the Story Points Navigator - Tableau
Tableau Certified Data Analyst Study Guide
NEW QUESTION # 38
You have the following worksheet.
You want to create a table calculation that shows sales growth over each year.
How should you complete the formula? (Use the dropdowns in the Answer Area to select the correct options to complete the formula.)
Answer:
Explanation:
Explanation:
There are different ways to create a table calculation that shows sales growth over each year, but one possible answer is:
SUM([Sales])
LOOKUP(SUM([Sales]), -1)
PREVIOUS_VALUE(0)
To calculate the sales growth over each year, you need to compare the current year's sales with the previous year's sales and divide the difference by the previous year's sales. You can use the SUM, LOOKUP, and PREVIOUS_VALUE functions to achieve this. The SUM function returns the total sales for each year. The LOOKUP function returns the value of an expression in a target row, specified as a relative offset from the current row. The PREVIOUS_VALUE function returns the value of the expression in the previous row, or a specified value if there is no previous row. The formula for the table calculation is:
(SUM([Sales]) - LOOKUP(SUM([Sales]), -1)) / PREVIOUS_VALUE(0)
This formula subtracts the sales of the previous year (LOOKUP(SUM([Sales]), -1)) from the sales of the current year (SUM([Sales])) and divides the result by the sales of the previous year. If there is no previous year, the formula uses 0 as the denominator (PREVIOUS_VALUE(0)) to avoid division by zero errors.
References:
Tableau Certified Data Analyst Exam Prep Guide, page 11, section "Creating Calculated Fields" Tableau Help: SUM Function Tableau Help: LOOKUP Function Tableau Help: PREVIOUS_VALUE Function
NEW QUESTION # 39
You have the following visualization.
You want the count of Returns displayed only for the first year in the table.
How should you complete the formula in the calculated field? (Use the dropdowns in the Answer Area to select the correct options to complete the formula.)
Answer:
Explanation:
NEW QUESTION # 40
You have a dataset that contains sates dat
a. The following is a sample of the data.
You need to return a value of true if a month has sales greater than $50 000. otherwise the formula must return a value of false.
Which two formulas achieve the goal Choose two
- A. IIF(SUM< [Sales] )>50000, TRUE, FALSE)
- B. MAX< [Sales], 50000)
- C. [Sales] > 50000
- D. SUM{[Sales]) IN (50000)
Answer: A,C
NEW QUESTION # 41
You have the following tiled dashboard that has one sheet.
You want to replace fit sheet with Sheet2.
What should you do?
- A. Select Sheets and click the Swap Sheet button next to Sheet2.
- B. From the context menu of Sheet3. select Deselect
- C. Drag Sheet2 to the dashboard.
- D. From the context menu of Sheet3. select Remove Dashboard item
- E. Right-click Sheet2 and select Add to Dashboard.
Answer: A
Explanation:
To replace a sheet on a tiled dashboard, you can simply drag the new sheet from the Sheets pane to the dashboard and drop it over the existing sheet. This will replace the old sheet with the new one and keep the same size and position. Alternatively, you can right-click on the old sheet and select Replace Data Source, then choose the new sheet from the list. 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_replace_datasource.htm
NEW QUESTION # 42
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%.
Answer:
Explanation:
check the steps below in explanation.
Explanation:
To modify the bar chart to show the percentage of sales for each Subcategory within every Category, 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 CategoryPercentage worksheet.
Click on the CategoryPercentage tab at the bottom of the workbook to open the worksheet. You will see a bar chart that shows the total sales for each Subcategory across all Categories.
Right-click on Sales on the Columns shelf and select Add Table Calculation from the menu. This will open a dialog box that allows you to apply a calculation to your measure.
Select Percent of Total from the Calculation Type drop-down list. This will calculate the percentage of sales for each Subcategory out of the total sales for all Subcategories.
Select Category from the Compute Using drop-down list. This will calculate the percentage of sales for each Subcategory within every Category, instead of across all Categories. The total percentage for every Category will be 100%.
Click OK to apply the table calculation. You will see that the bar chart now shows the percentage of sales for each Subcategory within every Category.
References: https://help.tableau.com/current/pro/desktop/en-us/calculations_tablecalculations.htm
https://help.tableau.com/current/pro/desktop/en-us/calculations_tablecalculations_create.htm
https://help.tableau.com/current/pro/desktop/en-us/calculations_tablecalculations_percentoftotal.htm
NEW QUESTION # 43
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:
Explanation:
A screenshot of a computer Description automatically generated
NEW QUESTION # 44
You company has two divisions located in the United States and Germany Bach division has a separate database. The following is a sample of the sales data for the division in the United States.
The following is a sample of the sales data for me division in Germany.
You have population data in a file named Populatio.csv. the following is a sample of the data.
You plan to create a visualization that ml show tie sales per capita for each salesperson Each salesperson must be identified by identified by their full name.
You need to prepare the data to support the planned visualization. The data source must support being published .
Which four actions should you perform in order?
(Place the four correct options n order Use the arrows to move Options to Answer Area arrows to re-order the options.
Use Answer Area arrows to re-order the options)
Answer:
Explanation:
1 - Open Tableau Desktop
2 - Create a new column to Concatenate the name for the Germany division.
3 - Union the sales data of both divisions.
4 - Join the sales data and the population data by using City as the join field.
NEW QUESTION # 45
A colleague provides you with access to a folder that contains the following files:
* Sates.csv
* Bookl.twb
* Sates.hyper
* Export.mdb
Which He contains an extract?
- A. Sales.csv
- B. Book1.twb
- C. Export mdb
- D. Sales.hyper
Answer: D
Explanation:
A .hyper file is an extract file that contains a snapshot of data from a data source. It is a compressed and optimized file format that can be used to improve the performance and portability of dashboards and workbooks. A .twb file is a workbook file that contains the visualization and connection information, but not the data itself. A .csv file is a comma-separated values file that contains plain text data. A .mdb file is a Microsoft Access database file that contains tables, queries, forms, and other objects. References:
https://help.tableau.com/current/pro/desktop/en-us/save_savework_packagedworkbooks.htm
https://help.tableau.com/current/pro/desktop/en-us/extracting_data.htm
https://help.tableau.com/current/pro/desktop/en-us/examples_csv.htm
https://support.microsoft.com/en-us/office/introduction-to-access-database-files-9f9a0f8c-9a3c-4a0b-8e6c-6d1f1
In Tableau, a .hyper file is an extract file created by the Hyper database engine.
It contains a snapshot of the data pulled into Tableau and is used to perform data analysis without the need for a live connection to the data source.
NEW QUESTION # 46
You have a data source that contains the following columns.
You have the following view that shows the percentage of total sales by category:
You want to change the calculation to show the percentage of total sales within the categories of every region annually. Which Compute Using option should you use? (Click the appropriate Option in the Answer Area.)
Answer:
Explanation:
NEW QUESTION # 47
You have the following dataset.
Which grouping option should you use m Tableau Prep to group al five names automatically?
- A. Spelling
- B. Manual Selection
- C. Common Characters
- D. Pronunciation
Answer: B
Explanation:
To group all five names automatically, you should use Manual Selection as a grouping option in Tableau Prep. Manual Selection is a feature that allows you to select values from your data and group them together based on your criteria. You can use Manual Selection by clicking on Group Values in Profile pane > Manual Selection from the menu. This will open a dialog box where you can select values from your data and assign them to a group.
In this case, you want to group all five names together based on their spelling variations. You can use Manual Selection by selecting all five values from your data and assigning them to a group named "Harry Potter". This will create a new field named Grouped Field that contains "Harry Potter" as one value.
The other options are not correct for this scenario. Pronunciation is a feature that groups values based on how they sound, but it may not work well with names or uncommon words. Spelling is a feature that groups values based on common spelling errors or typos, but it may not recognize all variations or synonyms. Common Characters is a feature that groups values based on the number of characters they share, but it may not capture the meaning or context of the values. Reference: https://help.tableau.com/current/prep/en-us/prep_group.htm https://help.tableau.com/current/prep/en-us/prep_group_manual.htm
NEW QUESTION # 48
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 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 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 # 49
......
Pass Your Tableau Exam with TDA-C01 Exam Dumps: https://www.practicetorrent.com/TDA-C01-practice-exam-torrent.html
Verified TDA-C01 Bundle Real Exam Dumps PDF: https://drive.google.com/open?id=14Jd4EQYcv6tGmXB63Hv7dR5NVIamMUbU