Certified Tableau ConsultantPreview

A consultant builds a report where profit margin is calculated as SUM([Profit]) / SUM([Sales]). Three groups of users are organized on Tableau Server with the following levels of data access that they can be granted.
Group 1: Viewers who cannot see any information on profitability
Group 2: Viewers who can see profit and profit margin
Group 3: Viewers who can see profit margin but not the value of profit
Which approach should the consultant use to provide the required level of access?

A transport and delivery company uses a command center dashboard in its logistics and distribution hubs. The dashboard is displayed on screens to show fleet movements, delivery status, and warehouse operations. The company needs the dashboard to provide up-to-date information without human intervention. The company’s environment cannot access the internet, and the data source is configured to maintain a real-time connection.
How should the company meet this requirement?

Sales managers use a daily extract from Snowflake to see the previous day’s snapshot. Sales managers should only be able to see statistics for their direct reports. The company has access to data management on Tableau Cloud. A Tableau consultant needs to design a centralized, low-maintenance row-level security (RLS) strategy to meet these requirements.
What should the consultant implement to ensure a low-maintenance RLS strategy?

During a Tableau Cloud implementation, a Tableau consultant has been tasked with implementing row-level security (RLS). They have already invested in implementing RLS within their own database for their legacy reporting solution. The client wants to know if they will be able to leverage their existing RLS after the Tableau Cloud implementation.
Which two requirements should the Tableau consultant share with the client? (Choose two.)

A client has a Tableau Cloud deployment. Currently, dashboards are available to only internal users. The client needs to embed interactive Tableau visualizations on their public website. The data for the visualization will be less than 5,000 rows, and the data will be updated infrequently with a manual refresh. The cost of the product is a priority for the client.
Which product should the client use to meet their needs?

A client provides survey data to a Tableau consultant in an Excel file with the following structure.

The client would like to see how many survey respondents agree with each statement in columns B, C, and D. The consultant connects to the Excel file in Tableau Desktop.
Which steps should the consultant take next to provide the requested information?

A client has a data source that stores a time stamp for each time a user interacts with a product feature. They visualize 3 years of data at the daily level. As adoption has grown over the last 6 months, the dashboard performance has steadily decreased, despite connecting via a data extract that is set to refresh every hour.
A Tableau consultant needs to improve performance of the dashboard with the least impact to the visualization.
Which option meets these requirements without additional cost?

A client collects information about a web browser customers use to access their website. They then visualize the breakdown of web traffic by browser version. The data is stored in the format shown below in the related table, with a NULL BrowserID stored in the Site Visitor Table if an unknown browser version accesses their website.

The client uses “Some Records Match” for the Referential Integrity setting because a match is not guaranteed. The client wants to improve the performance of the dashboard while also getting an accurate count of site visitors.
Which modifications to the data tables and join should the consultant recommend?

A stakeholder has multiple files saved (CSV/Tables) in a single location. A few files from the location are required for analysis. Data transformation (calculations) is required for the files before designing the visuals. The files have the following attributes.
All files have the same schema.
Multiple files have something in common among their file names.
Each file has a unique key column.
Which data transformation strategy should the consultant use to deliver the best optimized result?

A client wants guidance for Creators to build efficient extracts from large data sources.
Which three Tableau best practices should the Creators use? (Choose three.)

A database contains two related tables at different levels of granularity. The client wants to make all data available in Tableau Prep at the original level of granularity.
Which two solutions in Tableau meet the client’s requirements? (Choose two.)

A business analyst needs to create a view in Tableau Desktop that reports data from both Excel and MSSQL Server.
Which two features should the business analyst use to create the view? (Choose two.)

A client wants to view stores serviced by delivery drivers on a map. They have the information provided in the table below.

What does the client need to do to plot exact street addresses on the map?

A consultant is assisting a client to develop a specific dashboard. The current dashboard has the following configurations.
The dashboard uses a live connection to MySQL.
The dataset has approximately 10 million rows of daily data.
The dataset uses only 10% of the fields.
The data is updated once a month on the last day of the month.
The company only requires data at the month level.
The client wants to optimize the workbook and ensure that other users can use the data source.
What should the consultant do to meet the client’s requirements?

A consultant wants to improve the performance of reports by moving calculations to the data layer and materializing them in the extract.
Which type of calculation is the consultant able to move?

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 client is working in Tableau Prep and has a field named OrderID that is compiled by country, year, and an order number as shown in the following table.

They want to transform the table to appear as shown.

What should the consultant use to transform the table in the most efficient manner?

A customer migrated from Tableau Server to Tableau Cloud. However, there is still private network data behind the corporate firewall that Tableau Cloud needs to access securely.
Which data connection strategy should a Tableau consultant advise with minimal software maintenance by the customer?

A company has a Tableau dashboard that visualizes healthcare cost trends over time. The dashboard is connected to an extracted data source that uses Custom SQL to join two tables: a Claims table storing healthcare claims and a Members table storing member demographics. Each member can have many records in the Claims table, and each member can also have many records in the Members table.
Stakeholders at the company discover that the dashboard shows inaccurate trending data. Members’ claim costs are multiplied by the number of records the members have in the Members table. A consultant must resolve this issue while optimizing dashboard performance and ease of maintenance.
Which approach should the consultant use to solve this issue and meet the requirements?

A client’s fiscal calendar runs from February 1 through January 31.
How should the consultant configure Tableau to use the client’s fiscal calendar when building date charts?

A client wants to know which Tableau products to use to meet the following requirements.
Regulatory requirements state that all data must remain in the on-premises datacenter.
Prepare large datasets, including cleaning, shaping, and combining data sources.
Develop dashboards to deliver insights on the data.
Which solution should the consultant recommend?

A customer wants to leverage generative AI capabilities. The customer is currently on Tableau Server 2023.1.
How is the customer able to leverage generative AI in Tableau?

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 take to access the necessary metadata? (Choose two.)

A Tableau consultant has been asked by a client with Data Catalog which workbooks would be impacted by a change to a field in a published data source. The consultant searches the field in the published data source and responds with a list of six workbooks that will be impacted from the Lineage tab.
The client looks at the published data source and asks why the published data source reports seven connected workbooks, but only six were listed as being impacted by the change.
How should the consultant defend the conclusion that six workbooks will be impacted?