Salesforce Analytics-Con-301 問題集

質問 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 provide sales users with the ability to perform the following tasks:
* Access published visualizations and published data sources outside the company network.
* Edit existing visualizations.
* Create new visualizations based on published data sources.
. Minimize licensing costs.
Which site role should the client assign to the sales users?
A. Site Administrator
B. Viewer
C. Explorer (can publish)
D. Creator
正解：C
解説: (Topexam メンバーにのみ表示されます)

質問 3：
A client wants to produce a visualization to show quarterly profit growth and aggregated sales totals across a number of product categories from the data provided below.

Which set of charts should the consultant use to meet the client's requirements?
A. Line and bubble charts
B. Gantt and bar charts
C. Waterfall chart and tree map
D. Scatter plot and pie chart
正解：C
解説: (Topexam メンバーにのみ表示されます)

質問 4：
A client notices that several groups are sharing content across divisions and are not complying with their data governance strategy. During a Tableau Server audit, a consultant notices that the asset permissions for the client's top-level projects are set to "Locked," but that "Apply to Nested Projects" is not checked.
The consultant recommends checking "Apply to Nested Projects" to enforce compliance.
Which impact will the consultant's recommendation have on access to the existing nested projects?
A. Current custom access will be maintained, but new custom permissions will not be granted.
B. Access will be automatically rolled back to the top-level project permissions immediately.
C. Users will be prompted to manually update permissions for all nested projects.
D. Users will be notified that they will automatically lose access to content after 30 days.
正解：B
解説: (Topexam メンバーにのみ表示されます)

質問 5：
SIMULATION
From the desktop, open the CC workbook.
Open the City Pareto worksheet.
You need to complete the Pareto chart to show the percentage of sales compared to the percentage of cities. The chart must show references lines to visualize how the data compares to the Pareto principle.
From the File menu in Tableau Desktop, click Save.
正解：
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：
For a new report, a consultant needs to build a data model with three different tables, including two that contain hierarchies of locations and products. The third table contains detailed warehousing data from all locations across six countries. The consultant uses Tableau Cloud and the size of the third table excludes using an extract.
What is the most performant approach to model the data for a live connection?
A. Joining the tables in Tableau Prep
B. Blending the first two tables with the third
C. Relating the tables in Tableau Desktop
D. Joining the tables in Tableau Desktop
正解：C
解説: (Topexam メンバーにのみ表示されます)