1. Which of these are valid attached calculations in Tableau?

Question: Which of these are valid attached calculations in Tableau?

Answer: SUM(Price) * SUM(Items)

2. While running a metadata API query in Tableau, when will you get an
invalid_argument error?

Question: When running a metadata API query in Tableau, when will you get an
invalid_argument error?

Answer: Either Choice 1 or 2

 The query contains an invalid cursor.

 The query contains an undefined fragment.

3. Dynamic Dashboard Calculation

Question: Morgan is tasked with creating a dynamic dashboard that allows users to switch
between different measures (e.g., Profit, Sales) and dimensions (e.g., Product, Region)
seamlessly. Which Tableau calculation would be appropriate for him to achieve this dynamic
measure and dimension selection in a dashboard?

Answer: {FIXED: IF [Parameter] = "Profit" THEN SUM([Profit]) ELSEIF [Parameter] =

"Sales" THEN SUM([Sales]) END}

4. Which of these are valid attached calculations in Tableau?

Question: Which of these are valid attached calculations in Tableau?

Answer: Both Choice 2 and 3

 SUM(Price * Items)
 SUM(Price) * SUM(Items)

5. Tableau Metadata API: What does the "ConnectionType" property return?

Question: You are querying a database object that supports the "ConnectionType" property
when working with the Tableau Metadata API. What does the query return in this context?

Answer: The connection type

6. Styles of Showing History in Tableau

Question: Which of the following is not a style of showing history in Tableau?

Answer: Chevrons

7. Configuring Access Permissions in Tableau

Question: In a large enterprise with diverse teams, how would you configure access permissions
to ensure that sensitive financial data is accessible only by authorized users?

Answer: Group-based Permissions with Contextual Filters and Row-Level Security

8. Calculating Percentage Change in Sales Year-Over-Year in Tableau

Question: For analyzing sales data and to return a measure to calculate the percentage change in
sales compared to last year, which of the following is correct?

Answer: { FIXED [Year], [Product]: (SUM([Sales]) - LOOKUP(SUM([Sales]), -1)) /

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

9. Establishing a Connection Without a Native Connector in Tableau

Question: You are establishing a connection without creating custom codes when visualizing
your data in Tableau. How will Tableau help in establishing this connection if it has no native
connector provided?

Answer: By providing the Open Database Connectivity (ODBC) connection

10. Implementing a Dashboard with Multiple Views in Tableau

Question: You have created a dashboard to show the profit earned by various smartphones in the
past 5 years. You want to include 5 views in the dashboard to improve the scope of your story.
Which of the following is the best way to implement such a dashboard in Tableau?

Answer: Create one dashboard with 5 views

1. Treemap vs. Pie Chart in Tableau

Question: In which situation would you prefer a Treemap over a Pie chart in Tableau?
Correct Answer: Both Choice 1 and 2 (Leverage chart real estate more effectively and
Visualize data two-dimensionally)
2. Dynamic Parameters in Tableau
Question: Which Tableau calculation enables the creation of dynamic parameters?
Correct Answer: {FIXED [User Selection]: AVG([Value]) }
3. Slicing Filter in Tableau
Question: What is the behavior of a slicing filter in Tableau when applied to a
multidimensional data source?
Correct Answer: A slicing filter recalculates values for each measure using the
configured aggregations, providing precise control over the displayed data.
4. HTTP Status Code Error in Tableau
Question: What is NOT true about the error code "404002" in the context of the Tableau
REST API?
Correct Answer: It is a BAD REQUEST error
5. Collection Interface in Tableau JavaScript API
Question: What inference can be made if the has(key: string) method returns true?
Correct Answer: There is an element identifier in the collection associated with the key
6. Join Types in Tableau Data Models
Question: What does Tableau do during the analysis phase if no join types are specified for
relationships?
Correct Answer: It automatically selects the appropriate join types based on the fields
and context of analysis in the worksheet.
7. Restricting Data Export in Tableau
Question: How can you configure Tableau permissions to restrict certain users from
exporting data?
Correct Answer: Set Export Data Permissions at the Workbook Level
8. Tying Parameters to Views in Tableau
Question: How can you tie parameters to your views to make them more interactive?
Correct Answer: Using parameters in calculations and calculated fields that are used
in the view
9. Level of Detail (LOD) Expression in Tableau
Question: What type of LOD expression is best fit to achieve the objective of analyzing
sales data?
Correct Answer: Both 1 and 3 (FIXED and EXCLUDE)
10. Tableau Error Element
Question: Which of the following is NOT true in the given context of the error element
<error code="404002">?

Correct Answer: It is a BAD REQUEST error

11. Configuring Tableau Permissions
Question: How would you configure Tableau permissions to achieve the goal of restricting
certain users from exporting data?
Correct Answer: Set Export Data Permissions at the Workbook Level
12. Tableau Dashboard Interactivity
Question: How can you tie parameters to your views to make them more interactive?
Correct Answer: Using parameters in calculations and calculated fields that are used
in the view

1. Synchronized Interactions Between Sheets in Tableau

Question: You are working on a dashboard that requires synchronized interactions

between multiple sheets. Which Tableau feature would you use to synchronize actions
across different sheets within the same dashboard, ensuring that the selection on the
first filter limits the second to only those values that are now relevant?

Correct Answer: Dashboard Sets with Cascading Filters.

2. Challenges in Relating Fact Tables in Tableau

Question: You are building a complex data model with multiple tables in both the
logical and physical layers. You encounter a scenario where two fact tables, Sales and
Profit, need to be related through a shared dimension table, Product. What challenge
can you face in this situation and what measure can be taken?

Correct Answer: Circular relationships pose a challenge in this scenario, and the
user must carefully design the data model to avoid such relationships, which are
not supported in Tableau.

3. Using a Treemap Over a Pie Chart in Tableau

Question: In which of the following situations will you prefer a Treemap over a Pie chart
in Tableau?

Correct Answer: Both Choice 1 and 2 (You want to leverage chart real estate more
effectively, and you want to visualize data two-dimensionally (Size of square and Color
Density)).

4. Creating Dynamic Parameters in Tableau

Question: Den wants to create a dynamic set of parameters in Tableau that allows
users to customize the appearance of a dashboard based on their preferences. Which
Tableau calculation would enable him to create such dynamic parameters?

Correct Answer: {FIXED [User Selection]: AVG([Value]) }.

5. Using Wildcard Search for Union in Tableau Prep

Question: You want to use a wildcard search to perform a union on your tables in the
input step when working with Tableau Prep. Which of the following conditions should
the table meet in order to do so?

Correct Answer: The tables must be union compatible.

6. Adding Multiple Fields to Color in Tableau

Question: You are given a task to add multiple fields into color in Tableau. Which of the
following choices would you select to achieve your objective?

Correct Answer: You drag the fields onto the color button one after the other.
7. Behavior of Slicing Filters in Multidimensional Data Sources

Question: Your client has a complex view displaying sales data across various regions
and time quarters. They want to implement a slicing filter to focus on specific quarters
for a particular region without affecting the aggregation logic in the view. Which
statement accurately describes the behavior of a slicing filter in Tableau when applied to
a multidimensional data source, especially regarding the aggregation of non-additive
measures?

Correct Answer: In a multidimensional data source, a slicing filter automatically

performs a summation because the data is pre-aggregated, and the result is the
sum of a group of sums.

8. Using ATTR() in Tableau

Question: In what scenario would you use the ATTR() function in Tableau?

Correct Answer: When you want to return the value of the expression if it has a
single value for a group.

9. Box and Whisker Plot Solution in Tableau

Question: A data analyst notices that the box and whisker plot is large, confusing, and
some of the box and whisker plots don't have enough data points to make them actual
box and whisker plots. What is the most valid solution for this problem?

Correct Answer: Use the box and whisker plot data with reorganized data that is
categorized by department instead of by job position.

10. Parameter Usage in Tableau for Interactivity

Question: How can you tie parameters to your views in order to make them more
interactive when working with Tableau dashboards?

Correct Answer: Using parameters in calculations and calculated fields that are
used in the view.
11. Initial SQL in Tableau Prep for Identifying .tfl File

Question: Which parameter passed to your data source using Initial SQL in Tableau
Prep can be used to identify the name of the .tfl file?

Correct Answer: FlowName.

12. Fixing an Error in a Tableau Calculation

Question: If IF FIRST()==0 THEN [User Selection] END is used in a calculation, is this

calculation correct in Tableau?

Correct Answer: No, the calculation is incorrect because it doesn't account for all
possible outcomes and may lead to unintended results.

Question 1:

 Question: A data analytics firm used dynamic dashboard

layouts in their visualizations. Which among the given
options according to you is/are true to be the advantages
of doing this?
 Answer: 1, 2, 3, 4 and 5

Question 2:

 Question: While running metadata api query tableau

when we will get invalid_argument error?
 Answer: Either Choice 1 or 2

Question 3:

 Question: How does Ask data help you automatically

create certain visualization types when building views in
Tableau?
 Answer: By automatically changing a field or its
aggregation type
Question 4:

 Question: You are establishing a connection without

creating custom codes when visualizing your data in
Tableau in the given context, how will Tableau help in
establishing this connection if it has no native connector
provided?
 Answer: By providing the Open Database Connectivity
(ODBC) connection

Question 5:

 Question: You are querying a database object that

supports the "ConnectionType" property when working
with The tableau metadata api. What does the query
return in the given context?
 Answer: The connection type name.

Question 6:

 Question: Which of the following is not a style of showing

history in Tableau?
 Answer: Shapes

Question 7:

 Question: In a large enterprise with diverse teams

configuring access permission to ensure that sensitive
financial data is accessible only by authorized users
what's to done?
 Answer: Group-based Permissions with Contextual
Filters and row level security

Question 8:

 Question: For analysing sales data and to return a

measure to calculate percentage change in sales
compared to last year
 Answer: { FIXED [Product], [Year]: (SUM([Sales])-
LOOKUP(SUM([Sales]),-1))/ABS(LOOKUP(SUM([Sales]),
-1)) }

Question 9:

 Question: Foll want to use a wildcard search to perform a

 union on your tables in the input step when working with
Tableau prep. Which of the following conditions should the
table meet in order to do so?
 Answer: The tables must be union compatible.

Question 10:

 Question: in which of the following situations will you

prefer a Treemap over a Pie chart in Tableau?
 Answer: Both Choice 1 and 2

Question 11:

 Question: Den wants to create a dynamic set of

parameters in Tableau that allows users to customize the
appearance of a desmoord based on their preferences.
Which Tableau calculation would enable him to create
such dyrnijamic parameters?
 Answer: None of the above

Question 12:

 Question: You are a Tableau specialist working with a

corporate client that utlizes a multidimensional data
source to analyze finance des The client has a complex
view diaptaying sales data across various regions and
time quarters They want to implement a slicing fifter to
focus on specific quarters for a particular region without
affecting the aggregation logic in the view. Which among
the following statements accurately describes the
behavior of a slicing filter in Tableau when applied to s
multidimensional data source, especially regarding the
aggregation of non-additive measures?
 Answer: In a multidimensional data source, a slicing filter
automatically performs a summation because the data is
pre-aggregated, and the result is the sum of a group of
sums.

Question 13:

 Question: You come across the following error element in

the response body of a HTTP status code when working
with the BEST AP Tableau. <error code="404002"> Which
of the following is NOT true in the given context?
  Answer: It is a BAD REQUEST error

Question 14:

 Question: You are using the collection interface has (key:

string) when working with Collections in Tableau
JavaScript At the g context, which of the following
inferences can be made if the interface returns true?
 Answer: There is an element in the collection associated
with the key

Question 15:

 Question: When working with Tabiesu data models, you

have not specified join types for relationships. In the given
scenario, what does Tableau do during the analysis
phase?
 Answer: It automatically selects the appropriate join types
based on the fields and context of analysis in the
worksheet.

Question 16:

 Question: Your organization follows a role-based access

control model, and you need to restrict certain users from
exporting data from Tableau for security reasons. How
would you as an engineer configure Tableau permissions
to achieve this goal without affecting the overall
interactivity of the dashboard?
 Answer: Set Export Data Permissions at the Workbook
Level.

Question 17:

 Question: How can you tie parameters to your views in

order it more Interactive when working with Tableau
dashboards?
 Answer: Using parameters in calculations and calculated
fields that are used in the view.

Send