Tableau Data Analyst Test - 6

Welcome to your Tableau Data Analyst – Test-06

Name

Phone

Q1. In Tableau, what is the purpose of the “Custom Shapes“ feature?

Select 1 option(s):

Customize the shape of data points on a scatter plot

Create calculated fields for custom shapes

Apply conditional formatting to shape elements

Add custom images to data points in a visualization

Q2. When using the percent of total quick table calculation in Tableau, what does the computed value represent?

Select 1 option(s):

The percentage of the total distinct values in the dataset

The percentage of the total sum of the measure across all dimensions

The percentage of the total columns in the dataset

The percentage of the total rows in the dataset

Q3. How can you create alerts for a published workbook on Tableau Server or Tableau Cloud?

Select 1 option(s):

By clicking on the “Server“ menu in the toolbar, choosing “Create Alert,“ and configuring the alert settings

By right-clicking on the workbook, choosing “Create Alert,“ and configuring the alert settings

By selecting “Server“ from the toolbar, choosing “Create Alert,“ and configuring the alert settings

By selecting “File“ from the toolbar, choosing “Create Alert,“ and configuring the alert settings

Q4. What is the primary purpose of Tableau stories?

Select 1 option(s):

To add hyperlinks to specific data points or visualizations

To display summary statistics for a selected field

To create custom shapes and designs

To present a sequence of visualizations that convey a narrative

Q5. How does a Heat Map in Tableau represent data on a map?

Select 1 option(s):

By using different symbols or icons to convey information

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

By clustering data points based on geographical proximity

By filling areas with color based on data values

Q6. When applying a filter to dimensions and measures in Tableau, what does the “Top N“ filter option allow you to do?

Select 1 option(s):

Exclude the top N values based on a specified dimension

Include only the top N values based on a specified dimension

Show the top N values based on a specified measure

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

Q7. How can you apply padding to a Tableau dashboard?

Select 1 option(s):

By right-clicking on the dashboard and selecting “Apply Padding“

By dragging a padding field onto the dashboard and configuring the padding

By selecting “Format“ from the toolbar and choosing “Apply Padding“

By clicking on the dashboard canvas and adjusting the padding handles

Q8. When should you use a union operation in Tableau?

Select 1 option(s):

To aggregate data values

To sort data records

To combine rows from tables with different columns

To filter data during extraction

Q9. How can you sort data in Tableau, including custom sort?

Select 1 option(s):

By right-clicking on the field and selecting “Sort“

All of the above

By dragging the field to the “Sort“ shelf

By clicking on the column header of the field you want to sort

Q10. How does the running total quick table calculation behave in Tableau when dealing with dimensions?

Select 1 option(s):

It does not work with dimensions

It accumulates values based on the specified dimension

It resets the total for each dimension value

It accumulates values over the entire dataset

Q11. What is the purpose of a dashboard action in Tableau?

Select 1 option(s):

To emphasize specific data points when interacting with a visualization

To add color and formatting to the dashboard

To add hyperlinks to specific data points or visualizations

To create custom shapes and designs

Q12. What is the purpose of row-level and column-level bands in Tableau dashboards?

Select 1 option(s):

To apply shading or color to entire rows or columns

To emphasize specific data points when interacting with a visualization

To add hyperlinks to specific data points or visualizations

To create custom shapes and designs

Q13. You want to create a Tableau dashboard where users can click on navigation buttons to move between different sections of the dashboard. Which interactivity feature should you use?

Select 1 option(s):

Filter action

Navigation button

Highlight action

URL action

Q14. What is the purpose of the “Custom Sort“ option in Tableau?

Select 1 option(s):

Create calculated fields for custom sorting

Sort data based on user-defined criteria

Customize the appearance of sort elements

Apply conditional formatting to sort elements

Q15. What is the purpose of the “Show at Default Position“ option in Tableau maps?

Select 1 option(s):

Enable or disable map labels

Customize the color of map labels

Display map labels at their default locations

Adjust the default position of map labels

Q16. How can you create a highlight action between sheets on a Tableau dashboard?

Select 1 option(s):

By dragging fields from one sheet to another sheet

By selecting “Sheet“ from the toolbar and choosing “Highlight Action“

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

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

Q17. In Tableau, what is the purpose of the “Table Calculation“ feature?

Select 1 option(s):

Merge tables in the Data Source tab

Perform calculations at the row or cell level

Create calculated fields based on user-defined criteria

Aggregate data in a table format

Q18. How can you create a calculated field to calculate the average discount per product category in Tableau?

Select 1 option(s):

Use the AVG() function

Apply a table calculation for average discount

Create a calculated field with an average discount formula

Utilize the WINDOW_AVG() function

Q19. What is the purpose of the “Set Controls“ feature in Tableau?

Select 1 option(s):

Create calculated fields for custom sets

Dynamically control set membership based on user interaction

Adjust the appearance of set elements on a worksheet

Filter data based on set criteria

Q20. In Tableau, what is the purpose of the “Aggregated Measures“ option in the “Analysis“ menu?

Select 1 option(s):

Adjust the appearance of aggregated measures in visualizations

Filter data based on aggregated measure values

Create calculated fields for aggregated measures

Aggregate measures based on user-defined criteria

Select 1 option(s):

Use the CAGR() function

Apply a table calculation for compound growth rate

Create a calculated field with a compound growth formula

Utilize the ANNUALIZE() function

Q22. How can you create a calculated field that calculates the difference between two date fields in Tableau?

Select 1 option(s):

Use the DATE_DIFF() function

Apply a table calculation for date difference

Create a calculated field with a date difference formula

Utilize the TOTAL() function

Q23. How can you create a calculated field to calculate the weighted average profit in Tableau?

Select 1 option(s):

Utilize the AVG() function

Apply a table calculation for weighted average

Use the WEIGHTED_AVG() function

Create a calculated field with a weighted average formula

Q24. How can you create a parameter that allows users to switch between different dimensions in Tableau?

How can you create a parameter that allows users to switch between different dimensions in Tableau?

Select 1 option(s):

Apply a filter for each dimension

Create a dual-axis chart with synchronized dimensions

Use a calculated field for each dimension

Implement a parameter and use it in the dimension formula

Q25. How can you create a calculated field to calculate the percentage of total sales for each month in Tableau?

Select 1 option(s):

Utilize the PERCENTAGE_OF_TOTAL() function

Apply a table calculation for percentage of total

Use the TOTAL() function

Create a calculated field with a percentage formula

Q26. How can you create a calculated field to calculate the correlation coefficient between two measures in Tableau?

Select 1 option(s):

Use the CORR() function

Utilize the WINDOW_CORR() function

Apply a table calculation for correlation coefficient

Create a calculated field with a correlation formula

Q27. How can you create a calculated field to calculate the percentage of total profit for each sub-category in Tableau?

Select 1 option(s):

Apply a table calculation for percentage of total

Use the PERCENTAGE_OF_TOTAL() function

Utilize the TOTAL() function

Create a calculated field with a percentage formula

Q28. In Tableau, what is the purpose of the “Forecast“ feature?

Select 1 option(s):

Aggregate data based on forecast criteria

Predict future data points based on historical trends

Create a predictive model using machine learning algorithms

Display aggregated data in a time series format

Q29. What is the purpose of the “Grand Totals“ option in Tableau?

What is the purpose of the “Grand Totals“ option in Tableau?

Select 1 option(s):

Calculate the overall average of all measures

Display grand totals for all measures in a table

Enable or disable grand totals for specific measures

Summarize data at the grand total level

Q30. How can you create a calculated field to calculate the standard deviation of a measure in Tableau?

Select 1 option(s):

Utilize the WINDOW_STDEV() function

Apply a table calculation for standard deviation

Use the STDEV() function

Create a calculated field with a standard deviation formula

Q31. What is the primary purpose of hover actions in Tableau dashboards?

Select 1 option(s):

To display additional information when hovering over a data point

To create custom shapes and designs

To add hyperlinks to specific data points or visualizations

To emphasize specific data points when interacting with a visualization

Q32. How can you create a parameter action in a Tableau dashboard?

Select 1 option(s):

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

By dragging a parameter onto the dashboard and configuring it as an action

By right-clicking on a parameter and selecting “Create Parameter Action“

By dragging a field onto the “Pages“ shelf and configuring it as a parameter

Q33. How does the ‘Union‘ transformation in Tableau Prep handle fields with different names but similar data?

Select 1 option(s):

Combines fields into a single field

Throws an error

Discards fields with different names

Automatically renames fields to match

Q34. How can you configure the frequency of data extract refreshes in Tableau?

Select 1 option(s):

By right-clicking on the data extract, choosing “Configure Refresh Schedule,“ and setting the frequency options

By clicking on the “Data“ menu in the toolbar, choosing “Configure Refresh Schedule,“ and setting the frequency options

By selecting “Extract“ from the toolbar, choosing “Configure Refresh Schedule,“ and setting the frequency options

By selecting “File“ from the toolbar, choosing “Configure Refresh Schedule,“ and setting the frequency options

Q35. You want to create a calculated field in Tableau to calculate the number of months between two dates. Which date calculation function should you use?

Select 1 option(s):

DATEDIFF(‘month‘, [Start Date], [End Date])

DATEDIFF(‘day‘, [Start Date], [End Date]) / 30.44

MONTH([End Date]) - MONTH([Start Date])

DATEPART(‘month‘, [Start Date]) - DATEPART(‘month‘, [End Date])

Q36. What does the percent of total quick table calculation represent in Tableau?

Select 1 option(s):

The percentage of the total distinct values in the dataset

The percentage of the total rows in the dataset

The percentage of the total sum of the measure across all dimensions

The percentage of the total columns in the dataset

Q37. Which chart type in Tableau is used for visualizing data points as filled circles, with the size of the circles indicating a quantitative value, and their placement indicating categories?

Select 1 option(s):

Bar Chart

Scatter Plot

Bubble Chart

Line Chart

Q38. What is the purpose of a filter action in Tableau dashboards?

Select 1 option(s):

To emphasize specific data points when interacting with a visualization

To add hyperlinks to specific data points or visualizations

To create custom shapes and designs

To filter data points based on user interaction

Q39. What is the purpose of creating joins in Tableau?

Select 1 option(s):

To aggregate data values

To sort data records

To filter data during extraction

To combine rows from two or more tables based on related columns

Q40. You want to visualize the trend in monthly sales data. Which quick table calculation should you use in Tableau?

Select 1 option(s):

Percent of total

Percentile

Moving average

Running total

Q41. What type of map in Tableau represents data points on a map using different symbols or icons to convey information?

Select 1 option(s):

Heat Map

Symbol Map

Density Map

Choropleth Map

Q42. You want to create a dashboard in Tableau that combines multiple visualizations. Which feature should you use to organize the visualizations and manage their layout?

Select 1 option(s):

Containers

Sets

Parameters

Filters

Q43. You have a dataset with a column containing order dates, and you want to create a calculated field to calculate the number of days between each order date and the current date. What function should you use in the calculated field?

Select 1 option(s):

NOW() - [Order Date]

DATEDIFF(‘day‘, [Order Date], NOW())

TODAY() - [Order Date]

DATE_DIFF(‘day‘, [Order Date], TODAY())

Q44. 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 ‘Open‘ 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

Q45. What is the purpose of scheduling data extract refreshes in Tableau?

Select 1 option(s):

To automatically update the data extract at specific intervals

To create a backup copy of the data extract

To share the data extract with other users and allow them to connect to it

To apply formatting and styling to the data extract

Q46. What does the ‘Pivot‘ transformation in Tableau Prep do to the data?

Select 1 option(s):

Rotates rows into columns

Combines data with common fields vertically

Filters data based on conditions

Combines data with common fields horizontally

Q47. What does the DATEDIFF function in Tableau do?

Select 1 option(s):

Extracts date components

Parses date strings

Adds or subtracts time intervals to a date

Calculates the difference between two dates

Q48. 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):

Pie Chart

Line Chart

Bar Chart

Scatter Plot

Q49. When using the ‘Union‘ transformation in Tableau Prep, what happens if the input tables have different columns?

Select 1 option(s):

Tableau Prep automatically deletes extra columns

Fields with matching names are combined, and nulls are added for non-matching columns

Tableau Prep automatically adjusts the columns

An error occurs

Q50. What is the primary purpose of the ‘Join‘ transformation in Tableau Prep?

Select 1 option(s):

To perform aggregations

To filter data based on conditions

To rotate rows into columns

To combine data based on common fields horizontally

Q51. How can you remove gridlines from a Tableau dashboard?

Select 1 option(s):

By right-clicking on the dashboard and selecting “Hide Gridlines“

By selecting “Format“ from the toolbar and choosing “Remove Gridlines“

By clicking on the gridlines and pressing the Delete key

By dragging a gridline field onto the dashboard and configuring it as blank

Q52. How can you apply responsive design for specific device layouts in Tableau dashboards?

Select 1 option(s):

By selecting “Format“ from the toolbar and choosing “Responsive Design“

By dragging a device layout field onto the dashboard and configuring it as responsive

By right-clicking on the dashboard and selecting “Apply Responsive Design“

By clicking on the device layout icon in the toolbar and choosing a specific device

Q53. You want to annotate a specific data point in your Tableau visualization to provide additional context. Which formatting option should you use?

Select 1 option(s):

Data sources

Dashboard theme

Containers

Annotations

Q54. What is the primary benefit of scheduling data updates in Tableau Server or Tableau Cloud?

Select 1 option(s):

To create a backup copy of the data

To ensure that the data is always up-to-date without manual intervention

To reduce the number of users accessing the data

To save storage space on the server

Q55. You want to create a calculated field in Tableau to convert a string field into uppercase. Which string function should you use?

Select 1 option(s):

PROPER()

UPPER()

LOWER()

TRIM()

Q56. What is the purpose of creating alerts for published workbooks in Tableau?

Select 1 option(s):

To share the workbook with other users

To apply conditional formatting to specific data points

To create a backup copy of the workbook

To receive notifications when specified conditions are met in the workbook data

Q57. How can you perform data transformation based on a specific business requirement in Tableau Prep?

Select 1 option(s):

By consulting with IT support

By choosing transformations randomly

By choosing a transformation that aligns with the business scenario

By performing all available transformations

Q58. How can you create subscriptions for a published workbook on Tableau Server or Tableau Cloud?

Select 1 option(s):

By clicking on the “Server“ menu in the toolbar, choosing “Create Subscription,“ and configuring the subscription settings

By selecting “Server“ from the toolbar, choosing “Create Subscription,“ and configuring the subscription settings

By right-clicking on the workbook, choosing “Create Subscription,“ and configuring the subscription settings

By selecting “File“ from the toolbar, choosing “Create Subscription,“ and configuring the subscription settings

Q59. How can you create a filter action between sheets on a Tableau dashboard?

Select 1 option(s):

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

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

By dragging fields from one sheet to another sheet

By selecting “Sheet“ from the toolbar and choosing “Filter Action“

Q60. What does a Density Map in Tableau display?

Select 1 option(s):

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

Data points represented by different symbols or icons

Areas filled with color based on data values

Clusters of data points based on geographical proximity