Tableau Data Analyst Test - 4

Welcome to your Tableau Data Analyst – Test-04

Name

Phone

Q1. What does a Box Plot in Tableau represent?

Select 1 option(s):

Distribution of data points, including median, quartiles, and outliers

Hierarchical relationships among data points

Frequency of data points falling within specific ranges

Cumulative distribution of data points

Q2. What is the purpose of scheduling Tableau Prep workflows on Tableau Server or Tableau Cloud?

Select 1 option(s):

To create a backup copy of the workflow

To share the workflow with other users and allow them to edit it

To automatically run the workflow at specific intervals

To apply formatting and styling to the workflow

Q3. In Tableau, what does the difference quick table calculation compute?

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

Q4. What is the advantage of connecting to a data source on Tableau Server?

Select 1 option(s):

Allows collaboration and sharing of data sources

Provides offline access to data sources

Improves data security

Speeds up the data extraction process

Q5. Which operation is used to combine rows from two or more tables based on a related column between them?

Select 1 option(s):

Merge

Aggregate

Sort

Q6. How can you customize a data forecasting model in Tableau?

Select 1 option(s):

By selecting “Analysis“ from the toolbar and choosing “Customize Forecast“

By right-clicking on the Forecast line and selecting “Customize Forecast“

By dragging a field to the “Rows“ or “Columns“ shelf and configuring it as a custom forecast

By double-clicking on the Forecast line and choosing “Edit Forecast Model“

Q7. You want to change the default sorting order of a field in Tableau from ascending to descending. How can you achieve this?

Select 1 option(s):

Right-click the field, select Sort, and choose Descending

Drag the field to the Rows shelf, and choose Descending from the dropdown menu

Click the field, select Format, and choose Descending

Double-click the field, and it will automatically sort in descending order

Q8. How can you organize data into folders in Tableau?

Select 1 option(s):

Use file naming conventions

Use folder hierarchy in the data source tab

Use color coding for different datasets

Use data encryption

Q9. Which chart type in Tableau is suitable for showing hierarchical data as nested rectangles, with the size of each rectangle representing a quantitative value?

Select 1 option(s):

Pie Chart

Area Chart

Scatter Plot

Tree Map

Q10. You want to apply a specific color scheme and font style to your Tableau dashboard. Which formatting option should you use?

Select 1 option(s):

Data sources

Containers

Format pane

Dashboard theme

Q11. Scenario: You are working with a dataset that contains a column with product categories, but some entries have inconsistent naming conventions (e.g., “Electronics“ and “Electronic Goods“). You want to consolidate these categories for a clearer analysis.

Question: What is the most effective method in Tableau to consolidate inconsistent product categories?

Select 1 option(s):

Use the “Find and Replace“ feature in Tableau to correct inconsistent entries

Manually edit the data source and update each inconsistent category name

Utilize the “Group“ feature in Tableau to group similar categories together

Create a calculated field to standardize category names based on a predefined mapping

Q12. In Tableau, how can you perform cleaning operations on data?

Select 1 option(s):

By using Data Interpreter

By using the ‘Sort‘ feature

By using the ‘Clean Data‘ option

By using the ‘Aggregate‘ function

Q13. Scenario: You have a dataset containing employee salary information, and you want to calculate the percentage increase in salary for each employee compared to the previous year.

Question: What Tableau transformation technique is suitable for calculating the percentage increase in salary for each employee compared to the previous year?

Select 1 option(s):

Use a table calculation to compute the percentage change for each employee

Create a calculated field to manually compute the percentage increase

Apply a running total to the salary data to identify year-to-year changes

Utilize the “Window“ function to calculate the percentage increase over time

Q14. When should you choose a live connection over an extract in Tableau?

Select 1 option(s):

When you need to work offline

When the data source is large and complex

When you want to save disk space

When you need real-time data updates

Q15. You are analyzing sales data and want to create a set of products that meet specific criteria. Which Tableau feature should you use?

Select 1 option(s):

Sets

Bins

Hierarchies

Groups

Q16. When performing cleaning operations on data, what does data consistency refer to?

Select 1 option(s):

Correctness and reliability of data values

Presence of all required data fields

Uniformity of data formats and values

Completeness of data records

Q17. Scenario: You are analyzing a dataset containing customer transaction dates, and you want to create a new column indicating the day of the week for each transaction.

Question: What Tableau transformation technique is suitable for creating a new column indicating the day of the week for each transaction date?

Select 1 option(s):

Manually input day-of-week information for each transaction date in the data source

Utilize the “Data Interpreter“ to automatically identify and create day-of-week details

Use the “Pivot“ feature to transform transaction dates into separate day-of-week columns

Create a calculated field using the DATEPART function to extract day-of-week information

Q18. What is the purpose of using the ‘Split‘ feature in Tableau?

Select 1 option(s):

To divide a column into multiple columns based on a delimiter

To combine multiple columns into one

To sort data records alphabetically

To aggregate data values

Q19. You have a dataset with a column containing sales data. How can you create a calculated field to calculate the percentage change in sales compared to the previous row in Tableau?

Select 1 option(s):

WINDOW_AVG(SUM([Sales]), -1, 0)

SUM([Sales]) - LOOKUP(SUM([Sales]), -1)

RUNNING_SUM(SUM([Sales])) / TOTAL(SUM([Sales]))

PREVIOUS_VALUE(SUM([Sales])) / SUM([Sales])

Q20. What is the purpose of establishing relationships between multiple data sources in Tableau?

Select 1 option(s):

To filter data during extraction

To combine data fields from different sources

To sort data records

To limit the number of data records

Q21. What does data completeness refer to?

Select 1 option(s):

Presence of all required data fields

Accuracy of data values

Consistency of data formats

Number of data records

Q22. What is the purpose of publishing a data source to Tableau Server or Tableau Cloud?

Select 1 option(s):

To create a backup copy of the data source

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

To print the data source in a specific format

To apply formatting and styling to the data source

Q23. Which Tableau function allows you to write calculations involving date and time components, such as year, month, day, etc.?

Select 1 option(s):

DATEDIFF

DATEADD

DATEPART

DATENAME

Q24. How does the “Include“ filter setting work in Tableau?

Select 1 option(s):

It includes only the values specified in the filter

It includes all values except the ones specified in the filter

It includes a range of values based on the filter criteria

It includes additional values related to the ones specified in the filter

Q25. Scenario: You are working with a dataset that includes a column representing product ratings, and the ratings range from 1 to 5. However, you want to create a new categorical variable indicating whether a product is “Low,“ “Medium,“ or “High“ rated based on predefined criteria.

Question: What is the appropriate Tableau transformation technique for creating a new categorical variable based on predefined criteria for product ratings?

Select 1 option(s):

Use the “Filter“ shelf to group ratings into low, medium, and high categories

Create a calculated field with a CASE statement to categorize ratings

Utilize the “Pivot“ feature to transform ratings into a categorical format

Manually edit the data source and assign categories to each rating

Q26. In Tableau, what is the primary purpose of a Gantt Chart?

Select 1 option(s):

To display hierarchical data as nested rectangles

To show the distribution of data points as bars

To visualize project schedules and timelines

To represent data points as segments of a circle

Q27. How can you connect to .hyper files in Tableau?

Select 1 option(s):

Use the ‘Connect to Data‘ option and select the .hyper file

Use the ‘Open‘ option in Tableau and select the .hyper file

Use the ‘Import Data‘ option and choose the .hyper file

.hyper files cannot be connected in Tableau

Q28. You want to create a chart to display the proportion of sales for each product category relative to the total sales. Which chart type should you use in Tableau?

Select 1 option(s):

Data table

Tree map

Pie chart

Bubble chart

Q29. How does the window size affect the moving average quick table calculation in Tableau?

Select 1 option(s):

It determines the color of the visualization

It sets the average to include all data points

It determines the axis on which the average is plotted

It determines the number of data points included in the average

Q30. You want to create a calculated field in Tableau to convert a string field into a numerical value. Which type conversion function should you use?

Select 1 option(s):

INT()

FLOAT()

STR()

DATEPARSE()

Q31. You want to create a calculated field in Tableau to calculate the percentage contribution of each product category to the total sales. What function should you use in the calculated field?

Select 1 option(s):

SUM([Sales]) / TOTAL(SUM([Sales]))

SUM([Sales]) - TOTAL(SUM([Sales]))

SUM([Sales]) / WINDOW_SUM(SUM([Sales]))

SUM([Sales]) / RUNNING_SUM(SUM([Sales]))

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

Select 1 option(s):

A total that accumulates over a specific dimension

A total that remains constant

A total sum of the data points

A median value of the data

Q33. How can you combine multiple sheets into a dashboard in Tableau?

Select 1 option(s):

By dragging the sheets onto a dashboard and arranging them using containers and layout options

By right-clicking on the sheets and selecting “Combine into Dashboard“

By selecting “Dashboard“ from the toolbar and choosing “Combine Sheets“

By dragging the sheets onto a dashboard and arranging them using object properties

Q34. What file formats are commonly used for exporting content from Tableau?

Select 1 option(s):

.xls

.csv

.pdf

All of the above

Q35. You want to calculate the percentage of total sales for each product category. Which table calculation should you use in Tableau?

Select 1 option(s):

Moving average

Percent of total

Running total

Percentile

Q36. You want to filter data in Tableau based on a condition where sales are greater than 1000 and the region is ‘West.‘ Which filter setting should you configure?

Select 1 option(s):

Top N

Wildcard

Include

Conditional

Q37. Scenario: You have a dataset containing customer feedback, including text comments and sentiment scores. Your task is to analyze the sentiment trends over time and identify specific topics mentioned frequently in negative comments.

Question: What Tableau technique would be most suitable for analyzing sentiment trends over time and identifying topics mentioned frequently in negative comments?

Select 1 option(s):

A) Create a word cloud using the sentiment scores and filter for negative sentiments

Use a line chart to display sentiment scores over time and a heat map for frequent topics

Apply a clustering algorithm to group similar comments and analyze sentiment within clusters

Utilize Tableau‘s natural language processing (NLP) capabilities for sentiment analysis

Q38. You have a dataset with daily sales data, and you want to calculate the year-to-date sales for each day. Which table calculation should you use in Tableau?

Select 1 option(s):

Year to date

Month to date

Year over year

Index

Q39. You want to visualize the progress of multiple projects over time. Which chart type should you use in Tableau?

Select 1 option(s):

Bar chart

Gantt chart

Bubble chart

Scatter plot

Q40. When connecting to spreadsheets in Tableau, what format is supported?

Select 1 option(s):

Only .xls files

Only .xlsx files

Both .xls and .xlsx files

Only .csv files

Q41. You are analyzing customer data and want to categorize customers into groups based on their purchase frequency. Which Tableau feature should you use?

Select 1 option(s):

Sets

Bins

Hierarchies

Groups

Q42. You want to create a chart to show the relationship between two numerical variables. Which chart type should you use in Tableau?

Select 1 option(s):

Line chart

Bar chart

Scatter plot

Gantt chart

Q43. Scenario: You‘re analyzing employee performance metrics and want to compare the performance of different teams across various key performance indicators (KPIs). The dataset includes team IDs, KPI scores, and performance categories.

Question: Which Tableau feature or technique would be most appropriate for comparing the performance of different teams across various KPIs in the dataset?

Select 1 option(s):

Create a calculated field to compute average KPI scores per team

Use a dual-axis chart to compare teams‘ performance on multiple KPIs

Apply a radial chart to show KPI scores distribution for each team

Utilize Tableau‘s clustering algorithm to group teams based on KPI similarities

Q44. How can you apply color to specific rows or columns in Tableau dashboards?

Select 1 option(s):

By right-clicking on the row or column and selecting “Apply Color“

By dragging a color field onto the row or column and configuring the color

By selecting “Format“ from the toolbar and choosing “Apply Row/Column Color“

By clicking on the row or column and choosing “Apply Color“ from the toolbar

Q45. What is the purpose of using containers in Tableau dashboards?

Select 1 option(s):

To hold text elements and annotations

To arrange sheets and objects in a structured layout

To create custom shapes and designs

To add color and formatting to the dashboard

Q46. Scenario: You are working with a dataset that contains product prices, but some prices are recorded in different currencies. Your goal is to standardize all prices to a common currency for accurate analysis.

Question: What is the recommended approach in Tableau to standardize product prices recorded in different currencies?

Select 1 option(s):

Create calculated fields to manually convert each price to the common currency

Utilize Tableau‘s built-in currency conversion feature during data connection

Export the dataset, perform currency conversion in Excel, and then import into Tableau

Use Tableau‘s “Blend“ feature to combine data from different currencies

Q47. You have a Tableau data extract that needs to be updated regularly to reflect the latest data changes. What action should you set up to automate this process?

Select 1 option(s):

Schedule workbook publishing

Schedule data extract refresh

Schedule data source publishing

Schedule Tableau Prep workflow

Q48. How can you write logical and Boolean expressions in Tableau for conditional calculations?

Select 1 option(s):

Using the CASE statement

Using the AVG function

Using the LEFT function

Using the REPLACE function

Q49. You want to add custom shapes to your Tableau dashboard to represent different data points. Which formatting option should you use?

Select 1 option(s):

Data sources

Containers

Format pane

Custom shapes

Q50. What is the purpose of filter actions in Tableau dashboards?

Select 1 option(s):

To add hyperlinks to specific data points or visualizations

To filter data points based on user interaction

To emphasize specific data points when interacting with a visualization

To create custom shapes and designs

Q51. What does the percent of difference quick table calculation in Tableau calculate?

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

Q52. How can you publish a Tableau workbook to Tableau Server or Tableau Cloud with specific permissions?

Select 1 option(s):

By selecting “Server“ from the toolbar, choosing “Publish Workbook,“ and configuring permissions before publishing

By right-clicking on the workbook, choosing “Publish to Server,“ and configuring permissions during the publishing process

By clicking on the “Server“ menu in the toolbar, choosing “Publish Workbook,“ and configuring permissions before publishing

By selecting “File“ from the toolbar, choosing “Publish to Server,“ and configuring permissions during the publishing process

Q53. What function in Tableau is used for writing calculations involving numerical values, such as rounding or mathematical operations?

Select 1 option(s):

ROUND

NUM

CALC

AVG

Q54. What is the purpose of user groups in Tableau Server or Tableau Cloud?

Select 1 option(s):

To create custom designs for data points, such as icons or logos

To filter data points based on user interaction

To control who can access specific content and apply permissions collectively

To add hyperlinks to specific data points or visualizations

Q55. What is the purpose of choosing a data transformation based on a business scenario in Tableau Prep?

Select 1 option(s):

To improve query performance

To ensure data accuracy

To achieve specific business objectives

To simplify the data extraction process

Q56. How does Tableau use Bins?

Select 1 option(s):

To create hierarchical relationships

To group related dimensions or measures together

To categorize continuous numerical data into discrete ranges

To create custom calculated fields

Q57. In Tableau, what is the purpose of using custom SQL queries to pull data from relational databases?

Select 1 option(s):

To simplify the data extraction process

To perform advanced data transformations

To customize the data extraction logic

To enhance data security

Q58. You have a dataset with a column containing full names (first name and last name). How can you create a calculated field to extract only the first names from this column in Tableau?

Select 1 option(s):

LEFT([Full Name], FIND(“ “, [Full Name]) - 1)

RIGHT([Full Name], FIND(“ “, [Full Name]) - 1)

SUBSTRING([Full Name], 1, FIND(“ “, [Full Name]) - 1)

MID([Full Name], 1, FIND(“ “, [Full Name]) - 1)

Q59. How can you create a Predictive Model in Tableau?

Select 1 option(s):

By selecting “Analysis“ from the toolbar and choosing “Predictive Model“

By dragging a field to the “Rows“ or “Columns“ shelf and configuring it as a predictive model

By right-clicking on the visualization and selecting “Add Predictive Model“

By double-clicking on the visualization and choosing “Create Predictive Model“

Q60. What is the primary purpose of a Highlight Table in Tableau?

Select 1 option(s):

To display textual data in a tabular format

To emphasize specific data points in a visualization

To show hierarchical relationships among data points

To create a dual-axis chart