Tableau TCC-C01 問題集

質問 1：
An online sales company has a table data source that contains Order Date. Products ship on the first day of each month for all orders from the previous month.
The consultant needs to know the average number of days that a customer must wait before a product is shipped.
Which calculation should the consultant use?
A. Calc1: DATETRUNC ('month', DATEADD('month', 1, [Order Date]))
Calc2: AVG(DATEDIFF ('week', [Order Date], [Calc1]))
B. Calc1: DATETRUNC ('day', DATEADD ('day', 31, [Order Date]))
Calc2: AVG ([Order Date] - [Calc1])
C. Calc1: DATETRUNC ('month', DATEADD ('month', 1, [Order Date]))
Calc2: AVG(DATEDIFF ('day', [Order Date], [Calc1]))
D. Calc1: DATETRUNC ('day', DATEADD('week', 4, [Order Date]))
Calc2: AVG([Order Date] - [Calc1])
正解：C
解説: (Topexam メンバーにのみ表示されます)

質問 2：
A client wants to count all the distinct orders placed in 2010. They have written the following calculation, but the result is incorrect.
IF YEAR([Date])=2010 THEN COUNTD ([OrderID]) END
Which calculation will produce the correct result?
A. IF MIN(YEAR([Date]))=2010 THEN WINDOW_COUNTD([OrderID]) END
B. COUNT(IF YEAR([Date])=2010 THEN [OrderID] END)
C. COUNTD(IF YEAR([Date])=2010 THEN [OrderID] END)
D. IF YEAR([Date])=2010 THEN {COUNTD ([OrderID])} END
正解：C
解説: (Topexam メンバーにのみ表示されます)

質問 3：
A client is working in Tableau Prep and has a field named Orderld that is compiled by country, year, and an order number as shown in the following table.

What should the consultant use to transform the table in the most efficient manner?
A. A calculated field that uses the TRIM function
B. The Split option
C. A calculated field that uses the LEFT function
D. The Aliases option
正解：B
解説: (Topexam メンバーにのみ表示されます)

質問 4：
Use the following login credentials to sign in
to the virtual machine:
Username: Admin
Password:
The following information is for technical
support purposes only:
Lab Instance: 40201223
To access Tableau Help, you can open the
Help.pdf file on the desktop.

From the desktop, open the CC workbook.
Open the Categorical Sales worksheet.
You need to use table calculations to
compute the following:
. For each category and year, calculate
the average sales by segment.
. Create another calculation to
compute the year-over-year
percentage change of the average
sales by category calculation. Replace
the original measure with the year-
over-year percentage change in the
crosstab.
From the File menu in Tableau Desktop, click
Save.
正解：
See the complete Steps below in Explanation:
Explanation:
To compute the required calculations and update the worksheet in Tableau Desktop, follow these steps:
* Compute Average Sales by Segment for Each Category and Year:
* Open the CC workbook and navigate to the Categorical Sales worksheet.
* Drag the 'Sales' field to the Rows shelf if it's not already there.
* Drag the 'Segment' field to the Rows shelf as well, placing it next to 'Category' and 'Year'.
* Right-click on the 'Sales' field in the Rows shelf and select 'Quick Table Calculation' > 'Average'.
This will compute the average sales for each segment within each category and year.
* Create a Calculation for Year-over-Year Percentage Change:
* Right-click in the data pane and select 'Create Calculated Field'.
* Name the calculated field something descriptive, e.g., "YoY Sales Change".
* Enter the formula to calculate the year-over-year percentage change:
(ZN(SUM([Sales])) - LOOKUP(ZN(SUM([Sales])), -1)) / ABS(LOOKUP(ZN(SUM([Sales])), -1))
* Click 'OK' to save the calculated field.
* Replace the Original Measure with the Year-over-Year Percentage Change in the Crosstab:
* Remove the original 'Sales' measure from the view by dragging it off the Rows shelf.
* Drag the newly created "YoY Sales Change" calculated field to the Rows shelf where the 'Sales' field was originally.
* Format the "YoY Sales Change" field to display as a percentage. Right-click on the field in the Rows shelf, select 'Format', and adjust the number format to percentage.
* Save Your Changes:
* From the File menu, click 'Save' to ensure all your changes are stored.
References:
* Tableau Help: Offers guidance on creating calculated fields and using table calculations.
* Tableau Desktop User Guide: Provides instructions on formatting and saving worksheets.
These steps allow you to manipulate data within Tableau effectively, using table calculations to analyze trends and changes in sales data by category and segment over years.

質問 5：
A client is using the Tableau Content Migration Tool to move content from an old Tableau Server to a new Tableau Server.
Which content will need to be moved using a different tool or process?
A. Published data sources that use live connections
B. Workbooks
C. Published data sources that use extracts
D. Tableau Prep flows
正解：D
解説: (Topexam メンバーにのみ表示されます)

質問 6：
A client creates a report and publishes it to Tableau Server where each department has its own user group set on the server. The client wants to limit visibility of the report to the sales and marketing groups in the most efficient manner.
Which approach should the consultant recommend?
A. Grant access to the report on the Tableau Server only to the members of sales and marketing user groups.
B. Add user filters from Tableau Server to each worksheet and select only sales and marketing user groups.
C. Use user groups defined on Tableau Server to build user filters in the report's data source.
D. Prepare a row-level security (RLS) entitlement table to define limitations of the access and use it to build user filters in the report's data source.
正解：A
解説: (Topexam メンバーにのみ表示されます)