View Full Salesforce Certified Tableau Data Analyst Exam Dumps and Practice Test Dumps

 

Question 141.

Which Tableau function checks whether a value is missing?

1. ZN
2. ISNULL
3. DATEADD
4. CONTAINS

Correct Answer: 2

Explanation:

The ISNULL function checks whether an expression contains a null value and returns TRUE or FALSE accordingly. It is useful when analysts need to identify missing information and handle it within calculated fields. For example, a calculation can display a replacement label when a customer field is null. ISNULL can also be combined with conditional logic to create more controlled results. Analysts should distinguish null values from empty strings because they are not always treated identically. Properly identifying missing values helps improve calculations, filtering, and data-quality analysis throughout a Tableau workbook.

Question 142.

Which function replaces null numeric values with zero?

1. IFNULL
2. ATTR
3. MAKEDATE
4. STR

Correct Answer: 1

Explanation:

IFNULL returns an alternative value when the first expression evaluates to null. For numerical analysis, it can replace missing values with zero when that interpretation is appropriate. For example, a calculation can use IFNULL around a sales measure so that missing results are represented as zero. The replacement should always make business sense because a missing value does not necessarily mean that the actual amount was zero. IFNULL is especially useful in calculated fields where null results would otherwise affect arithmetic or visualization behavior. Analysts should understand the source of missing values before selecting a replacement value.

Question 143.

Which calculation extracts the month number from a date?

1. DATENAME
2. DATEDIFF
3. DATEPART
4. TODAY

Correct Answer: 3

Explanation:

DATEPART extracts a specific component from a date, such as year, quarter, month, week, or day. When the month part is requested, Tableau returns the corresponding numeric month value. This is useful when analysts need to perform calculations or comparisons using a particular date component. DATEPART differs from DATENAME because DATENAME returns a textual representation, while DATEPART returns the requested component as a numeric or appropriate date-part value. Choosing the correct function depends on whether the calculation needs a number for further processing or a descriptive name for display.

Question 144.

Which function returns the name of a date component?

1. DATENAME
2. DATEPART
3. DATEADD
4. DATEDIFF

Correct Answer: 1

Explanation:

DATENAME returns a textual representation of a specified date component. For example, it can return the name of a month or weekday rather than its numeric position. This makes DATENAME useful when creating labels intended for presentation or categorical analysis. It differs from DATEPART, which is generally used when the numerical component is required for calculations. Analysts should choose the function according to the intended output. Using DATENAME can make visualizations easier to read when descriptive date labels are preferable, while DATEPART is more appropriate when numerical date components are needed for analytical logic.

Question 145.

What does a calculated field allow an analyst to create?

1. New analytical logic
2. Physical database tables
3. User account credentials
4. Workbook storage folders

Correct Answer: 1

Explanation:

A calculated field allows analysts to create new values using formulas based on existing fields, constants, functions, and logical conditions. Calculations can support tasks such as custom metrics, classifications, date manipulation, conditional labeling, and mathematical analysis. They are created within Tableau rather than requiring direct modification of the original source database. Calculated fields can be reused across worksheets and dashboards, making them valuable for consistent analytical logic. Before creating a calculation, analysts should understand the data types and level of detail involved because aggregation and granularity can influence the resulting values.

Question 146.

Which function converts a numeric value into text?

1. FLOAT
2. INT
3. STR
4. ABS

Correct Answer: 3

Explanation:

The STR function converts a value into a string representation. This can be useful when a numerical value needs to participate in text-based calculations or display logic. For example, an analyst may need to combine a numeric identifier with descriptive text in a calculated field. Converting data types should be done deliberately because text values cannot always be used directly in numerical operations. Tableau provides several conversion functions for different situations. Analysts should preserve the original numeric field when calculations still require mathematical operations and use the converted version only where textual treatment is appropriate.

Question 147.

Which Tableau function calculates the difference between two dates?

1. DATEADD
2. DATEDIFF
3. DATETRUNC
4. MAKEDATE

Correct Answer: 2

Explanation:

DATEDIFF calculates the difference between two dates according to a specified date part, such as days, weeks, months, or years. It is useful for measuring durations and intervals. For example, analysts can calculate the number of days between an order date and a shipment date. The selected date part determines how the difference is interpreted, so choosing the correct unit is important. DATEDIFF does not simply subtract displayed date labels; it applies Tableau’s date logic to the specified components. Analysts should also consider whether partial periods and boundary crossings affect the interpretation of the resulting value.

Question 148.

Which function shifts a date forward or backward by an interval?

1. DATEADD
2. DATEDIFF
3. DATENAME
4. DATEPART

Correct Answer: 1

Explanation:

DATEADD adds a specified number of units to a date and can therefore move a date forward or backward. Units can include days, weeks, months, quarters, and years. This function is useful for creating comparison periods, adjusting dates, and building time-based calculations. For example, an analyst can calculate a date one month after an original transaction date. Negative intervals can move dates backward. DATEADD differs from DATEDIFF because it produces an adjusted date rather than measuring the distance between two dates. Careful selection of the date unit ensures the calculation matches the intended business period.

Question 149.

What does DATETRUNC do to a date value?

1. Converts it to text
2. Rounds it to a level
3. Removes all dates
4. Calculates elapsed time

Correct Answer: 2

Explanation:

DATETRUNC truncates a date to a specified level of detail, such as year, quarter, month, week, or day. This is useful when analysts want dates grouped consistently at a particular temporal level while retaining a date-type result. For example, truncating transaction dates to months allows records from the same month to share a common date value. DATETRUNC differs from simply formatting a date because formatting changes how a value appears, while truncation changes the date value used in the calculation. This distinction is important when creating date-based groupings and comparisons.

Question 150.

Which Tableau function returns the current date?

1. NOW
2. TODAY
3. DATEPARSE
4. MAKEDATE

Correct Answer: 2

Explanation:

TODAY returns the current date according to the environment in which the Tableau calculation is evaluated. It is useful for calculations that need to compare records with the present date, such as identifying recent transactions or calculating age in days. TODAY focuses on the date rather than providing a complete date-and-time value. Analysts should distinguish it from NOW, which includes the current date and time. Dynamic date functions can change as time passes, so calculations using TODAY should be tested with that behavior in mind when building dashboards or scheduled reports.

Question 151.

Which function returns the current date and time?

1. TODAY
2. NOW
3. DATE
4. YEAR

Correct Answer: 2

Explanation:

NOW returns the current date and time, making it useful when both calendar information and time information are required. For example, an analyst can compare a timestamp with the current moment when monitoring recent activity. Unlike TODAY, which provides the current date, NOW includes time-of-day information. Dynamic functions should be used carefully because their results can change as the calculation is evaluated or refreshed. Analysts should also consider the relevant time zone and data-source behavior when interpreting time-sensitive results. Choosing NOW instead of TODAY depends on whether time-of-day precision is needed.

Question 152.

Which function creates a date from separate year, month, and day values?

1. MAKEDATE
2. DATEPART
3. DATEADD
4. DATETRUNC

Correct Answer: 1

Explanation:

MAKEDATE creates a date using separate year, month, and day components. This is useful when source data stores date information across multiple fields rather than in one complete date field. Combining those components into a proper date allows Tableau to perform chronological sorting, date calculations, and time-based analysis more effectively. The supplied components need to represent valid calendar information for the resulting date to be meaningful. Analysts should verify the source fields before constructing the calculation, particularly when data comes from systems that store calendar components separately.

Question 153.

Which chart is effective for comparing many categorical values?

1. Bar chart
2. Area chart
3. Polygon map
4. Circle view

Correct Answer: 1

Explanation:

A bar chart is effective for comparing values across multiple categories because the lengths of bars provide a straightforward visual representation of magnitude. Categories can be arranged vertically or horizontally, depending on the number and length of labels. Sorting bars by the measure being analyzed can make larger and smaller values easier to identify. Bar charts are commonly used for product, region, customer, or department comparisons. They generally support precise comparisons better than charts that rely primarily on angles or areas. Analysts should avoid displaying excessive categories when readability becomes difficult.

Question 154.

Which visualization is useful for showing part-to-whole relationships?

1. Scatter diagram
2. Pie chart
3. Gantt timeline
4. Density display

Correct Answer: 2

Explanation:

A pie chart represents categories as portions of a complete whole. Each slice corresponds to a category’s contribution to the total, making the visualization suitable when the number of categories is limited and composition is the primary analytical question. Pie charts become harder to interpret when many similarly sized slices are present. Analysts should therefore use clear labels and avoid unnecessary categories when choosing this format. For precise comparisons among numerous categories, alternatives such as bars may provide easier visual measurement. The suitability of a pie chart depends on whether understanding overall composition is more important than exact category-to-category comparison.

Question 155.

What does a Gantt chart primarily represent?

1. Duration across time
2. Geographic boundaries
3. Percentage composition
4. Statistical correlation

Correct Answer: 1

Explanation:

A Gantt chart represents the duration or timing of activities across a timeline. It is useful for showing when tasks begin, how long they continue, and how activities relate to a broader schedule. Tableau can create Gantt-style views by using dates and duration-related measures. Common applications include project planning, shipment timelines, service periods, and operational schedules. Gantt charts focus on temporal duration rather than simple category comparison. Analysts should select appropriate date granularity and ensure that task labels remain readable. This visualization is particularly useful when understanding the timing and overlap of multiple activities is important.

Question 156.

Which visualization uses color intensity to compare values in a matrix?

1. Heat map
2. Symbol map
3. Funnel diagram
4. Timeline chart

Correct Answer: 1

Explanation:

A heat map uses color intensity to represent measure values across intersecting categories or dimensions. This makes it useful for identifying concentrations, differences, and patterns within a matrix-like structure. For example, an analyst can display sales across products and regions, with stronger visual intensity representing larger values. Heat maps are especially effective when many combinations need to be compared within limited dashboard space. Appropriate color encoding and legends are important because users must understand what changes in intensity represent. Analysts should avoid overly complex palettes that make neighboring values difficult to distinguish.

Question 157.

Which Tableau feature can display a numeric metric inside a compact dashboard tile?

1. KPI card
2. Density mark
3. Polygon layer
4. Spatial bin

Correct Answer: 1

Explanation:

A KPI card presents an important performance measure prominently so users can quickly understand a key result. In Tableau, KPI-style displays can be built using text marks, calculated fields, and supporting visual elements. They are commonly used for metrics such as revenue, profit, order count, or attainment percentage. A KPI should focus on a clearly defined measure and may include contextual information such as a comparison period or target. Analysts should avoid filling dashboards with too many KPI cards because excessive headline metrics can reduce focus and make it harder for users to identify the most important information.

Question 158.

Which feature can restrict records based on a condition before analysis?

1. Data source filter
2. Worksheet caption
3. Dashboard image
4. Story navigator

Correct Answer: 1

Explanation:

A data source filter limits the records available from a data source before they are used throughout the workbook. This can reduce the amount of information processed and can help ensure that only relevant records are available for analysis. For example, a workbook may be restricted to a particular business division or reporting period. Because the filter operates at the data-source level, its effect can extend across worksheets using that source. Analysts should configure such filters carefully because removing records at this stage can affect calculations and views throughout the workbook.

Question 159.

What does a worksheet filter primarily control?

1. Visible data members
2. Workbook permissions
3. Dashboard background
4. Server schedules

Correct Answer: 1

Explanation:

A worksheet filter controls which values or records are displayed within a particular worksheet. It can be applied to dimensions, measures, dates, or other supported fields depending on the analytical requirement. Worksheet filters allow users to focus on a relevant subset without necessarily changing the underlying source data. For example, a worksheet can be restricted to one quarter while other worksheets remain unaffected. The scope of filtering should always be reviewed when designing a dashboard. Analysts should also check interactions between multiple filters because combined conditions can significantly change the resulting view.

Question 160.

Which Tableau option helps publish a workbook for shared access?

1. Tableau Server
2. Data Interpreter
3. Calculation pane
4. Measure shelf

Correct Answer: 1

Explanation:

Tableau Server provides a platform for publishing and sharing Tableau workbooks and data sources within an organization. Published content can be accessed by authorized users through a centralized environment, supporting collaboration and governed analytics. Depending on configuration, users may interact with dashboards through a browser rather than opening the original workbook locally. Administrators can manage permissions and other access controls around published content. Analysts should understand the organization’s publishing and governance requirements before sharing workbooks. Proper permissions, data access, refresh configuration, and content organization all contribute to a reliable shared analytics environment.