Exam (elaborations)
TABLEAU CERTIFICATION QUESTIONS AND ANSWERS
- Course
- Institution
TABLEAU CERTIFICATION QUESTIONS AND ANSWERS
[Show more]
Content preview
TABLEAUCERTIFICATION
QUESTIONS AND
ANSWERS
To connect tableau to a csv data source what type of connection should you use? -
answers -text file
What are the two main groups that all fields are broken up into in tableau - answers -
dimension and measures
What are calculated fields in tableau - answers -these are custom variables that you
create from fields provided in the data
How many fields can you add to be shown in the label - answers -no limit
How do you decide what colors to use - answers -the main thing to take into account is
the end user / viewer. Colors should assist them in seeing the insights that your charts
are portraying
Which of these is a valid reason to use a data extract over a live connection to the
dataset - answers -your data is constantly being updated and you want to work with a
static file when building your visual (you will later return to the live connection when the
visual is ready)
What is the difference between the blue month() and the green month() - answers -blue
is a dimension and green is a measure. Blue ignores higher periods such as year and
treats month as a category. Green creates a proper timeline
How does tableau know at which level to aggregate variables - answers -values are
always aggregated at the level of granularity of the worksheet
,To add worksheets to a dashboard you can simply drag them onto the dashboard -
answers -true
What is the main conceptual difference between action: filter and action: highlight for a
dashboard - answers -when you use action: filter you are removing data from analysis
before it is illustrated on the visualization. Action: highlight all the data is visualized first
and then the action is applied after. Can lead to discrepancies in results.
You can automatically generate action: filter through the dropdown of the selected
worksheet in the dashboard - answers -true
Which of these is a good rough description of what happens when two tables are joined
- answers -the rows of the second table are placed to the side of the rows of the first.
The table is extended horizontally
What happens when one of the tables has duplicate values in the join clause - answers
-the matching row of the other table is replicated to accommodate the number of
duplicates
What can happen when you join on a single field when it is required to join on multiple
fields - answers -rows will be duplicated without an actual reason, hyper inflation of
measures, incorrect insights and business decisions
Data blending in tableau happens after aggregation is performed on the separate
datasets - answers -false
When would you use data blending and not data joining - answers -when your datasets
have different levels of granularity. When your data comes from disparate data sources.
When you simply cannot do a join for any other reason
What is the first thing you need to do after creating a dual axis chart - answers -
synchronize the axis
How is creating calculated fields in a blend different to creating normal calculated fields
- answers -the data elements used have to be aggregated
How do you set geographic roles - answers -right click the appropriate field and select
the appropriate geographic role
Which of the following is not a quick table calculation in tableau - answers -stochastic
oscillation
Which of these are types of allowable values for any parameter - answers -all. List.
Range.
What is the main visual element of a treemap called - answers -box
,Which of these explains the conceptual difference between a line chart and an area
chart - answers -an area chart stacks up values of different categories on top of each
other. A line chart visualizes them separately
Which of these is not a type of quick filter available in tableau - answers -json lookup
category
When would you need to create hierarchies in tableau - answers -when there are
hierarchies present in the dimensions and tableau needs to know about them for you to
build your visualization
Which of the following are different ways you can select the worksheets to which you
want to apply a filter - answers -all using this data source, selected worksheets, only this
worksheet
What are customer segmentation dashboards used for - answers -understand how
customers are segmented across different geographies. To make better business
decisions. To deliver a better customer experience making it tailored and relevant.
Which of the following statements about what can be used as pages in a storyline is
true - answers -both worksheets and dashboards can be used as pages in a storyline.
They cannot be combined on one page.
When you change the value of a parameter on one page of the storyline, it also
changes on all other pages of the storyline - answers -false
Approximately what percent of work of a data scientist is data preparation - answers -
70%
What is the best format of data for machines in tableau - answers -where each measure
and dimension has its own column
Which of these tableau 9 features allows you to change the format of the data from
where the years are in columns to when the years have their own columns - answers -
pivot
Which of the following is not a new feature introduced in tableau 10 - answers -3
dimensional dashboards
What does a highlighter allow you to accomplish - answers -subtly highlight different
marks on your chart based on the categories of the selected field without interfering with
the charts visual representation (marks shown, sizes, etc)
Is it possible to specify additional variables for clustering analysis (apart from the
variables present in your chart) - answers -yes, you can specify additional variables and
, you can remove unwanted variables from the clustering analysis without removing them
from the chart
Are clusters a dimension or a measure - answers -dimension- because they represent a
categorical split of your data
Does the introduction of cross database joins render blends completely useless -
answers -no. Blends are a left join that happens after the data has been aggregated to
the appropriate level.
It is possible to add a field to more than one hierarchy - answers -true. Right click and
choose duplicate field and then you can add it to more than one
We get a different color palette if we drop a discrete field on color in the marks card as
opposed to dropping a continuous field - answers -true. Discrete: categorical palette.
Different color for each category. Have no inherent order bc they are just categories. To
change the color for a value
1) click on an item on the left, under select data item.
2) click a new color in the palette on the right. In tableau desktop you can hover over a
swatch to identify the color.
3) repeat for as many values that you want to change.
4) in tableau desktop, click ok to exit the edit colors dialog box. In tableau server or
tableau online, simply close the dialog box.
For continuous: you get a continuous range of colors, like the fade thin. You can set the
number of steps and the colors for the highest and lowest and middle
By definition, tableau displays measures over time as a - answers -line. Line charts
connect individual data points in a view.
As best practice, how many categories can a pie chart display effectively - answers -2-
5. Anything more is not easy for your eyes to distinguish
You have cleaned a data source properly, created some calculated fields and renamed
some columns. You want to save these changes for future use cases. Which of the
following would best satisfy this requirement? - answers -save it as a .tds file.
Explanation:
After making changes to data, we can save that new data source as a .tds file. To do
so, go to data menu on top and then choose your current connected data source. Then
next click on add to saved data sources. This will save all calculated fields, changes to
fields etc. It will be saved in my tableau repository -> mydatasources. This will then also
appear on tableau home page under saved data sources like samplesuperstore.
Note: data source files do not contain the actual data but rather the information
necessary to connect to the actual data as well as any modifications you've made on
top of the actual data such as changing default properties, creating calculated fields,
adding groups, and so on.
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller Greaterheights. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $13.99. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
67163 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now