Tableau-Desktop-Found Practice Test 1 — 10 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