Tableau Certified Data Analyst Exam TDA-C01 Updated Dumps

Text Material Preview

TDA-C01 Tableau Certified Data Analyst Exam exam dumps questions are the
best material for you to test all the related Tableau exam topics. By using the
TDA-C01 exam dumps questions and practicing your skills, you can increase
your confidence and chances of passing the TDA-C01 exam.
Features of Dumpsinfo’s products
Instant Download
Free Update in 3 Months
Money back guarantee
PDF and Software
24/7 Customer Support
Besides, Dumpsinfo also provides unlimited access. You can get all
Dumpsinfo files at lowest price.
Tableau Certified Data Analyst Exam TDA-C01 exam free dumps questions
are available below for you to study. 
Full version: TDA-C01 Exam Dumps Questions
1.HOTSPOT
You have a blank dashboard.
You want to add two sheets to the dashboard. The sheets must support the Show/Hide button.
To which two objects can you add the sheets? (Click the two appropriate Options in the Answer
Area.)
 1 / 19
https://www.dumpsinfo.com/unlimited-access/
https://www.dumpsinfo.com/exam/tda-c01
Answer:
 2 / 19
https://www.dumpsinfo.com/
Explanation:
To add two sheets to the dashboard that support the Show/Hide button, you can add them to either a
horizontal or a vertical container. A container is an object that can hold one or more sheets or other
objects and allow you to arrange them in a layout. A Show/Hide button is a feature that lets you hide
or show a container and its contents on the dashboard. You can add a Show/Hide button to any
container, whether it is tiled or floating, by using the drop-down menu of the container and selecting
“Add Show/Hide Button.” You can also customize the appearance and behavior of the button.
To add a horizontal or a vertical container to the dashboard, you can drag them from the Objects
pane to the dashboard. A horizontal container will arrange the sheets or objects horizontally, while a
vertical container will arrange them vertically. You can then drag the sheets you want to add from the
Sheets pane to the container. You can resize and reorder the sheets or objects within the container
by using the handles and arrows.
The other objects in the Answer Area, such as text, image, web page, blank, navigation, download,
and extension, do not support the Show/Hide button. They are either static elements that cannot
hold other objects, or dynamic elements that require user interaction or external sources. You can
add them to the dashboard as well, but they will not have the same functionality as a container with
a Show/Hide button.
Reference: Add Show/Hide Buttons - Tableau
Layout Containers - Tableau
2.You have a data source that contains 20 tables.
You want the tables to be organized within the Data pane based on the type of data contained within
the tables.
What should you use?
A. Folders
B. Hierarchies
C. Sets
D. Groups
Answer: A
Explanation:
To organize the tables in the Data pane based on the type of data contained within the tables, you
should use folders. Folders are a way to manually group fields, parameters, sets, or tables in the Data
pane according to your preference. You can create folders by right-clicking on the fields or tables you
want to group and selecting Folders > Create Folder. You can also drag and drop fields or tables into
existing folders. You can name the folders according to the type of data they contain, such as sales,
customer, product, etc. Folders can help you find and access the fields or tables you need more
easily and efficiently.
Reference: Organize and Customize Fields in the Data Pane - Tableau Tableau Certified Data
Analyst Study Guide
3.DRAG DROP
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.)
 3 / 19
https://www.dumpsinfo.com/
Answer:
Explanation:
Select
Where
The correct way to complete the query is:
SELECT * FROM [dbo] . [Students]
WHERE [Students].[City] = ‘Berlin’
The SELECT statement is used to retrieve data from a table or a view. The * symbol means that all
columns will be returned. The FROM clause specifies the table or view name and the schema name.
The WHERE clause is used to filter the data based on a condition. The condition is [Students].[City] =
‘Berlin’, which means that only rows where the City column of the Students table is equal to ‘Berlin’
will be returned.
The other options are not relevant for this query. CAST is a function that converts a value from one
data type to another. JOIN is a clause that combines data from two or more tables based on a
common field. ON is a keyword that specifies the join condition. UNION is a set operation that
combines the results of two or more queries into one result set.
Reference:
 4 / 19
https://www.dumpsinfo.com/
https://docs.microsoft.com/en-us/sql/t-sql/queries/select-transact-sql?view=sql-server-ver15
https://docs.microsoft.com/en-us/sql/t-sql/queries/where-transact-sql?view=sql-server-ver15
https://docs.microsoft.com/en-us/sql/t-sql/functions/cast-and-convert-transact-sql?view=sql-server-
ver15
https://docs.microsoft.com/en-us/sql/t-sql/queries/from-transact-sql?view=sql-server-ver15#join
https://docs.microsoft.com/en-us/sql/t-sql/language-elements/set-operators-union-transact-
sql?view=sql-server-ver15
4.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.
Answer:
To create a histogram on the Quantity field by using bin size of 3, 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 Histogram tab at the bottom of the workbook to open the Histogram worksheet. You will
see a blank worksheet with no marks.
Right-click on Quantity in the Measures pane and select Create Bins from the menu. This will open a
dialog box that allows you to create bins for the Quantity field. Bins are groups of values that are
treated as one unit in a histogram.
Enter 3 in the Size of bins text box. This will set the bin size to 3, which means that each bin will
contain values that are 3 units apart. For example, one bin will contain values from 0 to 2, another bin
will contain values from 3 to 5, and so on.
 5 / 19
https://www.dumpsinfo.com/
Click OK to create the bins. You will see a new field named Quantity (bin) in the Measures pane with
a # sign next to it.
Drag Quantity (bin) from the Measures pane to Columns on the worksheet. This will create a
histogram that shows the distribution of Quantity by bins. You will see bars that represent the
frequency or count of values in each bin.
Optionally, you can adjust the width, color, and labels of the bars by using the options on the Marks
card. You can also add filters, tooltips, or annotations to enhance your histogram.
Reference:
https://help.tableau.com/current/pro/desktop/en-us/histograms.htm
https://help.tableau.com/current/pro/desktop/en-us/calculations_bins.htm
https://help.tableau.com/current/pro/desktop/en-us/buildmanual_histograms.htm
5.1.You have the following box plot that shows the distribution of average profits made in every state
by region.
 6 / 19
https://www.dumpsinfo.com/
 7 / 19
https://www.dumpsinfo.com/
Which region has the smallest distribution of profits?
A. South
B. Cast
C. Central
D. West
Answer: C
Explanation:
The central region has the smallest distribution of profits because it has the smallest interquartile
range (IQR), which is the distance between the first and third quartiles of the box plot. The IQR
measures the spread of the middle 50% of the data. The smaller the IQR, the less variation in the
data.
Reference:https://help.tableau.com/current/pro/desktop/en-us/buildexamples_boxplot.htm
https://www.statisticshowto.com/probability-and-statistics/interquartile-range/
6.You have the following tiled dashboard that has one sheet.
You want to replace the sheet with Sheet2.
What should you do?
A. Select Sheet3 and click the Swap Sheet button next to Sheet2.
B. Right-click Sheet2 and select Add to Dashboard.
C. From the context menu of Sheet3, select Deselect.
D. Drag Sheet2 to the dashboard.
E. From the context menu of Sheet3, select Remove Dashboard Item.
Answer: A
Explanation:
Reference:
Create a Dashboard - Tableau
Tableau Certified Data Analyst Study Guide
7.HOTSPOT
 8 / 19
https://www.dumpsinfo.com/
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:
 9 / 19
https://www.dumpsinfo.com/
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.
 10 / 19
https://www.dumpsinfo.com/
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.
Reference:
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
8.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
9.You have the following dataset in Microsoft Excel.
 11 / 19
https://www.dumpsinfo.com/
You are using interpreter to cleans the dataset. Data interpreter provides the following results.
 12 / 19
https://www.dumpsinfo.com/
How many rows of data will be ingested into Tableau as values?
A. 10
B. 20
C. 17
D. 15
Answer: C
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
 13 / 19
https://www.dumpsinfo.com/
10.HOTSPOT
You have a dashboard than contains two sheets named Sheet 1 and Sheet 2.
You want to add an object to the dashboard that users can click to switch to a different dashboard in
the workbook.
Which object should you add to the dashboard?
Answer:
The object that you should add to the dashboard to allow users to switch to a different dashboard in
the workbook is Navigation.
Navigation objects are used to create links between dashboards or sheets in a workbook. You can
add a navigation object to a dashboard by dragging it from the list of objects and dropping it on the
dashboard. You can then configure the navigation object to specify the destination dashboard or
sheet that you want users to navigate to when they click on it.
You can learn more about navigation objects and how to use them in this article:
https://help.tableau.com/current/pro/desktop/en-us/dashboards_navigation.htm
11.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.
 14 / 19
https://www.dumpsinfo.com/
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, select Valid in the Show values section.
B. For the data type of the Material field, select Custom, and then select Role1.
C. From the More actions menu of Materials, select Group Values, and then select Spelling.
D. From the More actions menu of Materials, filter the selected values.
Answer: BC
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.
Reference:
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
12.You have the following Map.
 15 / 19
https://www.dumpsinfo.com/
You need the map to appear as shown in the following visualization.
 16 / 19
https://www.dumpsinfo.com/
What should you do?
A. Drag Location to Size on the Marks card.
B. Change the opacity to 75%.
C. Drag Population to Size on the Marks card.
D. Change the mark type to Density.
E. Change the mark type to Map.
Answer: D
Explanation:
To create a map visualization that shows the concentration of data points in different locations, you
need to change the mark type to Density. This will create a heatmap that uses color and size to
indicate the density of the data points. You can also adjust the intensityand transparency of the
density marks to suit your needs.
 17 / 19
https://www.dumpsinfo.com/
Reference: The information is based on the following sources: Create Heatmaps that Show Trends or
Density in Tableau Build a Simple Map - Tableau
13.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:
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.
Reference:
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
 18 / 19
https://www.dumpsinfo.com/
14.HOTSPOT
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:
Powered by TCPDF (www.tcpdf.org)
 19 / 19
https://www.dumpsinfo.com/
http://www.tcpdf.org