Explanation

Tableau extracts are standalone, optimized copies of data that allow fast analysis even when disconnected from the original database. Since Tableau version 10.5 (released in 2018), the extract engine was completely rewritten, and the new format uses the .hyper extension. This file contains the actual rows and columns in a compressed, columnar structure that Tableau can query extremely quickly. Older .tde extracts are still supported, but any extract created today will always be .hyper.

Correct Option

✅ A. Sales.hyper
The .hyper file is unmistakably a Tableau extract. It holds the full dataset (or a subset defined during creation) in Tableau’s proprietary high-performance format. You can connect directly to a .hyper file as a data source, publish it to Tableau Server/Online, or include it in a packaged workbook (.twbx). It’s the only file in the list that actually contains extracted data.

Incorrect Options

❌ B. Sales.csv
This is a plain-text comma-separated values file — one of the most common raw data formats. While Tableau can connect to it live or extract from it, the .csv itself is just source data, not a Tableau extract. It remains human-readable in any text editor.

❌ C. Export.mdb
An .mdb file is a legacy Microsoft Access database. Tableau can connect to Access files as a data source (live or extract), but the .mdb is the original database, not a Tableau-created extract. It uses Microsoft’s proprietary format, not Tableau’s.

❌ D. Book1.twb
A .twb workbook contains only XML metadata: layouts, calculations, formatting, and connection information. It never stores the actual data rows. If data were bundled inside, the file would be a packaged workbook (.twbx) instead.

Reference
Extract Your Data

Explanation

To ensure the Sales field consistently appears with the currency symbol and is abbreviated with 'K' for thousands (e.g., $44K), you must modify the default properties of the measure. This is done by changing the default number format of the field, which allows you to apply custom formatting rules like currency, decimal places, and scaling (like dividing by 1,000 for 'K') globally across the workbook.

✅ Correct Option: C

Change the default number format of the Sales field.
This is the standard and recommended Tableau best practice. By right-clicking the Sales field in the Data Pane and navigating to Default Properties > Number Format, you can select Currency (Custom). Within the custom format options, you can set the currency symbol, zero decimal places, and crucially, apply custom formatting codes (like $,#K or similar depending on the Tableau version) to show the value in thousands with the 'K' suffix. This method ensures the underlying data type remains a Number, preserving its analytical capability.

❌ Incorrect Options

A. Change the data type of the Sales field to String.
Changing the data type to String (Text) is incorrect because it prevents the Sales field from being used in any numerical aggregations (like SUM, AVG, MAX) or continuous axes. While you can display text, you lose the ability to perform vital analytical functions, which is the core purpose of a measure like Sales.

B. Create a calculated field that uses a formula of 'S' * str(Round(([Sales],2)) + 'k'.
This formula is syntactically incorrect in Tableau. You cannot use the multiplication operator (*) to combine the string 'S' with the result of the STR() function. Even if fixed to concatenate, creating a new calculated field for basic display formatting is inefficient. It results in a new string field, losing numerical properties, and unnecessarily complicates the data pane.

D. Create a calculated field that uses a formula of 'S' + str(([Sales]/1000)).
This formula creates a new string calculated field by dividing sales by 1,000 and concatenating it with the string 'S'. This approach, while resulting in a display similar to the requirement, is inefficient and inappropriate. It produces a string field that cannot be used for numeric analysis and forces the creation of a new field when a simple format change on the existing field is the correct solution.

📖 Reference
Tableau Official Documentation: Formatting Numbers
Source: Tableau Help: Custom Number Formats (Search for "Tableau default number format" on the official Tableau website)

Note: Official Tableau documentation guides users to use the Default Properties menu to set the display format for fields globally, allowing for advanced custom number formats to handle scaling like 'K' for thousands.

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

Explanation

To modify the Line worksheet so it shows only the minimum and maximum values for both measures in each region, follow these steps after opening Book1:

➡️ Open the Line worksheet.
➡️ In the Filters shelf, add the two measures (e.g., Sales and Profit or Quantity depending on worksheet setup).
➡️ For each measure, click the Filter icon and choose Use All → Special → Non-null values if needed.
➡️ Right-click each measure on the Marks Card → Add Table Calculation.
➡️ Choose Rank and set Compute Using: Region, Value: Min & Max Only.
➡️ Drag Region to Columns and keep the measure(s) on Rows.
➡️ Use Filter → Rank = 1 and Rank = Last to keep only minimum and maximum values.

This ensures the line chart displays only the highest and lowest values for each measure within every region.

Summary
By applying ranking on measures and filtering only Rank 1 and Rank Last, the chart eliminates intermediate points and keeps only minimum and maximum values for each region. The visualization becomes more focused on extremes, making trend comparisons easier.

🔗 Reference
Official Tableau Documentation (Table Calculations & Filtering):
Transform Values with Table Calculations

Explanation

To set a second, specific refresh time for an existing extract on Tableau Server or Tableau Cloud, you must add a new refresh schedule to the published data source or workbook. Each extract can be linked to multiple, independent schedules, allowing for flexible refresh timings like weekly and end-of-month. The "Refresh Extracts" option for the workbook allows the analyst to manage all associated schedules without disrupting the already existing Monday schedule.

Options Analysis

✔️ Correct Option: [C] From Tableau Server, select the workbook, select Refresh Extracts, and then add a new extract refresh.
In the Tableau Server or Cloud interface, when you select a published workbook or data source, the Refresh Extracts option lets you view and manage its assigned schedules. To add the required last day of the month at 18:00 refresh without affecting the existing Monday refresh, you must explicitly add a new schedule that targets the same extract. This is the only way to assign multiple, different schedules.

❌ Incorrect Option: [A] From Tableau Server, select Schedules, find the schedule of the extract, and change the frequency to the last day of the month.
If you were to select the existing schedule (Monday at 10:00) and change its frequency, you would overwrite the Monday refresh. This action would ensure the extract refreshes on the last day of the month, but it would stop the necessary weekly Monday refresh, failing to meet the requirement of having both schedules running.

❌ Incorrect Option: [B] From Tableau Server, select Schedules, and change the priority of the existing schedule.
Changing the priority of an extract refresh schedule affects when it runs relative to other tasks scheduled for the same time, but it does not change the frequency or timing. Adjusting the priority would not add the required last-day-of-the-month refresh and is completely irrelevant to setting a new recurring time.

❌ Incorrect Option: [D] From Tableau Desktop, open the Publish Workbook dialog box and configure the schedule.
While the initial schedule is set during publishing from Tableau Desktop, the management and addition of subsequent schedules must be done directly on Tableau Server/Cloud after the workbook or data source has been published. Re-publishing just to change the schedule is inefficient, and the preferred method for managing schedules is always via the web interface.

Reference 🔗
Tableau Help: Extract Refresh Schedules