[2025年04月]更新のTDA-C01問題集本日限定!無料アクセス可能に!GoShikenで試そう [Q48-Q73]

Share

[2025年04月]更新のTDA-C01問題集本日限定!無料アクセス可能に!GoShikenで試そう

学習材料は有効TDA-C01効率的問題集!


Tableau TDA-C01認定試験は、データ分析と可視化のためにTableauを使用する専門家のスキルを証明するために設計されています。この試験は、データの準備、データ分析、可視化、共有など、データ分析に必要な幅広いトピックをカバーしています。試験は、実際の世界のデータ分析の問題を解決するためにTableauを使用する候補者のスキルと知識をテストするよう設計されています。

 

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

正解:

解説:
Send us your feedback on it


質問 # 49
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


質問 # 50
You have the following box plot that shows the distribution of average profits made in every state by region.

Which region has the smallest distribution of profits?

  • A. Cast
  • B. South
  • C. Central
  • D. West

正解:C

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


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

正解:

解説:
Send us your feedback on it


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

正解:

解説:


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

正解:C


質問 # 54
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. Set Discount to Dual Axis
  • D. Drag Discount to the Columns shelf

正解:B


質問 # 55
Open the link to Book1 found on the desktop. Open SalesVSProfit worksheet.
Add a distribution band on Profit to show the standard deviation from- 1 to 1.

  • A. check the steps below in explanation

正解:A

解説:
To add a distribution band on Profit to show the standard deviation from -1 to 1, 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 SalesVSProfit worksheet.
Click on the SalesVSProfit tab at the bottom of the workbook to open the worksheet. You will see a scatter plot that shows the relationship between Sales and Profit for each Sub-Category.
Click on the Analytics tab on the left side of the workbook to open the Analytics pane. You will see a list of analytical objects that you can drag and drop onto your worksheet.
Drag Distribution Band from the Analytics pane to Profit on the Rows shelf. This will add a distribution band on Profit that shows the average and confidence interval for each Sub-Category.
Click on the Edit button on the distribution band to open the Edit Distribution Band dialog box. You will see options to customize your distribution band.
Change the Band From value to -1 and the Band To value to 1. This will change the distribution band to show the standard deviation from -1 to 1, which means one standard deviation below and above the average.
Click OK to apply the changes. You will see that the distribution band now shows a narrower range of values for Profit.


質問 # 56
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. check the steps below in explanation

正解:A

解説:
To replace the existing data source with the Netflix_2019 data source, 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 Movie Durations worksheet.
Click on the Movie Durations tab at the bottom of the workbook to open the worksheet. You will see a bar chart that shows the number of movies by duration for the existing data source.
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 existing 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 Netflix_2019 from the list of available data sources and click OK. This will replace your existing data source with the Netflix_2019 data source and update your worksheet accordingly. You may need to fix any broken fields or calculations that result from the replacement.


質問 # 57
You have the following box plot that shows the distribution of average profits made in every state by region.

Which region has the smallest distribution of profits?

  • A. Cast
  • B. South
  • C. Central
  • D. West

正解:B

解説:
The box plot visualization displays the distribution of average profits by region. The distribution of profits is represented by the range of the box (interquartile range) and the whiskers (which often represent the total range excluding outliers). From the image provided, the South region has the smallest visible range within its box and the shortest whiskers, indicating the smallest distribution of average profits among the choices provided.


質問 # 58
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%.

正解:

解説:
Send us your feedback on it


質問 # 59
You are developing a data source in Tableau Prep.
You have two tables named Orders and Employees.
The Orders table was created in 2019 and contains the following columns.

The Employees table contains all the employee information for the various sales teams in the sales department and contains the following columns

You want to prepare the data so that you can analyze sales trends over time for every sales team.
Which three actions should you perform in order? (Place the three correct options in order. Use the arrows to move Options to Answer Area. Use Answer Area arrows to re-order the options.)

正解:

解説:

Explanation:

There are different ways to prepare the data in Tableau Prep, but one possible answer is:
Answer area:
Join the tables.
Aggregate the data by Sales Team.
Add the following filter to the Employees table: Sale Team - Team Alpha.
To analyze sales trends over time for every sales team, you need to combine the data from the Orders and Employees tables. You can do this by joining the tables on the Rep ID column, which is a common identifier for both tables. This will create a single table with all the columns from both tables. Next, you need to aggregate the data by Sales Team, which is the level of analysis you want. You can do this by grouping the data by the Sales Team column and applying an aggregation function (such as sum, average, count, etc.) to the other columns that you want to measure (such as Total Amount, Rep Tenure, etc.). This will create a summary table with one row for each sales team and the aggregated values for the other columns. Finally, you need to filter the data to focus on a specific sales team, such as Team Alpha. You can do this by adding a filter to the Employees table and selecting only the rows where Sales Team equals Team Alpha. This will remove the rows for other sales teams and keep only the data for Team Alpha.
References:
[Tableau Certified Data Analyst Exam Prep Guide], page 9, section "Preparing Data"
[Tableau Help: Join Your Data]
[Tableau Help: Aggregate Your Data]
[Tableau Help: Filter Your Data]


質問 # 60
You have the following dataset in Microsoft Excel.

You are using interpreter to cleans the dataset. Data interpreter provides the following results.

How many rows of data will be ingested into Tableau as values?

  • A. 0
  • B. 1
  • C. 2
  • D. 3

正解:C


質問 # 61
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%.

  • A. check the steps below in explanation

正解:A

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


質問 # 62
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. Book1.twb
  • B. Export mdb
  • C. Sales.hyper
  • D. Sales.csv

正解:C

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


質問 # 63
You have the following primary data source that contains a dimension named Dorm_Code.

You receive the following secondary data source that contains updated dorm codes.

You need to bring the updated dorm codes into Tableau and use the codes in existing visualizations. The new dorm codes must use the existing field name of Dorm_Code.
What should you do?

  • A. Bring in the secondary data source as a union.
  • B. Create a data blend and select Edit Primary Aliases to replace the primary data source alias values with values from the secondary data source
  • C. Bring in the secondary data source by using relationships. From the Data pane, right-click Dorm_Name select Replace References, and then select Dorm_Name_New
  • D. Bring in the secondary table as a left join to the primary data source. From the Data Source page, select Create Calculated Field in the Dorm_Name field and enter [Dcrm_Name_New] in the calculation window

正解:C

解説:
Using relationships: You can use relationships to link the secondary data source with the primary data source based on a common field. This will allow you to use fields from both data sources in your visualization without creating new fields or duplicating data. You can then replace references to update the dimension values. For example, you can use relationships to link the updated dorm codes with the primary data source and then replace Dorm_Code with Dorm_Code_New in your visualization.
https://community.tableau.com/s/question/0D54T00000C5ldZSAR/update-data-view-based-on-dimension To update existing visualizations with new codes without changing the field name, using relationships to bring in the secondary data source is appropriate. Then using Replace References allows you to update the references from the old dorm codes to the new ones while maintaining the existing field name.


質問 # 64
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. Right-click a bar in the chart select Mark Label and then select Always show.
  • B. Right-click a in the chat, select Annotate and then select Mark.
  • C. Drag Region to Tooltip on the Marks card
  • D. Edit the aliases for City.

正解:C

解説:
To show the corresponding region when users hover their mouse over any of the bars, you need to drag Region to Tooltip on the Marks card. This will add Region as a field in the tooltip text that appears when users hover over a mark. You can also customize the tooltip text by editing it in the Tooltip dialog box. Reference: https://help.tableau.com/current/pro/desktop/en-us/buildmanual_shelves.htm https://help.tableau.com/current/pro/desktop/en-us/formatting_tooltips.htm


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

正解:

解説:


質問 # 66
You have the following calculated fields in a worksheet.
[Calc1] = DATEADD ('year', -1, TODAY ())
[Calc2] = DATETRUNC ( 'month' , DATEADD ('year', -1, TODAY ())
You want to calculate the month to date value of the prior year.
How should you complete the formula? (Drag the appropriate Options to the Answer Area and drop into the correct locations.)

正解:

解説:

Explanation:
A screenshot of a computer Description automatically generated

To calculate the month to date value of the prior year, you need to filter the order date to be between the first day of the same month of the previous year and the same day of the previous year. You can use the calculated fields [Calc1] and [Calc2] to get these dates. [Calc1] returns the date that is one year before today, and [Calc2] returns the date that is the first day of the month of [Calc1]. By using these fields in the filter condition, you can get the desired result.
References:
Finding the Month-to-Date Values for the Prior Year
[DATEADD Function]
[DATETRUNC Function]


質問 # 67
You have the following visualization.

The Last() calculation is set to compute using Table (across)
Which value will appear in the crosstab for the Consumer segment of the year 2018 if you change compute to use Oder Dale?

  • A. 0
  • B. 1
  • C. 2
  • D. 3

正解:D


質問 # 68
In a dataset, you have a string field named Name that contains unnecessary semicolons.
Which function should you use to remove the semicolons from the Name field?

  • A. TRIM
  • B. SPLIT
  • C. REPLACE
  • D. CONTAINS

正解:C

解説:
The REPLACE function is used to replace all occurrences of a substring within a string with another substring.
In this case, it can be used to remove the semicolons from the Name field by replacing them with an empty string. For example, REPLACE ("John;Doe", ";", "") = "JohnDoe". References: The information is based on the following sources:
String Functions - Tableau
Remove special characters and add a semi colon in a word - Tableau


質問 # 69
You want to create the following dashboard.

The dashboard will contain two sheets that will connect to the same data source. The top sheet will be configured to filter the bottom sheet.
When you click a category on the top sheet, the sheets must resize as shown in the following exhibit.

How should you lay out the objects on the dashboard?

  • A. Drag a horizontal container to the dashboard and add both sheets to the container. Set the Fit to Standard.
  • B. Drag a vertical container to the dashboard and add both sheets to the container. Set Fit to Entire view.
  • C. Add both sheets to the dashboard. Set Fit to Fix width.
  • D. Drag a blank object to the dashboard and add both sheets to the dashboard. Set Fit to Entire view.

正解:B

解説:
To create the dashboard as shown in the image, you need to use a vertical layout container that will adjust the height of the sheets according to the window size. You also need to set the Fit to Entire view option for both sheets so that they will resize proportionally when you click a category on the top sheet. This way, you can achieve the desired effect of having the bottom sheet expand to fill the space left by the top sheet when it filters out some categories. Reference:
Size and Lay Out Your Dashboard - Tableau
Create a Dashboard - Tableau
Format Dashboard Layout in Tableau - GeeksforGeeks


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

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

正解:A


質問 # 71
You have the following tiled dashboard that has one sheet.

You want to replace fit sheet with Sheet2.
What should you do?

  • A. Drag Sheet2 to the dashboard.
  • B. From the context menu of Sheet3. select Deselect
  • C. From the context menu of Sheet3. select Remove Dashboard item
  • D. Right-click Sheet2 and select Add to Dashboard.
  • E. Select Sheets and click the Swap Sheet button next to Sheet2.

正解:A

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


質問 # 72
You have the following dashboard.

Currently the map is used as a filter that affects the data on the otter sheets of the dashboard You need to configure the dashboard to ensure that selecting a data point on the map only tillers the Detail table What should you do?

  • A. From the context menu of Sales over lime select Remove Dashboard Item
  • B. From the context menu of Sales over time select Deselect
  • C. From the context menu of Sales over time select Ignore Actions
  • D. From the context menu of Profits by Stale deselect Use as Filter

正解:C


質問 # 73
......

最新のTDA-C01試験エンジンPDFで全部無料問題集保証:https://www.goshiken.com/Tableau/TDA-C01-mondaishu.html

最新Tableau Certified TDA-C01実際の無料試験解答:https://drive.google.com/open?id=1dHDMfZ4tNB135yYT_JctzfO3PUlLOjA9