Tableau-Desktop-Found Connecting to and Preparing Data — Timed 20 Questions

Question 1

You are creating a data source that combines a large Sales table with a smaller Regions table. You need to ensure that the data remains at the lowest level of detail for the Sales table without duplicating records when joined. Which join type should you prioritize?

20 minute time limit — choose an answer to begin.

Accepted Answer

Left Join. A Left Join ensures that all rows from the primary Sales table are preserved, while matching rows from the Regions table are appended. This approach maintains the granularity of the Sales table, preventing row duplication that often occurs with Many-to-Many joins or Cartesian products. Understanding join behavior is critical for data integrity and ensuring that calculated fields, such as sums and averages, produce accurate results for business stakeholders.

Answer

Inner Join

Answer

Full Outer Join

Answer

Right Join

Question 2

Which TWO of the following statements regarding the 'Relationship' model in Tableau are true?

Accepted Answer

Relationships preserve the grain of each table. Relationships represent a modern approach to data modeling in Tableau that avoids the pitfalls of static joins. By preserving the individual grain of each table and calculating aggregations dynamically, relationships ensure data accuracy and improve performance. This is critical for users working with complex, multi-table datasets, as it significantly reduces the risk of incorrect calculations resulting from accidental data duplication during the data preparation phase.

Answer

Relationships perform a join at the time of query execution

Answer

Relationships always produce a Cartesian product

Answer

Relationships are only available for Excel files

Question 3

When cleaning data, you need to group similar strings that have slight variations (e.g., 'California', 'Calif.', 'CA'). Which feature should you use to handle this efficiently in the Data Source tab?

Accepted Answer

Group and Replace. Data Interpreter or the 'Group' feature in the Data Source tab is designed to handle messy text data. 'Group and Replace' is a powerful tool for cleaning inconsistent entries without complex formulas. It allows users to consolidate variations into a single, standardized value, ensuring that visualizations are not fragmented by typographical errors or inconsistent naming conventions in the source dataset.

Answer

Data Interpreter

Answer

Split Column

Answer

Change Data Type

Question 4

Which THREE of the following are benefits of creating a Tableau Extract (.hyper) instead of using a Live connection?

Accepted Answer

Improved query performance for large datasets. Extracts are a vital part of the Tableau architecture, offering performance and scalability. Understanding the trade-offs between extracts and live connections is essential for designing efficient data strategies. Extracts are generally preferred for heavy analytical workloads to ensure speed and offload processing from production systems, while live connections are reserved for scenarios where data freshness is the absolute priority over dashboard performance.

Answer

Always reflects the most real-time data possible

Answer

Automatic encryption of all data at rest

Question 5

Refer to the exhibit. You are attempting a cross-database join between an SQL Server table and a CSV file. Given the policy, why might the performance be slower than expected?

Accepted Answer

Data must be pulled into a single engine for processing. Cross-database joins force Tableau to pull data from both sources into a local memory buffer to perform the join. Even with a high-performance engine like Hyper, this requires moving data across the network, which is the primary bottleneck. Recognizing this limitation is crucial for architects when deciding whether to use physical joins or the more performant Relationship model, which optimizes how data is queried from different systems.

Answer

The JSON policy forces the use of a legacy driver

Answer

The Hyper engine cannot process CSV files

Answer

Cross-database joins are restricted by the policy

Question 6

You are connected to a database and need to see the underlying SQL that Tableau generates for your current view. Which feature allows you to view this?

Accepted Answer

View Data window. Viewing the underlying SQL is crucial for debugging complex data connections and optimizing performance. By using the 'View Data' window or the Tableau log files, you can inspect the exact queries sent to the database. This is essential for understanding how your filters, joins, and calculations are being translated into SQL and for working with your DBA to tune the database for better query performance.

Answer

Performance Recorder

Answer

Data Source Page

Answer

Calculated Field Editor

Question 7

When connecting to a live data source, you notice the performance is sluggish. What is the most effective way to improve performance without switching to an extract?

Accepted Answer

Add a data source filter.. Optimizing live connections often involves reducing the amount of data sent to the database or simplifying the query complexity. Context filters are particularly powerful because they create a temporary table, effectively reducing the scope of subsequent queries. This is a critical skill for balancing the need for real-time data against the constraints of database performance in enterprise-grade analytics environments where extract-based workflows might be prohibited by security or latency requirements.

Answer

Switch the data connection to legacy mode.

Answer

Create a group from the existing fields.

Answer

Increase the join complexity.

Question 8

Refer to the exhibit. Why is the 'Pivot' option unavailable for your data source?

Accepted Answer

Live relational databases do not support pivoting in Tableau.. Tableau's pivot functionality is natively supported for file-based data sources (like Excel, CSV) and some specific extracts. However, for live connections to relational databases (like SQL Server), Tableau cannot physically reorder columns into rows because it relies on the database's underlying schema. Understanding these limitations is critical for data architects who must decide between performing structural transformations in the database layer versus using Tableau's internal data preparation capabilities.

Answer

The data source requires a custom SQL query first.

Answer

The user lacks database administrator permissions.

Answer

The date field prevents pivoting of other columns.

Question 9

You are cleaning a dataset and need to replace 'USA', 'U.S.A.', and 'United States' with a single value, 'US'. What is the most efficient feature to use?

Accepted Answer

Use the Alias feature.. The Alias feature is the standard tool for renaming specific members of a dimension without altering the underlying data source. It is ideal for cleaning up inconsistent data entry, like variations in country names. By creating aliases, you standardize the visualization output while keeping the original data values intact, which is critical for maintaining data lineage and auditing purposes in professional reporting environments.

Answer

Use a calculated field with an IF statement.

Answer

Use the Data Interpreter to merge values.

Answer

Use a data source filter to remove the variations.

Question 10

When preparing data, which THREE actions can be performed directly within the Tableau Data Source page? (Choose three)

Accepted Answer

Renaming fields.. The Data Source page acts as a visual interface for managing your data pipeline before it enters the sheet level. Users can perform essential data grooming tasks, such as changing data types, hiding unnecessary columns, and adding filters, directly within this interface. These actions are fundamental to maintaining a clean, performant data model, as they allow for early-stage optimization before complex visualizations are even created, reducing the risk of errors and performance lag in dashboards.

Answer

Writing complex Python scripts.

Answer

Creating dashboard actions.

Question 11

Which THREE of the following represent best practices when preparing data in Tableau for a large-scale project? (Choose three)

Accepted Answer

Use descriptive naming for all fields.. Professional-grade Tableau projects rely on a clean, maintainable, and performant data foundation. Best practices involve limiting data to only what is needed, documenting the data model for team transparency, and using appropriate data types to avoid calculation errors. Following these standards ensures that dashboards remain fast and accurate as they scale, reducing the need for constant rework when requirements inevitably evolve or when data volumes increase over time.

Answer

Keep all columns in the data source to ensure flexibility.

Answer

Always use Custom SQL over standard table connections.

Question 12

Refer to the exhibit. You are using a Relationship in the logical layer to connect 'Sales' and 'Returns'. What happens to the 'Returns' data if a specific 'OrderID' exists in the Sales table but not in the Returns table?

Accepted Answer

The Returns fields will display null values.. In a relationship, Tableau performs a query-time join based on the context of the visualization. Because relationships behave like a left join by default in the logical layer, the Sales data is preserved, but the corresponding Return fields will appear as null. This prevents data loss and allows for accurate calculations, such as counting returns only when the data is present.

Answer

The entire row from Sales is removed.

Answer

The record from Sales is duplicated for each return.

Answer

The Returns table will throw a connection error.

Question 13

Which TWO of the following are benefits of using an Extract over a Live connection?

Accepted Answer

It improves performance for complex visualizations.. Extracts are snapshots of data that provide significant performance advantages by moving the computation from the source database to Tableau's high-speed Hyper engine. Choosing the right connection type is a fundamental skill that directly impacts dashboard responsiveness and load times, especially when dealing with large datasets or slow network latency that could otherwise hinder the user experience during analysis.

Answer

It ensures the data is always updated in real-time.

Answer

It maintains a permanent link to the original database for updates.

Answer

It automatically cleans all data fields during the connection.

Question 14

You have a field containing full names, but you need to analyze the data by last name. Which feature should you use to split the names into two separate fields?

Accepted Answer

Custom Split. Tableau's Split feature uses pattern recognition to automatically separate strings based on delimiters like spaces or commas. Mastering this tool is essential for data preparation, as raw data is rarely formatted for immediate analysis. Efficiently parsing names or categories allows for better grouping and hierarchy creation, which are the building blocks of drill-down capability in modern interactive dashboards.

Answer

Data Pivot

Answer

Group

Answer

Set

Question 15

Which THREE actions can be performed in the Data Source page to prepare data for analysis?

Accepted Answer

Rename fields. The Data Source tab is the primary interface for shaping data before it is visualized. Mastering these preparation tasks—such as renaming headers, pivoting, and cleaning—is fundamental to creating a clean, professional, and efficient analytics environment. These actions ensure that the data is structured correctly, which reduces the need for complex calculations later in the workbook development phase and improves overall performance.

Answer

Create sets based on member selection

Answer

Build custom dashboard layouts

Question 16

Which TWO factors should you consider when deciding whether to use a Relationship or a Join?

Accepted Answer

Whether you need to enforce a specific join type for all visuals.. Choosing the right method for combining tables is vital because it determines how Tableau handles aggregations and data integrity. Relationships are default for most use cases, while joins are reserved for specific, granular control. Understanding these differences prevents common analytical errors like data duplication or missing records, which are often the result of using a physical join when a logical relationship would have been more appropriate.

Answer

The number of rows in the largest table.

Answer

The file format of the source data.

Answer

The color of the data source icon.

Question 17

When connecting to a large flat file in Tableau Desktop, an analyst notices that unused text columns and sensitive employee identification numbers are visible in the Data Source page. What action should the analyst take to secure the data and improve extraction performance?

Accepted Answer

Hide the unused and sensitive fields directly within the Tableau Data Source tab interface.. Hiding unused fields prevents sensitive data from entering the extract file and reduces memory consumption. This optimization step ensures that only necessary columns are loaded into local storage, improving workbook performance and protecting Personally Identifiable Information from unauthorized view access.

Answer

Delete the sensitive columns directly within the original source flat file using a text editor.

Answer

Apply a global data source filter to remove null values from the employee identifier field.

Answer

Create a dashboard action filter that hides the columns whenever a user interacts with the view.

Question 18

An analyst needs to combine two tables from a Microsoft SQL Server database using a Full Outer Join. When inspecting the data grid in the Data Source page, rows from the left table that have no matching keys in the right table display null values for the right table columns. However, the analyst notices that some matching records are failing to join due to subtle trailing spaces in the key fields. What is the most efficient way to resolve this issue in Tableau Desktop before building visualizations?

Accepted Answer

Use the Data Source page menu to select the key field and apply the Trim operation to remove unwanted spaces.. Data cleaning operations like trimming whitespace are critical to ensure accurate joins and prevent data loss. Tableau provides built-in data interpretation and cleaning tools directly within the data source grid, allowing analysts to resolve data quality issues early. Fixing formatting discrepancies at the source level maintains referential integrity and guarantees that aggregations and visual analyses downstream reflect the true underlying relationship between the joined tables.

Answer

Create a custom SQL query to cast all keys as integers to automatically strip whitespace.

Answer

Apply a Data Interpreter step to automatically trim all leading and trailing spaces across the entire database.

Answer

Write a calculated field in the view using the TRIM() function and use it as the join clause.

Question 19

An analyst is preparing a data source that combines an Excel spreadsheet containing regional sales targets with a live enterprise database containing transactional sales. Which TWO actions must the analyst take when establishing a relationship between these two disparate data sources? (Choose two.)

Accepted Answer

Ensure that the matching fields in both the Excel file and the live database share the exact same data type.. Establishing relationships across disparate connectors requires matching data types and appropriately scoping performance options. Tableau uses relationships as a flexible, semantic way to combine data without prematurely aggregating rows, making proper configuration essential for accurate blending and multi-table analysis. Understanding these requirements ensures data integrity and optimal dashboard performance when dealing with mixed live and file-based connections.

Answer

Define a specific aggregation level for the relationship to match the finest granularity of the database.

Answer

Merge the Excel file and the database into a single physical table using custom SQL before creating relationships.

Answer

Set up a cross-database join instead of a relationship to ensure row-level security filters apply to both sources.

Question 20

When connecting to a JSON file, which TWO of the following are true about the schema discovery process in Tableau?

Accepted Answer

Tableau requires you to define the schema level for nested objects.. Tableau uses a schema discovery process to infer the structure of a JSON file. It looks for the first level of keys to suggest a schema. However, since JSON is hierarchical, Tableau often requires the user to flatten nested elements. Understanding this process is vital for successful data ingestion, as improperly mapped schemas result in missing fields or incorrectly structured data tables.

Answer

Tableau automatically scans the entire file to determine the schema.

Answer

The schema discovery process is only supported for local files.

Answer

JSON files cannot be combined with other data types.