Online Access Free Analytics-Con-301 Practice Test

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 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.
• B.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.
• C.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.
• D.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.

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.A calculated field that uses the LEFT function
• C.The Aliases option
• D.The Split option

A consultant has a view using a table calculation to calculate percent of total Sales by Category. The consultant would like to filter out particular categories, but wants the percent of total calculation to remain steady even as they filter items in or out.
What should the consultant do to achieve the desired impact?

• A.Create a FIXED Level of Detail (LOD) expression, and then use that instead of the table calculation.
• B.Filter Category by using a Data Source Filter instead of a Dimension Filter.
• C.Filter Category by using a Context Filter instead of a Dimension Filter.
• D.Create an aggregate expression, and then use that instead of the table calculation.

A Tableau Cloud client has requested a custom dashboard to help track which data sources are used most frequently in dashboards across their site.
Which two actions should the client use to access the necessary metadata? Choose two.

• A.Access metadata through the Metadata API.
• B.Download metadata through Tableau Catalog.
• C.Query metadata through the GraphiQL engine.
• D.Connect directly to the Site Content data source within the Admin Insights project.

A university has data on its undergraduate students and their majors by grade level (Freshman, Sophomore, Junior, Senior). The university is interested in visualizing the path students take as they change majors across grade levels.
Which visualization type should the consultant recommend?

• A.Sankey Diagram
• B.Tree Chart
• C.Chord Chart
• D.Radar Chart