Tableau Data Analyst Test - 3

Welcome to your Tableau Data Analyst – Test-03

Name

Phone

Q1. What permissions are required to publish content to Tableau Server or Tableau Cloud?

Select 1 option(s):

View permissions

Edit permissions

Admin permissions

Publish permissions

Q2. You want to create a filter in Tableau to display only the top 10 performing products based on sales. Which filter setting should you configure?

Select 1 option(s):

Top N

Wildcard

Context

Conditional

Q3. How does changing default field properties in Tableau impact the data visualization?

Select 1 option(s):

It modifies the underlying data

It changes the data source

It affects the appearance and behavior of the field in visualizations

It filters the data

Q4. You want to create a Tableau dashboard where users can switch between different views by selecting options from a drop-down menu. Which interactivity feature should you use?

Select 1 option(s):

Filter action

URL action

Parameter-driven action

Navigation button

Q5. In Tableau, what is the purpose of an extract filter?

Select 1 option(s):

To filter data during visualization

To filter data during extraction

To filter data during import

To filter data during export

Q6. In Tableau, what does a Set represent?

Select 1 option(s):

A subset of data based on specified conditions

A hierarchical arrangement of dimensions and measures

A grouping of related dimensions or measures

A predefined set of dimensions or measures

Q7. When using the moving average quick table calculation, how does the window size affect the calculation?

Select 1 option(s):

It determines the number of data points included in the average

It sets the average to include all data points

It affects the color of the visualization

It determines the axis on which the average is plotted

Q8. Scenario: You have been provided with a dataset containing daily website traffic data for an e-commerce platform. Your objective is to identify patterns in user behavior, specifically focusing on identifying days with significant spikes or drops in website traffic compared to the average.

Question: What visualization technique in Tableau would be most suitable for identifying days with significant spikes or drops in website traffic compared to the average?

Select 1 option(s):

Line Chart with a trendline

Heatmap showing daily traffic fluctuations

Box-and-Whisker Plot for daily traffic distribution

Time Series Analysis using forecasting

Q9. You want to create a filter in Tableau to exclude certain product categories from the analysis. Which filter setting should you configure?

Select 1 option(s):

Top N

Wildcard

Include

Exclude

Q10. What is a Hierarchy in Tableau?

Select 1 option(s):

A way to group related dimensions or measures together

A predefined set of dimensions or measures

An organized structure of related dimensions, often displayed in a tree-like format

A subset of data based on specified conditions

Q11. What type of objects can be added to a Tableau dashboard?

Select 1 option(s):

Sheets, images, web content, and text objects

Only sheets and images

Only sheets and web content

Only sheets and text objects

Q12. You are working with a dataset where the same data appears in multiple columns. What technique can you use to organize this data for analysis?

Select 1 option(s):

Use Data Interpreter to merge the columns automatically

Manually merge the columns in Tableau

Use pivot to transform the columns into rows

Ignore the redundant columns during analysis

Q13. When should you use the ‘Union‘ operation in Tableau?

Select 1 option(s):

To combine rows from tables with different columns

To aggregate data values

To sort data records

To filter data during extraction

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

Select 1 option(s):

Create alerts

Create subscriptions

Create filters

Create sets

Q15. You have a dataset with a column containing sales data. You want to create a calculated field to find the difference between each sales value and the average sales value across all records. Which function should you use in the calculated field?

Select 1 option(s):

ABS(SUM([Sales]) - WINDOW_AVG(SUM([Sales])))

SUM([Sales]) - TOTAL_AVG(SUM([Sales]))

ABS(SUM([Sales]) - TOTAL_AVG(SUM([Sales])))

WINDOW_AVG(SUM([Sales])) - SUM([Sales])

Q16. You are analyzing employee performance data and want to rank employees based on their sales achievements. Which custom table calculation should you use in Tableau?

Select 1 option(s):

Year to date

Month to date

Year over year

Ranking

Q17. Scenario: You‘re working on analyzing customer churn for a telecommunications company and want to identify the primary reasons leading to customer attrition. The dataset contains customer profiles, service usage details, and churn status.

Question: Which Tableau visualization technique would be most effective for identifying the primary reasons leading to customer churn based on the available dataset?

Select 1 option(s):

Stacked Bar Chart showing churn status by service type

Scatter Plot with service usage details vs. customer tenure

Treemap illustrating churn distribution across customer demographics

Cohort Analysis comparing customer behavior over time

Q18. What does the DATEADD 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

Q19. Scenario: You have been tasked with scheduling a daily refresh for a Tableau Server workbook that relies on an Excel file hosted on a network drive.

Question: What is the appropriate method in Tableau Server to schedule the daily refresh of a workbook using data from an Excel file on a network drive?

Select 1 option(s):

Embed the Excel file data in the workbook and schedule the refresh

Use a live connection to the Excel file and schedule a regular data extract

Copy the Excel file to Tableau Server and link the workbook to the local copy

Schedule an extract refresh directly from the network drive

Q20. You want to save your Tableau visualization as an image file for external use or presentation. What action should you perform?

Select 1 option(s):

Publish a workbook

Publish a data source

Print content

Export content

Q21. You have a Tableau Prep workflow that cleans and prepares your data. What action should you set up to automate the workflow execution?

Select 1 option(s):

Schedule workbook publishing

Schedule data extract refresh

Schedule data source publishing

Schedule Tableau Prep workflow

Q22. Scenario: You are connecting to a large dataset stored in a relational database, and you want to optimize performance by fetching only the necessary columns for analysis.

Question: What Tableau feature would you use to optimize performance by fetching only the necessary columns from a relational database?

Select 1 option(s):

Apply data source filters to exclude unnecessary columns

Use the “Extract“ feature to create a subset of the dataset with only required columns

Utilize the “Data Interpreter“ to automatically identify and fetch relevant columns

Adjust column selections directly in the SQL query during data connection

Q23. Which file format is used for Tableau data extracts?

Select 1 option(s):

.txt

.tds

.tde

.csv

Q24. How can you create a Combo chart in Tableau?

Select 1 option(s):

By selecting “Combo“ from the chart type dropdown menu

By dragging multiple fields to the “Rows“ or “Columns“ shelf and choosing “Combo“

By right-clicking on the chart and selecting “Create Combo Chart“

By double-clicking on the chart and choosing “Combo Chart“

Q25. How can you replace the connected data source with another data source for an existing chart or sheet in Tableau?

Select 1 option(s):

Use the ‘Replace Data Source‘ option

Create a new chart or sheet with the desired data source

Copy and paste the data from the new source

Delete the existing chart or sheet and start over

Q26. Scenario: You have been provided with a dataset containing financial data for multiple companies over several years. Your goal is to identify any correlations between specific financial metrics (e.g., revenue, expenses, profit) and the economic conditions during each year.

Question: Which Tableau technique or feature would be most effective for exploring correlations between financial metrics and economic conditions across multiple years in the dataset?

Select 1 option(s):

Create a calculated field for economic conditions and perform correlation analysis

Use Tableau‘s trend line feature to visualize financial metrics against economic indicators

Employ Tableau‘s forecasting feature to predict financial metrics based on economic data

Utilize Tableau‘s built-in statistical functions to conduct regression analysis

Q27. What is the purpose of highlight actions in Tableau dashboards?

Select 1 option(s):

To add hyperlinks to specific data points or visualizations

To create custom shapes and designs

To emphasize specific data points when interacting with a visualization

To filter data points based on user interaction

Q28. What is a Set in Tableau used for?

Select 1 option(s):

Grouping related dimensions or measures together

Creating a subset of data based on specified conditions

Categorizing data into bins

Defining hierarchical relationships

Q29. Which chart type in Tableau is used for visualizing data points as filled circles, with the size and color of the circles indicating additional data dimensions?

Select 1 option(s):

Scatter Plot

Bubble Chart

Bar Chart

Gantt Chart

Q30. 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 sum of the measure across all dimensions

The percentage of the total rows in the dataset

The percentage of the total columns in the dataset

The percentage of the total distinct values in the dataset

Q31. When creating calculated fields in Tableau, what does the WINDOW_AVG function do?

Select 1 option(s):

Computes an average across a fixed range of values

Computes an average for a specific window of data

Computes an average across all values

Computes an average for a specific partition of data

Q32. Scenario: You are working with a dataset that contains customer information, including names, addresses, and contact numbers. However, the data is inconsistent, with some entries having missing values in the “Contact Number“ field.

Question: What is the most appropriate action in Tableau to handle missing values in the “Contact Number“ field?

Select 1 option(s):

Replace missing values with the average contact number in the dataset

Use the “Clean“ option in Tableau to automatically fill missing values with placeholders

Manually input a default contact number for all entries with missing values

Create a calculated field to identify and handle missing values during data analysis

Q33. How can you implement user guiding sentences in Tableau dashboards?

Select 1 option(s):

By right-clicking on the view and selecting “Add User Guide“

By dragging a user guide field onto the view and configuring it as a parameter

By clicking on the view and choosing “Add User Guide“ from the toolbar

By creating calculated fields for user guiding sentences

Q34. What is the purpose of creating relationships between tables in Tableau?

Select 1 option(s):

To combine rows from tables with different columns

To filter data during extraction

To blend data fields from different sources

To limit the number of data records

Q35. What is the purpose of the ‘Data Interpreter‘ feature in Tableau?

Select 1 option(s):

To interpret complex data structures

To interpret ambiguous data values

To interpret data source metadata

To interpret unstructured data

Q36. Scenario: You have created a Tableau workbook that connects to a live database for real-time data analysis. Now, you want to share this workbook with a colleague, but you are concerned about sharing sensitive database credentials.

Question: What is the best practice in Tableau for sharing a workbook that connects to a live database without exposing database credentials?

Select 1 option(s):

Share the workbook and provide the database credentials separately

Embed the database credentials within the workbook for convenience

Create an extract of the data before sharing the workbook

Save the workbook as a PDF and share the static version

Q37. How can you schedule automatic updates for a Tableau dashboard on Tableau Server or Tableau Cloud?

Select 1 option(s):

By selecting “Server“ from the toolbar, choosing “Schedule Updates,“ and configuring the update frequency

By right-clicking on the dashboard, choosing “Schedule Updates,“ and configuring the update frequency

By clicking on the “Server“ menu in the toolbar, choosing “Schedule Updates,“ and configuring the update frequency

By selecting “File“ from the toolbar, choosing “Schedule Updates,“ and configuring the update frequency

Q38. Which chart type in Tableau is used to display data points as segments of a circle, with each segment representing a proportion of the whole data set?

Select 1 option(s):

Bar Chart

Line Chart

Pie Chart

Area Chart

Q39. When connecting to a relational database, what is the purpose of using stored procedures in Tableau?

Select 1 option(s):

To enhance data security

To automate complex data transformations

To create custom calculations

To optimize query performance

Q40. You are working with a dataset that contains inconsistent date formats. What function can you use to standardize the date formats in Tableau?

Select 1 option(s):

TODate()

DATEPARSE()

FORMAT()

CONVERT()

Q41. How can you schedule data extract refreshes for a Tableau workbook on Tableau Server or Tableau Cloud?

Select 1 option(s):

By selecting “Server“ from the toolbar, choosing “Schedule Extract Refresh,“ and configuring the refresh frequency

By right-clicking on the workbook, choosing “Schedule Extract Refresh,“ and configuring the refresh frequency

By clicking on the “Server“ menu in the toolbar, choosing “Schedule Extract Refresh,“ and configuring the refresh frequency

By selecting “File“ from the toolbar, choosing “Schedule Extract Refresh,“ and configuring the refresh frequency

Q42. You‘ve been provided with a complex dataset containing information about customer transactions, including purchase history, timestamps, and customer demographics. Your task is to identify the top three product categories that contribute the most to overall sales during specific promotional periods.

Question: What is the most appropriate method in Tableau to identify the top three product categories contributing the most to sales during specific promotional periods within the dataset?

Select 1 option(s):

Create a calculated field to rank product categories based on sales amounts

Use table calculations to compare sales across different product categories

Apply date filters and aggregate sales by product category using a bar chart

Implement level of detail (LOD) expressions to determine top-selling product categories

Q43. You want to create an interactive dashboard in Tableau where users can click on a specific region to see detailed information. Which interactivity feature should you use?

Select 1 option(s):

Filter action

URL action

Highlight action

Navigation button

Q44. What does the “Totals and Subtotals“ feature in Tableau allow you to do?

Select 1 option(s):

Calculate the sum and average of data points

Display summary statistics for a selected field

Show total and subtotal values for dimensions and measures

Create reference lines

Q45. How can you perform data transformation in Tableau Prep based on specific business requirements?

Select 1 option(s):

By choosing transformations randomly

By consulting with IT support

By using transformations that align with the business scenario

By performing all available transformations

Q46. You want to create a Tableau dashboard where users can click on a specific data point to navigate to another dashboard showing related information. Which interactivity feature should you use?

Select 1 option(s):

Filter action

URL action

Highlight action

Navigation button

Q47. When performing data transformation in Tableau Prep, what is the purpose of using the ‘Clean‘ transformation?

Select 1 option(s):

To remove unwanted columns

To handle missing values

To perform data type conversions

To rename fields

Q48. You have a dataset with a column containing product names, some of which are misspelled or have inconsistent spellings. How can you create a calculated field to group similar products together in Tableau?

Select 1 option(s):

Use the REPLACE() function to correct misspelled product names

Manually edit the product names to ensure consistency

Create a group in Tableau and manually specify similar product names

Use CONTAINS() function to identify similar product names and create a group

Q49. What does the ‘Year to Date‘ custom table calculation in Tableau compute?

Select 1 option(s):

The total for the current year

The average for the current year

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

The difference between the current year and the previous year

Q50. How is the percentile quick table calculation in Tableau computed?

Select 1 option(s):

By ranking values and finding the value at a specific percentile

By averaging the values and finding the percentile

By summing the values and dividing by the percentile

By multiplying the values and finding the percentile

Q51. What does the compound growth rate quick table calculation in Tableau compute?

Select 1 option(s):

The average growth rate over a specific period

The total growth rate over the entire dataset

The growth rate multiplied by the values

The growth rate raised to the power of values

Q52. What do user guiding sentences in Tableau dashboards typically include?

Select 1 option(s):

Detailed explanations of data points

Custom shapes and designs

Navigation instructions (click..., hover..., menu options)

Hyperlinks to external websites

Q53. What is the primary purpose of custom shapes in Tableau dashboards?

Select 1 option(s):

To add hyperlinks to specific data points or visualizations

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

To emphasize specific data points when interacting with a visualization

To filter data points based on user interaction

Q54. Scenario: You have a Tableau Server environment where multiple teams collaborate on various projects. One team wants to restrict access to a specific project only to members of their team.

Question: What is the recommended method in Tableau Server to restrict access to a specific project for a particular team?

Select 1 option(s):

Adjust workbook permissions individually for each team member

Use user filters within each workbook to limit access

Set project permissions to grant access only to the specific team

Create a duplicate project and move relevant workbooks there

Q55. How can you perform cleaning operations on data in Tableau?

Select 1 option(s):

By using Data Interpreter

By using the ‘Sort‘ feature

By using the ‘Clean Data‘ option

By using the ‘Aggregate‘ function

Q56. What is the purpose of navigation buttons in Tableau dashboards?

Select 1 option(s):

To create custom shapes and designs

To emphasize specific data points when interacting with a visualization

To navigate between different dashboard pages or views

To filter data points based on user interaction

Q57. What is the purpose of creating subscriptions for published workbooks in Tableau?

Select 1 option(s):

To apply conditional formatting to specific data points

To share the workbook with other users

To automatically receive the workbook or views via email at specified intervals

To create a backup copy of the workbook

Q58. What is the purpose of Groups in Tableau?

Select 1 option(s):

To create hierarchical relationships

To group related dimensions or measures together

To create a subset of data based on specified conditions

To categorize continuous numerical data into discrete ranges

Q59. What is the purpose of converting between dimensions and measures in Tableau?

Select 1 option(s):

To change the default field properties

To specify the data granularity

To enable or disable data aggregation

To create calculated fields

Q60. How can you check the status of content that you have published to Tableau Server or Tableau Cloud?

Select 1 option(s):

By selecting “Server“ from the toolbar and choosing “Check Status“

By right-clicking on the content and selecting “Check Status“

By clicking on the content and choosing “Check Status“ from the toolbar

By logging into Tableau Server or Tableau Cloud and navigating to the content