1. Keith has created some reports in tableau that include charts and row
data. He wants to change the color of the headers to crimson and increase the
font size of the titles to 19px. Which of the following levels of formatting
should he use to make the desired changes?
2. Which of the following tableau tables contains the textual and descriptive
for various related entities ?
A.
3. In tableau prep, which of following components is used for indicating the logical flow of the data?
A). Step
4. Which of the following of the Tableau server allows the user to save the
current state of the dashboard based on the selections, filters, and parameter
values?
A) View
5. olivia has prepared a line graph which shows the trends of two companies
for the sale of mobile phones. She wants to add some additional marks in the chart
at points where the sales are at the top. Which of the following types of annotations
should she use to achieve this?
A).Area
6. In Tableau, which of the following data types does not contain records for
certain values?
A) . Sparse
7. Which of the following tableau features is responsible for dynamically showing
and hiding the view on a dashboard?
A). Sheet selection
8. Which of the following Tableau products is a data presentation tool that
aims to automate the cleaning process to help the user visually shape the data
?
A). Tableau Prep
9. Robert was assigned a project which took around 90 days to complete. He has
been asked by his manager to provide the complete timeline details of the
activities performed by his team in a visual form. Which of the following chart
types should he use to fulfil the task?
A). Gantt
10. Serra, a data administrator, wants to link tables of data together on row-by-row
basis. Which of the following Tableau features will help Serra perform the
task?
A). Joins
11. In Tableau, which of the following distinctions defines the lowest
level of the table?
A). Cell
12. which of the following types of sets is enumerated for a single
dimension based on the conditional specified by the user?
A). Dynamic
13 Clark works as an economic analyst in XYZ company. He has been asked to analyze
the overall economic situation of the country. He wants to know the percentage
increase or decrease in the GDP growth rate of the current year as compared to
the previous year. Which of the following chart types should he use to accomplish
this task?
A). Bar-in-bar
14. Which of the following file extensions is used to save an extract file?
A). .hyper
15. Thomas has been provided with some related to the properties located in
different blocks of a city. He has been asked to provide the average rent of
the properties per block. Which of the following level of detail types should
he use to the result?
A). Fixed
16. Martin has plotted a bar graph displaying the sales for different
products made by a company. He wants to provide some additional details like
category, sub-category, name of the product, and the discount offered whenever
he clicks or hovers over any bar in the graph. Which of the following tableau
features should he use to display the information?
A). Tooltip
17. In tableau, which of the following panes provides the user with the options
to add average reference lines, box plats, trend lines, and forecasts to the
visualizations?
A). Analytics
18. Which of the following features of the Create parameter window
interface provides the user with the ability to limit the scope of the permissible
values?
A). Allowable values
19. Which of the following file types can be exported from OLAP databases?
A). Local cube
20. Eliza, an analyst in a cinema production, wants to visualize the performance
of the films nominated for the academy awards against the other films released
in corresponding year. Which of the following chart types should she use to
carry out the task?
A). Scatter plot
21. In tableau, which of the following calculations provides the user with
the ability to write a calculated field to be joined in joins?
A). Join
22. Benjamin is having sales data of the previous year. He needs to display
the total sales value for each month in the
calendar type view. Which of the following tableau features should he
use to obtain the result?
A). Data scaffolding
23. Which of the following features is the heart of tableau?
A). Data visualization
24. Which of the following tableau objects helps the user to adjust the
spacing between the dashboard items?
A). Blank
25. Which of the following tableau features provides the user the ability
to focus on the marks in a view by selecting the values from the dropdown menu?
A). Data highlighter
26. Which of the following joins in tableau returns the common records
between the joining tables?
A). Inner
27. A five-star hotel provides booking offers to its guests. The manager to
the hotel has asked jeff, a financial analyst, to provide a list of guests who
had checked-in in the last month and highlight those guests who availed offers
while booking online. Which of the following types of calculations should jeff
use to accomplish the task?
A). Ad-hoc
28. Which of the following types of values is used to define aggregated
values that can be summed, averaged, counted, or have a minimum or maximum?
A). Measure
29. Which of the following programming languages is commonly used by the
analysts for data cleansing and manipulation?
A). Python
30. Which of the following territories is useful in providing long-term
solutions?
A). Field-defined
31. Which of the following tableau components is used by clustering
algorithm to determine related data points?
A). Variable
32 In tableau, which of the following features are the key aspects of the
formatting window?
A). 1. The fields drop-down in the
upper-tight corner allows the user to fine-tune formatting at the field level.
2. The icons on the top match the selection options of the format menu.
3. The title of the window provides the user with the context for the formatting
selections.
33. Which of the following file extensions saves XML file that specifies
the map services and configuration.
A). .Tms
34. In tableau, which of the following methods are used for creating table
calculations?
A). 1.From the drop-down menu for the active field used as a numeric aggregate
in the view, select the quick calculation option
2. create a calculated field and use the table calculation functions for writing
custom table calculations
3. from the drop-down menu for the
active field used as a numeric aggregate in the view, select the Add Table
calculation option, and then select the calculation type.
35. What is the primary objective of a dashboard?
A). To communicate data to the audience with an intended result
36. Patrick has been provided with the dataset of bank transactions for the
last five months. He needs to provide the count of the account holders who have
made transactions of the amount greater then $3000 in the last month along with
the aggerate value of those transactions. Which of the following functions
should he use to accomplish the task?
A) TOTAL()
37. which of the following components of the tableau prep builder provides
the user with the options for training and resources?
A). Discover
38. Caroline is working on a tableau project where she to prepare a report
showing a list of employee details working as a customer support executive with
the latest total count of tickets resolved by them since their data of joining.
She needs to fetch ticket count data from the MySQL server which she has to run
an SQL query inside Tableau. Which of the following function groups can she use
to pass a raw SQL query to the tableau data source?
A). Pass-through
39. In tableau, which of the following tabs displays different data source
connections in the same workbook?
A). Data
40. Which of the following Tableau objects provides the user with the
ability to add controls and objects to the dashboards?
A). Extension
41. Which of the following Tableau actions underlines specific marks and
headers in the view?
A). Highlight
42. Allison has appeared for the Tableau test scheduled by
her university. She has correctly attempted all the questions but got stuck on
one. This question contains an image that gives an overview of the table
calculations having a question mark along with one o the curved arrows showing
the flow. Which of the following types of results should Allison choose to replace
the question mark given in the image with the correct answer?
A) Aggregated
43. In tableau, which of the following trend models is used to plot a curve
line for a dependent variable that increases at a predetermined rate?
A). power
44. Which of the following are the steps of the data analytics cycle?
A). 1. Data preparation
2. Data storytelling
3. Data analysis
45. Which of the following components of tableau defines a collection of dashboards
or single views arranged to convey a narrative from the dataset?
A). Story
46. Catherine works for an e-commerce company. She is asked to provide a
chart showing the total sales of electronic items of different brands for the previous
year. Which of the following chart types will help her accomplish the task?
A). Stacked bar
47. An organization wants to create a centralized data source for its
employees so that they can operate on the data sets collectively on tableau.
This approach will also provide more security to the data and ease in
collaboration with the other data sources. Which of the following tableau
products should be used in this scenario?
A). Tableau server
48. Dylan is working on the sales dataset of a superstore. He wants to prepare
to analyze the monthly sales trends based on the duration of the sales. The
duration value indicates a certain state that exists only for a certain period
of time and then moves to another state. Which of the following visualization
types should he use to accomplish the task?
A). Jump Line
49. Which of the following distribution options allows programmatic interactions
with the tableau server?
A). REST API
50. Which of the following file extensions is used to save a tableau prep packaged
flow file stores the definition of the steps and changes of a data flow?
A). Tflx
1) Which of the following types of values define an aggregated value that can be summed, averaged, counted, or have a minimum or a maximum?
A. Measures
2) The _________ pane provides a user with the option to add average reference lines, box plots, trend lines, and forecasts to the visualizations.
A. Analytics
3) In Tableau, which of the following data types does not contain records for certain values?
A. Sparse
4) Which of the following Tableau objects helps a user to adjust the spacing between the dashboard items?
A. Blank
5) Benjamin has sales data of the previous year. He needs to display the total sales value for each month in the calendar-type view. Which of the following Tableau features should he use to obtain the desired result?
A. Data scaffolding
6) Dylan is working on the sales dataset of a superstore. He wants to prepare a chart to analyze the monthly sales trends based on how long each sale stays in a specific state before transitioning to another. Which of the following visualization types should he use to accomplish the task?
A. Jump line
7) Which Tableau product is a data presentation tool that aims to automate the cleaning process to help a user visually shape the data?
A. Tableau Prep
8) Which of the following components of the Tableau Prep Builder provides a user with options for training and resources?
A. Discover
9) What are the several ways to create table calculations?
Each correct answer represents a complete solution. Choose all that apply.
A. From the drop-down menu for the active field used as a numeric aggregate in the view, select Quick Table Calculation, and then select the calculation type.
10) Olivia, a data analyst, has created a line graph comparing the sales trends of two companies in the mobile phone market. She aims to insert rectangular annotations at specific points where sales peak on the chart. These annotations need to dynamically include actual sales values and other relevant data points from the worksheet.
A. Area
11) Which file extension is used to save a Tableau Prep packaged flow file that stores the definition of the steps and changes of a data flow?
A. .tflx
12) Which of the following components is used by a clustering algorithm to determine related data points?
A. Variable
13) Which of the following Tableau objects provides a user with the ability to add controls and objects to the dashboards that they or a third party has developed for interacting with the dashboard and providing extended functionality?
A. Extension
14) John, a data analyst at a retail company, is preparing a report on product sales performance across different store locations. He needs to calculate the average sales per store location dynamically within Tableau, without permanently altering the dataset or adding fields to the Data pane.
A. Ad hoc
15) A _______ defines the lowest level of a table.
A. Cell
16) Which of the following Tableau tables contains the textual and descriptive attributes of various related entities?
A. Dimension
17) Which of the following Tableau actions underlines specific marks and headers in the view?
A. Highlight
18) Which of the following Tableau features provides a user the ability to focus on the marks in a view by selecting the values from the dropdown menu?
A. Data highlighter
19) In Tableau, which of the following data types does not contain records for certain values?
A. Sparse
20) Which of the following file extensions saves an XML file that specifies the map services and configuration.
A. .tms
21) Which of the following features of the Create Parameter window interface provides a user with the ability to limit the scope of the permissible values?
A. Allowable values
22) An organization wants to create a centralized data source for its employees so that they can operate on the data sets collectively on Tableau. This approach will also provide more security to the data and ease collaboration with the other data sources. Which of the following Tableau products should be used in this scenario
A. Tableau Server
23) Robert was assigned a project which took around 90 days to complete. He has been asked by his manager to provide the complete timeline details of the activities performed by his team in a visual form. Which of the following chart types should he use to fulfill the task?
A. Gantt
24) Benjamin has sales data of the previous year. He needs to display the total sales value for each month in the calendar-type view. Which of the following Tableau features should he use to obtain the desired result?
A. Data scaffolding
25) Anna is a data analyst at a marketing firm tasked with analyzing the relationship between advertising spending and sales revenue across various product categories. She wants to determine if there is a correlation between advertising spending and sales revenue across different product categories
A. Scatterplot
26) Which of the following defines a collection of dashboards or single views arranged to convey a narrative from the dataset?
A. Story
27) Which programming language is commonly used by data analysts for data cleansing and manipulation?
A. Python
28) Which of the following distribution options allows programmatic interactions with the Tableau Server?
A. REST API
29) David, a sales manager, is analyzing the monthly sales performance of different product lines across multiple stores. He wants to calculate the overall sales for each store and assess how each product line's sales contribute to it. Which Tableau function should he use to achieve this task?
A. Total()
30. Which of the following best defines a step?
A. The logical flow of the data
31. Which of the following is responsible for dynamically showing and hiding the view on a dashboard?
A. Sheet selection
32. Which of the following file extensions is used to save an extract file?
A. .hyper
33. Clark works as an economic analyst at XYZ Company. He has been asked to analyze the overall economic situation of the country. He wants to determine the percentage increase or decrease in the GDP growth rate of the current year as compared to the previous year. Which of the following chart types should he use to accomplish this task?
A. Bar-in-bar
34. A _______ set is enumerated for a single dimension based on the conditional calculation specified by a user. As the data changes, the results of the condition may change and records may switch between in and out of the set.
A. Dynamic
35. What is the primary objective of a dashboard?
A. To communicate data to the audience with an intended result
36. Which of the following components of the Tableau Prep Builder provides a user with options for training and resources?
A. Discover
37. Which of the following options of the Tableau Server allows a user to save the current state of the dashboard based on the selections, filters, and parameter values?
A. View
38. Which of the following features is the heart of Tableau?
A. Data visualization
39. Which of the following Tableau objects helps a user to adjust the spacing between the dashboard items?
A. Blank
40. Which of the following trend models is used when the relationship between two items is non-linear and somewhere between a diminishing logarithmic trend and an explosive exponential trend?
A. Power
41. Thomas has been provided with some data related to the properties located in different blocks of a city. He has been asked to provide the average rent of the properties per block. Which of the following level of detail types should he use to get the result?
A. Fixed
42. Which of the following file types can be exported from OLAP databases?
A. Local cube
43. Caroline is working on a Tableau project where she has to prepare a report showing a list of employee details working as a customer support executive with the latest total count of tickets resolved by them since their date of joining. She needs to fetch the ticket count data from the MySQL server for which she has to run an SQL query inside Tableau. Which of the following function groups can she use to send a raw SQL query to the Tableau data source?
A. Pass Through
44. What are the key aspects of the formatting window?
Each correct answer represents a complete solution. Choose all that apply.
A. The Fields drop-down in the upper-right corner allows a user to fine-tune formatting at the field level.
The icons on the top match the selection options of the Format menu.
The title of the window provides a user with the context for the formatting selections.
45. Keith has created some reports in Tableau that include charts and row data. He wants to change the color of the headers to crimson and increase the font size of the titles to 19px. Which of the following levels of formatting should he use to make the desired changes?
A. Rich-text
46. Which of the following types of values define an aggregated value that can be summed, averaged, counted, or have a minimum or a maximum?
A. Measures
47. Martin has plotted a bar graph displaying the sales for different products made by a company. He wants to provide some additional details like category, sub-category, name of the product, and the discount offered whenever he clicks or hovers over any bar in the graph. Which of the following Tableau features should he use to display the information?
A. Tooltip
48. The _____ join in Tableau returns the common records between the joining tables.
A. Inner
49. A time series is an example of a:
A. line chart
50. Which Tableau product is a data presentation tool that aims to automate the cleaning process to help a user visually shape the data?
A. Tableau Prep
Comments
Post a Comment