最新なTableau TCC-C01問題集（57題）、真実試験の問題を全部にカバー！

質問 1：
A client is considering migrating from Tableau Server to Tableau Cloud.
Which two elements are determining factors of whether the client should use Tableau Server or Tableau Cloud? Choose two.
A. Whether or not the client needs the ability to connect to public, cloud-based data sources
B. Amount of data storage used on the client's existing server
C. Whether or not the client plans to leverage single sign-on (SSO)
D. Whether or not there are large numbers of concurrent extract refreshes
正解：C,D
解説: (Pass4Test メンバーにのみ表示されます)

質問 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 YEAR([Date])=2010 THEN {COUNTD ([OrderID])} END
B. COUNTD(IF YEAR([Date])=2010 THEN [OrderID] END)
C. COUNT(IF YEAR([Date])=2010 THEN [OrderID] END)
D. IF MIN(YEAR([Date]))=2010 THEN WINDOW_COUNTD([OrderID]) END
正解：B
解説: (Pass4Test メンバーにのみ表示されます)

質問 3：
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.

質問 4：
A client wants to see the average number of orders per customer per month, broken down by region. The client has created the following calculated field:
Orders per Customer: {FIXED [Customer ID]: COUNTD([Order ID])}
The client then creates a line chart that plots AVG(Orders per Customer) over MONTH(Order Date) by Region. The numbers shown by this chart are far higher than the customer expects.
The client asks a consultant to rewrite the calculation so the result meets their expectation.
Which calculation should the consultant use?
A. {INCLUDE [Customer ID]: COUNTD([Order ID])}
B. {FIXED [Customer ID], [Region], [Order Date]: COUNTD([Order ID])}
C. {EXCLUDE [Customer ID]: COUNTD([Order ID])}
D. {FIXED [Customer ID], [Region]: COUNTD([Order ID])}
正解：D
解説: (Pass4Test メンバーにのみ表示されます)

質問 5：
A company has a data source for sales transactions. The data source has the following characteristics:
. Millions of transactions occur weekly.
. The transactions are added nightly.
. Incorrect transactions are revised every week on Saturday.
The end users need to see up-to-date data daily.
A consultant needs to publish a data source in Tableau Server to ensure that all the transactions in the data source are available.
What should the consultant do to create and publish the data?
A. Publish an incremental extract refresh every day and publish a secondary data set containing data revisions.
B. Publish an incremental refresh every Saturday.
C. Publish a live connection to Tableau Server.
D. Publish an incremental extract refresh every day and perform a full extract refresh every Saturday.
正解：D
解説: (Pass4Test メンバーにのみ表示されます)

質問 6：
A new Tableau user created a simple dashboard on Tableau Server using supply chain data. Now, the user wants to know if they created the dashboard in accordance with specific performance best practices.
Which approach should the consultant recommend for the client to make this determination?
A. Use inbuilt dashboards in Tableau Server to troubleshoot the performance.
B. Use Performance Recording in Tableau Desktop.
C. Run Workbook Optimizer.
D. Use Performance Recording on Tableau Server.
正解：C
解説: (Pass4Test メンバーにのみ表示されます)