Tableau TCC-C01 問題集

質問 1：
A client wants to flag orders that have sales higher than the regional average.
Which calculated field will produce the required result?
A. { FIXED [Order ID] : SUM([Sales]) }
>
{ FIXED [Region] : AVG({ FIXED [Order ID] : SUM([Sales]) }) }
B. { FIXED [Order ID] : SUM([Sales]) }
>
{ INCLUDE [Region] : AVG({ FIXED [Order ID] : SUM([Sales]) }) }
C. [Sales]
>
{ FIXED [Order ID] : SUM([Sales]) }
D. { FIXED [Order ID] : SUM([Sales]) }
>
{ FIXED [Region] : SUM([Sales]) }
正解：A
解説: (Topexam メンバーにのみ表示されます)

質問 2：
A client calculates the percent of total sales for a particular region compared to all regions.

Which calculation will fix the automatic recalculation on the % of total field?
A. {FIXED [Region]:[Sales]}/{FIXED: SUM([Sales])}
B. {FIXED [Region]:sum([Sales])}
C. {FIXED [Region]:sum([Sales])}/SUM([Sales]}
D. {FIXED [Region]:sum([Sales])}/{FIXED :SUM([Sales])
正解：C
解説: (Topexam メンバーにのみ表示されます)

質問 3：
A client has a published data source in Tableau Server and they want to revert to the previous version of the data source. The solution must minimize the impact on users.
What should the consultant do to accomplish this task?
A. Delete and recreate the data source manually.
B. Select a previous version from Tableau Server, download it, and republish that data source.
C. Request that a server administrator restore a Tableau Server backup.
D. Select a previous version from Tableau Server, and then click Restore.
正解：D
解説: (Topexam メンバーにのみ表示されます)

質問 4：
A consultant migrated a data source to improve performance. The consultant wants to identify which workbooks need to be updated to point to the new data source.
Which Tableau tool should the consultant use?
A. Activity Log
B. Prep Conductor
C. Data Management
D. Tableau Advanced Management
正解：D
解説: (Topexam メンバーにのみ表示されます)

質問 5：
From the desktop, open the CC workbook.
Open the City Pareto worksheet.
You need to complete the Pareto chart toshow the percentage of sales compared tothe percentage of cities. The chart mustshow references lines to visualize how thedata compares to the Pareto principle.
From the File menu in Tableau Desktop, clickSave.
正解：
See the complete Steps below in Explanation:
Explanation:
To complete the Pareto chart in the "City Pareto" worksheet of your Tableau Desktop and add reference lines to illustrate how the data compares to the Pareto principle, follow these steps:
* Open the CC Workbook and Access the Worksheet:
* From the desktop, double-click on the CC workbook to open it in Tableau Desktop.
* Navigate to the City Pareto worksheet by selecting its tab at the bottom of the window.
* Construct the Pareto Chart:
* Ensure that sales data is aggregated by city. If not, drag the 'City' dimension to the Columns shelf and the 'Sales' measure to the Rows shelf.
* Sort the sales data in descending order to properly align the cities according to their sales contribution.
* To create a running total of sales, right-click on the 'Sales' measure on the Rows shelf, select
'Quick Table Calculation', and choose 'Running Total'.
* Drag the 'Number of Records' field to the Rows shelf next to the Sales running total. Right-click on it, select 'Quick Table Calculation', and choose 'Running Total'. Set its calculation to 'Percent of Total' from the 'Edit Table Calculation' option to represent the percentage of cities.
* Add Reference Lines for the Pareto Principle:
* Click on the Analytics tab in the sidebar.
* Drag a 'Reference Line' element and drop it onto the chart area.
* Set the Reference Line for the Sales axis at 80% to represent the typical Pareto cutoff where 80% of effects come from 20% of causes.
* Add another Reference Line on the axis representing the percentage of cities, set at 20%, to visually assess the Pareto principle.
* Adjust the Appearance of the Chart:
* Format the reference lines by right-clicking on them, selecting 'Edit', and choosing a distinct style or color to make them stand out.
* Ensure the chart is clear and labels are appropriately adjusted for easy understanding of the data visualization.
* Save Your Changes:
* From the File menu, click 'Save' to ensure all your changes are stored.
References:
* Tableau Help: Offers detailed guidance on creating Pareto charts and adding reference lines.
* Tableau Visualization Best Practices: Provides tips on effectively displaying cumulative data and principles such as Pareto.
By following these steps, you will have successfully enhanced the City Pareto worksheet to include a complete Pareto chart with reference lines that illustrate how the sales data compares to the Pareto principle, making it easier to analyze and communicate the distribution of sales across cities.

質問 6：
A client is searching for ways to curate and document data in order to obtain data lineage. The client has a data source connected to a data lake.
Which tool should the consultant recommend to meet the client's requirements?
A. Tableau Catalog with Tableau Server Management Add-on
B. Tableau Catalog with Tableau Data Management Add-on
C. Tableau Catalog without Tableau Data Management Add-on
D. Tableau Prep Conductor
正解：B
解説: (Topexam メンバーにのみ表示されます)