==================================================
Question No. 11
You are given the data of students that contains many tables under one schema. Which feature
will help you extract the information from the tables?
© Union
© Key-column pair
O Groups
O Tasks
==================================================
Question No. 1
Identify the file present in the bookmarks folder in the Tableau repository that contains a single
worksheet.
@ .tbm
O.tm
O.tb
O .tk
==================================================
Question No. 2
You have been working on a project and need to specify dimensions to exclude from the view
level of detail. Which of the following options will be helpful in this scenario?
O FIXED LOD
© CUSTOM LOD
© INCLUDE LOD
@ EXCLUDE LOD
==================================================
Question No. 3
Which of the following visualizations is the least appropriate for categorical data?
@ Line chart
O Pie chart
© Bar chart
© Combo chart
==================================================
Question No. 4
In Tableau, what is the purpose of a "calculated field"?
O To filter data based on specific criteria
@ To perform mathematical operations on existing data fields
O To create hierarchies within the data structure
O To visualize geographical data on maps
==================================================
Question No. 5
What is the role of "Tableau Server" in a Tableau deployment?
O To develop and design dashboards and visualizations
O To automate data refreshes at regular intervals
@ To share and collaborate on Tableau workbooks and dashboards within an organization
O To connect to external data sources for data visualization
==================================================
Question No. 6
You are trying to create multiple lookups in which one of them is add_name in Informatica
session. You do not want the add_name to return multiple rows for a single search. a) Which of
the following will you use? b) which of the following properties can you override after the
declaration in the above session?
O a)use a cached map item value for the lookupb) Bulk loading map
@ a)Use a cached dynamic lookupb) Target table name
O a) use a workflow of the single lookup fieldb) Target properties
O a) update an empty record in the lookup to block multiple searchesb) Target db connection
==================================================
Question No. 7
You need to compute values using specified dimensions in addition to whatever dimensions are
present in the view. Which of the following options can you use to accomplish the task?
O FIXED LOD
@ CUSTOM LOD
© INCLUDE LOD
O EXCLUDE LOD
==================================================
Question No. 8
What is a frequently used technique in data visualization that involves adding a little purposeful
noise to the image to avoid overlapping and to preserve the integrity of what is
communicated known as?
O Blending
O Joining
© Jittering
O Filtering
==================================================
Question No. 9
Acompany has no sales, so they implement the following function. What will be the output of
this code? ZN(SUM([SALES]))
ONull
@0
CO It will throw an error.
oO-1
==================================================
Question No. 10
What will be the output of the following code snippet? FINDNTH("multiplication", ‘i, 2)
O2
@8
o4
oo
==================================================
Question No. 11
You are given the data of students that contains many tables under one schema. Which feature
will help you extract the information from the tables?
© Union
© Key-column pair
O Groups
@ Tasks
==================================================
Question No. 12
A developer working on Tableau wants to use a file containing the details of a workbook. Which
of the following options would help him use the required file?
O Tableau workbook
O Tableau packaged workbook
CO Tableau data source
@ Tableau packaged data source
==================================================
Question No. 13
A developer wants to sort a graph with more than one dimension without using the combined
field. Which of the following tools can she use in this case?
O Dynamic sort option
O Nested sort option
@ Multiple sort option
O Negative sort option
==================================================
Question No. 14
Sarah, a developer, requires a chart used to visualize the matrix value graphically using colors.
What of the following can she use for this?
O Tree Map
@ Histogram
O Heat Map
O Pie Chart
==================================================
Question No. 15
Jennifer wants to open a URL within a dashboard rather than opening the system's web
browser. Is it possible to deploy a URL action on a dashboard?
@ Yes, using the Tableau server.
O Yes, using a Tableau object.
CO Yes, using a Web Page object.
O Yes, it requires a plugin.
==================================================
Question No. 16
If you are using a live connection, Tableau automatically selects the option "Auto Update
Worksheet". Choose the correct option that will disable this feature.
© Analysis --> Deselect the "Auto Update Worksheet" option
O Dashboard --> Auto Updates --> Deselect the "Auto Update Worksheet" option
@ Worksheet --> Auto Updates --> Deselect the "Auto Update Worksheet" option
O Format --> Auto Updates --> Deselect the "Auto Update Worksheet" option
==================================================
Question No. 17
As a cloud developer, Richie is implementing different types of date sets for a project. Which of
the following options does not demonstrate a discrete date set?
O Days in a week
O Different days in a week
CO Different months
@ Same months in different years
==================================================
Question No. 18
What will be the best visualization to compare the profit of different products manufactured by
your company?
O Histogram
O Scatter Plot
@ Bar Chart
O Density Map
==================================================
Question No. 19
Paulie wants to use a file format containing the data used in a .twb file in a highly compressed
columnar data format. Identify the file format that can be used for this.
@ Tableau data extract
O Tableau data source
O Tableau packaged workbook
O Tableau workbook
==================================================
Question No. 20
In which of the following types of filters, a filter condition is applied first to the data source, and
then some other filters are used only for the resulting records?
O Quick filter
O Action filter
© Context filter
O Dimension filter
==================================================
Question No. 21
You are working on a report, and it requires performing the blending process. Which type of join
should you use to achieve the desired results?
O Right Join
O Left Join
© Full Join
O Inner Join
==================================================
Question No. 22
You are working on a project and are required to display measures over a period of time. Which
of the following options would you use for this task?
O Line Chart
© Bar Chart
O Histogram
O Scatter Plot
==================================================
Question No. 23
A developer working on filters wants to limit the result set from a filter. Which of the following
filters can he use for this?
O Top filter
© Multiple values filter
O Single value filter
O Wildcard match filter
==================================================
Question No. 24
Carla has been working on data aggregation on a Tableau project for which she needs to
implement the table calculations. Which of the following options correctly defines the
calculations?
O Calculations are functions that can be used to send SQL expressions directly to the database.
© Calculations are functions that allow you to perform computations on values in a table.
CO Calculations are functions that allow you to pass data directly to a running external service
instance.
O Calculations are functions that can specify, include, or omit dimensions from the current view.
==================================================
Question No. 25
Four functionalities of RANK_DENSE in Tableau are provided in the options. Which of them is
the correct option?
O It returns the rank for the current row in the partition. With this function, the set of values (6,
9, 9, 14) would be ranked (3, 2, 2, 1).
O It returns the rank for the current row in the partition. With this function, the set of values (6,
9, 9, 14) would be ranked (0.25, 0.75, 0.75, 1.00).
CO It returns the rank for the current row in the partition. With this function, the set of values
(6, 9, 9, 14) would be ranked (4, 2, 3, 1).
O It returns the rank for the current row in the partition. With this function, the set of values (6,
9, 9, 14) would be ranked (4, 3, 3, 1).
==================================================
Question No. 26
While going through the code for a Tableau project, you found the following code snippet. What
will be the output of this code snippet? FLOOR(CEILING(3.456))
o4
O3
O35
O Syntax error
==================================================
Question No. 27
Penny, a developer, wants to display the progress of the value of a task or resource over a
period. Which of the following charts should she use for this?
© Bubble Chart
© Bullet Chart
© Crosstab Chart
© Gantt Chart
==================================================
Question No. 28
The table contains the data of people who prefer tea over coffee and availability of tea and
coffee. Which of the following options is the best visualization to find the relation between
these
two parameters?
O Histogram
O Scatter Plot
O Bar Chart
O Density Map
==================================================
Question No. 29
Which of the following view uses the text tables to display the numbers associated with
dimension members?
O Crosstab
© Dashboard
CO Calculated field
O Data Pane
==================================================
Question No. 30
Harry has implemented the filtering of data in a Tableau project. Which of the following options
is not a type of filter in Tableau?
© Custom
© Context
© Normal
O Highlight
==================================================
Question No. 31
You're tasked with designing a data warehouse for a multinational retail corporation. The
corporation manages a diverse range of products across different categories, and it requires a
data model that allows for flexible reporting and analysis.Which data modeling approach would
you recommend, and why?
© Implement a Dimensional Modeling approach with a Star Schema. Use dimension tables for
product attributes like category, brand, and location, and a central fact table for sales
transactions. This approach provides easy querying and flexibility for reporting.
CO Adopt a Snowflake Schema for better normalization. Break down dimension tables into sub-
dimensions for more granular reporting. Utilize multiple fact tables to capture different
aspects of sales transactions. This approach offers more detailed reporting capabilities.
O Utilize a NoSQL data model for improved scalability and flexibility. Design document-based
collections to represent products, categories, and sales transactions. Leverage
document databases like MongoDB for storing and querying the data. This approach provides
flexibility for evolving product structures.
O Implement a Graph Data Model to represent the relationships between products, categories,
and sales transactions. Utilize a graph database like Neo4j to store and traverse
these relationships. This approach is beneficial for analyzing complex interdependencies.
==================================================
Question No. 32
A developer wants to display the cumulative effect of sequential positive and negative values.
Which of the following charts should he use for this?
© Bullet Chart
© Crosstab Chart
© Gantt Chart
O Waterfall Charts
==================================================
Question No. 33
You want to create a flexible dashboard that includes three bar charts given below. You want to
select a particular department in your dashboard and have the other two sheets adjust to
only view values for that department. 1. Amount by department2. Amount by category3.
Quantity by categoryWhich of the following features will you use for such a requirement?
O Filters
CO Parameters
O Sets
O Groups
==================================================
Question No. 34
What is the purpose of the "Show Me Pane" in Tableau?
O To display a list of available data sources
O To suggest appropriate visualization types based on the selected data fields
O To create calculated fields using predefined formulas
O To export visualizations to other formats such as PDF or image files
==================================================
Question No. 35
You are creating a Tableau report and need to use either an extract or a live connection. What is
the best option available to choose an extract over a live connection?
O You need the latest possible data at all times.
O You need the data source to be only supported by a live connection via ODBC.
O You need to join the tables that are in the data source.
O You need to apply an aggregation that takes too long when using a live connection.
==================================================
Question No. 36
As a site developer, Caroline is working on a project report for which she needs to use the bullet
graph. For which of the following options can you use a bullet graph?
O Analyzing the trend for a time period.
© Comparing the actual against the target sales.
CO Adding data to bins and calculating count measures.
O Displaying the sales growth for a particular year.
==================================================
Question No. 37
You created a column chart with the product name and price and got a chart with the same
color for all the columns. Which of the following steps should you follow to assign one color for
each column?
© Drag and drop the price in the color marks card and change the measure to continuous.
CO Drag and drop the price in the color marks card and change the measure to discrete.
O Drag and drop the price into colors.
O Drag and drop the product name into colors.
==================================================
Question No. 38
You've been assigned the responsibility of optimizing the performance of a data warehouse
system, specifically one that deals with complex analytical queries. This system often
encounters lengthy processing times when handling these intricate queries. For this, you decide
to use a technique that involves breaking down a query into smaller tasks that can be
executed simultaneously across multiple CPU cores. Which technique should you employ to
improve processing speed and efficiency in this scenario?
CO Data SDifficulting
O Indexing
O Parallel Processing
O Materialized Views
==================================================
Question No. 39
A data analyst has to complete a project in 4 months. He divided his project into multiple tasks
and wanted to schedule his tasks. Which of the following is the best visualization suited to
solve the problem?
© Bullet Chart
O Heat Map
© Gantt Chart
O Bar Graph
==================================================
Question No. 40
You have data on expired medicine from the years 2001 to 2020 of all products in
pharmaceutical companies. You have to calculate the average amount of expired medicine
between the
years 2010 and 2015. Which of the following options can be used for this?
© RUNNING_COUNT(SUM([Expired_Amount]
© RUNNING_AVG(SUM([Expired_Amount]
© AVG(SUM([Expired_Amount]
O RUNNING_SUM(SUM([Expired_Amount]
