Tableau Data Analyst Test - 2

Welcome to your Tableau Data Analyst – Test-02

Name

Phone

Q1. What is the purpose of the ‘Rename‘ transformation in Tableau Prep?

Select 1 option(s):

To rename the entire dataset

To rename specific fields

To rename the project folder

To rename the Tableau Prep application

Q2. You want to automate the delivery of specific Tableau workbook views to a shared network folder on a regular basis. What action should you set up?

Select 1 option(s):

Create alerts

Create subscriptions

Create filters

Create sets

Q3. What is the purpose of the ‘Filter‘ transformation in Tableau Prep?

Select 1 option(s):

To combine data based on common fields vertically

To perform aggregations

To rotate rows into columns

To filter data based on conditions

Q4. Scenario: You are tasked with analyzing customer feedback data stored in a CSV file. The data includes columns for customer IDs, satisfaction scores, and comments. Your goal is to filter out comments with a length less than 10 characters and create a visualization based on the remaining data.

Question: What is the most appropriate step in Tableau to filter out comments with a length less than 10 characters?

Select 1 option(s):

Use the “Filter“ shelf and set a condition on the comment length

Create a calculated field to count the characters in each comment and then filter the data

Use the “Data Source“ tab to edit the CSV file and remove rows with short comments

Apply a default filter on the comment length during the data connection process

Q5. Which of the following statements about live connections in Tableau is true?

Select 1 option(s):

Live connections allow data blending with other data sources

Live connections do not support real-time data updates

Live connections are only supported for Excel files

Live connections do not support aggregations

Q6. What is the purpose of a parameter action in Tableau dashboards?

Select 1 option(s):

To add hyperlinks to specific data points or visualizations

To create interactive parameters that change based on user interaction

To filter data points based on user interaction

To display summary statistics for a selected field

Q7. You want to create a calculated field in Tableau that calculates the average sales per category. Which type of aggregation should you use in this calculated field?

Select 1 option(s):

SUM()

AVG()

MAX()

MIN()

Q8. Scenario: You have connected to a SQL database containing information about product sales. The sales data has a column named “OrderDate,“ which is in the format YYYY-MM-DD. To perform a time-based analysis in Tableau, you want to convert this column into separate fields for Year, Month, and Day.

Question: What is the most suitable transformation step in Tableau to achieve the goal of converting the “OrderDate“ column into separate Year, Month, and Day fields?

Select 1 option(s):

Use the “Split“ feature in the data source pane and specify the delimiter as “-“

Create calculated fields for Year, Month, and Day using the DATEPART function

Edit the SQL query directly to include separate columns for Year, Month, and Day

Use the “Pivot“ feature in Tableau to rearrange the data into separate columns

Q9. What is the purpose of permissions in Tableau Server or Tableau Cloud?

Select 1 option(s):

To control who can view and interact with content

To apply formatting and styling to content

To create a backup copy of content

To print content in a specific format

Q10. How does the ‘Ranking‘ custom table calculation in Tableau work?

Select 1 option(s):

It ranks values based on a specific field, allowing ties

It ranks values based on a specific field, breaking ties arbitrarily

It ranks values based on the order of appearance in the data

It ranks values based on a specific field, ignoring ties

Q11. You are analyzing the performance of marketing campaigns and want to show the conversion rates at different stages of the sales funnel. Which Tableau chart type is most suitable for this analysis?

Select 1 option(s):

Radial Bar Chart

Sankey Diagram

Choropleth Map

Heatmap

Q12. How does the “Wildcard“ filter option work in Tableau?

Select 1 option(s):

It filters values that match a specific pattern using wildcard characters

It filters values that do not match a specific pattern using wildcard characters

It filters values alphabetically

It filters values numerically

Q13. You have a dashboard that contains confidential information about patients health. The data needs to always be up to date tor a team of healthcare workers How should you share me dashboard with the healthcare workers?

Select 1 option(s):

Publish the dashboard to Tableau Public

Print the dashboard to PDF

Publish aw dashboard to Tableau Server

Export the dashboard as a .twbx

Q14. You plan to create a visualization that has a dual axis chart. The dual axis chart will contain a shape chart and a line chart will use the same measure named Population on the axis. You need to configure be shapes to be much larger than the line.

What should you do?

Select 1 option(s):

Duplicate Population Drag the duplicate to the second Marks card and configure the see of the marks independently

Create a custom shape that is larger than the default shape and add the shape to the Shapes folder in My Repository

Change Population to a discrete dimension

Q15. When should you use an aggregate transformation in Tableau Prep?

Select 1 option(s):

To combine data with common fields vertically

To combine data with common fields horizontally

To perform aggregations

To rotate rows into columns

Q16. What is the primary purpose of a Data Table in Tableau?

Select 1 option(s):

To display hierarchical relationships among data points

To emphasize specific data points in a visualization

To create a tabular representation of data points

To show the distribution of data points as bars

Q17. What is the purpose of annotations in Tableau dashboards?

Select 1 option(s):

To add hyperlinks to specific data points or visualizations

To display additional information when hovering over a data point

To provide context or additional details about specific data points or areas of interest

To emphasize specific data points when interacting with a visualization

Q18. What do “Distribution Bands“ in Tableau indicate?

Select 1 option(s):

They show total and subtotal values for dimensions and measures

They display summary statistics for a selected field

They create bands to highlight specific data ranges

They indicate the distribution of data points in a visualization

Q19. You are the owner of an alert.

Select 1 option(s):

You receive an email notification that the alert was suspended From where can you resume the suspended alert?

The Data Source page of Tableau Desktop

The Notification area of Tableau Prep

The My Content area of Tableau web pages

The Shared with My page

Q20. You have a dataset containing daily temperature data for different cities. You want to calculate the average temperature for each city and compare it to the overall average temperature. Which table calculation should you use in Tableau?

Select 1 option(s):

Totals and subtotals

Reference lines

Reference bands

Average lines

Q21. Scenario: You have multiple dashboards in a Tableau workbook, and you want to create a streamlined experience by allowing users to navigate between dashboards using buttons.

Question: What is the recommended feature in Tableau for creating navigation buttons between dashboards in a workbook?

Select 1 option(s):

Create hyperlinks within dashboard text objects

Use a dashboard action to navigate between sheets

Embed web pages as navigation elements in the dashboard

Create a story to link different dashboards

Q22. You want to automate the delivery of specific Tableau workbook views to your email inbox on a regular basis. What action should you set up?

Select 1 option(s):

Create alerts

Create subscriptions

Create filters

Create sets

Q23. You are analyzing the trend in monthly website traffic data. Which chart type should you use in Tableau to show the trend over time?

Select 1 option(s):

Scatter plot

Histogram

Line chart

Gantt chart

Q24. Scenario: You are managing a Tableau Online project with numerous workbooks and data sources. The project has grown, and you want to organize it by creating subprojects for different departments.

Question: What is the correct way to organize workbooks into subprojects in Tableau Online?

Select 1 option(s):

Create folders within the existing project for each department

Use tags to categorize workbooks by department

Request Tableau Support to enable subprojects for the project

Duplicate the project and customize it for each department

Q25. You want to create a chart to display the distribution of sales across different product categories. Which chart type should you use in Tableau?

Select 1 option(s):

Bar chart

Line chart

Scatter plot

Pie chart

Q26. You want to receive notifications when specific conditions are met in your published Tableau workbook, such as sales dropping below a certain threshold. What action should you set up?

Select 1 option(s):

Create alerts

Create subscriptions

Create filters

Create sets

Q27. You have a dataset with a column containing both city names and postal codes. How can you separate the city names and postal codes into distinct fields?

Select 1 option(s):

Use Data Interpreter to automatically split the column

Use REPLACE() function in Tableau

Manually edit the column to split the data

Use split functionality in Tableau to divide the column into separate fields

Q28. Scenario: You have a dataset containing sales information, and the “Date“ field is in a string format (e.g., “2023-05-15“). You need to convert this string into a date format for proper time-based analysis.

Question: What Tableau transformation technique is suitable for converting a string date into a date format?

Select 1 option(s):

Use the “PARSE“ function in Tableau to convert the string to a date

Apply the “Pivot“ feature to transform the string into separate date components

Utilize the “Group“ function to aggregate the data based on the string date

Manually edit the string date format in the data source tab

Q29. When using the ‘Month to Date‘ custom table calculation in Tableau, what is being calculated?

Select 1 option(s):

The total for the current month

The average for the current month

The cumulative sum from the start of the month up to the current point

The difference between the current month and the previous month

Q30. You have a dataset with a column containing mixed data types (numbers and text). What function can you use to extract only the numeric values from this column in Tableau?

Select 1 option(s):

NUM()

VALUE()

INT()

REGEXP_EXTRACT().

Q31. How can you add a custom shape to a specific data point in Tableau?

Select 1 option(s):

By right-clicking on the data point and selecting “Add Custom Shape“

By dragging a shape field onto the data point and configuring the shape

By clicking on the data point and selecting “Add Custom Shape“ from the toolbar

By selecting “Dashboard“ from the toolbar and choosing “Add Custom Shape“

Q32. Scenario: You are a data analyst working for a retail company, and your manager has asked you to create a Tableau dashboard to analyze sales performance. The dataset includes information about products, sales, and customer demographics.

Question: After creating the initial dashboard, you notice that the sales performance is not consistent across different product categories. Your manager wants you to investigate further and identify the underperforming product categories.
Which visualization type in Tableau would be most effective for comparing the sales performance of different product categories?

Select 1 option(s):

Pie Chart

Treemap

Stacked Bar Chart

Scatter Plot

Q33. Which Tableau function allows you to write calculations involving date and time components, such as extracting the year or quarter?

Select 1 option(s):

DATENAME

DATEADD

DATEPART

DATEDIFF

Q34. How would you go about ensuring that the extract for your dashboard, which currently updates every Monday at 10:00, is also scheduled to refresh on the last day of each month at 18:00?

Select 1 option(s):

From Tableau Desktop, open the Publish Workbook dialog box and configure the schedule.

From Tableau Server select the workbook select Refresh Extracts and then add a new extract refresh

From Tableau Server. select Schedules find the schedule of the extract, and change the frequency to the Last day of the month

From Tableau Server. select Schedules and change the priority of the existing schedule

Q35. In a healthcare setting, you are tasked with visualizing the distribution of patient wait times in different departments. Which Tableau chart type is best suited for this analysis?

Select 1 option(s):

Box-and-Whisker Plot

Sunburst Chart

Network Diagram

3D Surface Plot

Q36. What is the purpose of creating aliases in Tableau?

Select 1 option(s):

To rename columns

To specify default field properties

To create calculated fields

To provide alternative names for field values

Q37. You want to automate the delivery of specific Tableau workbook views to an FTP server on a regular basis. What action should you set up?

Select 1 option(s):

Create alerts

Create subscriptions

Create filters

Create sets

Q38. Scenario:

You have been provided with a dataset containing information about sales transactions for an e-commerce platform. The dataset includes columns such as product category, sales amount, date of purchase, and customer information.
As a Tableau analyst, your goal is to analyze the sales performance and identify trends over time. How would you approach this task using Tableau?

Select 1 option(s):

Create a line chart to visualize the trend of total sales over time, and use filters to explore specific product categories.

Generate a scatter plot to analyze the relationship between sales amount and customer information, such as customer age or location.

Utilize a tree Design a heat map to highlight peak sales periods during the year and identify any seasonal patterns.map to represent the distribution of sales across different product categories and their contribution to the total sales.

Design a heat map to highlight peak sales periods during the year and identify any seasonal patterns.

Q39. What is the purpose of configuring notifications for scheduled data updates in Tableau Server or Tableau Cloud?

Select 1 option(s):

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 receive notifications about the success or failure of scheduled data updates

To apply formatting and styling to the data extract

Q40. You have a dataset with historical stock prices, and you want to create a predictive model to forecast future stock prices. Which analytics feature should you use in Tableau?

Select 1 option(s):

Average lines

Trend lines

Distribution bands

Create a predictive model

Q41. How can you customize field properties such as data types and sorting in Tableau?

Select 1 option(s):

By using Data Interpreter

By using the ‘Filter‘ transformation

By using the ‘Clean‘ transformation

By using the ‘Data‘ pane and choosing the specific field

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

Select 1 option(s):

When the field represents categorical data

When the field represents numerical data

When creating calculated fields

When creating hierarchies

Q43. You are working as a data analyst for a multinational corporation that operates in various regions. The company has provided you with two separate data sources: one containing information about employee demographics and another containing sales data for different products. Your goal is to create a comprehensive analysis by combining these datasets in Tableau.

Question: After connecting to the employee demographics and sales data sources, you notice that there is a common field “EmployeeID“ in both datasets. To create a meaningful analysis, what action should you take in Tableau?

Select 1 option(s):

Use the “EmployeeID“ field as a filter to limit data visibility

Create a calculated field to concatenate the “EmployeeID“ field from both sources

Merge the datasets using the “EmployeeID“ field

Ignore the “EmployeeID“ field as it is not relevant for the analysis

Q44. What is the purpose of using the pivot transformation in Tableau Prep?

Select 1 option(s):

To combine data with common fields vertically

To combine data with common fields horizontally

To perform aggregations

To rotate rows into columns

Q45. What is the purpose of tooltips in Tableau dashboards?

Select 1 option(s):

To add hyperlinks to specific data points or visualizations

To display additional information when hovering over a data point

To provide context or additional details about specific data points or areas of interest

To filter data points based on user interaction

Q46. What does the ‘First-Last‘ custom table calculation in Tableau calculate?

Select 1 option(s):

The difference between the first and last values

The ratio of the first value to the last value

The sum of the first and last values

The absolute value of the difference between the first and last values

Q47. What does a “Trend Line“ in Tableau represent?

Select 1 option(s):

It shows the average value of the selected data points

It displays the overall trend or pattern in the data

It indicates the median value of the data points

It represents the sum of the data points

Q48. Scenario: You have created an insightful dashboard in Tableau that visualizes key performance indicators for your company. Now, you need to share this dashboard with your team members for collaboration and receive their feedback.

Question: What is the most appropriate method in Tableau for sharing your dashboard with team members while allowing them to provide feedback?

Select 1 option(s):

Export the dashboard as a PDF and email it to the team

Save the workbook locally and share it via a shared network drive

Publish the dashboard to Tableau Server or Tableau Online

Take screenshots of the dashboard and share them in a presentation

Q49. What does the “Reference Bands“ feature in Tableau allow you to do?

Select 1 option(s):

Show total and subtotal values for dimensions and measures

Display summary statistics for a selected field

Add bands to indicate reference values

Create bands to highlight specific data ranges

Q50. What does the FIXED LOD calculation in Tableau allow you to do?

Select 1 option(s):

Compute an average for a specific window of data

Compute a total for a specific partition of data

Compute an aggregate calculation at a specific level of dimensions

Compute a total across all values in the visualization

Q51. You want to create a calculated field in Tableau to calculate the fixed level of detail (LOD) average sales across all regions. Which LOD calculation should you use?

Select 1 option(s):

FIXED AVG([Sales])

INCLUDE AVG([Sales])

EXCLUDE AVG([Sales])

TOTAL AVG([Sales])

Q52. Scenario: You are a Tableau administrator responsible for managing content on Tableau Server. A new version of a dataset used in several workbooks has been uploaded, and you need to update all relevant workbooks to use the latest data.

Question: What is the recommended approach in Tableau Server for updating the dataset in multiple workbooks efficiently?

Select 1 option(s):

Manually download each workbook, update the data source, and republish

Delete the old dataset, upload the new dataset with the same name, and refresh workbooks

Use the “Content Upgrade“ feature to automatically update all workbooks using the old dataset

Create a new project for the updated dataset and ask users to move their workbooks

Q53. What does the “Conditional“ filter setting do in Tableau?

What does the “Conditional“ filter setting do in Tableau?

Select 1 option(s):

Applies the filter conditionally based on user input

Applies different filter criteria based on specified conditions

Applies a filter only if certain conditions are met

Applies the filter conditionally based on the data type

Q54. How does the ‘Aggregate‘ transformation in Tableau Prep affect the granularity of the data?

Select 1 option(s):

It increases the granularity

It decreases the granularity

It preserves the granularity

It combines all data into a single record

Q55. How can you add a custom shape palette to a Tableau dashboard?

Select 1 option(s):

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

By dragging a shape palette field onto the dashboard and configuring the shapes

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

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

Q56. As a data analyst in a financial institution, you are asked to compare the performance of multiple investment portfolios over time. The goal is to identify periods of significant growth or decline. Which Tableau chart type is most suitable for this analysis?

Select 1 option(s):

Bubble Chart

Gantt Chart

Candlestick Chart

Word Cloud

Q57. In Tableau, what does the ‘Index‘ custom table calculation calculate?

Select 1 option(s):

The ranking of values based on a specific field

The percentage of total for each value

The position of values in a sorted list

The cumulative sum of values

Q58. You have a dataset containing sales data for different products. You want to create a chart that displays the sales data for each product category along with the average sales for all categories. Which chart type should you use in Tableau?

Select 1 option(s):

Dual axis chart

Combo chart

Bar chart with reference line

Stacked bar chart

Q59. You want to receive notifications when specific conditions are met in your published Tableau workbook, such as customer satisfaction scores falling below a certain threshold. What action should you set up?

Select 1 option(s):

Create alerts

Create subscriptions

Create filters

Create sets

Q60. In Tableau, which chart type is suitable for displaying hierarchical data as nested rectangles, with the size of each rectangle representing a quantitative value, and the rectangles grouped together based on categories?

Select 1 option(s):

Pie Chart

Area Chart

Scatter Plot

Tree Map