Explanation

This question tests your understanding of how to perform a grouped calculation that is independent of the visual layout. The requirement is to find the first (minimum) purchase date for each customer, even when the Customer ID is not present in the view. This is a classic use case for a Level of Detail (LOD) expression in Tableau. A FIXED LOD expression computes a value using the specified dimensions (here, [Customer ID]) regardless of what is in the view, which is precisely what is needed to solve this problem .

✅ Correct Option

A. { FIXED [Customer ID] : MIN([Purchase Date]) }
This is the correct syntax for a FIXED Level of Detail expression in Tableau. The part before the colon, [Customer ID], defines the dimension at which the calculation will be performed. The part after the colon, MIN([Purchase Date]), is the aggregate calculation. Together, this expression instructs Tableau to find the earliest purchase date for each Customer ID, and this value will be available in the visualization even when the Customer ID field is removed from the view.

❌ Incorrect Options

B. MIN([Purchase Date])
This is a simple table calculation or measure aggregation. Without being grouped by [Customer ID] in the view, this function would not calculate the date per customer. Instead, it would return the single earliest [Purchase Date] found across the entire dataset, which is not the requested outcome. It lacks the grouping logic required to segment the result by each individual customer.

C. [Customer ID] : { [Purchase Date] }
This syntax is completely invalid in Tableau. It incorrectly places the dimension outside the LOD curly braces and, more critically, omits any aggregate function (like MIN, MAX, or AVG). An LOD expression must always include an aggregation to be meaningful. Tableau's calculation engine would reject this structure due to these fundamental syntax and logical errors.

D. [Customer ID] : MIN([Purchase Date])
This is not a recognized syntax for any calculation type in Tableau. While it attempts to imply a relationship between the dimension and the measure, it is missing the essential components of a valid LOD expression (the curly braces {} and a keyword like FIXED) and is also not a standard grouped calculation, which would typically be defined using the INCLUDE or EXCLUDE keywords or simply by dragging dimensions to the view.

📝 Summary
To find the first purchase date per customer independent of the view's dimensions, a FIXED LOD expression is required. Option A uses the correct syntax to compute the minimum purchase date for each customer ID, which will persist even when Customer ID is filtered out of the view.

🔗 Reference
For the definitive guide on this topic, please consult the "Create Level of Detail Expressions" section in the official Tableau Documentation.

Explanation

The file extension .tds stands for Tableau Data Source. This is a proprietary Tableau file type designed to save the connection information to data, without saving the actual data itself. A .tds file stores details like the database server name (e.g., SQL Server), port, credentials (or prompt for them), and any customized settings, folders, calculations, or hierarchies applied within Tableau. This file type is specifically used to share and reuse a standardized connection setup.

✅ Correct Option: B. Sales.tds
The .tds (Tableau Data Source) file is an XML file created by Tableau Desktop. Its primary function is to store the full definition of a data connection, including the type of database (e.g., SQL Server), server address, authentication requirements, and any metadata customizations specific to Tableau. It acts as a shortcut or template, allowing an analyst to easily reconnect to the external data source without having to rebuild the connection from scratch.

❌ Incorrect Option: A. Sales.csv
A .csv (Comma Separated Values) file is a plain text file that contains the raw, delimited data itself. It does not contain any connection information to an external, live data source like an SQL Server database. The data within a CSV is already static and local to the file, and it is not designed to maintain a dynamic connection.

❌ Incorrect Option: C. Export.mdb
A .mdb file is a file format used by Microsoft Access Database. While it is a database that contains both data and database objects, it is a local, file-based database. It does not contain the connection instructions for a separate, external SQL Server database, which is typically accessed via an ODBC/JDBC driver and a .tds or similar connection file.

❌ Incorrect Option: D. Book1.json
A .json (JavaScript Object Notation) file is a standard text-based format for transmitting and storing data, often used by web applications. Similar to a CSV, a JSON file contains the raw data itself, structured in key-value pairs. It does not contain the necessary connection instructions, drivers, or metadata to establish a live connection to an external SQL Server database.

📚 Reference
You can find the official documentation for Tableau file types:
Tableau Help: Tableau File Types and Folders

Explanation

The question asks for the percent difference in sales compared to the same quarter of the previous year (YoY % change). In Tableau, when the view is broken down by quarter in chronological order, the value from the same quarter last year is accessed using LOOKUP(..., -4). The complete percent difference formula must subtract the previous value and then divide the result by that same previous value.

Correct Option:

✅ B. (SUM ([Sales]) - LOOKUP (SUM ([Sales]), -4) ) / (LOOKUP (SUM ([Sales]), -4) )
This is the official and most widely recommended Tableau formula for year-over-year percent change by quarter. It correctly computes (Current Sales – Sales 4 quarters ago) ÷ Sales 4 quarters ago, returning the true percentage growth or decline (e.g., 0.12 = +12%).

Incorrect Options:

❌ A. (SUM ([Sales]) - LOOKUP (SUM ([Sales]), -4))
This formula only calculates the absolute difference in sales (e.g., +$50,000). It completely misses the division step needed to convert the raw change into a percentage, so the result is expressed in currency units instead of a percent, making it incorrect for the requested “percent difference”.

❌ C. (SUM([Sales]) / (LOOKUP (SUM ([Sales]), -4)))
This produces a ratio rather than a percent difference (e.g., 1.15 means sales are now 115% of last year’s same quarter). While related, it is not the same as percent change; it requires subtracting 1 and formatting as percent to match the question, which this formula does not do.

❌ D. (ZN (SUM ([Sales]) ) - LOOKUP (ZN (SUM ([Sales]) ), -4) )
The ZN() function replaces nulls with zero to avoid errors, which can be helpful in some cases. However, this calculation still only returns the absolute difference (raw dollar change), not a percentage. It adds unnecessary complexity and fails to include the required division by the previous period’s value.

Reference:
Support Portal Experience Enhancements for Tableau Customers and Partners
Tableau Training – Table Calculations: https://www.tableau.com/learn/training

Explanation:

In Tableau dashboards, built-in objects provide navigation, images, text, and web elements. However, exporting or downloading functions such as saving a dashboard as an image require functionality beyond native dashboard objects. Tableau allows developers to embed additional tools via Extensions, which provide new capabilities like exporting, exporting to Excel, downloading images, or publishing to external tools. These extensions function as add-ons to perform actions not available through standard objects.

Correct Option (✅ C. Extension):
A dashboard extension can be added to enable tasks such as exporting a visualization or the entire dashboard as an image. Extensions allow integration with external services and custom scripts that trigger downloads. Since Tableau does not provide a built-in “download image” button as a dashboard object, an extension is needed to create that export functionality.

Incorrect Options:

❌ A. Image:
An Image object only inserts a static image file into the dashboard. It does not perform actions or allow interaction such as exporting or downloading. It simply displays visual content and provides no functionality related to export options.

❌ B. Ask Data:
Ask Data is a feature for natural language query and exploration, enabling users to type questions to explore data. This tool enhances data analysis but does not offer exporting capabilities, nor does it provide any dashboard interaction related to downloading.

❌ D. Download:
There is no dashboard object named Download in Tableau. Although users can download dashboards from Tableau Server or Tableau Public, that occurs outside dashboard objects. Choosing this option reflects a misunderstanding of Tableau’s object library.

❌ E. Navigation:
A Navigation object allows linking to another dashboard, sheet, or external URL. It can’t export or download content; it only redirects viewers. Adding this object will not produce an export button or image download option.

Summary:
To add image export capability inside a dashboard, Tableau requires a dashboard extension. Other objects either display content or navigate between content, but they cannot enable exporting or downloading.

Reference:
Tableau Official Documentation – Use Dashboard Extensions

Explanation

To access the results of a Tableau Prep flow before it's published or shared via Tableau Server/Cloud, the most direct and efficient method is for the colleague to output the data to a local file. Tableau Prep's standard output format is the .hyper file, which is optimized for Tableau Desktop connections. The analyst can then take this file, typically shared over a network or local drive, and connect to it directly as a data source within Tableau Desktop to begin building the dashboard.

Options Analysis

🟢 Correct Option: [D] Have the colleague output the results of the flow to a .hyper file. On the Tableau Desktop Connect page, under To a File, choose "More ...", and browse for the .hyper file on the local file system.
This is the standard and correct workflow for sharing unpublished Prep results. The colleague sets the flow's Output step to save the cleaned data as a .hyper file (a highly optimized file format for Tableau). The analyst then receives this file and uses the Connect to Data page in Tableau Desktop, selecting To a File and then choosing the .hyper file. This action creates a live connection to the prepared data, allowing dashboard development to start immediately.

❌ Incorrect Option: [A] On the Tableau Desktop Connect page, under To a File, choose "More ...", and browse for the colleague's .tf file on the local file system.
The .tfl or .tflx file extension is for the Tableau Prep Flow logic itself, not the data output. Tableau Desktop is designed to connect to data sources (like .hyper files, databases, or spreadsheets), not to the flow definition file. Connecting to a .tfl file would be incorrect and would not provide the analyst with the prepared data to build a dashboard.

❌ Incorrect Option: [B] Have the colleague output the results of the flow to a .hyper file. Create a new workbook in Tableau Cloud, choose Files on the Connect to Data page, and upload the .hyper file from the computer.
While this method will work, it's less direct than using Tableau Desktop for an analyst who wants to start work on a dashboard immediately on their local machine. More importantly, this process introduces an unnecessary step of uploading to Tableau Cloud. The question implies a local data exchange to "start work," making the local connection via Tableau Desktop (Option D) the most appropriate and common first step.

❌ Incorrect Option: [C] Open Tableau Desktop and make a connection to Tableau Prep, then choose the colleague's flow that the analyst wants to connect to.
There is no direct, native connector in Tableau Desktop labeled "Connect to Tableau Prep." Tableau Desktop connects to the output of a flow (a .hyper file or a published data source), not to the running flow application itself. The flow must be run first, and its output saved or published for Tableau Desktop to be able to access the results.

Reference 🔗
Tableau Help: Save and Share Your Work