あなたを合格させる試験には100%確認済みTDA-C01試験問題 [Q16-Q38]

あなたを合格させる試験には100%確認済みTDA-C01試験問題

TDA-C01問題集PDFでTDA-C01リアル試験問題解答

Tableau TDA-C01（Tableau Certified Data Analyst）試験は、Tableauを使用したデータ分析に熟練したい個人向けに設計された認定試験です。試験は、Tableauを使用したデータ可視化、データブレンディング、およびデータ分析の候補者の知識をテストするように設計されています。認定は、世界中の多くの組織によって認識され、評価されており、データ分析の分野において非常に求められる認定資格となっています。

Tableau TDA-C01認定試験は、複数選択問題からなるコンピュータベースの試験です。試験時間は2時間で、合格点は75％です。試験は2つのセクションに分かれており、第1セクションはTableau Desktopの機能をカバーし、第2セクションはデータ分析の概念をカバーしています。候補者は両方のセクションに合格する必要があり、認定を取得するためには両方のセクションを合格する必要があります。

質問 # 16
You have a dataset that contains daily sales by business segment from 2017 to the present You want to use monthly historical trends to predict sales by segment in the future Which three actions should you perform m order?
(Place the three correct options in order Use the arrows to move Options lo Answer Area I In Answer Area arrows to re order the options.)

正解：

解説：

1 - Aggregate the date to month and year
2 - Create a calculated field that uses the MODEL_QUANTILE function.
3 - Add the date to the Columns shelf Add the segment and the sales to the Rows shelf

質問 # 17
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)

正解：

解説：

1 - Open Tableau Prep
2 - Union the sales data of both divisions
3 - Create a new column to concatenate the name for the Germany division
4 - Join the sales data and the population data by using Country as the join field

質問 # 18
You have the following dataset.

Yon need to calculate the ranking shown in the Rank field.
How should you complete the formula? (Use the dropdowns in the Answer Area to select the correct options to complete the formula ?

正解：

解説：

質問 # 19
You have the following dataset.

Which grouping option should you use m Tableau Prep to group al five names automatically?

A. Pronunciation
B. Manual Selection
C. Spelling
D. Common Characters

正解：B

質問 # 20
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'

正解：A、D

解説：
End
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 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

質問 # 21
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)

正解：

解説：

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.

質問 # 22
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 Replace Data Source
B. From the Data menu select New Data Source
C. From the File menu select Import Workbook
D. From the File menu select New

正解：D

質問 # 23
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: [Region] SUM Sales}
C. {Fixed: [Region]: TOTAL Sales}
D. {FIXED: TOTAL (Sales)}

正解：A

解説：
The correct Level of Detail (LOD) expression to calculate the grand total of sales across all regions would be {SUM(Sales)}. The FIXED expression is not needed here because we are not computing the sum at the level of each region, but rather the total sum across all regions. The FIXED keyword is typically used to aggregate at a certain level regardless of the view.
https://help.tableau.com/current/pro/desktop/en-us/functions_functions_tablecalculation.htm#TOTAL

質問 # 24
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. IF [Profits] != null then [Profits] END
C. IFNULL([Profits],0)
D. ISNULL ([Profits])
E. IF [Profits] != null then [Profits] END
F. IFNULL [(profits] ,0)

正解：B、F

解説：
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:

質問 # 25
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)

正解：

解説：

1 - Open Tableau Prep
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 Country as the join field

質問 # 26
Open the link to Book1 found on the desktop. Open the Movie Durations worksheet.
Replace the existing data source with the Netflix_2019 data source.

正解：

解説：
Send us your feedback on it

質問 # 27
You have a dataset that has four fields named Category. Profit Sates and Customer Name. You need to create the following visualization.

正解：

解説：

質問 # 28
You have two tables named Employeelnfo and DepartmentInfo. Employeelnfo contains four fields named Full Name, Department ID, Start Date, and Salary.
DepartmentInfo contains four fields named Department Name, Size, Department ID, and VP.
You want to combine the tables to meet the following requirements:
. Each record in Employeelnfo must be retained in the combined table.
. The records must contain the Department Name, Size, and VP fields.
Every record must have a full name.
Which type of join should you use?

A. Union
B. Full outer
C. Left
D. Inner

正解：C

解説：
To combine the tables and meet the requirements, you should use a left join. A left join will keep all the records from the left table (Employeelnfo) and match them with the records from the right table (DepartmentInfo) based on the common field (Department ID). If there is no matching record in the right table, the fields from the right table will be null. This way, you will retain all the records from Employeelnfo, and also include the Department Name, Size, and VP fields from DepartmentInfo. Every record will have a full name because it is a field from the left table. A left join will look like this:
References:
Join Your Data - Tableau
Join Types in Tableau

質問 # 29
You want to show the cumulative total of each year for every state.
Which quick table calculation should you use?

A. Running Total
B. YTD Total
C. VTD Growth
D. Year Over Year Growth

正解：A

質問 # 30
You have a database that includes field named sales, City and Region.
You have the following chart that shows the number of sales made in different cities.

You want to dynamically show the corresponding region when users hover their mouse over any of the bars.
What should you do?

A. Edit the aliases for City.
B. Right-click a bar in the chart select Mark Label and then select Always show.
C. Drag Region to Tooltip on the Marks card
D. Right-click a in the chat, select Annotate and then select Mark.

正解：D

質問 # 31
Open the link to Book1 found on the desktop. Open the Line worksheet.
Modify the chart to show only main and max values of both measures in each region.

正解：

解説：
To modify the chart to show only min and max values of both measures in each region, 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 Line worksheet.
Click on the Line tab at the bottom of the workbook to open the worksheet. You will see a line chart that shows the sales and profit for each month by region.
Drag Month from the Columns shelf to Filters shelf. This will open a dialog box that allows you to filter by different criteria.
Select Range of Dates from the dialog box. This will show you options to filter by a range of dates or values.
Select Minimum and Maximum from the drop-down list next to Month. This will filter by the minimum and maximum values of Month for each region. You can also enter specific values or use the sliders to adjust the range.
Click OK to apply the filter. You will see that the line chart now shows only min and max values of both measures in each region.

質問 # 32
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.)

正解：

解説：

Explanation:
A screenshot of a computer Description automatically generated

質問 # 33
Open the link to Book1 found on the desktop. Open the Movie Durations worksheet.
Replace the existing data source with the Netflix_2019 data source.

A. Send us your
B. Send us your feedback on it.

正解：B

質問 # 34
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 Deselect.
B. Select Sheet3 and click the Swap Sheet button next to Sheet2.
C. Drag Sheet2 to the dashboard.
D. Right-click Sheet2 and select Add to Dashboard.
E. From the context menu of Sheet3, select Remove Dashboard Item.

正解：C

解説：
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 where the current sheet (Sheet3) is. This will replace the existing visualization with the new one.

質問 # 35
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: [Region] SUM Sales}
C. {FIXED: TOTAL (Sales)}
D. {Fixed: [Region]: TOTAL Sales}

正解：C

解説：
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

質問 # 36
You have a line chart on a worksheet.
You want to add a comment to March 2020 as shown in the following visualization.
What should you do?

A. Enable captions
B. Annotate March 2020
C. Drag the growth rate to Text on the Marks card
D. Add a tooltip

正解：B

解説：
To add a comment to March 2020 on a line chart, you need to annotate that mark. You can right-click on the mark and select Annotate > Mark from the menu. This will open a dialog box where you can type your comment and format it as you like. You can also drag and drop the annotation to position it on the worksheet. Dragging the growth rate to Text on the Marks card will add a label to every mark on the line chart, enabling captions will show a description of the worksheet at the bottom, and adding a tooltip will show a text box when users hover over a mark. Reference: https://help.tableau.com/current/pro/desktop/en-us/formatting_annotations.htm https://help.tableau.com/current/pro/desktop/en-us/formatting_annotations_create.htm

質問 # 37
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.)

正解：

解説：

質問 # 38
......

Tableau TDA-C01（Tableau Certified Data Analyst）認定試験は、Tableauを使用したデータ分析のスキルと専門知識を検証する、世界的に認められた資格です。この認定試験は、データを使用して複雑なビジネス問題を解決する能力を示し、Tableauの熟練度を証明したい専門家を対象に設計されています。

TDA-C01問題集100合保証には最新のサンプル：https://www.passtest.jp/Tableau/TDA-C01-shiken.html

準備TDA-C01問題解答無料更新には100%試験合格保証 [2025年更新]：https://drive.google.com/open?id=107i-ynEWpqX2SIoQRV1kyAkyphEEYy0s

関するブログ

もっと

TDA-C01 無料問題集