Salesforce Analytics-Con-301 問題集

質問 1：
A company has a sales team that is segmented by territory. The team's manager wants to make sure each sales representative can see only data relevant to that representative's territory in the team Sales Dashboard.
The team is large and has high turnover, and the manager wants the mechanism for restricting data access to be as automated as possible. However, the team does not have a Tableau Data Management license.
What should the consultant recommend to meet the company's requirements?
A. Create separate workbooks for each territory. Publish each dashboard to the same Sales Dashboard project, and set permissions so each sales representative can see only the dashboards for their territories.
B. Create a user filter in the Sales Dashboard workbook and map each sales representative to the territories they are responsible for. Publish this dashboard to the Sales Dashboard project and ensure all users have permissions to view the dashboard.
C. Create one group for each territory and assign sales representatives to the appropriate groups. Map each group to a territory in the Sales Dashboard. Publish this dashboard to the Sales Dashboard project and ensure all users have permissions to view the dashboard.
D. Create a data source by joining the sales data table to an entitlements data table. Add a data source filter to restrict access and publish the data source. Connect the Sales Dashboard to this published data source.
正解：D
解説: (Topexam メンバーにのみ表示されます)

質問 2：
A client wants to migrate their Tableau Server to Tableau Cloud. The Tableau Server is configured with three sites: Finance, Strategy, and Marketing. A consultant must provide a solution that minimizes user impact and costs.
Which configuration should the consultant recommend for Tableau Cloud to meet the client's requirements?
A. One Tableau Cloud instance configured with a Finance project folder, Strategy project folder, and Marketing project folder
B. One Tableau Cloud instance with two sites for Strategy and Marketing, and one Tableau Server instance for Finance
C. Three separate Tableau Cloud instances for Finance, Strategy, and Marketing
D. One Tableau Cloud instance configured with all workbooks in a single project
正解：A
解説: (Topexam メンバーにのみ表示されます)

質問 3：
A consultant updates an IF-THEN calculation to use a newly created calculated field "Last Name" (parsed from "Full Name"). After the change, performance becomes noticeably worse.
Which two options should the consultant use to improve dashboard performance without altering functionality? Choose two.
A. Change the IF THEN calculation to a CASE statement.
B. Redesign the dashboard to replace Quick Filters with Action Filters.
C. Precalculate "Last Name" in the data source and use it.
D. Calculate "Last Name" in the IF THEN calculation.
正解：B,C
解説: (Topexam メンバーにのみ表示されます)

質問 4：
A client is migrating their data warehouse. They visualize the data in workbooks hosted on Tableau Server with Tableau Data Management enabled and want to see how many workbooks will be impacted.
What should the consultant do to quickly identify how many workbooks will be impacted?
A. Leverage the Tableau Developer API to query the workbooks' metadata.
B. Open each workbook and identify the data source.
C. Complete the migration and let users report errors as they are noticed.
D. In Tableau Server, select the database from External Assets, then select the Lineage tab.
正解：D
解説: (Topexam メンバーにのみ表示されます)

質問 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 メンバーにのみ表示されます)

質問 7：
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 メンバーにのみ表示されます)

質問 8：
A client has a dashboard that renders in less than 10 seconds. The client receives a request to add a new calculated field that will return TRUE if a Project contains any one of the values "Project 1" or "Project 2" and FALSE otherwise. After adding the function found below, the dashboard's render time increases to 14 seconds from 10 seconds.
[Project] = 'Project 1' OR [Project] = 'Project 2'
Which function should the consultant use to reduce the render time?
A. [Project] IN ('Project 1' OR 'Project 2')
B. [Project] = 'Project 1' AND [Project] = 'Project 2'
C. (([Project] = 'Project 1') OR ([Project] = 'Project 2'))
D. [Project] IN ('Project 1', 'Project 2')
正解：D
解説: (Topexam メンバーにのみ表示されます)