Connecting to and Preparing Data

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

What is the purpose of the 'Relationships' feature in Tableau's logical layer?

You have a single data source connected to a SQL database. You want to see the total sum of sales for each region. Where should you drag the 'Region' and 'Sales' fields?

You have a dataset where each row represents a student's final grade in a class. You want to calculate the average grade per department, but you discover that the data is at the individual student level. What is the most efficient way to prepare this for your view?

Refer to the exhibit. You are attempting to join several tables in a physical layer and receive the error shown. What is the most likely cause?

Refer to the exhibit. Why is the 'Revenue' field failing to aggregate as a sum?

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?

You are preparing a data source and need to pivot multiple columns representing 'Month' into a single column. What is the primary requirement for this action?

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

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?

When connecting to a flat file, you notice that Tableau is interpreting a 'Date' column as a String. Which action should you take to ensure the field is recognized correctly for time-series analysis?

You are connecting to a large Excel file with 20 sheets. You need to combine data from three sheets that share the same structure into a single table. Which method is most efficient for data preparation?

You have a dataset with columns 'Date', 'Region', 'Sales', and 'Profit'. You need to reshape the data so that 'Sales' and 'Profit' are in a single column called 'Measure Name' and their values are in a 'Measure Value' column. Which TWO steps should you take?

What is the purpose of the 'Data Interpreter' in the Tableau Data Source tab?

You are connecting to a large SQL Server database and notice that performance is sluggish when dragging measures onto the canvas. You need to improve performance while still maintaining access to all historical data. Which action should you take?

You need to connect to a CSV file that is updated daily. To maintain the most up-to-date data while keeping the file lightweight, which connection strategy should you use?

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?

You have connected to a database and need to combine two tables based on a shared ID, but you also need to ensure that no records are lost from the 'Primary' table. Which join type should you use?

You are creating a data source that combines a large Sales table with a smaller Regions mapping table. You want to ensure that only rows from the Sales table that have a corresponding match in the Regions table are kept. Which join type should you use?

Refer to the exhibit. You are attempting to join a local Excel file with a live connection to a secured Salesforce object. Why is this error occurring?

When connecting to an Excel file with multiple sheets, you need to combine the data into a single table structure using the Data Source tab. Which feature allows you to stack these sheets vertically if they share the same column headers?

Refer to the exhibit. Why are the sales records being duplicated in the output?

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

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?

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

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

You are working with a CSV file and want to ensure that Tableau treats certain columns as numbers, even though they look like categories. What should you do?

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?

What is the primary difference between a Data Extract and a Live connection in Tableau?

You are connecting Tableau Desktop to a large transactional database containing millions of rows. You need to improve workbook performance and reduce query load on the live database during exploratory analysis. What is the most effective connection and data storage strategy to achieve this?

You have a dataset with a 'Date' field that is recognized as a string. What is the best way to convert it to a Date type so you can use it in a time-series chart?

You have a large CSV file with millions of rows. You want to keep the data updated every morning. What is the best strategy?

You are a data analyst at a retail company. You have a Tableau data source that combines two tables: Orders (containing order ID, customer ID, order date, and product ID) and Returns (containing return ID, order ID, return date, and reason). You need to analyze the return rate by product category. After connecting to the data, you notice that when you drag Order ID to the view, some orders appear multiple times. What is the most likely cause of this duplication?

You have a dataset containing sales information for different years. You want to connect to this data but only need to keep records from the last two years. Which approach is the most efficient?

Refer to the exhibit. You are receiving a calculation error when trying to aggregate a 'Revenue' field. What is the most efficient way to resolve this in the Data Source tab?

You are connecting to a large database and only need a small subset of the data based on a specific geographic region. How can you limit the amount of data brought into Tableau?

You have connected to a CSV file and notice that the headers are not being correctly identified, resulting in column names like F1, F2, and F3. What is the fastest way to fix this in the Data Source page?

An analyst needs to combine two tables from a local PostgreSQL database. The tables share a common identifier, but one table contains transactional rows at a granular date level while the other contains monthly aggregate targets. What joining strategy best prevents metric inflation caused by data duplication?