Tableau-Desktop-Found Practice Questions

Question 1

Refer to the exhibit. You are connected to an Oracle database. You can see the tables list, but when you drag a table onto the canvas, you receive this error. What is the most likely cause?

Accepted Answer

The user lacks permissions to read the table metadata.. Metadata extraction failure often indicates that while the connection to the server succeeds, the user lacks the necessary read permissions for the specific schema or table metadata. This is a common issue in enterprise environments where database administrators restrict access to system catalogs. Without metadata, Tableau cannot query the column definitions required to build the join or extract structure.

Answer

The database is currently offline.

Answer

The data table is empty.

Answer

The Oracle driver is incompatible with the version.

Question 2

Which Tableau component acts as a container for multiple worksheets and provides the layout structure for a final presentation?

Accepted Answer

Dashboard. A dashboard is the primary container in Tableau used to combine multiple worksheets, images, text, and other objects onto a single canvas. Understanding the distinction between a worksheet, which focuses on a single visualization, and a dashboard, which provides a comprehensive view, is fundamental for report authors. Dashboards allow for complex interactions, enabling users to synthesize data from different sources and present insights in a cohesive, user-friendly format for stakeholders.

Answer

Story

Answer

Worksheet

Answer

Data Source Page

Question 3

Which of the following describes the purpose of a 'Data Extract' in Tableau?

Accepted Answer

To improve performance and enable local access.. Data extracts are local, optimized snapshots of data that allow Tableau to store data in a highly compressed and performant .hyper format. By moving data from a source (like a slow database) into an extract, you significantly improve query speed and offload processing from the source system. This is an essential technique for ensuring that end users have a fast, responsive dashboard experience, regardless of the latency of the underlying source.

Answer

To keep data updated in real-time.

Answer

To automatically join different data sources.

Answer

To increase the security of the data connection.

Question 4

You are analyzing sales data and need to identify the top 10 products by profit. You have dragged 'Product Name' to the Rows shelf and 'Profit' to the Columns shelf. What is the most efficient way to isolate only the top 10 performers?

Accepted Answer

Drag Product Name to the Filters shelf, select the Top tab, and define a limit by field.. Using a Top N filter allows Tableau to perform the calculation at the data source level before rendering the visualization. This is more performant than using a manual hide or a set, as it dynamically adjusts if the underlying data changes. Mastering this technique is essential for creating clean, focused dashboards that guide stakeholders directly to the most critical business metrics without overwhelming them with unnecessary, low-value data points.

Answer

Sort the visualization in descending order and manually hide all rows after the tenth item.

Answer

Create a calculated field using the RANK function and filter for values less than or equal to 10.

Answer

Apply a wildcard filter to the Product Name dimension to include only the top 10 records.

Question 5

Which of the following scenarios best justifies the use of a data relationship (Noodles) over a physical join?

Accepted Answer

When combining tables with different levels of granularity. Relationships offer a flexible, logical approach to combining data without duplicating values at the join level. This is critical for multi-fact tables where grain differences exist. Understanding this concept is essential for avoiding the 'fan trap'—where duplicated rows inflate aggregate figures—thereby ensuring data accuracy and maintaining a clean, performant data model that reflects real-world business entity relationships.

Answer

When you need to perform a strict inner join

Answer

When you need to physical merge two tables into a single extract

Answer

When you want to remove unmatched rows from the primary table

Question 6

When creating an extract, what is the impact of choosing 'Aggregate data for visible dimensions'?

Accepted Answer

It summarizes the data to reduce extract size.. This option reduces the size of the extract by summarizing data at the level of the dimensions currently in the view. This is an excellent optimization strategy for very large datasets where row-level granularity is not required for the dashboard. By storing only the necessary aggregates, the extract becomes much faster to query and takes up significantly less disk space, improving the overall efficiency of the analytical application.

Answer

It keeps all original rows in the extract.

Answer

It only affects the metadata, not the physical data.

Answer

It removes all measures from the extract.

Question 7

You are joining two tables: 'Sales' and 'Targets'. The 'Targets' table has only one row per region, while the 'Sales' table has multiple rows per region. What join type should you use to preserve all sales data while adding target information?

Accepted Answer

Left Join. A Left Join is appropriate here because it keeps every row from the primary 'Sales' table and adds matching 'Targets' data where available. Since 'Targets' is at a higher level of aggregation (region level), this join preserves the transaction-level granularity of the 'Sales' table while associating each transaction with its corresponding target for performance comparison. This correctly models the one-to-many relationship often found in business intelligence.

Answer

Inner Join

Answer

Right Join

Answer

Full Outer Join

Question 8

When you have a large dataset that is slow to load, what is the 'first' step you should take to improve performance in Tableau?

Accepted Answer

Hide unused columns and apply a data source filter.. Minimizing data before it reaches the dashboard is the fundamental rule of Tableau performance. By excluding unnecessary columns and applying data source filters early, you reduce the workload on both the local environment and the underlying database. These initial steps are the most impactful, as they prevent unnecessary data from being processed and stored, leading to a much snappier user experience in the final interactive dashboards.

Answer

Add a dashboard filter.

Answer

Create a hide/unhide dashboard action.

Answer

Increase the number of CPU cores on the machine.

Question 9

Refer to the exhibit. You are trying to create a calculated field for sales performance. Why is this formula failing?

Accepted Answer

Mixing aggregate and non-aggregate fields is illegal.. In Tableau, you cannot mix aggregate and non-aggregate values in a calculation unless all non-aggregate fields are wrapped in an aggregation function. This ensures that the calculation is performed consistently across the entire dataset. Recognizing this rule is vital for creating accurate ratios and percentages, as calculations that mix grains often result in unexpected errors or logically incorrect outputs that can ruin dashboards.

Answer

The fields must be joined in the physical layer first.

Answer

Calculations cannot reference dimension fields.

Answer

The data source requires a live connection.

Question 10

Which file type should you use if you want to save a Tableau data source that includes the connection information and the underlying data in a single compressed file?

Accepted Answer

.tdsx. A Tableau Packaged Data Source (.tdsx) encapsulates the data connection parameters along with the actual data file itself. This is highly beneficial for portability, as it allows users to share a complete, self-contained dataset with colleagues who may not have access to the original underlying database or local file, ensuring the workbook remains fully functional without broken connections.

Answer

.tds

Answer

.twb

Answer

.tde

Question 11

Refer to the exhibit. You are trying to establish a relationship between two tables, but receive this error. What is the best way to fix this?

Accepted Answer

Use a calculation to cast both fields to the same type. Tableau's relationship engine requires consistent data types for the related fields. If one is an integer and the other is a string, the engine cannot establish a valid relationship. This is a common issue when pulling data from disparate systems. The solution is to create a calculated field to cast the data to a matching type, ensuring logical consistency for the underlying query engine to execute successfully.

Answer

Change the database schema of the original source

Answer

Delete the Relationship and use a join instead

Answer

Restart the Tableau instance

Question 12

Which TWO of the following are valid ways to combine data from different sources in Tableau?

Accepted Answer

Blending. Understanding how to integrate data is fundamental to Tableau. Blending and Relationships are the primary methods for combining data from multiple sources. Choosing the right one depends on the nature of the data, the desired level of granularity, and performance requirements. Relationships are generally preferred for their flexibility and intelligence, while blending serves as a useful secondary tool for quick, high-level analysis when more complex modeling is not feasible.

Answer

Data Mining

Answer

Data Sorting

Answer

Extracting

Question 13

You are analyzing customer spending behavior and notice that the 'Profit' measure is skewed by a few extreme outliers. Which technique should you use to minimize the impact of these outliers while keeping the data in the view?

Accepted Answer

Apply a logarithmic scale to the axis.. When outliers distort the scale of a visualization, a log scale is often the best remedy. It compresses the range of the data, allowing both the extreme high-value outliers and the smaller, more typical data points to be visible on the same chart. This preserves the entire dataset while providing a more balanced view that highlights trends across the full spectrum of values without hiding or deleting records.

Answer

Filter out the top 5% of records.

Answer

Change the aggregation from SUM to AVG.

Answer

Replace the measure with a calculated field.

Question 14

When you drag a continuous date field (e.g., Order Date) to the Columns shelf, what does Tableau display by default?

Accepted Answer

A continuous time axis. Tableau defaults to showing a continuous time axis when a continuous date field is placed on the shelf. This allows for a smooth line chart that accurately reflects the temporal nature of the data. Understanding default behaviors helps analysts save time by avoiding unnecessary manual configuration of time scales, ensuring quick insights into trends, seasonality, and overall performance patterns over time.

Answer

A list of discrete years

Answer

A bar chart of frequencies

Answer

A filter dialog box

Question 15

You want to show the distribution of Sales across different states and highlight the ones that are performing above the national average. What is the most straightforward way to visualize this?

Accepted Answer

Use a Reference Line. Reference lines are the most efficient way to add a benchmark to a visualization. By adding a reference line representing the average of the data, users can immediately identify states that fall above or below the threshold. This provides instant visual context and helps stakeholders make data-driven decisions regarding performance, avoiding the need for complex calculations or extra visual clutter.

Answer

Create a calculated field to flag values above average

Answer

Use a Trend Line

Answer

Change the mark color to red and blue

Salesforce Certified Tableau Desktop Foundations Tableau-Desktop-Found practice test

Three ways to study

Study Tableau-Desktop-Found by domain

Study Tableau-Desktop-Found by topic

Understanding Tableau Concepts practice questions

Exploring and Analyzing Data practice questions

Sharing Insights practice questions

Connecting to and Preparing Data practice questions

Tableau-Desktop-Found fundamentals practice questions

Tableau-Desktop-Found scenario practice questions

Tableau-Desktop-Found troubleshooting practice questions

Salesforce Certified Tableau Desktop Foundations practice questions