Tableau Certified Data Analyst Exam TDA-C01 Dumps Questions

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 dataset that has four fields named Category.
Profit Sates and Customer Name. You need to create the following visualization.
 1 / 18
https://www.dumpsinfo.com/unlimited-access/
https://www.dumpsinfo.com/exam/tda-c01
 2 / 18
https://www.dumpsinfo.com/
Answer:
 3 / 18
https://www.dumpsinfo.com/
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.
Reference: https://help.tableau.com/current/pro/desktop/en-us/buildmanual_shelves.htm
https://help.tableau.com/current/pro/desktop/en-us/buildexamples_scatter.htm
2.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 Data menu select New Data Source
B. From the Data menu select Replace Data Source
C. From the File menu select Import Workbook
D. From the File menu select New
Answer: A
Explanation:
To connect a Tableau workbook to a dataset in a Microsoft Excel spreadsheet, you need to select
New Data Source from the Data menu. This will open the Connect pane, where you can choose
Microsoft Excel as your data source and browse for your spreadsheet file. You can then drag and
 4 / 18
https://www.dumpsinfo.com/
drop your sheets or tables to join or union them in the data source page.
Reference:
https://help.tableau.com/current/pro/desktop/en-us/connect_basic.htm
https://help.tableau.com/current/pro/desktop/en-us/connect_excel.htm
3.You have a data source that has two tables named Table1 and Table2. Table1 is the primary table
and Table2 is the secondary table.
You want to combine the tables by using Tableau Prep. The combined table must include only values
from Table1 that do NOT match any values in Table2. The field values from Table2 must appear as
null values.
Which type of join should you use?
A. Left only
B. Union
C. Inner
D. Left
E. Full outer
Answer: A
Explanation:
To combine the tables by using Tableau Prep and include only values from Table1 that do not match
any values in Table2, you should use a left only join. A left only join is a type of join that returns only
the rows from the primary table (Table1) that have no matching rows in the secondary table (Table2).
The field values from Table2 will appear as null values in the combined table. A left only join is also
known as an anti-join or an exclusion join.
Reference: Tableau Certified Data Analyst Exam Prep Guide, page 9, section “Preparing Data”
Tableau Help: Join Your Data
Tableau Help: Left Only Join
4.You have a Tableau workbook.
You want to make the workbook available in Tableau Online.
What should you do?
A. From the Server menu, select Tableau Public, and then select Save to Tableau Public.
B. From the File menu, select Export Packaged Workbook.
C. From the Server menu, select Publish Data Source.
D. From the Server menu, select Publish Workbook.
Answer: D
5.You have the following table.
 5 / 18
https://www.dumpsinfo.com/
 6 / 18
https://www.dumpsinfo.com/
You need each record to alternate between grey and white.
What should you change in the Format Shading pane?
A. the row banding size to 1
B. the column banding size to 1
C. the row banding size to 3
D. the column banding size to 3
Answer: A
6.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, 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
 7 / 18
https://www.dumpsinfo.com/
7.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 top N condition filer on a dimension in Sheet 1 and Sheet2
C. A context filler on a dimension m Sheet3
D. A dimension filter on all the sheets
Answer: D
Explanation:
A data source filter is a filter that applies to all the worksheets that use the same data source. It filters
the data before any other filters or calculations are applied. You can add a data source filter from the
Data Source page by clicking on the Add button next to Filters.
The type of filter that will appear in the Edit Data Source Filters dialog box is a dimension filter on all
the sheets. This means that you can choose a dimension from your data source and filter it by values,
range, condition, or top/bottom. The filter will affect all the worksheets that use that dimension.
The other types of filters are not data source filters and will not appear in the Edit Data Source Filters
dialog box. A table calculation filter is a filter that applies to a table calculation, such as percent of
total or running total. A top N condition filter is a filter that shows only the top or bottom N values of a
measure or dimension based on a condition. A context filter is a filter that creates a subset of data
that other filters can use.
Reference:
https://help.tableau.com/current/pro/desktop/en-us/filtering_datasource.htm
https://help.tableau.com/current/pro/desktop/en-us/filtering.htm
https://help.tableau.com/current/pro/desktop/en-us/filtering_tablecalculations.htm
https://help.tableau.com/current/pro/desktop/en-us/filtering_topn.htm
https://help.tableau.com/current/pro/desktop/en-us/filtering_context.htm
8.You plan to create a visualization that has a dual axis chart. The dual axis chart will contain a shape
chart and a line chart will use the same measure named Population on the axis. You need to
configure be shapes to be much larger than the line.
What should you do?
A. DuplicatePopulation Drag the duplicate to the second Marks card and configure the see of the
marks independently
B. Create a custom shape that is larger than the default shape and add the shape to the Shapes
folder in My Repository
C. For the second axis select Shape on the Marks card From Select Shape Palette select Custom
and then select Reset
D. Change Population to a discrete dimension
Answer: A
Explanation:
To configure the shapes to be much larger than the line, you need to duplicate Population and drag it
to the second Marks card. This will create a dual axis chart with two measures on one axis. You can
then select Shape on one Marks card and Line on another Marks card, and adjust the size of each
mark independently using the Size slider or menu.
Reference:
https://help.tableau.com/current/pro/desktop/en-us/multiplemeasures_dualaxes.htm
https://help.tableau.com/current/pro/desktop/en-us/marks_markproperties_size.htm
9.From Tableau Desktop you sign in lo a Tableau Server site.
 8 / 18
https://www.dumpsinfo.com/
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
10.You have the following dataset.
You want to create a new calculated dimension field named Category that meets the following
conditions:
. When Subject is Computer Science or Science, Category must be Sciences.
. When Subject is English or Social Studies, Category must be Humanities.
Which two logical functions achieve the goal? Choose two.
A. IF [Subject]- 'Science' THEN 'Sciences' ELSEIF [Subject]='English' THEN 'Humanities' ELSEIF
[Subject]-'Social Studies' THEN 'Humanities' ELSEIF [Subject]= 'Computer Science' THEN 'Sciences'
END
B. IIF(( CONTAINS ([Subject], 'Science') = TRUE) , 'Humanities', 'Sciences')
C. IF ENDSWITH ( [Subject], 'Computer Science') THEN 'Sciences' ELSE 'Humanities' END
D. CASE [Subject]
WHEN 'Computer Science' THEN 'Sciences'
WHEN 'Science' THEN 'Sciences'
WHEN 'English' THEN 'Humanities'
WHEN 'Social Studies' THEN 'Humanities'
End
Answer: AD
Explanation:
To create a new calculated dimension field named Category that meets the given conditions, you can
use either the IF or the CASE logical function. Both functions allow you to evaluate an expression and
 9 / 18
https://www.dumpsinfo.com/
return a value based on different scenarios. Option A uses the IF function with multiple ELSEIF
clauses to check the value of the Subject field and assign it to either ‘Sciences’ or ‘Humanities’.
Option D uses the CASE function with multiple WHEN clauses to do the same thing. Both options will
produce the same result, but the CASE function is more concise and easier to read.
Option B is incorrect because it will assign ‘Humanities’ to any subject that contains ‘Science’ in its
name, which is not the desired outcome.
Option C is incorrect because it will only check if the subject ends with ‘Computer Science’ and
ignore the other subjects.
Reference: Logical Functions - Tableau
Tableau Certified Data Analyst Study Guide
11.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. Extract Refreshes
C. Connected Workbooks
D. Connections
Answer: B
Explanation:
To ensure that the data is updated every hour, you need to select Extract Refreshes from the data
source menu on Tableau Server. This will allow you to add a new extract refresh schedule or edit an
existing one. You can specify the frequency and time of the refresh, as well as any custom options or
credentials. New will create a new data source, Connected Workbooks will show you which
workbooks use this data source, and Connections will show you which tables or files are connected to
this data source.
Reference:
https://help.tableau.com/current/server/en-us/refresh_extracts.htm
https://help.tableau.com/current/server/en-us/refresh_extracts_add.htm
12.You have the following tiled dashboard that has one sheet.
 10 / 18
https://www.dumpsinfo.com/
You want to replace fit sheet with Sheet2.
What should you do?
A. Right-click Sheet2 and select Add to Dashboard.
B. Select Sheets and click the Swap Sheet button next to Sheet2.
C. From the context menu of Sheet3. select Remove Dashboard item
D. Drag Sheet2 to the dashboard.
E. From the context menu of Sheet3. select Deselect
Answer: B
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
13.HOTSPOT
You have a data set that contains three columns named Sales, Profit, and Quantity.
You need to build the following scatter plot.
 11 / 18
https://www.dumpsinfo.com/
 12 / 18
https://www.dumpsinfo.com/
Answer:
 13 / 18
https://www.dumpsinfo.com/
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.
Reference: Build a Scatter Plot
Understanding and Using Scatter Plots
Scatter plot in Tableau
14.HOTSPOT
You receive a tab-delimited data file name sales.tsv.
You need to connect to the file.
Which option should you select in Tableau Desktop?
 14 / 18
https://www.dumpsinfo.com/
Answer:
 15 / 18
https://www.dumpsinfo.com/
Explanation:
To connect to a tab-delimited data file named sales.tsv, you should select the option To a File > Text
file in Tableau Desktop. This option will allow you to browse and select the file from your local or
network drive and connect to it as a data source. You can then specify the text file properties, such as
the delimiter, the text qualifier, and whether the first row contains column names. You can also join,
union, or blend the data with other data sources if needed.
Reference: Text File - Tableau
Tableau Certified Data Analyst Study Guide
 16 / 18
https://www.dumpsinfo.com/
15.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. 2N ([Profits])
B. ISNULL ([Profits])
C. IFNULL [(profits] ,0)
D. IF [Profits] != null then [Profits] END
Answer: AC
Explanation:
The two formulas that willmake the data appear as shown in the second table are:
C. IFNULL([Profits],0)
D. IF [Profits] != null then [Profits] END
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
 17 / 18
https://www.dumpsinfo.com/
https://help.tableau.com/current/pro/desktop/en-us/functions_functions_logical.htm#ISNULL
Powered by TCPDF (www.tcpdf.org)
 18 / 18
https://www.dumpsinfo.com/
http://www.tcpdf.org