Tableau Data Analyst Test - 5

Welcome to your Tableau Data Analyst – Test-05

Name

Phone

Q1. How does the ‘Ranking‘ custom table calculation handle tied values in Tableau?

Select 1 option(s):

It ignores tied values and continues ranking without interruption

It assigns sequential ranks to tied values

It assigns the same rank to all tied values and continues with the next rank without a gap

It assigns the same rank to all tied values and leaves a gap in the subsequent ranks

Q2. In Tableau, how can you connect to a relational database using custom SQL queries?

Select 1 option(s):

Use the ‘Import Data‘ option and write SQL queries

Use the ‘Connect to Data‘ option and select the database

Use the ‘Connect to Data‘ option and choose the ‘Custom SQL‘ option

Use the ‘Open‘ option and write SQL queries

Q3. What is the purpose of a Symbol Map in Tableau?

Select 1 option(s):

To represent data points as a grid of colored rectangles, with color intensity indicating data values

To represent data points by using different symbols or icons to convey information

To cluster data points based on geographical proximity

To fill areas with color based on data values

Q4. You want to visualize the distribution of customer ages in your dataset. Which chart type should you use in Tableau?

Select 1 option(s):

Tree map

Scatter plot

Histogram

Gantt chart

Q5. What does a moving average quick table calculation in Tableau calculate?

Select 1 option(s):

An average that moves with the data

An average that remains constant

A total sum of the data points

A median value of the data

Q6. You want to compare the sales performance of different products in a specific region. Which chart type should you use in Tableau?

Select 1 option(s):

Histogram

Tree map

Scatter plot

Bar chart

Q7. You want to create a dashboard that displays key performance indicators (KPIs) for different regions. Which object should you use in Tableau to display the KPIs?

Select 1 option(s):

Filter

URL Action

Object

Indicator

Q8. You have a dataset with a column containing product ratings on a scale of 1 to 5. You want to create a calculated field to categorize the ratings into groups such as ‘Low,‘ ‘Medium,‘ and ‘High.‘ What function should you use in the calculated field?

Select 1 option(s):

IF [Rating] <= 2 THEN ‘Low‘ ELSEIF [Rating] <= 4 THEN ‘Medium‘ ELSE ‘High‘ END

GROUPBY([Rating], 2, 4)

IF [Rating] < 3 THEN ‘Low‘ ELSEIF [Rating] < 4 THEN ‘Medium‘ ELSE ‘High‘ END

CATEGORIZE([Rating], 1, 3, 5)

Q9. You have a dataset with a column containing product categories, and you want to create a calculated field to assign a numerical value to each category for analysis. What function should you use in the calculated field?

Select 1 option(s):

LEN([Product Category])

FIND([Product Category], ‘Electronics‘)

IF [Product Category] = ‘Electronics‘ THEN 1 ELSE 0 END

SUM(IF [Product Category] = ‘Electronics‘ THEN 1 ELSE 0 END)

Q10. You want to display additional information about a data point when users hover over it in your Tableau dashboard. Which formatting option should you use?

Select 1 option(s):

Tooltips

Annotations

Data sources

Containers

Q11. When should you convert a field from continuous to discrete in Tableau?

Select 1 option(s):

When creating calculated fields

When the field represents numerical data

When creating sets

When the field represents categorical data

Q12. What is the purpose of a URL action in Tableau dashboards?

Select 1 option(s):

To add color and formatting to the dashboard

To create custom shapes and designs

To display summary statistics for a selected field

To add hyperlinks to specific data points or visualizations

Q13. How can you apply a filter to a specific view in Tableau?

Select 1 option(s):

By dragging a field onto the view and configuring the filter

By selecting “View“ from the toolbar and choosing “Apply Filter“

By double-clicking on the view and choosing “Add Filter“

By right-clicking on the view and selecting “Apply Filter“

Q14. You want to create a quick visualization to show the total sales per region. Which quick table calculation should you use in Tableau?

Select 1 option(s):

Moving average

Percent of total

Percentile

Running total

Q15. What does a moving average quick table calculation in Tableau calculate?

Select 1 option(s):

An average that remains constant

An average that moves with the data

A total sum of the data points

A median value of the data

Q16. You have a dataset with a column containing dates in different time zones. How can you create a calculated field to standardize all dates to a specific time zone in Tableau?

Select 1 option(s):

DATEADD([Date], -5, ‘hour‘)

DATETIME([Date], ‘America/New_York‘)

CONVERT_TIMEZONE([Date], ‘GMT‘, ‘PST‘)

TODATETIME([Date], ‘GMT‘)

Q17. What does the difference quick table calculation do when applied to a field in Tableau?

Select 1 option(s):

It calculates the relative difference as a percentage

It calculates the average difference between values

It calculates the sum of differences between adjacent values

It calculates the absolute difference between the current and previous values

Q18. How can you schedule a Tableau Prep workflow on Tableau Server or Tableau Cloud?

Select 1 option(s):

By selecting “Server“ from the toolbar, choosing “Schedule Workflow,“ and configuring the schedule options

By right-clicking on the workflow, choosing “Schedule,“ and configuring the schedule options

By selecting “File“ from the toolbar, choosing “Schedule Workflow,“ and configuring the schedule options

By clicking on the “Server“ menu in the toolbar, choosing “Schedule Workflow,“ and configuring the schedule options

Q19. What does the “Bottom N“ filter option do in Tableau?

Select 1 option(s):

Exclude the bottom N values based on a specified dimension

Show the bottom N values based on a specified measure

Include all values except the bottom N based on a specified measure

Include only the bottom N values based on a specified dimension

Q20. How can you perform filtering in Tableau Prep?

Select 1 option(s):

By using the ‘Join‘ transformation

By using the ‘Clean‘ transformation

By using the ‘Aggregate‘ transformation

By using the ‘Filter‘ transformation

Q21. What is the purpose of using extract filters in Tableau?

Select 1 option(s):

To filter data during extraction

To enable real-time data updates

To improve query performance during visualization

To limit the data included in the extract

Q22. You want to receive notifications when specific conditions are met in your published Tableau workbook, such as website traffic exceeding a certain threshold. What action should you set up?

Select 1 option(s):

Create subscriptions

Create filters

Create sets

Create alerts

Q23. How are Hierarchies created in Tableau?

Select 1 option(s):

By organizing dimensions into levels, often based on a categorical order

By creating a calculated field

By grouping related dimensions or measures together

By defining a subset of data based on specified conditions

Q24. What does changing default field properties in Tableau include?

Select 1 option(s):

Renaming columns

Modifying sorting options

Creating aliases

Converting between dimensions and measures

Q25. Which Tableau feature is used to transform data by rotating rows into columns or columns into rows?

Select 1 option(s):

Data Interpreter

Pivoting

Joining

Blending

Q26. What does a running total quick table calculation in Tableau calculate?

Select 1 option(s):

A total sum of the data points

A median value of the data

A total that accumulates over a specific dimension

A total that remains constant

Q27. You want to automate the delivery of specific Tableau workbook views to a SharePoint site on a regular basis. What action should you set up?

Select 1 option(s):

Create filters

Create subscriptions

Create alerts

Create sets

Q28. How can you add a custom color palette to a Tableau dashboard?

Select 1 option(s):

By dragging a color palette field onto the dashboard and configuring the colors

By selecting “Format“ from the toolbar and choosing “Add Color Palette“

By right-clicking on the dashboard and selecting “Add Color Palette“

By clicking on the color palette icon in the toolbar and choosing “Add Custom Palette“

Q29. How can you add an image to a Tableau dashboard?

Select 1 option(s):

By right-clicking on the dashboard canvas and selecting “Insert Image“

By selecting “Dashboard“ from the toolbar and choosing “Add Image“

By dragging an image file from the computer onto the dashboard

By dragging an image field from the data source and dropping it onto the dashboard

Q30. In Tableau, what does the “Wildcard“ filter option allow you to do?

Select 1 option(s):

Filter values based on their alphabetical order

Filter values that match a specific pattern using wildcard characters

Filter values that do not match a specific pattern using wildcard characters

Filter values based on their numerical order

Q31. You have a dataset with a column containing decimal values, and you want to round these values to the nearest whole number in Tableau. Which number function should you use?

Select 1 option(s):

ROUND()

CEIL()

FLOOR()

INT()

Q32. What is a Choropleth Map (Filled Map) in Tableau used for?

Select 1 option(s):

Representing data points as a grid of colored rectangles, with color intensity indicating data values

Clustering data points based on geographical proximity

Filling areas with color based on data values

Using different symbols or icons to convey information

Q33. You are preparing data for analysis in Tableau. The data source contains incomplete data in some columns. What should you do to assess data quality?

Select 1 option(s):

Use Data Interpreter to automatically clean incomplete data

Manually review the data and identify incomplete records

Use aggregations to fill in missing values

Ignore incomplete data during analysis

Q34. What does the compound growth rate quick table calculation in Tableau indicate when the result is greater than 1?

Select 1 option(s):

Negative growth

No growth

Positive growth

Exponential growth

Q35. You have a dataset with a column containing order quantities, and you want to create a calculated field to calculate the total order quantity for each category. What function should you use in the calculated field?

Select 1 option(s):

SUM([Order Quantity])

TOTAL(SUM([Order Quantity]))

WINDOW_SUM(SUM([Order Quantity]))

RUNNING_SUM(SUM([Order Quantity]))

Q36. You want to create a calculated field to calculate the year-over-year growth rate of sales. Which table calculation should you use in Tableau?

Select 1 option(s):

Moving average

Percent of total

Running total

Year over year

Q37. What is the purpose of connecting to extracts in Tableau?

Select 1 option(s):

To create a backup of the original data source

To enable real-time data updates

To improve performance and allow offline work

To automatically schedule data refreshes

Q38. How can you print content from Tableau Server or Tableau Cloud?

Select 1 option(s):

By selecting “Server“ from the toolbar and choosing “Print“

By right-clicking on the content and selecting “Print“

By clicking on the content and choosing “Print“ from the toolbar

By selecting “File“ from the toolbar and choosing “Print“

Q39. You need to connect to multiple spreadsheets containing different datasets and merge them into one dataset for analysis. What action should you take?

Select 1 option(s):

Connect to each spreadsheet separately and blend the data in Tableau

Union the spreadsheets in Tableau to combine the data

Use custom SQL queries to join the spreadsheets

Export the spreadsheets to a single CSV file and import it into Tableau

Q40. Which of the following is a valid method to pull data from relational databases in Tableau?

Select 1 option(s):

Use custom SQL queries

Use only pre-built queries

Use only stored procedures

Use only views

Q41. What does the DATEDIFF function in Tableau do?

Select 1 option(s):

Extracts date components

Adds or subtracts time intervals to a date

Calculates the difference between two dates

Parses date strings

Q42. How can you write string functions in Tableau for manipulating text values?

Select 1 option(s):

Using the STR function

Using the NUM function

Using the CASE statement

Using the LEFT function

Q43. How can you apply a specific color scheme to a Tableau dashboard?

Select 1 option(s):

By selecting a color palette from the “Color“ dropdown menu in the toolbar

By right-clicking on a visualization and choosing “Apply Color Scheme“

By dragging a color field onto the dashboard and configuring the color palette

By selecting “Format“ from the toolbar and choosing “Apply Color Scheme“

Q44. Which type of chart in Tableau is suitable for displaying the relationship between two numerical variables, where one variable is plotted on the X-axis and the other on the Y-axis?

Select 1 option(s):

Line Chart

Scatter Plot

Bar Chart

Pie Chart

Q45. How can you assess data accuracy in Tableau?

Select 1 option(s):

By checking the completeness of data records

By validating data formats

By cross-referencing with external sources or known values

By organizing data into folders

Q46. Which function in Tableau is used to write logical and Boolean expressions, allowing conditional logic in calculated fields?

Select 1 option(s):

STR

INT

AVG

Q47. What does the percent of difference quick table calculation represent in Tableau?

Select 1 option(s):

The absolute difference between values

The relative difference as a percentage

The sum of differences between adjacent values

The average difference between values

Q48. You have a data source in Tableau Desktop that you want to share with your colleagues so they can create their own analyses. What action should you perform?

Select 1 option(s):

Publish a workbook

Publish a data source

Print a data source

Export a data source

Q49. How can you create a URL action in a Tableau dashboard?

Select 1 option(s):

By dragging a URL field from the data source and dropping it onto the dashboard

By right-clicking on a sheet and selecting “Create URL Action“

By selecting “Dashboard“ from the toolbar and choosing “Create URL Action“

By dragging a dimension onto the “Pages“ shelf and configuring it as a URL

Q50. How can you write date calculations in Tableau, specifically to parse a date string into a date data type?

Select 1 option(s):

DATEADD

DATEPARSE

DATEPART

DATEDIFF

Q51. Scenario: You have a dataset containing employee performance metrics, including productivity scores and project completion times. Your objective is to identify high-performing employees based on their overall contributions to project success.

Question: Which Tableau feature would be most appropriate for identifying high-performing employees based on their overall contributions to project success in the dataset?

Select 1 option(s):

Utilize Tableau‘s correlation analysis feature to identify relationships between variables

Create calculated fields to aggregate and rank employee performance scores across projects

Apply filters to isolate projects with the highest impact on overall success

Utilize Tableau‘s forecasting feature to predict future employee performance

Q52. What is the purpose of a URL action in Tableau dashboards?

Select 1 option(s):

To add hyperlinks to specific data points or visualizations

To create custom shapes and designs

To add color and formatting to the dashboard

To display summary statistics for a selected field

Q53. You are analyzing survey data and want to categorize responses as either ‘Positive,‘ ‘Neutral,‘ or ‘Negative.‘ Which logical function should you use in Tableau?

Select 1 option(s):

IIF([Response] > 3, ‘Positive‘, ‘Negative‘)

CASE [Response] WHEN 3 THEN ‘Neutral‘ ELSE IF [Response] > 3 THEN ‘Positive‘ ELSE ‘Negative‘ END

IF [Response] = 3 THEN ‘Neutral‘ ELSEIF [Response] > 3 THEN ‘Positive‘ ELSE ‘Negative‘ END

IF [Response] > 3 THEN ‘Positive‘ ELSEIF [Response] = 3 THEN ‘Neutral‘ ELSE ‘Negative‘ END

Q54. You want to create a parameter in Tableau to allow users to dynamically adjust the reference line value in a visualization. Which parameter configuration should you use?

Select 1 option(s):

In calculations

With filters

With reference lines

Q55. What is the first step in connecting to data sources in Tableau?

Select 1 option(s):

Choose an appropriate data source

Choose between live connection or extract

Connect to extracts

Connect to spreadsheets

Q56. In Tableau, which chart type is used to display data points as circles on a two-dimensional plane, where the position of each point is determined by its two numerical values?

Select 1 option(s):

Bar Chart

Scatter Plot

Line Chart

Pie Chart

Q57. How can you publish a Tableau workbook to Tableau Server or Tableau Cloud?

Select 1 option(s):

By selecting “Server“ from the toolbar and choosing “Publish Workbook“

By right-clicking on the workbook and selecting “Publish to Server“

By clicking on the “Server“ menu in the toolbar and choosing “Publish Workbook“

By selecting “File“ from the toolbar and choosing “Publish to Server“

Q58. What does the “Exclude“ filter setting do in Tableau?

Select 1 option(s):

Excludes only the values specified in the filter

Excludes all values except the ones specified in the filter

Excludes a range of values based on the filter criteria

Excludes additional values related to the ones specified in the filter

Q59. How is the percentile quick table calculation in Tableau affected by the specified percentile value?

Select 1 option(s):

It determines the percentage of values above the specified percentile

It determines the percentage of values below the specified percentile

It determines the value at the specified percentile position

It has no impact on the calculation

Q60. Which chart type is best suited for displaying data points as bars and is often used for comparing categorical data?

Select 1 option(s):

Line Chart

Scatter Plot

Bar Chart

Pie Chart