{"id":23350,"date":"2026-09-28T05:10:12","date_gmt":"2026-09-28T05:10:12","guid":{"rendered":"https:\/\/www.examlabs.com\/certification\/?p=23350"},"modified":"2026-09-28T05:10:12","modified_gmt":"2026-09-28T05:10:12","slug":"tableau-tda-c01-practice-test-questions-and-exam-dumps-part16-q301-320","status":"publish","type":"post","link":"https:\/\/www.examlabs.com\/certification\/tableau-tda-c01-practice-test-questions-and-exam-dumps-part16-q301-320\/","title":{"rendered":"Tableau TDA-C01 Practice Test Questions and Exam Dumps Part16 Q301-320"},"content":{"rendered":"

View Full <\/b>Tableau TDA-C01 Exam Dumps<\/b><\/a> and Practice Test Dumps<\/b><\/h2>\n

 <\/p>\n

Question 301.<\/b><\/p>\n

An analyst wants to show only the top 5 Product Sub-Categories by SUM(Sales) within a selected Region. Which approach is most appropriate?<\/b><\/p>\n

    \n
  1. <\/b> Add Region to context, then apply a Top 5 filter to Sub-Category based on SUM(Sales)<\/span>
    \n<\/span>2.<\/b> Apply a Top 5 filter first and then hide Region<\/span>
    \n<\/span>3.<\/b> Use a highlight action instead of filtering<\/span>
    \n<\/span>4.<\/b> Convert Sales to a dimension<\/span><\/li>\n<\/ol>\n

    Correct Answer: 1<\/b><\/p>\n

    Explanation:<\/b><\/p>\n

    Tableau evaluates filters according to its order of operations. If the analyst wants the Top 5 Sub-Categories within a selected Region, Region should be placed in context so the regional subset is established first. The Top 5 Sub-Category filter can then be evaluated against that smaller set of data. Without context, Tableau may determine the top members across a broader dataset and only afterward apply the Region filter, producing unexpected results. Highlighting does not restrict the dataset, and converting Sales into a dimension would change its analytical behavior. Context filters are especially useful when a later Top N or conditional filter must be calculated within an earlier filtered subset.<\/span><\/p>\n

    Question 302.<\/b><\/p>\n

    Which Tableau filter is evaluated after dimension filters and is based on aggregated measure values such as SUM(Sales)?<\/b><\/p>\n

      \n
    1. <\/b> Extract filter<\/span>
      \n<\/span>2.<\/b> Measure filter<\/span>
      \n<\/span>3.<\/b> Context filter<\/span>
      \n<\/span>4.<\/b> Data source filter<\/span><\/li>\n<\/ol>\n

      Correct Answer: 2<\/b><\/p>\n

      Explanation:<\/b><\/p>\n

      A measure filter operates on aggregated quantitative values after Tableau has grouped the data according to the dimensions in the view. For example, if Customer Name is present and Sales is filtered as SUM(Sales) greater than a threshold, Tableau evaluates the aggregate for each customer and then filters the resulting marks. Extract and data source filters operate earlier, while context filters establish a subset before standard dimension filters. Understanding this order matters because changing the filter type can change the data included in calculations and can produce different results even when the visible filter condition appears similar.<\/span><\/p>\n

      Question 303.<\/b><\/p>\n

      Which Tableau calculation is most appropriate for determining the total Sales for each Customer regardless of the dimensions displayed in the current worksheet?<\/b><\/p>\n

        \n
      1. <\/b> RUNNING_SUM(SUM([Sales]))<\/span>
        \n<\/span>2.<\/b> { INCLUDE [Customer ID] : SUM([Sales]) }<\/span>
        \n<\/span>3.<\/b> { FIXED [Customer ID] : SUM([Sales]) }<\/span>
        \n<\/span>4.<\/b> WINDOW_SUM(SUM([Sales]))<\/span><\/li>\n<\/ol>\n

        Correct Answer: 3<\/b><\/p>\n

        Explanation:<\/b><\/p>\n

        A FIXED level-of-detail expression calculates using the dimensions explicitly defined in the expression. <\/span>{ FIXED [Customer ID] : SUM([Sales]) }<\/span> therefore creates a customer-level total that does not automatically change when dimensions such as Category, Region, or Sub-Category are added to the visualization. The result can still be affected by filters that are evaluated before FIXED, particularly context filters. INCLUDE calculations are relative to the current view’s detail, while RUNNING_SUM and WINDOW_SUM are table calculations operating on already aggregated marks. When the grain must remain explicitly fixed at Customer ID, a FIXED LOD expression is the appropriate solution.<\/span><\/p>\n

        Question 304.<\/b><\/p>\n

        An analyst needs to calculate Sales at the Customer level even though the worksheet displays only Region. Which LOD expression type is designed for this scenario?<\/b><\/p>\n

          \n
        1. <\/b> EXCLUDE<\/span>
          \n<\/span>2.<\/b> FIXED only<\/span>
          \n<\/span>3.<\/b> Table calculation<\/span>
          \n<\/span>4.<\/b> INCLUDE<\/span><\/li>\n<\/ol>\n

          Correct Answer: 4<\/b><\/p>\n

          Explanation:<\/b><\/p>\n

          INCLUDE adds one or more dimensions to the level of detail used for a calculation, even when those dimensions are not visible in the view. For example, an INCLUDE expression can calculate Sales at Customer ID while the worksheet itself is displayed only at Region. Tableau then aggregates those finer customer-level results back to the Region level. This is useful for metrics such as average customer sales or customer-level profitability. EXCLUDE removes dimensions from the current view’s detail, while table calculations operate later on aggregated marks. INCLUDE directly addresses the need to introduce a hidden finer-grained dimension into a calculation.<\/span><\/p>\n

          Question 305.<\/b><\/p>\n

          A view contains Region and State, but the analyst wants a calculation that ignores State and returns Region-level Sales. Which Tableau approach is most suitable?<\/b><\/p>\n

            \n
          1. <\/b> Use an EXCLUDE LOD expression for State<\/span>
            \n<\/span>2.<\/b> Use a histogram<\/span>
            \n<\/span>3.<\/b> Convert State to a measure<\/span>
            \n<\/span>4.<\/b> Apply a URL action<\/span><\/li>\n<\/ol>\n

            Correct Answer: 1<\/b><\/p>\n

            Explanation:<\/b><\/p>\n

            An EXCLUDE LOD expression removes one or more dimensions from the level of detail used for the calculation while leaving those dimensions visible in the view. If Region and State are shown, excluding State allows the calculation to return a Region-level Sales total for each state mark. This is useful for comparing state performance with the total for its parent region. A histogram analyzes numeric distributions, converting State to a measure would not produce the desired aggregation, and URL actions provide external navigation. EXCLUDE is intended specifically for broader calculations that should ignore selected dimensions already present in the visualization.<\/span><\/p>\n

            Question 306.<\/b><\/p>\n

            Which Tableau table calculation is most appropriate for showing cumulative Profit from January through each subsequent month?<\/b><\/p>\n

              \n
            1. <\/b> Difference<\/span>
              \n<\/span>2.<\/b> Running Total<\/span>
              \n<\/span>3.<\/b> Percent of Total<\/span>
              \n<\/span>4.<\/b> Rank<\/span><\/li>\n<\/ol>\n

              Correct Answer: 2<\/b><\/p>\n

              Explanation:<\/b><\/p>\n

              Running Total accumulates the selected measure across the chosen addressing dimension. If Month is arranged chronologically and SUM(Profit) is used, the calculation adds January Profit to February, then adds March, and continues through the sequence. This makes it ideal for year-to-date profitability and cumulative performance tracking. The analyst must verify the Compute Using setting so the calculation progresses across Month and resets where intended, such as at the start of a new year. Difference measures changes between marks, Percent of Total shows contribution, and Rank orders marks. For cumulative values over time, Running Total is the appropriate calculation.<\/span><\/p>\n

              Question 307.<\/b><\/p>\n

              Which table calculation is most appropriate for displaying the percentage change from one month\u2019s Sales to the next?<\/b><\/p>\n

                \n
              1. <\/b> Running Total<\/span>
                \n<\/span>2.<\/b> Percent of Total<\/span>
                \n<\/span>3.<\/b> Percent Difference<\/span>
                \n<\/span>4.<\/b> Rank<\/span><\/li>\n<\/ol>\n

                Correct Answer: 3<\/b><\/p>\n

                Explanation:<\/b><\/p>\n

                Percent Difference compares the current mark with another mark, typically the preceding one, and expresses the change as a percentage. Applied to monthly Sales, it can show month-over-month growth or decline. Correct addressing is essential so Tableau compares the current month with the immediately preceding month. Running Total accumulates values, Percent of Total measures each value\u2019s share of a total, and Rank orders values. Percent Difference is particularly useful when the analyst wants relative change rather than an absolute difference because it normalizes the change according to the previous period\u2019s magnitude.<\/span><\/p>\n

                Question 308.<\/b><\/p>\n

                Which Tableau table-calculation function can return the Sales value from the next mark in the current partition?<\/b><\/p>\n

                  \n
                1. <\/b> INDEX()<\/span>
                  \n<\/span>2.<\/b> SIZE()<\/span>
                  \n<\/span>3.<\/b> RANK()<\/span>
                  \n<\/span>4.<\/b> LOOKUP(SUM([Sales]),1)<\/span><\/li>\n<\/ol>\n

                  Correct Answer: 4<\/b><\/p>\n

                  Explanation:<\/b><\/p>\n

                  LOOKUP()<\/span> retrieves the value of an expression from a different mark at a relative offset within the current table-calculation partition. An offset of <\/span>1<\/span> refers to the next mark, while <\/span>-1<\/span> refers to the previous mark. This is useful for forward-looking comparisons, custom difference calculations, and checking subsequent period values. INDEX returns positional numbering, SIZE returns the number of marks in the partition, and RANK assigns a position based on values. LOOKUP depends on the current sort order, partitioning, and addressing, so those settings must be correct for the retrieved value to represent the intended next period.<\/span><\/p>\n

                  Question 309.<\/b><\/p>\n

                  Which Tableau function returns the number of marks in the current table-calculation partition?<\/b><\/p>\n

                    \n
                  1. <\/b> SIZE()<\/span>
                    \n<\/span>2.<\/b> INDEX()<\/span>
                    \n<\/span>3.<\/b> FIRST()<\/span>
                    \n<\/span>4.<\/b> LOOKUP()<\/span><\/li>\n<\/ol>\n

                    Correct Answer: 1<\/b><\/p>\n

                    Explanation:<\/b><\/p>\n

                    SIZE()<\/span> returns the number of marks or rows in the current table-calculation partition. It is useful in calculations that depend on partition length, such as custom row selection, conditional formatting, or validating whether enough observations exist for a rolling calculation. Like all table calculations, its value depends on the current partitioning of the worksheet. INDEX returns a mark’s sequential position, FIRST returns an offset to the first row, and LOOKUP retrieves values from other marks. SIZE specifically answers how many marks belong to the active calculation partition.<\/span><\/p>\n

                    Question 310.<\/b><\/p>\n

                    Which Tableau function returns a mark\u2019s sequential position in its current table-calculation partition?<\/b><\/p>\n

                      \n
                    1. <\/b> SIZE()<\/span>
                      \n<\/span>2.<\/b> INDEX()<\/span>
                      \n<\/span>3.<\/b> RANK()<\/span>
                      \n<\/span>4.<\/b> ATTR()<\/span><\/li>\n<\/ol>\n

                      Correct Answer: 2<\/b><\/p>\n

                      Explanation:<\/b><\/p>\n

                      INDEX()<\/span> assigns a sequential position to each mark in a table-calculation partition, starting with 1. It differs from RANK because INDEX is based on the ordering of marks rather than directly ranking a measure\u2019s value. This makes it useful for row numbering, advanced filtering, pagination-like logic, or custom table calculations. The result can change if the sort order changes or if the addressing configuration is modified. SIZE returns the partition size, while ATTR checks whether one common value represents the underlying data. For simple positional numbering within a partition, INDEX is the appropriate function.<\/span><\/p>\n

                      Question 311.<\/b><\/p>\n

                      Which Tableau calculation is best for averaging Sales over the current month and the two previous months?<\/b><\/p>\n

                        \n
                      1. <\/b> FIXED LOD expression<\/span>
                        \n<\/span>2.<\/b> Percent of Total<\/span>
                        \n<\/span>3.<\/b> Moving Average table calculation<\/span>
                        \n<\/span>4.<\/b> Context filter<\/span><\/li>\n<\/ol>\n

                        Correct Answer: 3<\/b><\/p>\n

                        Explanation:<\/b><\/p>\n

                        A Moving Average table calculation is designed to average values across a rolling window of marks. For a three-month moving average, the analyst can configure the calculation to average the current month with the two preceding months. This smooths short-term fluctuations and helps reveal underlying trends. Because it is a table calculation, the result depends on the order of months and the Compute Using setting. A FIXED LOD expression defines aggregation granularity but does not inherently create a rolling window. Percent of Total and context filters address different analytical requirements. Moving Average is therefore the correct feature.<\/span><\/p>\n

                        Question 312.<\/b><\/p>\n

                        Which Tableau function is best suited for replacing null numeric values with zero?<\/b><\/p>\n

                          \n
                        1. <\/b> ISNULL()<\/span>
                          \n<\/span>2.<\/b> IFNULL() only<\/span>
                          \n<\/span>3.<\/b> COUNT()<\/span>
                          \n<\/span>4.<\/b> ZN()<\/span><\/li>\n<\/ol>\n

                          Correct Answer: 4<\/b><\/p>\n

                          Explanation:<\/b><\/p>\n

                          ZN()<\/span> is designed specifically for numeric null handling. When its argument is null, it returns zero; otherwise, it returns the original numeric value. This can simplify calculations where a missing numeric value should legitimately be treated as zero. IFNULL can also provide a replacement value but is more general-purpose, while ISNULL only tests whether a value is missing. COUNT performs aggregation and does not replace nulls. Analysts should make sure that converting null to zero is semantically correct because missing information and an actual measured value of zero may represent different business conditions.<\/span><\/p>\n

                          Question 313.<\/b><\/p>\n

                          Which Tableau function should be used to check whether a string starts with the prefix <\/b>INV-<\/b>?<\/b><\/p>\n

                            \n
                          1. <\/b> STARTSWITH()<\/span>
                            \n<\/span>2.<\/b> CONTAINS()<\/span>
                            \n<\/span>3.<\/b> RIGHT()<\/span>
                            \n<\/span>4.<\/b> FIND()<\/span><\/li>\n<\/ol>\n

                            Correct Answer: 1<\/b><\/p>\n

                            Explanation:<\/b><\/p>\n

                            STARTSWITH()<\/span> returns TRUE when a string begins with the specified substring. For example, <\/span>STARTSWITH([Document ID],”INV-“)<\/span> can identify invoice-related identifiers. CONTAINS tests whether the substring appears anywhere, while RIGHT extracts characters from the end of the string. FIND returns the position of a substring and could be used indirectly, but STARTSWITH expresses the business rule more clearly. Purpose-specific functions improve readability and make calculated fields easier to maintain, especially when logic is shared across multiple worksheets or workbooks.<\/span><\/p>\n

                            Question 314.<\/b><\/p>\n

                            Which Tableau string function should an analyst use to convert a text field to uppercase?<\/b><\/p>\n

                              \n
                            1. <\/b> LOWER()<\/span>
                              \n<\/span>2.<\/b> UPPER()<\/span>
                              \n<\/span>3.<\/b> TRIM()<\/span>
                              \n<\/span>4.<\/b> STR()<\/span><\/li>\n<\/ol>\n

                              Correct Answer: 2<\/b><\/p>\n

                              Explanation:<\/b><\/p>\n

                              UPPER()<\/span> converts alphabetic characters in a string to uppercase. This is useful for normalizing source values that use inconsistent capitalization. For example, <\/span>east<\/span>, <\/span>East<\/span>, and <\/span>EAST<\/span> can all be converted to <\/span>EAST<\/span> before comparison, grouping, or filtering. LOWER converts text to lowercase, TRIM removes surrounding spaces, and STR converts compatible non-string values into text. Standardizing capitalization can prevent logically identical values from appearing as separate categories and can improve the reliability of calculated-field comparisons and custom classification logic.<\/span><\/p>\n

                              Question 315.<\/b><\/p>\n

                              Which Tableau function can replace a substring such as <\/b>Ltd.<\/b> with <\/b>Limited<\/b> inside a text field?<\/b><\/p>\n

                                \n
                              1. <\/b> TRIM()<\/span>
                                \n<\/span>2.<\/b> FIND()<\/span>
                                \n<\/span>3.<\/b> REPLACE()<\/span>
                                \n<\/span>4.<\/b> LEN()<\/span><\/li>\n<\/ol>\n

                                Correct Answer: 3<\/b><\/p>\n

                                Explanation:<\/b><\/p>\n

                                REPLACE()<\/span> substitutes occurrences of one substring with another. For example, <\/span>REPLACE([Company],”Ltd.”,”Limited”)<\/span> can standardize company naming for analysis or display. This transformation affects the Tableau calculation result rather than permanently modifying the underlying source data. TRIM removes whitespace, FIND returns the position of a substring, and LEN returns the number of characters in a string. REPLACE is therefore useful for predictable text normalization, abbreviation cleanup, or removing unwanted characters where a known search-and-substitute rule can be applied consistently.<\/span><\/p>\n

                                Question 316.<\/b><\/p>\n

                                Which Tableau date function should be used to calculate the number of months between Order Date and Ship Date?<\/b><\/p>\n

                                  \n
                                1. <\/b> DATEADD()<\/span>
                                  \n<\/span>2.<\/b> DATETRUNC()<\/span>
                                  \n<\/span>3.<\/b> DATEPART()<\/span>
                                  \n<\/span>4.<\/b> DATEDIFF()<\/span><\/li>\n<\/ol>\n

                                  Correct Answer: 4<\/b><\/p>\n

                                  Explanation:<\/b><\/p>\n

                                  DATEDIFF()<\/span> returns the difference between two dates using a specified unit. An expression such as <\/span>DATEDIFF(‘month’,[Order Date],[Ship Date])<\/span> calculates the number of month boundaries between the two dates. This can be useful for long fulfillment periods, subscription duration, or tenure calculations. DATEADD shifts a date, DATETRUNC rounds a date to a time boundary, and DATEPART extracts one component. The analyst should remember that DATEDIFF counts boundaries between the dates rather than necessarily measuring exact fractional months. For elapsed date units, DATEDIFF is the correct function.<\/span><\/p>\n

                                  Question 317.<\/b><\/p>\n

                                  Which Tableau function should be used to return the beginning of the month that contains a date?<\/b><\/p>\n

                                    \n
                                  1. <\/b> DATETRUNC(‘month’,[Date])<\/span>
                                    \n<\/span>2.<\/b> MONTH([Date])<\/span>
                                    \n<\/span>3.<\/b> DATEADD(‘month’,1,[Date])<\/span>
                                    \n<\/span>4.<\/b> DATEDIFF(‘month’,[Date],TODAY())<\/span><\/li>\n<\/ol>\n

                                    Correct Answer: 1<\/b><\/p>\n

                                    Explanation:<\/b><\/p>\n

                                    DATETRUNC(‘month’,[Date])<\/span> returns the first day of the month containing the source date. It retains a date data type and preserves the year context, which makes it useful for grouping, comparing, joining, or plotting monthly periods. MONTH returns only the month component, while DATEADD shifts dates and DATEDIFF measures intervals. DATETRUNC is especially helpful when the analyst wants all dates in a given month to map to a consistent month-start value rather than simply returning a month name or month number.<\/span><\/p>\n

                                    Question 318.<\/b><\/p>\n

                                    Which Tableau operation should be used to append rows from similarly structured tables such as <\/b>Sales_2024<\/b>, <\/b>Sales_2025<\/b>, and <\/b>Sales_2026<\/b>?<\/b><\/p>\n

                                      \n
                                    1. <\/b> Join<\/span>
                                      \n<\/span>2.<\/b> Union<\/span>
                                      \n<\/span>3.<\/b> Relationship<\/span>
                                      \n<\/span>4.<\/b> Blend<\/span><\/li>\n<\/ol>\n

                                      Correct Answer: 2<\/b><\/p>\n

                                      Explanation:<\/b><\/p>\n

                                      A union stacks rows vertically from tables that have compatible column structures. If the yearly Sales tables contain the same fields, a union can combine them into one dataset spanning multiple years. A join combines columns based on matching keys, while relationships connect logical tables without immediately flattening them. Data blending combines aggregated results from different data sources. When data is partitioned by year, month, or another period and each table follows the same schema, a union is the natural operation for creating one continuous analytical dataset.<\/span><\/p>\n

                                      Question 319.<\/b><\/p>\n

                                      Which join type preserves all records from both tables, including records that do not match?<\/b><\/p>\n

                                        \n
                                      1. <\/b> Inner join<\/span>
                                        \n<\/span>2.<\/b> Left join<\/span>
                                        \n<\/span>3.<\/b> Full outer join<\/span>
                                        \n<\/span>4.<\/b> Right join<\/span><\/li>\n<\/ol>\n

                                        Correct Answer: 3<\/b><\/p>\n

                                        Explanation:<\/b><\/p>\n

                                        A full outer join preserves all matching records and also retains unmatched records from both the left and right tables. When no corresponding record exists on one side, the fields from that side are null. This is useful when analysts need a complete view of both populations, including records missing a counterpart. Inner joins keep only matched records, while left and right joins preserve the complete population from only one side. Full outer joins can increase result size and expose data-quality issues, so analysts should review join keys and row counts carefully after combining the tables.<\/span><\/p>\n

                                        Question 320.<\/b><\/p>\n

                                        A dashboard user should be able to click a Product Category and have multiple other worksheets show only data related to that category. Which Tableau feature should be configured?<\/b><\/p>\n

                                          \n
                                        1. <\/b> Highlight action<\/span>
                                          \n<\/span>2.<\/b> Parameter action<\/span>
                                          \n<\/span>3.<\/b> URL action<\/span>
                                          \n<\/span>4.<\/b> Filter action<\/span><\/li>\n<\/ol>\n

                                          Correct Answer: 4<\/b><\/p>\n

                                          Explanation:<\/b><\/p>\n

                                          A filter action passes values from selected marks in a source worksheet to one or more target worksheets and restricts those target views to matching data. Selecting a Product Category can therefore cause tables, charts, and maps elsewhere on the dashboard to show only records associated with that category. A highlight action keeps unrelated marks visible, parameter actions update parameters, and URL actions open external resources. Filter actions are one of Tableau\u2019s most common dashboard interaction tools because they allow visualizations themselves to act as intuitive filtering controls for related views.<\/span><\/p>\n

                                           <\/p>\n","protected":false},"excerpt":{"rendered":"

                                          View Full Tableau TDA-C01 Exam Dumps and Practice Test Dumps   Question 301. An analyst wants to show only the top 5 Product Sub-Categories by SUM(Sales) within a selected Region. Which approach is most appropriate? Add Region to context, then apply a Top 5 filter to Sub-Category based on SUM(Sales) 2. Apply a Top 5 […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[1648,1647],"tags":[],"_links":{"self":[{"href":"https:\/\/www.examlabs.com\/certification\/wp-json\/wp\/v2\/posts\/23350"}],"collection":[{"href":"https:\/\/www.examlabs.com\/certification\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.examlabs.com\/certification\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.examlabs.com\/certification\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.examlabs.com\/certification\/wp-json\/wp\/v2\/comments?post=23350"}],"version-history":[{"count":1,"href":"https:\/\/www.examlabs.com\/certification\/wp-json\/wp\/v2\/posts\/23350\/revisions"}],"predecessor-version":[{"id":23351,"href":"https:\/\/www.examlabs.com\/certification\/wp-json\/wp\/v2\/posts\/23350\/revisions\/23351"}],"wp:attachment":[{"href":"https:\/\/www.examlabs.com\/certification\/wp-json\/wp\/v2\/media?parent=23350"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.examlabs.com\/certification\/wp-json\/wp\/v2\/categories?post=23350"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.examlabs.com\/certification\/wp-json\/wp\/v2\/tags?post=23350"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}