Tableau Assessment
Tableau Assessment
Sudhir Singh
Singh ((2561319@[Link]
2561319@[Link]
2561319@[Link]))
Status : Fail
Assessment Date : 04-02-2025 [Link] (GMT+05:30)
Performance Level : Low
Low
17.00
17.00 40.00
40.00 32.00
32.00
Your Total Assessment Cut-Off marks
Score Score (Pass Marks)
42.50
42.50 LL
Your Performance
Percentage Category
Performance
Performance Category
Category Definitions
Definitions
Excellent
Outstanding level of performance indicates that the candidate has done excellent work and mastered the concepts.
High
High level of performance indicates that the candidate has done above average work and mastered almost all the concepts.
Moderate
Acceptable level of performance indicates that the candidate has done average work and has mastered many of the concepts.
Low
Needs improvement in performance indicates that the candidate has done and mastered very few or none of the concepts.
Performance
Performance Criteria
Criteria
Performance
Performance Category
Category based
based on
on student
student marks
marks
S1 (Tableau) 36.40 and above 32.40 to 36.00 24.40 to 32.00 Below 24.00
Overall Score 36.40 and above 32.40 to 36.00 24.40 to 32.00 Below and equal to 24.00
Where
Where do
do you
you stand?
stand?
TIME
MARKS SPENT YOUR YOUR MAX NO OF MARKED
SECTION SCORED BY SECTION SECTION TOTAL QUESTIONS QUESTIONS CORRECT INCORRECT UNANSWERED FOR
(GROUP) BY YOU YOU PERCENTAGE ACCURACY QUESTIONS - TO ATTEMPTED REVIEW
(IN ATTEMPT
MINS)
S1
17.00 28:41 42.50% 42.50% 40 40 39 17 22 1 0
(Tableau)
Note:The percentage (%) and accuracy below the prescribed values (60 %) are shown in red color
Section-wise marks
S1, 17
S1
SECTION(GROUP) NUMBER OF INCORRECT RESPONSES MARKS LOST DUE TO INCORRECT RESPONSES TOTAL SCORE IF INCORRECT RESPONSES WERE NOT MARKED
S1(grp1) 22 0 17
Overall 22 0 17.00
In order to attempt more accurately, consider the following suggestions while attempting the questions:
1. If you are not able to solve a question correctly or have doubts in your approach towards the solution, skip it for later.
2. Quickly revise the steps for avoiding calculation or casual mistakes.
3. Avoid guesswork.
Time Management
Below table shows the time you spent in each section.
S1 (Tableau) 28:41
Recommendations
1. It is essential for each aspirant to plan and schedule time for each section diligently. This is important to score well in each section and ultimately
meet the cut-off.
2. This will also help you in attempting all the questions in each section and hence not missing the opportunity to score more.
S1 (Tableau) 0 0 0 0 0 17 22
Overall 0 0 0 0 0 17 22
It is suggested that guesswork should be avoided for any type of response changes. It has been observed that more often than not, guesswork leads
to an incorrect response thereby inviting negative marks which in turn has an adverse effect on the overall rank.
You must use your knowledge, observation and elimination skills to arrive at the correct answer.
Overview: S1
The below table provides your marks in S1 along with the average marks scored by the others (students who cleared this assessment) and the marks
scored by the topper.
MARKS SCORED BY YOU YOUR SECTION PERCENTAGE YOUR SECTION ACCURACY TIME SPENT BY YOU (IN MINS)
Note:The percentage (%) and accuracy below the prescribed values (60%) are shown in red color
Correct, 17
InCorrect, 22
Performance Analysis: S1
1. The below table analyzes your performance at question level
2. It highlights conceptually strong and improvement areas within the section and areas that require reinforcement of concepts.
3. The accuracy of the response to each question and time spent are correlated and interpreted in terms of expert advice on preparedness level.
Question Details
Q1.
Q1. 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?
Status : Answered
Answered
Marks Obtained : 1
Options :
1. Blending
2. Joining
3. Jittering
4. Filtering
Timespent (in sec): 73
73
Correct to Incorrect: 00
Incorrect to Correct: 00
Incorrect to Incorrect: 00
Correct to unanswered: 00
Incorrect to unanswered: 00
Unanswered to Correct: 11
Unanswered to Incorrect: 00
Q2. Sarah, a developer, requires a chart used to visualize the matrix value graphically using colors. What of the following can she use for this?
Marks Obtained : 1
Total Question Marks : 1
Options :
1. Tree Map
2. Histogram
3. Heat Map
4. Pie Chart
Timespent (in sec): 29
29
Correct to Incorrect: 00
Incorrect to Correct: 00
Incorrect to Incorrect: 00
Correct to unanswered: 00
Incorrect to unanswered: 00
Unanswered to Correct: 11
Unanswered to Incorrect: 00
Q3. What will be the best visualization to compare the profit of different products manufactured by your company?
Marks Obtained : 1
Total Question Marks : 1
Options :
1. Histogram
2. Scatter Plot
3. Bar Chart
4. Density Map
Timespent (in sec): 83
83
Correct to Incorrect: 00
Incorrect to Correct: 00
Incorrect to Incorrect: 00
Correct to unanswered: 00
Incorrect to unanswered: 00
Unanswered to Correct: 11
Unanswered to Incorrect: 00
Q4. 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?
Marks Obtained : 0
Total Question Marks : 1
Options :
1. 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.
2. 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.
3. 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.
4. 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.
Timespent (in sec): 63
63
Correct to Incorrect: 00
Incorrect to Correct: 00
Incorrect to Incorrect: 00
Correct to unanswered: 00
Incorrect to unanswered: 00
Unanswered to Correct: 00
Unanswered to Incorrect: 11
Q5. Four functionalities of RANK_DENSE in Tableau are provided in the options. Which of them is the correct option?
Marks Obtained : 0
Total Question Marks : 1
Options :
1. 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).
2. 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).
3. 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).
4. 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).
Timespent (in sec): 12
12
Correct to Incorrect: 00
Incorrect to Correct: 00
Incorrect to Incorrect: 00
Correct to unanswered: 00
Incorrect to unanswered: 00
Unanswered to Correct: 00
Unanswered to Incorrect: 11
Q6. 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?
Marks Obtained : 0
Total Question Marks : 1
Options :
1. FIXED LOD
2. CUSTOM LOD
3. INCLUDE LOD
4. EXCLUDE LOD
Timespent (in sec): 31
31
Correct to Incorrect: 00
Incorrect to Correct: 00
Incorrect to Incorrect: 00
Correct to unanswered: 00
Incorrect to unanswered: 00
Unanswered to Correct: 00
Unanswered to Incorrect: 11
Q7. 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?
Marks Obtained : 0
Total Question Marks : 1
Options :
1. Calculations are functions that can be used to send SQL expressions directly to the database.
2. Calculations are functions that allow you to perform computations on values in a table.
3. Calculations are functions that allow you to pass data directly to a running external service instance.
4. Calculations are functions that can specify, include, or omit dimensions from the current view.
Timespent (in sec): 31
31
Correct to Incorrect: 00
Incorrect to Correct: 00
Incorrect to Incorrect: 00
Correct to unanswered: 00
Incorrect to unanswered: 00
Unanswered to Correct: 00
Unanswered to Incorrect: 11
Q8. If you are using a live connection, Tableau automatically selects the option "Auto Update Worksheet". Choose the correct option that will disable
this feature.
Marks Obtained : 1
Total Question Marks : 1
Options :
Q9. A developer wants to display the cumulative effect of sequential positive and negative values. Which of the following charts should he use for
this?
Marks Obtained : 0
Total Question Marks : 1
Options :
1. Bullet Chart
2. Crosstab Chart
3. Gantt Chart
4. Waterfall Charts
Timespent (in sec): 17
17
Correct to Incorrect: 00
Incorrect to Correct: 00
Incorrect to Incorrect: 00
Correct to unanswered: 00
Incorrect to unanswered: 00
Unanswered to Correct: 00
Unanswered to Incorrect: 11
Q10. 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?
Marks Obtained : 0
Total Question Marks : 1
Options :
1. Bullet Chart
2. Heat Map
3. Gantt Chart
4. Bar Graph
Timespent (in sec): 20
20
Correct to Incorrect: 00
Incorrect to Correct: 00
Incorrect to Incorrect: 00
Correct to unanswered: 00
Incorrect to unanswered: 00
Unanswered to Correct: 00
Unanswered to Incorrect: 11
Q11. 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.
Marks Obtained : 1
Total Question Marks : 1
Options :
Q12. Harry has implemented the filtering of data in a Tableau project. Which of the following options is not a type of filter in Tableau?
Marks Obtained : 1
Total Question Marks : 1
Options :
1. Custom
2. Context
3. Normal
4. Highlight
Timespent (in sec): 16
16
Correct to Incorrect: 00
Incorrect to Correct: 00
Incorrect to Incorrect: 00
Correct to unanswered: 00
Incorrect to unanswered: 00
Unanswered to Correct: 11
Unanswered to Incorrect: 00
Q14. Which of the following visualizations is the least appropriate for categorical data?
Marks Obtained : 0
Total Question Marks : 1
Options :
1. Line chart
2. Pie chart
3. Bar chart
4. Combo chart
Timespent (in sec): 13
13
Correct to Incorrect: 00
Incorrect to Correct: 00
Incorrect to Incorrect: 00
Correct to unanswered: 00
Incorrect to unanswered: 00
Unanswered to Correct: 00
Unanswered to Incorrect: 11
Q15. 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?
Marks Obtained : 0
Total Question Marks : 1
Options :
1. Line Chart
2. Bar Chart
3. Histogram
4. Scatter Plot
Timespent (in sec): 11
11
Correct to Incorrect: 00
Incorrect to Correct: 00
Incorrect to Incorrect: 00
Correct to unanswered: 00
Incorrect to unanswered: 00
Unanswered to Correct: 00
Unanswered to Incorrect: 11
Q16. 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?
Marks Obtained : 1
Total Question Marks : 1
Options :
Q18. 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?
Marks Obtained : 0
Total Question Marks : 1
Options :
Q19. 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?
Marks Obtained : 1
Total Question Marks : 1
Options :
Q20. 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?
Marks Obtained : 0
Total Question Marks : 1
Options :
1. RUNNING_COUNT(SUM([Expired_Amount]
2. RUNNING_AVG(SUM([Expired_Amount]
3. AVG(SUM([Expired_Amount]
4. RUNNING_SUM(SUM([Expired_Amount]
Timespent (in sec): 132
132
Correct to Incorrect: 00
Incorrect to Correct: 00
Incorrect to Incorrect: 00
Correct to unanswered: 00
Incorrect to unanswered: 00
Unanswered to Correct: 00
Unanswered to Incorrect: 11
Q21. 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?
Marks Obtained : 0
Total Question Marks : 1
Options :
1. Days in a week
2. Different days in a week
3. Different months
4. Same months in different years
Timespent (in sec): 22
22
Correct to Incorrect: 00
Incorrect to Correct: 00
Incorrect to Incorrect: 00
Correct to unanswered: 00
Incorrect to unanswered: 00
Unanswered to Correct: 00
Unanswered to Incorrect: 11
Q22. 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?
Marks Obtained : 0
Total Question Marks : 1
Options :
1. Bubble Chart
2. Bullet Chart
3. Crosstab Chart
4. Gantt Chart
Timespent (in sec): 33
33
Correct to Incorrect: 00
Incorrect to Correct: 00
Incorrect to Incorrect: 00
Correct to unanswered: 00
Incorrect to unanswered: 00
Unanswered to Correct: 00
Unanswered to Incorrect: 11
Q23. 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?
Marks Obtained : 0
Total Question Marks : 1
Options :
1. Tableau workbook
2. Tableau packaged workbook
3. Tableau data source
4. Tableau packaged data source
Timespent (in sec): 37
37
Correct to Incorrect: 00
Incorrect to Correct: 00
Incorrect to Incorrect: 00
Correct to unanswered: 00
Incorrect to unanswered: 00
Unanswered to Correct: 00
Unanswered to Incorrect: 11
Q24. Which of the following view uses the text tables to display the numbers associated with dimension members?
Marks Obtained : 0
Total Question Marks : 1
Options :
1. Crosstab
2. Dashboard
3. Calculated field
4. Data Pane
Timespent (in sec): 33
33
Correct to Incorrect: 00
Incorrect to Correct: 00
Incorrect to Incorrect: 00
Correct to unanswered: 00
Incorrect to unanswered: 00
Unanswered to Correct: 00
Unanswered to Incorrect: 11
Q25. 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?
Marks Obtained : 1
Total Question Marks : 1
Options :
1. Union
2. Key-column pair
3. Groups
4. Tasks
Timespent (in sec): 29
29
Correct to Incorrect: 00
Incorrect to Correct: 00
Incorrect to Incorrect: 00
Correct to unanswered: 00
Incorrect to unanswered: 00
Unanswered to Correct: 11
Unanswered to Incorrect: 00
Q26. 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?
Marks Obtained : 0
Total Question Marks : 1
Options :
Q27. A developer working on filters wants to limit the result set from a filter. Which of the following filters can he use for this?
Marks Obtained : 1
Total Question Marks : 1
Options :
1. Top filter
2. Multiple values filter
3. Single value filter
4. Wildcard match filter
Timespent (in sec): 22
22
Correct to Incorrect: 00
Incorrect to Correct: 00
Incorrect to Incorrect: 00
Correct to unanswered: 00
Incorrect to unanswered: 00
Unanswered to Correct: 11
Unanswered to Incorrect: 00
Q28. 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))
Marks Obtained : 0
Total Question Marks : 1
Options :
1. 4
2. 3
3. 3.5
4. Syntax error
Timespent (in sec): 122
122
Correct to Incorrect: 00
Incorrect to Correct: 00
Incorrect to Incorrect: 00
Correct to unanswered: 00
Incorrect to unanswered: 00
Unanswered to Correct: 00
Unanswered to Incorrect: 11
Q29. 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?
Q30. 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?
Marks Obtained : 1
Total Question Marks : 1
Options :
1. Data SDifficulting
2. Indexing
3. Parallel Processing
4. Materialized Views
Timespent (in sec): 62
62
Correct to Incorrect: 00
Incorrect to Correct: 00
Incorrect to Incorrect: 00
Correct to unanswered: 00
Incorrect to unanswered: 00
Unanswered to Correct: 11
Unanswered to Incorrect: 00
Q31. 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?
Marks Obtained : 0
Total Question Marks : 1
Options :
1. Drag and drop the price in the color marks card and change the measure to continuous.
2. Drag and drop the price in the color marks card and change the measure to discrete.
3. Drag and drop the price into colors.
4. Drag and drop the product name into colors.
Timespent (in sec): 42
42
Correct to Incorrect: 00
Incorrect to Correct: 00
Incorrect to Incorrect: 00
Correct to unanswered: 00
Incorrect to unanswered: 00
Unanswered to Correct: 00
Unanswered to Incorrect: 11
Q32. 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?
Marks Obtained : 0
Total Question Marks : 1
Options :
1. Right Join
2. Left Join
3. Full Join
4. Inner Join
Timespent (in sec): 19
19
Correct to Incorrect: 00
Incorrect to Correct: 00
Incorrect to Incorrect: 00
Correct to unanswered: 00
Incorrect to unanswered: 00
Unanswered to Correct: 00
Unanswered to Incorrect: 11
Q33. A company has no sales, so they implement the following function. What will be the output of this code? ZN(SUM([SALES]))
Marks Obtained : 1
Total Question Marks : 1
Options :
1. Null
2. 0
3. It will throw an error.
4. -1
Timespent (in sec): 65
65
Correct to Incorrect: 00
Incorrect to Correct: 00
Incorrect to Incorrect: 00
Correct to unanswered: 00
Incorrect to unanswered: 00
Unanswered to Correct: 11
Unanswered to Incorrect: 00
Q34. 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?
Marks Obtained : 0
Total Question Marks : 1
Options :
1. Histogram
2. Scatter Plot
3. Bar Chart
4. Density Map
Timespent (in sec): 22
22
Correct to Incorrect: 00
Incorrect to Correct: 00
Incorrect to Incorrect: 00
Correct to unanswered: 00
Incorrect to unanswered: 00
Unanswered to Correct: 00
Unanswered to Incorrect: 11
Q35. What will be the output of the following code snippet? FINDNTH("multiplication", 'i', 2)
Marks Obtained : 1
Total Question Marks : 1
Options :
1. 2
2. 8
3. 4
4. 0
Timespent (in sec): 135
135
Correct to Incorrect: 00
Incorrect to Correct: 00
Incorrect to Incorrect: 00
Correct to unanswered: 00
Incorrect to unanswered: 00
Unanswered to Correct: 11
Unanswered to Incorrect: 00
Q36. Identify the file present in the bookmarks folder in the Tableau repository that contains a single worksheet.
Marks Obtained : 0
Total Question Marks : 1
Options :
1. .tbm
2. .tm
3. .tb
4. .tk
Timespent (in sec): 63
63
Correct to Incorrect: 00
Incorrect to Correct: 00
Incorrect to Incorrect: 00
Correct to unanswered: 00
Incorrect to unanswered: 00
Unanswered to Correct: 00
Unanswered to Incorrect: 11
Q37. 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?
Marks Obtained : 1
Total Question Marks : 1
Options :
1. Quick filter
2. Action filter
3. Context filter
4. Dimension filter
Timespent (in sec): 21
21
Correct to Incorrect: 00
Incorrect to Correct: 00
Incorrect to Incorrect: 00
Correct to unanswered: 00
Incorrect to unanswered: 00
Unanswered to Correct: 11
Unanswered to Incorrect: 00
Q38. 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 department 2. Amount by category 3.
Quantity by category Which of the following features will you use for such a requirement?
Marks Obtained : 0
Total Question Marks : 1
Options :
1. Filters
2. Parameters
3. Sets
4. Groups
Timespent (in sec): 28
28
Correct to Incorrect: 00
Incorrect to Correct: 00
Incorrect to Incorrect: 00
Correct to unanswered: 00
Incorrect to unanswered: 00
Unanswered to Correct: 00
Unanswered to Incorrect: 11
Q39. 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?
Marks Obtained : 0
Total Question Marks : 1
Options :
1. FIXED LOD
2. CUSTOM LOD
3. INCLUDE LOD
4. EXCLUDE LOD
Timespent (in sec): 37
37
Correct to Incorrect: 00
Incorrect to Correct: 00
Incorrect to Incorrect: 00
Correct to unanswered: 00
Incorrect to unanswered: 00
Unanswered to Correct: 00
Unanswered to Incorrect: 11
0 0 0 0 0 17 22