Free Tableau Desktop FoundationsPractice Test

A data analyst needs to connect Tableau Desktop to a CSV file stored on their local computer. Which connection type should they use?

An analyst connects to a data source and notices that a numeric field containing product codes is automatically assigned a data type of Number. The codes should not be used in calculations. What should the analyst do?

A user wants to combine data from two Excel files that have different column structures but share a common field called 'Customer ID'. Which join type would include all records from both tables?

When working with a live connection versus an extract in Tableau Desktop, which statement is true?

A data analyst needs to clean data by removing leading and trailing spaces from a text field called 'Product Name'. What should they use?

Which chart type is best suited for showing the relationship between two continuous measures across many data points?

A business analyst creates a dashboard with three worksheets. They want users to be able to click on a region in one worksheet and have the other worksheets filter automatically to show only that region's data. What feature should they use?

An analyst wants to display sales data as both a line chart showing trends over time and a bar chart showing totals by category. What is the most efficient way to accomplish this in a single view?

A dashboard designer wants to ensure that a filter applies to only two specific worksheets on a dashboard containing five worksheets. How should they configure this?

When creating a visualization, what does Tableau do when you drag a dimension to the Color shelf?

A data visualization shows a map with sales by state, but several states are not displaying even though they have data. What is the most likely cause?

An analyst needs to create a view that shows the top 10 products by sales, but the filter should update automatically as data changes. What type of filter should they use?

What is the primary difference between a dashboard and a story in Tableau?

A user creates a calculated field with the formula: IF [Sales] > 10000 THEN 'High' ELSE 'Low' END. What type of field does this create?

An analyst needs to calculate the running total of sales across months. Which type of calculation should they use?

What is the result of the calculation: [Sales] / [Profit] when [Profit] equals zero for some records?

A business analyst needs to calculate the average sales per customer, where the total should be: (Sum of all Sales) / (Count of Distinct Customers). Which calculation approach is correct?

A data analyst wants to publish a workbook to Tableau Server so that colleagues can view and interact with it. What permissions must the analyst have?

When publishing a workbook that uses an extract to Tableau Server, what options are available for the data source?

A team wants to ensure that a published dashboard always displays the most current data from their database without manual intervention. The database is updated daily at 2 AM. What is the best approach?