Tableau TDA-C01 Practice Test - Questions Answers, Page 10

Tableau Help: DATENAME Function

Tableau Help: Date Functions

To add a column that shows the day of the week for each row, you should complete the formula as follows:

DATENAME

(

'weekday'

, [Order Date])

The DATENAME function in Tableau returns the name of a specified part of a date or datetime value, such as the year, month, or day. It takes two arguments: the date part and the date. In this question, you want to return the name of the weekday, such as Monday, Tuesday, or Wednesday, for each order date. Therefore, you need to use 'weekday' as the date part and [Order Date] as the date. The formula will return a string value that represents the name of the weekday for each order date.

Tableau Help: DATENAME Function

Tableau Help: Date Functions

To ensure that the extract also refreshes on the last day of the month at 18:00, you need to add a new extract refresh task to the workbook on Tableau Server. You can do this by selecting the workbook, selecting Refresh Extracts, and then choosing Schedule a Refresh. You can then select an existing schedule that matches your desired frequency and time, or create a new schedule with a custom frequency and time. This will add a new extract refresh task to the workbook, in addition to the existing one that refreshes every Monday at 10:00. You can also modify or delete the extract refresh tasks as needed.Reference:

Tableau Certified Data Analyst Exam Prep Guide, page 10, section ''Publishing and Scheduling Data Refreshes''

Tableau Help: Refresh Data on a Schedule

Tableau Help: Manage Refresh Tasks

In Tableau, the RANK function assigns a rank to each row within a partition of the data, based on the value of the field being ranked. It is important to understand that the rank is recalculated whenever the underlying data or the partitioning changes.

In the given scenario, the Overall Rank is based on the Sales figures, while the Rank (presumably) is based on the Sales within the Category. When filtering on the condition where [Overall Rank] - 1, it means we are excluding the sub-category that has an Overall Rank of 2.

Looking at the data:

Furnishings has an Overall Rank of 8, which does not meet the filter condition ([Overall Rank] - 1). Therefore, its rank remains the same.

Tables have an Overall Rank of 3. When the sub-category with an Overall Rank of 2 is removed (Chairs in this case), Tables move up in the overall ranking. However, since Tables are the top-ranked within the Furniture category, their Rank within the category would remain unchanged at 1.

Chairs have an Overall Rank of 2, which meets the filter condition and thus will be removed from the view. We cannot determine the change in Rank for Chairs because they are filtered out.

Accessories have an Overall Rank of 5. If any sub-category with a higher Overall Rank (1 to 4) is removed, the rank of Accessories within the Technology category could change because it is currently ranked 3 in its category. With the removal of Phones (Overall Rank 1), the Rank of Accessories could potentially increase.

Copiers have an Overall Rank of 6, which does not meet the filter condition. Therefore, its rank remains the same.

Machines have an Overall Rank of 4. If we remove Phones (Overall Rank 1), Machines will move up in the overall ranking and potentially within the Technology category as well, changing its Rank from 2 to 1.

Phones have an Overall Rank of 1, which does not meet the filter condition of being Overall Rank 2. Therefore, its rank remains the same.

Bookcases have an Overall Rank of 7, which does not meet the filter condition. Therefore, its rank remains the same.

Based on this analysis, when the sub-category with an Overall Rank of 2 (Chairs) is removed, the Rank value will change for Tables, Accessories, and Machines, as they will move up in the overall ranking within their respective categories. However, it's important to note that while Tables will move up in the overall ranking, their rank within the Furniture category would not change as they are already at the top. The rank changes for Accessories and Machines are due to the removal of Phones, which is ranked higher overall and within the Technology category.

Tableau Certified Data Analyst Exam Prep Guide, page 10, section ''Filtering Data''

Tableau Help: Parameters

Tableau Help: Top Filters

To schedule a refresh of the data, you need to ensure that Tableau Server or Tableau Online can access the database without prompting for credentials. This can be done by embedding the credentials in the workbook or the published data source. You also need to extract the data from the database and publish it as a separate data source or as part of the workbook. A live connection would not allow you to refresh the data on a schedule, as it would always query the database directly. A hyper file is a format for storing extracted data, but it is not a requirement for scheduling a refresh.Reference:

Tableau Certified Data Analyst Exam Prep Guide, page 10, section ''Publishing and Scheduling Data Refreshes''

Tableau Help: Embedding Database Credentials

Tableau Help: Extract Your Data

[Tableau Certified Data Analyst Exam Prep Guide], page 9, section ''Preparing Data''

[Tableau Help: Join Your Data]

[Tableau Help: Aggregate Your Data]

[Tableau Help: Filter Your Data]

Tableau Certified Data Analyst Exam Prep Guide, page 11, section ''Creating Calculated Fields''

Tableau Help: SUM Function

Tableau Help: LOOKUP Function

Tableau Help: PREVIOUS_VALUE Function

To create the Position column, you should use the FIRST () function. The FIRST () function returns the number of rows from the current row to the first row in the partition. For example, the first row in a partition will return 0, the second row will return -1, and so on. In this question, the partition is defined by the Segment field, and the table is sorted by the Sales field in descending order. Therefore, the Position column shows the offset of each row from the first row in each segment, based on the sales ranking.Reference:

Tableau Certified Data Analyst Exam Prep Guide, page 11, section ''Creating Calculated Fields''

Tableau Help: FIRST Function

To combine the tables by using Tableau Prep and include only values from Table1 that do not match any values in Table2, you should use a left only join. A left only join is a type of join that returns only the rows from the primary table (Table1) that have no matching rows in the secondary table (Table2). The field values from Table2 will appear as null values in the combined table. A left only join is also known as an anti-join or an exclusion join.Reference:

Tableau Certified Data Analyst Exam Prep Guide, page 9, section ''Preparing Data''

Tableau Help: Join Your Data

Tableau Help: Left Only Join