Tableau Desktop Specialist Practice Test Questions (Udemy)

Creating a scatter plot requires a minimum of how many measures? A.) 3 B.) 1 C.) 2 D.) 4

Creating a scatter plot requires a minimum of how many measures? D.) 4 -------------------------------------------------------------- *In Tableau, you create a scatter plot by placing at least one measure on the Columns shelf and at least one measure on the Rows shelf (Total 2 minimum). *If these shelves contain both dimensions and measures, Tableau places the measures as the innermost fields, which means that measures are always to the right of any dimensions that you have also placed on these shelves. *The word "innermost" in this case refers to the table structure.

A Tableau Data Source File (.tds) contains which of the following? (Select all that apply) A.) Copy of any local file-based data B.) Data Source Type C.) Default Field Properties D.) Calculated Fields

A Tableau Data Source File (.tds) contains which of the following? (Select all that apply) B.) Data Source Type C.) Default Field Properties D.) Calculated Fields

A union of two tables usually results in an _____________________. A.) increase in the number of rows B.) decrease in the number of rows C.) increase in the number of columns D.) decrease in the number of columns

A union of two tables usually results in an _____________________. A.) increase in the number of rows

Beginning in version 10.5, when you create a new extract, it uses the _________ format instead of the .tde format. A.) .hyper B.) .tdex C.) .tds D.) .twbx

Beginning in version 10.5, when you create a new extract, it uses the _________ format instead of the .tde format. A.) .hyper -------------------------------------------------------------- *Extracts in the .hyper format take advantage of the improved data engine, which supports the same fast analytical and query performance as the data engine before it, but for even larger extracts. *Benefits for using .hyper: 1.) Create larger extracts 2.) Create and refresh extracts faster 3.) Experience better performance when interacting with views that use extract data sources

How can you add color to marks in the view in Tableau? A.) From the Analytics pane, drag a model to Color on the Marks card B.) Click on Data in the main menu above, and click on choose color C.) From the Data pane, drag a field to Color on the Marks card D.) In the column/row shelf, right-click the field and click on edit in shelf to select the color

How can you add color to marks in the view in Tableau? C.) From the Data pane, drag a field to Color on the Marks card -------------------------------------------------------------- *If you drop a discrete field (a blue field), such as Category, on Color, the marks in the view are broken out by category, and each category is assigned a color. *If you drop a continuous field, such as SUM(sales), on Color, each mark in the view is colored based on its sales value.

If you are working with a huge dataset, which of the following are strong reasons to use a context filter? (Select all that apply) A.) To make the context filter a dependent filter B.) To include only the data of interest C.) To help clean the data D.) Improve query performance

If you are working with a huge dataset, which of the following are strong reasons to use a context filter? (Select all that apply) B.) To include only the data of interest D.) Improve query performance -------------------------------------------------------------- *By default, all filters that you set in Tableau are computed independently. *That is, each filter accesses all rows in your data source without regard to other filters. *However, you can set one or more categorical filters as context filters for the view. *You can think of a context filter as being an independent filter (Option stating - To create a dependent filter eliminated here). *Any other filters that you set are defined as dependent filters because they process only the data that passes through the context filter.

If you have a dashboard and are displaying its filter, how can you rearrange it? A.) By clicking on the 2 lines on top and dragging the filter B.) By clicking on the filter title and dragging it C.) By clicking anywhere inside the filter and dragging it D.) By clicking on the dropdown and dragging the filter

If you have a dashboard and are displaying its filter, how can you rearrange it? A.) By clicking on the 2 lines on top and dragging the filter

If you see a Blue field, generally it will add _____________ to the view. A.) Axes B.) Headers C.) Both D.) None

If you see a Blue field, generally it will add _____________ to the view. B.) Headers

In which of the following scenarios would having a live connection be more beneficial than using an extract? (Select all that apply) A.) Analyzing historical housing prices B.) Analyzing a subset of a dataset having 1 billion rows C.) Analyzing and tracking real time flight updates D.) Analyzing real time stock prices E.) Analyzing real time data from productions systems

In which of the following scenarios would having a live connection be more beneficial than using an extract? (Select all that apply) C.) Analyzing and tracking real time flight updates D.) Analyzing real time stock prices E.) Analyzing real time data from productions systems

Is it possible to make a Measure discrete? Yes No

Is it possible to make a Measure discrete? Yes

Suppose I have the following view: **Image of a 7-column bar chart w/ 1 Dimension in column shelf & 1 Measure in row shelf** What will be the total number of marks if I drag a new measure to the row shelf vs the column shelf? A.) If dragged to row shelf: 7 marks; if dragged to column shelf: 14 marks B.) If dragged to row shelf: 7 marks; if dragged to column shelf: 7 marks C.) If dragged to row shelf: 14 marks; if dragged to column shelf: 14 marks D.) If dragged to row shelf: 14 marks; if dragged to column shelf: 7 marks

Suppose I have the following view. What will be the total number of marks if I drag a new measure to the row shelf vs the column shelf? D.) If dragged to row shelf: 14 marks; if dragged to column shelf: 7 marks -------------------------------------------------------------- *Dragged to row shelf: We now have 2 rows, and the same 7 columns for both these rows. Therefore, 2x7 = 14 marks! *One graph on top of another* *Dragged to column shelf: But if we drag the same measure to the column shelf, we have just 1 row and a chart created for each of the columns. So (1x7) = 7 marks!

Suppose you have a bar chart. When we group by labels in a view, which of the following happens? A.) The colors of the members selected are now the same, and different for the rest of the members B.) Nothing changes in the view, but a group is created in the Dimensions shelf C.) A new mark (bar) is created, which consolidates all members of the group D.) It is not possible to group by labels

Suppose you have a bar chart. When we group by labels in a view, which of the following happens? C.) A new mark (bar) is created, which consolidates all members of the group -------------------------------------------------------------- *See Image...a new bar is then created, and the color of all bars remain the same *If we had grouped by choosing the marks instead of the labels, the color of those specific bars would be different, and a new mark (bar) would not be created

True or False: Physical tables remain distinct (normalized), not merged in the data source whereas logical tables are merged into a single, flat table.

True or False: Physical tables remain distinct (normalized), not merged in the data source whereas logical tables are merged into a single, flat table. False -------------------------------------------------------------- *Whenever you think of joins: Think that after the join is created, we get 1 single flat combined (joined) table. This flat combined table is created prior to us creating our visualizations. This happens at the physical layer. *If you ever think about relationships, know that all tables will remain distinct and separate, and relationships sit at the logical layer. *At run time, when you bring in the dimensions and measures to create your viz, Tableau very smartly creates the necessary joins, relates the tables and sends queries to these tables to get the resultant data back in the most meaningful way possible.

What do the colors Blue and Green represent in Tableau? A.) Blue = Dimensions & Green = Measures B.) Blue = Continuous & Green = Discrete C.) Blue = Measures & Green = Dimensions D.) Blue = Discrete & Green = Continuous

What do the colors Blue and Green represent in Tableau? D.) Blue = Discrete & Green = Continuous

When field names in the Union do not match, then: A.) An error is raised and both fields are dropped from the resulting Union B.) Only one field name is present in the Union with null values C.) Both field names are present in the Union, but contain several null values D.) Only one field name is present in the Union with correct values since Tableau automatically corrects field name mismatch

When field names in the Union do not match, then: C.) Both field names are present in the Union, but contain several null values -------------------------------------------------------------- *You can merge the non-matching fields into a single field using the merge option to remove the null values. *When you use the merge option, the original fields are replaced by a new field that displays the first non-null value for each row in the non-matching fields. *You can also create your own calculation or, if possible, modify the underlying data to combine the non-matching fields.

When is an axis created for the visualization in Tableau? A.) When we drag a dimension to the row/column shelf B.) When we drag a continuous field to the row/column shelf C.) When we drag a measure to the row/column shelf D.) When we drag a discrete field to the row/column shelf

When is an axis created for the visualization in Tableau? B.) When we drag a continuous field to the row/column shelf

When there are both negative and positive values for a field, the default range of values will use two color ranges. This is known as a ______________ palette. A.) Diverging B.) Converging C.) Reversed D.) Stepped

When there are both negative and positive values for a field, the default range of values will use two color ranges. This is known as a ______________ palette. A.) Diverging

Which of the following are benefits of combining sheets using dashboards? (Select all that apply) A.) Provides the ability to use one sheet as a filter for another B.) Easier to compare visualizations side by side C.) It is mandatory to combine sheets when using Tableau D.) Helps in faster analysis

Which of the following are benefits of combining sheets using dashboards? (Select all that apply) A.) Provides the ability to use one sheet as a filter for another B.) Easier to compare visualizations side by side D.) Helps in faster analysis

Which of the following are true about Dashboards in Tableau? (Select all that apply) A.) Floating items can be layered over other objects B.) Tiled items don't overlap C.) A bar chart can be used as a floating item D.) None of these

Which of the following are true about Dashboards in Tableau? (Select all that apply) A.) Floating items can be layered over other objects B.) Tiled items don't overlap C.) A bar chart can be used as a floating item

Which of the following are true about dimensions? (Select all that apply) A.) They affect the level of detail in the view B.) They contain numeric, quantitative values C.) Dates are mostly placed in dimensions by default for relational data sources D.) They contain qualitative values (such as names, dates, or geographical data)

Which of the following are true about dimensions? (Select all that apply) A.) They affect the level of detail in the view C.) Dates are mostly placed in dimensions by default for relational data sources D.) They contain qualitative values (such as names, dates, or geographical data) -------------------------------------------------------------- *MEASURES contain numeric, quantitative values

Which of the following are valid Layout Container types when using Dashboards in Tableau? (Select all that apply) A.) Split Container B.) Horizontal Container C.) Diagonal Container D.) Vertical Container

Which of the following are valid Layout Container types when using Dashboards in Tableau? (Select all that apply) B.) Horizontal Container D.) Vertical Container

Which of the following are valid reasons to use a Tableau Data Extract (.tde) over Live Connections? (Select all that apply) A.) To support additional functionality such as count distinct B.) To have access to the freshest possible data at all times C.) Help improve performance D.) Fast to create

Which of the following are valid reasons to use a Tableau Data Extract (.tde) over Live Connections? (Select all that apply) A.) To support additional functionality such as count distinct C.) Help improve performance D.) Fast to create

Which of the following are valid ways to export a dashboard with multiple visualizations as an image? A.) Click on Dashboard in the Menu bar followed by Copy Image B.) Right-click on the dashboard, and choose Copy, then Image C.) Click on Worksheet in the Menu bar followed by Export, then choose Image D.) Using the floating export worksheet option on the Dashboard

Which of the following are valid ways to export a dashboard with multiple visualizations as an image? A.) Click on Dashboard in the Menu bar followed by Copy Image -------------------------------------------------------------- * Answer B & C = Try doing this, you will end up copying just one of the worksheets not the entire dashboard *Answer D = does not exist

Which of the following are valid ways to italicize Tooltip content in Tableau? (Select all that apply) A.) Click on Worksheet in the Menu bar, select Tooltip, and then use the italics option B.) Click on Format in the Menu bar, choose Font, and then edit the Tooltip options to italicize the font C.) Click on Tooltip in the Marks card, select the text, and then use the italics option D.) Click on Dashboard in the Menu bar, select Tooltip, and then use the italics option

Which of the following are valid ways to italicize Tooltip content in Tableau? (Select all that apply) A.) Click on Worksheet in the Menu bar, select Tooltip, and then use the italics option B.) Click on Format in the Menu bar, choose Font, and then edit the Tooltip options to italicize the font C.) Click on Tooltip in the Marks card, select the text, and then use the italics option -------------------------------------------------------------- *Image = Answer D (incorrect)

Which of the following are valid ways to make either Rows or Columns Bold without affecting the other? (Select all that apply) A.) Choose Format then Font from the Menu bar, and select Bold under the Header option B.) Right-click on Rows or Columns, and choose format. In the Font option click on Bold C.) Choose Format from the Menu bar, select Row or Column, and then select Bold under the header option D.) Select Text Label on the Marks Card, choose Rows or Columns, and then select Bold

Which of the following are valid ways to make either Rows or Columns Bold without affecting the other? (Select all that apply) B.) Right-click on Rows or Columns, and choose format. In the Font option click on Bold C.) Choose Format from the Menu bar, select Row or Column, and then select Bold under the header option -------------------------------------------------------------- *Image = Answer B *Answer A = this modifies both rows and columns at the same time *Answer D = does not exist

Which of the following are valid ways to make the font more readable in Tableau? (Select all that apply) A.) Use a clear and readable font B.) Make the Font color sharper/darker than the background C.) Decrease the Font size D.) Don't use backgrounds E.) Increase the Font size

Which of the following are valid ways to make the font more readable in Tableau? (Select all that apply) A.) Use a clear and readable font B.) Make the Font color sharper/darker than the background E.) Increase the Font size

Which of the following calculations DO NOT need a quick table calculation? (Select all that apply) A.) Variance B.) Rank C.) Moving Average D.) Standard Deviation

Which of the following calculations DO NOT need a quick table calculation? (Select all that apply) A.) Variance D.) Standard Deviation -------------------------------------------------------------- * Options for Quick Table Calculations: 1.) Running total 2.) Difference 3.) Percent difference 4.) Percent of total 5.) Rank 6.) Percentile 7.) Moving average 8.) YTD total 9.) Compound growth rate 10.) Year of year growth 11.) YTD growth

Which of the following can you add a reference line to? (Select all that apply) A.) Calculated Fields B.) Measures C.) Dimensions D.) Groups

Which of the following can you add a reference line to? (Select all that apply) A.) Calculated Fields B.) Measures -------------------------------------------------------------- *You can add reference lines, bands, distributions, or (in Tableau Desktop but not on the web) box plots to any continuous axis in the view. *You can add a reference line at a constant or computed value on the axis. *Computed values can be based on a specified field. *You can also include confidence intervals with a reference line.

Which of the following describes the best way to change the formatting at a workbook level? A.) Choose Format from the menu on top and then specify the formatting in the new Format workbook pane B.) Click on Text in the Marks card, choose Format, and then specify the formatting in the new Format workbook pane C.) It is only possible to specify formatting at a worksheet level, not at the workbook level D.) Right-click anywhere in the view, choose Format, and then specify the formatting in the new Format workbook pane

Which of the following describes the best way to change the formatting at a workbook level? A.) Choose Format from the menu on top and then specify the formatting in the new Format workbook pane -------------------------------------------------------------- *You can quickly change how fonts, titles, and lines look in every view in a workbook by specifying format settings at the workbook level, instead of the worksheet level. *For example, you might want to use a specific font, size, and color so that all views adhere to your company's brand. *Note: If you have made font changes at the worksheet level, such as on a filter card or a worksheet title, changing the font at the WORKBOOK level will overwrite those changes.

Which of the following is a benefit of using a Tableau Data Source (.tds)? A.) To create a local copy of a subset or entire data set that you can use to share data with others, when you need to work offline, and improve performance. B.) To hold one or more worksheets, plus zero or more dashboards and stories. C.) To 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, etc. D.) To create a single zip file that contains a workbook along with any supporting local file data and background images. This is great for sharing your work with others who don't have access to the original data.

Which of the following is a benefit of using a Tableau Data Source (.tds)? C.) To 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, etc. -------------------------------------------------------------- *Answer A = Extract (.hyper or .tde) *Answer B = Workbooks (.twb) *Answer D = Tableau Packaged Workbook (.twbx)

Which of the following is a compelling reason to export a sheet in Tableau to a PDF? A.) If we want a static view of the visualization B.) If we want to use filters in the visualization C.) If we want to interact with the visualization D.) If we want to dynamically enter parameters to the visualization

Which of the following is a compelling reason to export a sheet in Tableau to a PDF? A.) If we want a static view of the visualization -------------------------------------------------------------- *It is NOT possible to interact with it, use filters, or dynamically enter anything in a visualization exported PDF. *In Tableau Desktop, you can save views as PDF files rather than printing them as hard copies. *When you print an individual sheet to PDF, filters in the view are not included. *To show filters, create a dashboard containing the sheet and export the dashboard to PDF.

Which of the following lets you group related dashboard items together so you can quickly position them? A.) Layout Extensions B.) Layout Containers C.) Layout Blanks D.) Layout Positioners

Which of the following lets you group related dashboard items together so you can quickly position them? B.) Layout Containers -------------------------------------------------------------- *As you change the size and placement of items inside a container, other container items automatically adjust.

Which of the following options best describe measures? A.) They are categorical, qualitative B.) They are categorical, quantitative C.) They are numerical, qualitative D.) They are numerical, quantitative

Which of the following options best describe measures? D.) They are numerical, quantitative -------------------------------------------------------------- *Measures contain numeric, quantitative values that you can "measure". *Measures can be aggregated. When you drag a measure into the view, Tableau applies an aggregation to that measure (by default).

Which of the following sets would you use to compare the members of two separate sets? A.) Combined Sets B.) Static Sets C.) Dynamic Sets D.) None of these

Which of the following sets would you use to compare the members? A.) Combined Sets -------------------------------------------------------------- *When you combine sets, you create a new set containing either the combination of all members, just the members that exist in both, or members that exist in one set but not the other. *Combining sets allows you to answer complex questions and compare cohorts of your data. *To combine two sets, they must be based on the same dimensions. That is, you can combine a set containing the top customers with another set containing the customers that purchased last year. However, you cannot combine the top customers set with a top products set.

While borders and background colors let you visually highlight items on a dashboard, _________ lets you precisely space items. A.) Margining B.) Tiling C.) Spacing D.) Padding

While borders and background colors let you visually highlight items on a dashboard, _________ lets you precisely space items. D.) Padding -------------------------------------------------------------- *Inner padding sets the spacing between item contents and the perimeter of the border and background color *Outer padding provides additional spacing beyond the border and background color

How can you change the Default Aggregation for a measure in Tableau? A.) By changing its properties manually every time we need to use it B.) By right clicking the dimension => Default properties and choosing Aggregation C.) By double clicking on the measure, and then choosing Window => Default Aggregation D.) By right clicking the measure => Default properties and choosing Aggregation

How can you change the Default Aggregation for a measure in Tableau? D.) By right clicking the measure => Default properties and choosing Aggregation

The default path for all supporting files, data sources, icons, logs etc is in ______________________. A.) Documents ==> Tableau Files B.) Downloads ==> Tableau Support Files C.) Documents ==> Tableau D.) Documents ==> My Tableau Repository

The default path for all supporting files, data sources, icons, logs etc is in ______________________. D.) Documents ==> My Tableau Repository

The number of marks will increase when you increase the number of Dimensions in a view. Yes No

The number of marks will increase when you increase the number of Dimensions in a view. Yes

Which of the following are valid Dashboard size options? (Select all that apply) A.) Fixed Size B.) Scaled C.) Range D.) Automatic

Which of the following are valid Dashboard size options? (Select all that apply) A.) Fixed Size C.) Range D.) Automatic

*Not A Question; Just Important Information* -Dates in Tableau will behave differently depending on whether they are a Datepart (blue) or a Datevalue (green). -This affects how the axes display/behave and also how visualisations such as line charts will display. -The difference essentially boils down to Dateparts behaving like a dimension as opposed to a measure which is how Datevalues behave. -This means that Dateparts behave like discrete categories on the view whereas Datevalues are more like continuous numeric values.

-If Datepart months are placed on filters January to December will be tick-able options in the filter. This also means that conditions and top/bottom filters can be applied to datepart filters like any other dimension filter. -Datevalues placed on filters behave like measure filters. A min and a max date can be set and there is a relative dates option which allows you to choose things like only show the previous 3 months or years etc.

A _____________ action is a hyperlink that points to a web page, file, or other web-based resource outside of Tableau. A.) Go to URL B.) Go to Hyperlink C.) Go to Web page D.) Go to Sheet

A _____________ action is a hyperlink that points to a web page, file, or other web-based resource outside of Tableau. A.) Go to URL

A ________________ is a single zip file that contains a workbook along with any supporting local file data and background images. This format is the best way to package your work for sharing with others who don't have access to the original data. A.) .tde file B.) .twbx file C.) .tbm file D.) .twb file

A ________________ is a single zip file that contains a workbook along with any supporting local file data and background images. This format is the best way to package your work for sharing with others who don't have access to the original data. B.) .twbx file -------------------------------------------------------------- *Tableau packaged workbooks have the .twbx file extension. *This format is the best way to package your work for sharing with others who don't have access to the original data.

According to Tableau's 'Order of Operations', which of the following filters is applied FIRST? A.) Extract Filter B.) Dimension Filter C.) Context Filter D.) Measure Filter

According to Tableau's 'Order of Operations', which of the following filters is applied FIRST? A.) Extract Filter

Are animations enabled by default in Tableau? Yes No

Are animations enabled by default in Tableau? No -------------------------------------------------------------- *We can animate visualizations to better highlight changing patterns in your data, reveal spikes and outliers, and see how data points cluster and separate. *Animations visually transition between filter, sort, and zoom settings, different pages, and changes to filter, parameter, and set actions. As visualizations animate in response to these changes, viewers can more clearly see how data differs, helping them make better informed decisions.

As a general best practice, how many categories can a pie chart display effectively? A.) 2 to 8 B.) 3 to 5 C.) 2 to 5 D.) 3 to 7

As a general best practice, how many categories can a pie chart display effectively? C.) 2 to 5

Broadly speaking, after importing a dataset in Tableau Desktop, all fields in it are broken down into _______________________. A.) Labels and Values B.) Numbers and Headers C.) Rows and Columns D.) Dimensions and Measures

Broadly speaking, after importing a dataset in Tableau Desktop, all fields in it are broken down into _______________________. D.) Dimensions and Measures

Broadly speaking, when users connect to Tableau, the data fields in their data set are automatically assigned a ____________ and a ____________. A.) ID, Key B.) Data Type, Value C.) Dimension, Measure D.) Type, Role

Broadly speaking, when users connect to Tableau, the data fields in their data set are automatically assigned a ____________ and a ____________. D.) Type, Role -------------------------------------------------------------- *Roles: 1) Dimension 2) Measure *Types: 1) String 2) Number 3) Geographic 4) Boolean 5) Date 6) Date and Time

By default, measures placed in a view are aggregated. The type of aggregation applied ______________ A.) is always AVERAGE B.) is always SUM C.) is always COUNT D.) depends on the context of the view

By default, measures placed in a view are aggregated. The type of aggregation applied ______________ D.) depends on the context of the view -------------------------------------------------------------- *By default, measures placed in a view are aggregated. Mostly you'll notice that the aggregation is SUM, but not ALWAYS.

By default, what does Tableau do when you connect to a data source? A.) Creates a live connection to the data B.) Loads your actual file into Tableau C.) Creates an extract of the data D.) Sorts the data in descending order

By default, what does Tableau do when you connect to a data source? A.) Creates a live connection to the data -------------------------------------------------------------- *Before you can build a view and analyze your data, you must first connect Tableau to your data. *Live connection refers to a data source that contains direct connection to underlying data, which provides real-time or near real-time data. *With a live connection, Tableau makes queries directly against the database or other source and returns the results of the query for use in a workbook.

By definition, Tableau displays measures over time as a ____________. A.) Packed Bubble B.) Line C.) Stacked Bar D.) Bar

By definition, Tableau displays measures over time as a ____________. B.) Line -------------------------------------------------------------- *Line charts connect individual data points in a view. *They provide a simple way to visualize a sequence of values and are useful when you want to see trends over time, or to forecast future values.

Data blending simulates a traditional _________________ Join. A.) Inner B.) Full Outer C.) Right D.) Left

Data blending simulates a traditional _________________ Join. D.) Left -------------------------------------------------------------- *The main difference between the two is when the aggregation is performed. *A join combines the data and then aggregates. *A blend aggregates and then combines the data. * An asterisk (*) in a view with blended data indicates multiple values. This can be resolved by ensuring there is only one matching value in the secondary data source for each mark in the primary data source, potentially by swapping the primary and secondary data sources.

Dimensions containing ____________ and ____________ values cannot be continuous. (Select all that apply) A.) Date B.) Boolean C.) String D.) Date and Time

Dimensions containing ____________ and ____________ values cannot be continuous. (Select all that apply) B.) Boolean C.) String

Dragging a ______________ to color creates distinct colors for each item whereas dragging a ______________ to color creates a gradient. A.) Discrete Value, Continuous Value B.) Continuous Value, Discrete Value C.) Longitude, Latitude D.) Geographic Value, Discrete Value

Dragging a ______________ to color creates distinct colors for each item whereas dragging a ______________ to color creates a gradient. A.) Discrete Value, Continuous Value

For Bullet Graphs, we need at least ____________ measures. A.) 1 B.) 2 C.) 3 D.) 4

For Bullet Graphs, we need at least ____________ measures. B.) 2 -------------------------------------------------------------- *A bullet graph is a variation of a bar graph developed to replace dashboard gauges and meters. *A bullet graph is useful for comparing the performance of a primary measure to one or more other measures.

For a ____________ sort, no matter how the data changes, the values will always stay in the sort order we kept stuff in. A.) Hierarchical B.) Topological C.) Random D.) Manual

For a ____________ sort, no matter how the data changes, the values will always stay in the sort order we kept stuff in. D.) Manual

For which of the following charts, does the Size option on the Marks card not work? A.) Gantt Chart B.) Bar Chart C.) Tree Map D.) Pie Chart

For which of the following charts, does the Size option on the Marks card not work? C.) Tree Map -------------------------------------------------------------- *In a Tree Map, the measure itself defines the size and colour! The greater the sum of Measure for each category, the darker and larger its box. *You use dimensions to define the structure of the treemap, and measures to define the size or color of the individual rectangles.

How can you change the default Tableau repository location? A.) By clicking on Help => Change Repository Location B.) By clicking on File => Repository Location and choosing a new location C.) By clicking on Window => Repository Location D.) By Moving the repository location manually to wherever we want

How can you change the default Tableau repository location? B.) By clicking on File => Repository Location and choosing a new location

How can you format an axis as Bold in Tableau? A.) By clicking on Format on the main menu bar, choosing Field Labels, and setting it to bold. B.) By right clicking on the axis, choosing Edit Axis, and then setting its Font to bold C.) By choosing the axis and selecting Command/Control + B on your keyboard D.) By right clicking on the axis, choosing Format, and then setting its Font to bold

How can you format an axis as Bold in Tableau? D.) By right clicking on the axis, choosing Format, and then setting its Font to bold

How can you format numbers in Tableau as currency? A.) Right-click on the Sheet name and select Format. Then in the Format pane, click the Numbers drop-down menu. B.) Right-click on the data source used in the view and select Format. Then in the Format pane, click the Numbers drop-down menu. C.) Right-click a measure or axis in the view and select Format. then in the format pane, click the Numbers drop-down menu. D.) Right-click a dimension in the view and select Format. Then in the Format pane, click the Numbers drop-down menu.

How can you format numbers in Tableau as currency? C.) Right-click a measure or axis in the view and select Format. Then in the format pane, click the Numbers drop-down menu.

How does Tableau know at which level to aggregate values? A.) Aggregation is always done by using Tableau special formulas B.) Values are always aggregated at the level of the Date Part C.) Values are always aggregated at the level of granularity of the worksheet D.) Tableau doesn't aggregate values, we do!

How does Tableau know at which level to aggregate values? C.) Values are always aggregated at the level of granularity of the worksheet -------------------------------------------------------------- *In Tableau, you can aggregate measures or dimensions, though it is more common to aggregate measures. *Whenever you add a measure to your view, an aggregation is applied to that measure by default. *The type of aggregation applied varies depending on the context of the view.

How would you calculate GDP per capita in Tableau? A.) SUM([Population] / [GDP]) B.) SUM([GDP] / [Population]) C.) SUM([GDP]) / SUM([Population]) D.) SUM([GDP] * [Population])

How would you calculate GDP per capita in Tableau? C.) SUM([GDP]) / SUM([Population]) -------------------------------------------------------------- *GDP / Population = GDP Per Capita

If you decide you want to see all of the marks in the view at the most detailed level of granularity, you can __________________ the view. A.) aggregate the measures B.) sort the measures C.) disaggregate the measures D.) break-down the measures E.) split the measures

If you decide you want to see all of the marks in the view at the most detailed level of granularity, you can __________________ the view. C.) disaggregate the measures -------------------------------------------------------------- *The different aggregations available for a measure determine how the individual values are collected: they can be added (SUM), averaged (AVG), or set to the maximum (MAX) or minimum (MIN) value from the individual row values. *Disaggregating your data can be useful for analyzing measures that you may want to use both independently and dependently in the view.

If you use a percent difference Quick Table Calculation, what value will be the first data value? A.) -1 B.) 0 C.) null D.) 0000

If you use a percent difference Quick Table Calculation, what value will be the first data value? C.) null -------------------------------------------------------------- *When using a Percent difference, Tableau calculates what the percent change has occurred as compared to the last data value. *BUT, for the first data value, there is no previous value to compare it to. Hence, it appears as NULL.

In Tree maps, the size begins with the largest rectangle on the ________________ and the smallest rectangle on the ________________. A.) Top Left, Bottom Right B.) Top Left, Bottom Left C.) Top Right, Bottom Left D.) Top Right, Bottom Right

In Tree maps, the size begins with the largest rectangle on the ________________ and the smallest rectangle on the ________________. A.) Top Left, Bottom Right

In order to avoid any confusions, what should you do after creating a Dual-axis chart? A.) Hide the axis B.) Edit the labels C.) Change the colors D.) Synchronize the axis

In order to avoid any confusions, what should you do after creating a Dual-axis chart? D.) Synchronize the axis -------------------------------------------------------------- *To align the two axes in a dual axes chart to use the same scale, right-click the secondary axis, and select Synchronize Axis. This aligns the scale of the secondary axis to the scale of the primary axis.

Is SUM a table calculation? Yes No

Is SUM a table calculation? No -------------------------------------------------------------- *SUM is an aggregate function, not a table calculation! *A table calculation is a transformation you apply to the values in a visualization. *Table calculations are a special type of calculated field that computes on the local data in Tableau. They are calculated based on what is currently in the visualization and do not consider any measures or dimensions that are filtered out of the visualization.

Is it possible to add both a Dashboard and a Worksheet at the same time to a Story Point in Tableau? Yes No

Is it possible to add both a Dashboard and a Worksheet at the same time to a Story Point in Tableau? No -------------------------------------------------------------- *We are talking about story POINTS, and not entire stories in the question. *To create a story, let's say I have a blank story with 1 dashboard and 1 worksheet. *I can simply drag the dashboard into the view to create a new story point. *Now, if I try to adjust the worksheet beside it in this same view, I cannot. (See image) *The only option available is to replace the existing view.

Is it possible to use measures in the same view multiple times (e.g. SUM of the measure and AVG of the measure)? Yes No

Is it possible to use measures in the same view multiple times (e.g. SUM of the measure and AVG of the measure)? Yes

Most viewers scan content starting at the _____________ of a page. A.) Top Right B.) Center C.) Top Left D.) Bottom Right E.) Bottom Left

Most viewers scan content starting at the _____________ of a page. C.) Top Left

Our use case states that we need to create a set showing the Bottom 10 products by Profit in each Region. Which of the following filter types should you apply on Region? A.) Measure Filters B.) Context Filters C.) Dimension Filters D.) Extract Filters

Our use case states that we need to create a set showing the Bottom 10 products by Profit in each Region. Which of the following filter types should you apply on Region? B.) Context Filters -------------------------------------------------------------- *According to Tableau's Order of Operations, they are executed before Sets. *This means that based on what Region's you've selected - Tableau will first only preserve the rows for those Regions. THEN, after this it will compute the Set, i.e , Bottom 10 products in each Region.

Relationships are represented by __________________ and operate at the ____________________. A.) noodles, physical layer B.) Venn diagrams, logical layer C.) noodles, logical layer D.) Venn diagrams, physical layer

Relationships are represented by __________________ and operate at the ____________________. C.) noodles, logical layer -------------------------------------------------------------- *The default view that you first see in the Data Source page canvas is the logical layer of the data source. *You combine data in the logical layer using relationships (or noodles).

Suppose you create a bar chart by dragging a dimension to the Column shelf and a measure to the Rows shelf. Which of the following would create a stacked bar chart? A.) By dragging another dimension to Color on the Marks card B.) By dragging another measure to the Columns shelf C.) By dragging another dimension to the Rows shelf D.) By dragging another measure to Color on the Marks card

Suppose you create a bar chart by dragging a dimension to the Column shelf and a measure to the Rows shelf. Which of the following would create a stacked bar chart? A.) By dragging another dimension to Color on the Marks card

Tableau auto-generates ____________ dimension(s) and _____________ measure(s) for us A.) 1, 4 B.) 2, 2 C.) 2, 3 D.) 1, 2

Tableau auto-generates ____________ dimension(s) and _____________ measure(s) for us A.) 1, 4 -------------------------------------------------------------- *1 Dimension - Measure Names *4 Measures - Latitude, Longitude, Number of records, Measure Values

The View Data window displays as much of the data as possible by default, up to _______________ rows. A.) 10,000 B.) 5,000 C.) 15,000 D.) 20,000

The View Data window displays as much of the data as possible by default, up to _______________ rows. A.) 10,000

To connect Tableau to a CSV data source what type of connection should you use? A.) Excel B.) Text C.) Spatial D.) JSON

To connect Tableau to a CSV data source what type of connection should you use? B.) Text -------------------------------------------------------------- *Tableau recognizes a CSV file as a TEXT file.

True or False: All rows from both tables are returned in an INNER JOIN

True or False: All rows from both tables are returned in an INNER JOIN False -------------------------------------------------------------- *The INNER JOIN keyword selects all rows from both tables as long as there is a match between the columns.

True or False: Bins can be created on dimensions.

True or False: Bins can be created on dimensions. True -------------------------------------------------------------- *Bins are a user-defined grouping of numerical data in the data source, regardless if they are a dimension or measure. *It's sometimes useful to convert a continuous measure (or a numeric dimension) into bins.

True or False: It is not possible to blend axes for multiple measures into a single axis.

True or False: It is not possible to blend axes for multiple measures into a single axis. False -------------------------------------------------------------- *It is possible. Such charts are called Combined-Axis / Blended-Axis charts. *Measures can share a single axis so that all the marks are shown in a single pane. To blend multiple measures, drag one measure or axis and drop it onto an existing axis. *Instead of adding rows and columns to the view, when you blend measures there is a single row or column and all of the values for each measure is shown along one continuous axis.

True or False: It is possible to add a field to more than one hierarchy.

True or False: It is possible to add a field to more than one hierarchy. True -------------------------------------------------------------- *Yes! It is possible to duplicate a field and add it to more than one hierarchy. Right click and choose duplicate.

True or False: The Highlighting action can be disabled for the entire workbook.

True or False: The Highlighting action can be disabled for the entire workbook. True

True or False: Trend lines can only be used with numeric or date fields.

True or False: Trend lines can only be used with numeric or date fields. True -------------------------------------------------------------- *You can show trend lines in a visualization to highlight trends in your data. *To add trend lines to a view, both axes must contain a field that can be interpreted as a number. For example, you cannot add a trend line to a view that has the Product Category dimension, which contains strings, on the Columns shelf and the Profit measure on the Rows shelf. *However, you can add a trend line to a view of sales over time because both sales and time can be interpreted as numeric values.

True or False: We get different color palette options if we drop a discrete field on "Color" in the marks card compared to if we drop a continuous field on Color.

True or False: We get different color palette options if we drop a discrete field on "Color" in the marks card compared to if we drop a continuous field on Color. True -------------------------------------------------------------- *Categorical/Discrete Values = color for each value in the field *Quantitative/Continuous Values = continuous range of colors

True or False: You get different filtering options for categorical and quantitative data.

True or False: You get different filtering options for categorical and quantitative data. True -------------------------------------------------------------- *Categorical Data: (see image) * Quantitative Data: Sum, Average, Median, Count, Count (Distinct), Minimum, Maximum, Standard Deviation, Standard Deviation (Population), Variance, Variance (Population)

We can join a maximum of ______ tables in Tableau. A.) 32 B.) 128 C.) 16 D.) 64

We can join a maximum of ______ tables in Tableau. A.) 32

What does the following marker/icon do in Tableau? **Image of 'highlighter' icon in Container which is used as a legend to assign labels to different colors** A.) Edit the colors B.) Highlight the largest value C.) Toggle the highlighting on/off D.) Format the legend

What does the following marker/icon do in Tableau? C.) Toggle the highlighting on/off -------------------------------------------------------------- *If selected, whichever value you choose from this legend will be highlighted in the view. *However, if it is deselected, then even if you choose a value in the Legend, it will NOT be highlighted.

What does the icon at the bottom of the view that looks like "3 squares & a plus sign" do in Tableau? A.) Create a Story and Dashboard both B.) Create a Story C.) Create a Worksheet D.) Create a Dashboard

What does the icon at the bottom of the view that looks like "3 squares & a plus sign" do in Tableau? D.) Create a Dashboard

What is a story point in Tableau? A.) A collection of both worksheets and dashboards B.) A single worksheet or dashboard C.) A collection of dashboards D.) A collection of worksheets

What is a story point in Tableau? B.) A single worksheet or dashboard -------------------------------------------------------------- *A story is a sequence of visualizations that work together to convey information. You can create stories to tell a data narrative, provide context, demonstrate how decisions relate to outcomes, or to simply make a compelling case. A story is a sheet, so the methods you use to create, name, and manage worksheets and dashboards also apply to stories. At the same time, a story is also a collection of sheets, arranged in a sequence. Each individual sheet (worksheet or dashboard) in a story is called a story point.

What is the icon that looks like "a small data table" in the Data pane used to do? A.) Sort Data B.) Extract Data C.) Clean Data D.) View Data

What is the icon that looks like "a small data table" in the Data pane used to do? D.) View Data -------------------------------------------------------------- *View Data allows you to inspect your data in a spreadsheet-like layout. *You can view data either for the data source as a whole, or to see the underlying data for an individual mark or a group of marks. *In a worksheet, the rows that you see in the View Data window are always scoped to the current selection or the current view.

What is the one critical difference between normal calculated fields, and the calculated fields created after Data blending? A.) The calculated fields in Blends cannot use more than 2 fields B.) The calculated fields in Blends cannot be edited once created C.) Fields used in Blends must first be aggregated D.) No difference, calculated fields cannot be created in Blends

What is the one critical difference between normal calculated fields, and the calculated fields created after Data blending? C.) Fields used in Blends must first be aggregated -------------------------------------------------------------- *sum([Sales]) / SUM([Sales Targets] . [Sales Target]) *SUM([Sample - Superstore] . [Sales]) / sum([Sales Target]) *In addition to handling calculations slightly differently, there are some limitations on secondary data sources. *You may not be able to sort by a field from a secondary data source, and action filters may not work as expected with blended data.

When creating a dashboard for multiple devices, which of the following Device options are available in the Device Preview section? A.) Phone, Tablet, Laptop, Desktop B.) Monitor, Default, Phone, Tablet C.) Default, Phone, Tablet, Desktop D.) Phone, Monitor, Laptop, Default

When creating a dashboard for multiple devices, which of the following Device options are available in the Device Preview section? C.) Default, Phone, Tablet, Desktop

When exporting a worksheet as an image in Tableau, which of the following file formats are available? (Select all that apply) A.) JPEG Image (.JPG, .JPEG) B.) Windows Bitmap (.BMP) C.) Portable Network Graphic (.PNG) D.) Tagged Image File Format (TIFF)

When exporting a worksheet as an image in Tableau, which of the following file formats are available? (Select all that apply) A.) JPEG Image (.JPG, .JPEG) B.) Windows Bitmap (.BMP) C.) Portable Network Graphic (.PNG)

When using Animations in a Tableau, which of the following is the default duration for animations? A.) 0.5s B.) 0.3s C.) 0.2s D.) 0.4s

When using Animations in a Tableau, which of the following is the default duration for animations? B.) 0.3s -------------------------------------------------------------- *Animations are disabled by default and must be manually enabled.

When using the manage metadata option, we can create custom names for columns where _____________ is the original name of the column whereas _____________ is the custom name we created in Tableau. A.) Local Field, Global Field B.) Local Name, Actual Name C.) Column Name, Actual Name D.) Remote Field Name, Field Name

When using the manage metadata option, we can create custom names for columns where _____________ is the original name of the column whereas _____________ is the custom name we created in Tableau. D.) Remote Field Name, Field Name -------------------------------------------------------------- *We can rename a particular column name to make it easier to remember and use in Tableau. * (See image)...Now, we'll see oID when using this data source in Tableau. This WILL NOT affect the original data source. The remote field name lets us see what the name of the column is in the ORIGINAL Data source.

When you drop a continuous field on Color, Tableau displays a quantitative legend with a ___________ range of colors. A.) Continuous B.) Mixed C.) Discrete D.) Fading

When you drop a continuous field on Color, Tableau displays a quantitative legend with a ___________ range of colors. A.) Continuous -------------------------------------------------------------- *When you drop a discrete field on Color in the Marks card, Tableau displays a categorical palette and assigns a color to each value of the field. *When you drop a continuous field on Color, Tableau displays a quantitative legend with a continuous range of colors.

When you want to first apply a filter and THEN show the Top N or Bottom N elements, which of the following filters would you use? (...when you are already working on a sheet) A.) Data Source Filter B.) Context Filter C.) Extract Filter D.) None of these

When you want to first apply a filter and THEN show the Top N or Bottom N elements, which of the following filters would you use? B.) Context Filter -------------------------------------------------------------- *By default, all filters that you set in Tableau are computed independently. That is, each filter accesses all rows in your data source without regard to other filters. *However, you can set one or more categorical filters as context filters for the view. You can think of a context filter as being an independent filter. Any other filters that you set are defined as dependent filters because they process only the data that passes through the context filter.

Which of the following URL prefixes are permitted when creating a URL Action in Tableau? (Select all that apply) A.) FTP B.) HTTP C.) SMTP D.) HTTPS

Which of the following URL prefixes are permitted when creating a URL Action in Tableau? (Select all that apply) A.) FTP B.) HTTP D.) HTTPS -------------------------------------------------------------- *A URL action is a hyperlink that points to a web page, file, or other web-based resource outside of Tableau. *To customize links based on your data, you can automatically enter field values as parameters in URLs.

Which of the following are benefits of using Data Extracts in Tableau? (Select all that apply) A.) Working with freshest data at all times B.) Ability to use the data offline C.) Faster to work with D.) Improved performance

Which of the following are benefits of using Data Extracts in Tableau? (Select all that apply) B.) Ability to use the data offline C.) Faster to work with D.) Improved performance -------------------------------------------------------------- *Extracts support large data sets *Extracts are fast to create *Extracts help improve performance *Extracts support additional functionality *Extracts provide offline access to your data *Live Connections allow you to work the most up-to-date data

Which of the following are compelling reasons to use a Stacked Bar Chart? (Select all that apply) A.) To visualize each discrete category using a separate bar B.) To easily visualize trends over time C.) To be able to visualize complex information with fewer bars/marks D.) To visualize parts of a whole

Which of the following are compelling reasons to use a Stacked Bar Chart? (Select all that apply) C.) To be able to visualize complex information with fewer bars/marks D.) To visualize parts of a whole -------------------------------------------------------------- *Stacked bar charts will usually have lesser number of bars compared to a normal bar chart. *We can easily see a 'part-of-a-whole' methodology being used here as well; we are seeing the breakdown of Segments within each Category. *A.) To visualize each discrete category using a separate bar - this can be accomplished using a simple bar chart *B.) To easily visualize trends over time - this is the definition of a line chart

Which of the following are correct ways to define a join in Tableau version 2020.3 and above? (Select all that apply) A.) Double-click a physical table to go to the Join/Union canvas in the logical layer and add joins or unions. B.) Right-click a logical table and click on open to go to the Join/Union canvas in the physical layer and add joins or unions. C.) Double-click a logical table to go to the Jon/Union canvas in the physical layer and add joins or unions. D.) Right-click a physical table and click on open to go to the Join/Union canvas in the logical layer and add joins or unions

Which of the following are correct ways to define a join in Tableau version 2020.3 and above? (Select all that apply) B.) Right-click a logical table and click on open to go to the Join/Union canvas in the physical layer and add joins or unions. C.) Double-click a logical table to go to the Jon/Union canvas in the physical layer and add joins or unions. -------------------------------------------------------------- *Remember that joins are defined in the physical layer and relationships in the logical layer. *The top-level layer is the logical layer of the data source. You combine data between tables in the logical layer using relationships. *The next layer is the physical layer of the data source. You combine data between tables at the physical layer using joins.

Which of the following are stored in a .tds file? (Select all that apply) A.) Data Connection Information B.) Visualizations C.) Metadata Edits D.) Calculated Fields E.) Data Extracts

Which of the following are stored in a .tds file? (Select all that apply) A.) Data Connection Information C.) Metadata Edits D.) Calculated Fields -------------------------------------------------------------- *If you've created a data connection that you might want to use with other workbooks or share with colleagues, you can export (save) the data source to a file. * You might want to do this also if you've added joined tables, default properties, or custom fields—such as groups, sets, calculated fields, and binned fields—to the Data pane.

Which of the following are valid objects when creating a dashboard in Tableau? (Select all that apply) A.) Text B.) Extension C.) Web Page D.) Image E.) Video

Which of the following are valid objects when creating a dashboard in Tableau? (Select all that apply) A.) Text B.) Extension C.) Web Page D.) Image

Which of the following are valid ways of Grouping Data? (Select all that apply) A.) Using Labels in the View B.) From the Dimensions Shelf C.) Using Marks in the view D.) From the Analytics Pane

Which of the following are valid ways of Grouping Data? (Select all that apply) A.) Using Labels in the View B.) From the Dimensions Shelf C.) Using Marks in the view

Which of the following are valid ways to Bold the Tooltip content in Tableau? (Select all that apply) A.) Click on Worksheet in the Menu bar, followed by Tooltip and select the bold option B.) Click on Analysis, Tooltip options, and select bold C.) Right-click somewhere on the view, click Format and then under the default worksheet formatting, choose Tooltip and make it bold D.) Click on Tooltip in the Marks card, and select bold

Which of the following are valid ways to Bold the Tooltip content in Tableau? (Select all that apply) A.) Click on Worksheet in the Menu bar, followed by Tooltip and select the bold option C.) Right-click somewhere on the view, click Format and then under the default worksheet formatting, choose Tooltip and make it bold D.) Click on Tooltip in the Marks card, and select bold -------------------------------------------------------------- *Image = Part of Answer C

Which of the following are valid ways to add Totals to a view? (Select all that apply) A.) Using the Analytics Pane B.) Using the Marks shelf C.) From the Analysis Tab in the Menu bar on top D.) Using the Data Pane

Which of the following are valid ways to add Totals to a view? (Select all that apply) A.) Using the Analytics Pane C.) From the Analysis Tab in the Menu bar on top

Which of the following are valid ways to copy a worksheet visualization as an image? (Select all that apply) A.) Using the Marks shelf and choosing Copy => Image B.) By right clicking on the worksheet visualization and selecting Copy => Image C.) By clicking on Worksheet in the Tableau Main Menu above, and choosing Copy => Image D.) By simply clicking Control + V on the keyboard

Which of the following are valid ways to copy a worksheet visualization as an image? (Select all that apply) B.) By right clicking on the worksheet visualization and selecting Copy => Image C.) By clicking on Worksheet in the Tableau Main Menu above, and choosing Copy => Image

Which of the following are valid ways to show Mark Labels in the visualization? (Select all that apply) A.) Click on the Show Mark Labels icon in the Toolbar B.) Click on Analysis in the Menu bar and choose Show Mark Labels C.) Drag the measure to the Text label in the Marks Card D.) Click on Data in the Menu bar and choose Show Mark Labels

Which of the following are valid ways to show Mark Labels in the visualization? (Select all that apply) A.) Click on the Show Mark Labels icon in the Toolbar B.) Click on Analysis in the Menu bar and choose Show Mark Labels C.) Drag the measure to the Text label in the Marks Card

Which of the following can help us focus on specific data without removing data in the visualization? A.) Highlighters B.) Sets C.) Filters D.) Clusters

Which of the following can help us focus on specific data without removing data in the visualization? A.) Highlighters -------------------------------------------------------------- *When you have a view with a large amount of data you might want to explore your data interactively and highlight a specific mark or group of marks while still maintaining the context of where those marks show in your view. *To do this you can turn on the Highlighter for one or more discrete fields that are included in your view and that affect the level of detail.

Which of the following can you use to create a Histogram? A.) 2 Measures B.) 1 Measure C.) 2 Dimensions D.) 1 Dimension

Which of the following can you use to create a Histogram? B.) 1 Measure

Which of the following chart type makes use of 'binned' data? A.) Histogram B.) Gantt Chart C.) Bullet Chart D.) Tree Maps

Which of the following chart type makes use of 'binned' data? A.) Histogram -------------------------------------------------------------- *A histogram is a chart that displays the shape of a distribution. A histogram looks like a bar chart but groups values for a continuous measure into ranges, or bins.

Which of the following fields would be best used as Dimensions? (Select all that apply) A.) Categories B.) Profit C.) Sales D.) Names

Which of the following fields would be best used as Dimensions? (Select all that apply) A.) Categories D.) Names -------------------------------------------------------------- *Names and Categories would be mostly used as dimensions (categorical data). *Profit and measures contain quantitative data and would be more suitable for Measures!

Which of the following is NOT a valid official data source in Tableau Desktop? A.) Google Firebase B.) Amazon Redshift C.) SAP HANA D.) PostgreSQL

Which of the following is NOT a valid official data source in Tableau Desktop? A.) Google Firebase

Which of the following is a valid way to create Sets in Tableau? A.) In the Data pane, right-click a measure and select Create => Set. B.) In the Tableau Main Menu, choose Dashboard and select Create => Set. C.) In the Data pane, right-click a dimension and select Create => Set. D.) In the Tableau Main Menu, choose Worksheet and select Create => Set.

Which of the following is a valid way to create Sets in Tableau? C.) In the Data pane, right-click a dimension and select Create => Set. -------------------------------------------------------------- *There are two types of sets: dynamic sets and fixed sets. *The members of a dynamic set change when the underlying data changes. Dynamic sets can only be based on a single dimension.

Which of the following is an example of a Date Part? A.) November B.) 04 2017 C.) March 2019 D.) September 2020

Which of the following is an example of a Date Part? A.) November -------------------------------------------------------------- *All other options are combinations of a year with one other value (like a month, quarter, or day). So, this is how by looking at an option you can know if it's a date part or date value!

Which of the following is true about 'Incremental Refresh' when creating Extracts in Tableau? A.) It only adds rows that are new since the previous refresh B.) They can only be used with large datasets C.) There is no difference, both are the same when using extracts. They are different when using live connections. D.) It replaces all of the contents in the extract

Which of the following is true about 'Incremental Refresh' when creating Extracts in Tableau? A.) It only adds rows that are new since the previous refresh -------------------------------------------------------------- *After you create an extract, you can refresh it with data from the original data. *When refreshing the data, you have the option to either do a full refresh, which replaces all of the contents in the extract, or you can do an incremental refresh, which only adds rows that are new since the previous refresh.

Which of the following represent a valid method to create a Bullet Graph with the LEAST number of fields possible? A.) Using 1 Measure B.) Using 2 Dimensions C.) Using 2 Measures D.) Using 2 Dimensions and 3 Measures

Which of the following represent a valid method to create a Bullet Graph with the LEAST number of fields possible? C.) Using 2 Measures

Which of the following shapes does a Heat Map use by default? A.) Text B.) Square C.) Circle D.) Line

Which of the following shapes does a Heat Map use by default? B.) Square

Which of the following would you use to connect to multiple tables in a single data source at once? A.) Join B.) Set C.) Blend D.) Hierarchy

Which of the following would you use to connect to multiple tables in a single data source at once? A.) Join -------------------------------------------------------------- *The data that you analyze in Tableau is often made up of a collection of tables that are related by specific fields (that is, columns). *Joining is a method for combining data on based on those common fields. The result of combining data using a join is a virtual table that is typically extended horizontally by adding columns of data.

Which of the following would you use to edit the Shape, color, and Text of your visualizations? A.) Analytics Pane B.) Data Pane C.) Marks Card D.) Filter Shelf

Which of the following would you use to edit the Shape, color, and Text of your visualizations? C.) Marks Card

Which of these is NOT a type of Quick Filter available in Tableau? A.) Regex Match B.) Multiple Values (dropdown) C.) Single Value (slider) D.) Wildcard Match

Which of these is NOT a type of Quick Filter available in Tableau? A.) Regex Match

Which one of the following is a dimension? A.) Measure Names B.) Number of Records C.) Longitude D.) Latitude

Which one of the following is a dimension? A.) Measure Names

You can create _____________ for members in a dimension so that their labels appear differently in the view. A.) Aliases B.) Duplicates C.) Renames D.) Copies

You can create _____________ for members in a dimension so that their labels appear differently in the view. A.) Aliases -------------------------------------------------------------- *Aliases can be created for the members of discrete dimensions only. *They cannot be created for continuous dimensions, dates, or measures.

You clicked Sheet 1 from the data source page, and now you have opened the Tableau Desktop workspace. What is the main thing that you do next? A.) Create visualizations to analyze your data B.) clean the data C.) Rename the fields and change data types D.) Preview the data

You clicked Sheet 1 from the data source page, and now you have opened the Tableau Desktop workspace. What is the main thing that you do next? A.) Create visualizations to analyze your data

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? A.) Save it as a .twm file B.) Save it as a .twb file C.) Save it as a .twbx file D.) Save it as a .tds file

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? D.) Save it as a .tds file -------------------------------------------------------------- *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.

You have just created a histogram and now want to be able to change the size of bins dynamically. Using which of the following will easily satisfy your requirement? A.) Calculation B.) Parameters C.) Sets D.) Groups

You have just created a histogram and now want to be able to change the size of bins dynamically. Using which of the following will easily satisfy your requirement? B.) Parameters -------------------------------------------------------------- *A parameter is a global placeholder value such as a number, date, or string that can replace a constant value in a calculation, filter, or reference line. *For example, you may create a calculated field that returns True if Sales is greater than $500,000 and otherwise returns False. *You can replace the constant value of "500000" in the formula with a parameter. *Then, using the parameter control, you can dynamically change the threshold in your calculation.

You just added the field SUM(Profit) to the Columns shelf. What will this create? A.) A horizontal header B.) A horizontal axis C.) A vertical header D.) A vertical axis

You just added the field SUM(Profit) to the Columns shelf. What will this create? B.) A horizontal axis -------------------------------------------------------------- *We know that continuous fields will always create an axis, so options stating 'header' are automatically eliminated. * Had the question asked us to place this pill on the Rows shelf instead, it would have created a vertical bar.

You may create a context filter to: (Select all that apply) A.) To replace a data source filter B.) Improve performance C.) Create a dependent numerical or top N filter D.) To create a dependent filter

You may create a context filter to: (Select all that apply) B.) Improve performance C.) Create a dependent numerical or top N filter -------------------------------------------------------------- *You cannot use a context filter to replace a data source filter since each filter type has its own use case. *Also, a content filter is an independent filter, and all other filters are called dependent since they only process the data that passes through a context filter.

You want to add Custom shapes to your visualization. Where can you add these new shapes? A.) In My Documents => My Tableau Repository => Shapes B.) In Program Files => Tableau => Shapes C.) In Downloads => My Tableau Repository => Shapes D.) In My Computer => C: => Tableau => Shapes

You want to add Custom shapes to your visualization. Where can you add these new shapes? A.) In My Documents => My Tableau Repository => Shapes -------------------------------------------------------------- * How to add image files to your repository: 1)Find image file on the internet. I try to find consistent image formats if I plan to use a set of shapes such as logos or flags. 2) Download the image to your computer. 3) Drag images into your My Documents -> My Tableau repository -> Shapes folder. 4) Open Tableau and your new shapes will automatically be included in your "edit shapes" menu.

_____________ charts are typically used to represent accumulated totals over time and are the conventional way to display stacked lines. A.) Line B.) Bullet C.) Area D.) Gantt

_____________ charts are typically used to represent accumulated totals over time and are the conventional way to display stacked lines. C.) Area -------------------------------------------------------------- *An area chart is a line chart where the area between the line and the axis are shaded with a color. *Mark Type: Area Columns Shelf: Dimension Rows Shelf: Measure Color: Dimension

______________ is a method for appending values (rows) to tables. You can use this method if both tables have the same columns. The result is a virtual table that has the same columns but extends vertically by adding rows of data. A.) Joining B.) Blending C.) Combining D.) Unioning

______________ is a method for appending values (rows) to tables. You can use this method if both tables have the same columns. The result is a virtual table that has the same columns but extends vertically by adding rows of data. D.) Unioning

______________ refers to the level of detail for a piece of data, wherever you are looking. A.) Data Cleanliness B.) Data Granularity C.) Data Connectivity D.) Data LOD

______________ refers to the level of detail for a piece of data, wherever you are looking. B.) Data Granularity -------------------------------------------------------------- *Data is generated and analyzed at many different levels of granularity. Granularity is the level of detail of the data.

_______________ enables us to create workbooks and views, dashboards, and data sources in Tableau Desktop, and then publish this content to our own server. A.) Tableau Prep B.) Tableau myServer C.) Tableau Server D.) Tableau Public

_______________ enables us to create workbooks and views, dashboards, and data sources in Tableau Desktop, and then publish this content to our own server. C.) Tableau Server -------------------------------------------------------------- *Also, as a Tableau Server administrator you will control who has access to server content to help protect sensitive data.

________________ can only create header. _______________ will create header and axis both. A.) Dates, Strings B.) Dimensions, Measures C.) Measures, Dimensions D.) Groups, Sets

________________ can only create header. _______________ will create header and axis both. B.) Dimensions, Measures -------------------------------------------------------------- * Image = Dimension Example

________________ files are shortcuts for quickly connecting to the original data that you use often. 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. A.) .tbm B.) .tds C.) .twb D.) .tde

________________ files are shortcuts for quickly connecting to the original data that you use often. 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. B.) .tds -------------------------------------------------------------- *Tableau data source files have the .tds file extension. *Data source files are shortcuts for quickly connecting to the original data that you use often. *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.

_________________ are a local copy of a subset or entire data set that you can use to share data with others, when you need to work offline, and improve performance. A.) .twbx files B.) .tbm files C.) .tde files D.) .twb files

_________________ are a local copy of a subset or entire data set that you can use to share data with others, when you need to work offline, and improve performance. C.) .tde files -------------------------------------------------------------- *Depending on the version the extract was created in, Tableau extract files can have either the .hyper or .tde file extension.

_________________ is useful when you need to change how the data source is configured on a sheet-by-sheet basis, and when you want to combine databases that don't allow relationships or joins. A.) Data Segregation B.) Data Joining C.) Union D.) Data Blending

_________________ is useful when you need to change how the data source is configured on a sheet-by-sheet basis, and when you want to combine databases that don't allow relationships or joins. D.) Data Blending -------------------------------------------------------------- *To create a blend in a workbook already connected to at least two data sources, bring a field from one data source to the sheet...it becomes the primary data source. *Switch to the other data source and use a field on the same sheet...it becomes a secondary data source. *An orange linking icon will appear in the data pane, indicating which field(s) are being used to blend the data sources.