TDA-C01試験無料問題集（178題）「Tableau Certified Data Analyst 認定」

出題：1

You create the following worksheet
The Pick Measure parameter contains the following list of values
Users can select a value from Pick Measure to change the visualization to show either the Sales measure or the Profit measure.
Which formula is used in the Selected Measure calculated field lo switch between measures?

A. Case AVG([Pick Measure])
WHEN [Sales] then 1
WHEN [Profit] then 2
END

B. Case [Pick Measure:
WHEN [Sales] then 1
WHEN [Profit] then 2 END

C. Case [Pick Measure]
WHEN 1 then ([Sales])
WHEN 2 then ([Profit])
END

D. Case STFMEPick Measure])
WHEN "Sales" then ([Sales])
WHEN "Profit" then ([Profit]) e::i

正解：C 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：2

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. Convert Discount to Discrete

B. Drag Discount to Color on the Marks card

C. Drag Discount to the Columns shelf

D. Set Discount to Dual Axis

正解：D 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：3

A Data Analyst has the following chart.

The analyst needs to enable the drilldown from Category to Subcategory as shown in the following chart.

What should the analyst create?

A. A group of Category and Subcategory

B. A bin for Category and a bin for Subcategory

C. A combined set for Category and Subcategory

D. A hierarchy of Category and Subcategory

正解：D 解答を投票する

出題：4

Which function should a Data Analyst use to average sales at a less-granular level of detail than is in the view?

A. EXCLUDE

B. AVG

C. RUNNING_AVG

D. INCLUDE

正解：A 解答を投票する

出題：5

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.)

正解：

Explanation:
we need to create a calculated field that displays the count of returns only for the first year in the table. To do this, we can use the following formula:
IF FIRST () = 0 THEN COUNT (Returns) END
This formula uses the FIRST () function, which returns the number of rows from the current row to the first row in the partition. If the current row is the first row, then FIRST () returns 0. The IF statement checks if this condition is true, and if so, it returns the count of returns for that row. Otherwise, it returns NULL.
To complete the formula in the calculated field, you should select the following options from the drop-down menus:
* FIRST ()
* 0
* COUNT (Returns)
https://help.tableau.com/current/pro/desktop/en-us/functions_functions_date.htm

出題：6

When should a Data Analyst use a Treemap in Tableau?

A. To display hierarchical data with nested categories

B. To visualize the change in a measure across different regions in a map

C. To analyze the distribution of a measure over time

D. To show the correlation between two continuous variables

正解：A 解答を投票する

出題：7

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?

正解：

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

出題：8

A Data Analyst has the following bar chart.

The analyst wants the chart to appear as shown in the following exhibit.

What should the analyst add?

A. A distribution band

B. A reference line

C. An average line

D. A reference band

正解：A 解答を投票する

出題：9

Which syntax should a Data Analyst use to find the first purchase date per customer when Customer is not in the view?

A. MIN([Purchase Date])

B. [Customer ID] : { [Purchase Date] }

C. [Customer ID] : MIN([Purchase Date])

D. { FIXED [Customer ID] : MIN([Purchase Date]) }

正解：D 解答を投票する

出題：10

You have the following dataset:

Which grouping option should you use in Tableau Prep to group all five names automatically?

A. Manual Selection

B. Common Characters

C. Spelling

D. Pronunciation

正解：B 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：11

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.

正解：

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

TDA-C01試験無料問題集「Tableau Certified Data Analyst 認定」