Tableau-Desktop-Found Practice Test 2 — 10 Questions

Question 1

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 2

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 3

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 4

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 5

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 6

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 7

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 8

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 9

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 10

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'.