Tableau-Desktop-Found Practice Exam 1 — 20 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

Question 16

An analyst builds a view showing Sales by Region using a live connection to a massive enterprise data warehouse. The dashboard feels sluggish during filtering. Which architectural component processes the query generation and executes the heavy lifting in this live connection setup?

Accepted Answer

The connected database management system executes the query and returns aggregated result sets to Tableau.. In a live connection scenario, Tableau acts as the query generator that translates user actions into native database queries. The underlying database engine performs the heavy aggregation and data processing. Understanding this distinction is crucial for optimizing dashboard performance because bottlenecks often stem from database tuning rather than Tableau client configurations when working with live enterprise sources.

Answer

The Tableau Data Engine processes the query natively in memory before sending requests to the database backend.

Answer

The VizQL Server translates visual specifications into database execution plans and caches the returned result sets.

Answer

The Backgrounder service intercepts the dashboard filters and streams pre-calculated data blocks asynchronously.

Question 17

You are analyzing sales performance and want to compare the growth rate of two different product categories over time. Which technique is most effective for visualizing the relative performance differences regardless of the absolute scale?

Accepted Answer

Apply a 'Percent Difference' quick table calculation on the sales measure.. Using a dual-axis chart with a synchronized axis is not the solution here because the scales differ. Instead, applying a Quick Table Calculation for 'Percent Difference' or 'Year-over-Year Growth' allows you to normalize the values. This approach is essential for identifying trends in performance when categories have vastly different revenue volumes, ensuring the visual comparison focuses on rate of change rather than total value.

Answer

Change the mark type to a Gantt bar to show the start and end points.

Answer

Create a scatter plot using the sales values of both categories as axes.

Answer

Use a highlight table to display the raw sales values for each month.

Question 18

You want to show the percentage of total sales per region. What is the most efficient way to do this?

Accepted Answer

Right-click the Sales measure, select 'Quick Table Calculation', and choose 'Percent of Total'.. Using Quick Table Calculations is the fastest way to perform complex math like percentages without writing formulas. Understanding these built-in functions is essential for quick data exploration. They allow analysts to derive meaningful insights instantly, helping to surface proportions and comparisons that are not immediately obvious from raw sales values alone in a standard table.

Answer

Create a calculated field: SUM(Sales) / SUM(Total Sales).

Answer

Change the aggregation of Sales from SUM to Percent.

Answer

Filter out all regions except the one you are calculating for.

Question 19

An analyst wants to combine two tables from the same Microsoft SQL Server database using a relationship instead of a physical join in the Tableau data source canvas. What is the primary operational characteristic of relationships compared to traditional joins?

Accepted Answer

Relationships evaluate context dynamically, aggregating measures at each table's native level of detail prior to matching.. Relationships are dynamic and non-invasive, meaning they preserve the native level of detail of each table independently and aggregate data during query generation based on the visual context. This prevents common data duplication and row inflation errors that frequently plague traditional physical joins, making relationships the modern standard for blending related tables in Tableau Desktop without manual LOD expressions.

Answer

Relationships force an immediate row-level cross product across all tables before any visual query executes in the view.

Answer

Relationships permanently merge the underlying tables into a single wide flat table stored directly in the local extract file.

Answer

Relationships require all connected tables to share an identical primary key column name and exact data type natively.

Question 20

You are connecting to a CSV file that contains dates in the format 'DD-MM-YYYY'. When you drag the date field into the view, Tableau interprets it as a string. How can you fix this?

Accepted Answer

Change the data type to Date in the Data Source pane.. Tableau needs specific formatting to recognize dates. If a format isn't standard, it defaults to a string. You can change the data type to Date in the Data Source tab. If the format remains unrecognized, you can use a calculated field with the DATEPARSE function to explicitly define the format, ensuring Tableau correctly interprets the temporal information for time-series analysis.

Answer

Convert the column to a Measure.

Answer

Use the Split function to separate the date parts.

Answer

Rename the column to start with 'Date'.