Tableau

What is the difference between a Cross-Database Join and Blending? A Cross-Database Join integrates two data sources at the row level to create a single data source. Blending takes separate query results from each data source and aggregates them in the view. There is no difference between Cross-Database Joins and Blending. A Cross-Database join combines two data representations and a blend mixes all the data together while automatically cleaning it. A Cross-Database Join takes separate query results from each data source and aggregates them in the view. Blending integrates two data sources at the row level to create a single data source.

A Cross-Database Join integrates two data sources at the row level to create a single data source. Blending takes separate query results from each data source and aggregates them in the view.

Which of the following can you use to create a calculated field that return data independent of the data granularity in a view? an INCLUDE LOD calculation A FIXED LOD calculation a table calculation a basic calculation

A FIXED LOD calculation

Which type of calculation could be used to distinguish data in a visualization that satisfies a certain criterion? A calculation using a "Vlookup" statement. A distinguish statement calculation. A calculation using "If" and "Then" statements. A "Sum" calculation.

A calculation using "If" and "Then" statements.

In Tableau, which of the following best describes a dashboard? A variable from the dataset that is often aggregated and is usually continuous data. A canvas for displaying multiple sheets that allows the user to interact with the display. A single chart or map in Tableau. The entire Tableau file containing your sheets and dashboards.

A canvas for displaying multiple sheets that allows the user to interact with the display.

In Tableau, which of the following best describes a story? A coherent sequence of visualizations. An individual sheet in a story. Where you determine which variables will go on what axis. Controls most of the visual elements in a sheet. Allows you to switch between different chart types (bar, line, symbol, filled map, and so), change colors and sizes, add labels, and change the level of detail.

A coherent sequence of visualizations.

In Tableau, which of the following best describes a sheet? A variable from the dataset that is often aggregated and is usually continuous data. The entire Tableau file containing your sheets and dashboards. A canvas for displaying multiple sheets that allows the user to interact with the display. A single chart or map in Tableau.

A single chart or map in Tableau.

In Tableau, which of the following best describes a measure? A variable from the dataset that is often aggregated and is usually continuous data. A single chart or map in Tableau. A canvas for displaying multiple sheets that allows the user to interact with the display. The entire Tableau file containing your sheets and dashboards

A variable from the dataset that is often aggregated and is usually continuous data.

What are parameters in Tableau? A function that only allows the user to replace numbers outside of a certain range with "Null." Parameters are not used in Tableau. A variable whose value is controlled by the end user. A function that allows the user to fix the granularity of data, preventing it from fully aggregating.

A variable whose value is controlled by the end user.

What does "AGG" mean when included in a pill in Tableau? An aggressive iterative calculation error has occurred. A possible negative data aggregation has occurred in this calculation's execution. An aggregate calculation has been included in this calculation instead of being separately calculated. Nothing, AGG only applies to Tableau Prep.

An aggregate calculation has been included in this calculation instead of being separately calculated.

A field that shows average home values for the United States in 2016 is most likely: A geographical dimension A continuous date value dimension An aggregated measure A discrete date part dimension

An aggregated measure

In Tableau, which of the following best describes a story point? Where you determine which variables will go on what axis. A coherent sequence of visualizations. An individual sheet in a story. Controls most of the visual elements in a sheet. Allows you to switch between different chart types (bar, line, symbol, filled map, and so), change colors and sizes, add labels, and change the level of detail.

An individual sheet in a story.

Dashboards provide a view of the most important information needed to achieve one or more objectives. According to Stephen Few's definition of a dashboard, they should also (pick the single most important): Have as much information as possible on multiple pages Be consolidated on a single computer screen so that they can be monitored at a glance Contain complex diagnostics that the user can use to drill-down into other reports Be interactive and "clickable"

Be consolidated on a single computer screen so that they can be monitored at a glance

What color indicates a discrete (not continuous) measure in Tableau? Orange Red Green Blue

Blue

Which Aggregate Function is used to calculate distinct count? COUNT() SUM() COUNTD() AVG()

COUNTD()

In Tableau, this statement, "SUM([Profit])/SUM([Sales])" is best described as a: Connection Classification Analysis Calculation

Calculation

How is a data field hierarchy created? Click on create hierarchy within a data field's menu Assign the same alias to multiple data fields Hierarchies are not a feature in Tableau None is correct.

Click on create hierarchy within a data field's menu

In using best practices in Tableau, dimensions are mostly _______ while measures are mostly _____________. Numbers, Alignments Discrete Numbers, Continuous Numbers Added, Grouped Categories, Numbers

Categories, Numbers

How would you add a linear trend line to a scatter plot? Click on analytics, then drag trend line onto linear In the toolbar, click on analysis then select linear trend line Right click anywhere on the scatter plot and select linear trend line None of the above

Click on analytics, then drag trend line onto linear

How would you add a linear trend line to a scatter plot? None of the above In the toolbar, click on analysis then select linear trend line Click on analytics, then drag trend line onto linear Right click anywhere on the scatter plot and select linear trend line

Click on analytics, then drag trend line onto linear

How can you assign a geographic role to a data field in the data pane? Contact the United Nations geographic database to assign geographic information to your data You Answered Geographic roles are not a function in Tableau Click on the data type symbol of the data field and select the geographic role Program geographic roles by editing the data field

Click on the data type symbol of the data field and select the geographic role

What does a Tableau union do? Unions cannot be performed in Tableau, only Joins can be used. Places two visualizations on a dashboard. Combines data from multiple tables by bringing in new columns or records that match the structure of the original data. Combines data from multiple tables by bringing in new rows or records that match the structure of the original data.

Combines data from multiple tables by bringing in new rows or records that match the structure of the original data.

What does the device designer feature in Tableau allow the user to do? Allows the user to design each graph individually outside of the dashboard. Creates a master dashboard and allows customization to determine what it would look like on a desktop, tablet, or phone. Device designer is only a Tableau Prep tool and is not useful for publishing. Allows the user to save the file to a separate device of the user's choosing.

Creates a master dashboard and allows customization to determine what it would look like on a desktop, tablet, or phone.

Which part of the toolbar should be used to export an image of a dashboard? format Dashboard Analysis File

Dashboard

Which data structure does tableau prefer: Pivot tables photographs Gantt charts Flat files

Flat files

How does a user publish a workbook from Tableau Desktop? From inside Tableau Desktop, go to "File" and click "Publish to Tableau Online." From inside Tableau Desktop, go to "Data" and click "Publish." From inside Tableau Desktop, go to "Server" and click "Publish Workbook... From inside Tableau Prep, click "Output."

From inside Tableau Desktop, go to "Server" and click "Publish Workbook...

What is the key difference between a data extract and live connection in Tableau? Live connections update automatically and data extracts need to be refreshed They are the same Data extracts update automatically and live connections need to be refreshed They are not Tableau features

Live connections update automatically and data extracts need to be refreshed

What must you have to publish a workbook? Ability to download your Tableau data to an excel file. Tableau approval through Tableau Online for data to be published anywhere. The Tableau workbook is solely for presentation purposes and cannot be published publicly. Publishing access to either Tableau Server or Tableau Online.

Publishing access to either Tableau Server or Tableau Online.

Some calculations are available without manual creation. These are called: Instant Viz Calculations Fast Calculations Easy Access Calculations Quick Table Calculations

Quick Table Calculations

Name the color scheme used in the following visualization: Categorical Exponential Sequential Diverging

Sequential

How do you change a data field's properties to express "Profit" in terms of dollars? Right-click on Profit the click on default properties to select the desired currency in number format Recode the data to express the profit as dollars Data field properties can only be edited when the data fields is in either rows or columns Data field properties cannot be charged within Tableau

Right-click on Profit the click on default properties to select the desired currency in number format

Which of the following is not an action that can be added to Dashboards? URL Highlight Run Filter

Run

Which version of Tableau runs on the client's (not Tableau's) server? Online Server Public Desktop

Server

Which of the following will present a sequence of visualizations? Map Dashboard Worksheet Story

Story

What happens when you drag a dimension or measure from the data pane into the view? Nothing Tableau creates a pill Tableau creates a data duplication A singularity is created

Tableau creates a pill

In Tableau, which of the following best describes a tooltip? Controls most of the visual elements in a sheet. Allows you to switch between different chart types (bar, line, symbol, filled map, and so), change colors and sizes, add labels, and change the level of detail. Where you determine which variables will go on what axis. Text boxes that appear when hovering over a mark on a sheet to give more information. Used to limit what data is displayed on the sheet.

Text boxes that appear when hovering over a mark on a sheet to give more information.

In Tableau, which of the following best describes a workbook? The entire Tableau file containing your sheets and dashboards. A variable from the dataset that is often aggregated and is usually continuous data. A canvas for displaying multiple sheets that allows the user to interact with the display. A single chart or map in Tableau.

The entire Tableau file containing your sheets and dashboards.

What does Granularity mean in Tableau? The extent to which the view is broken down. The more aggregated, the more granular. The extent of the quality of the graph type. The visualization's picture definition. The extent to which the view is broken down. The less aggregated, the more granular.

The extent to which the view is broken down. The less aggregated, the more granular.

Why does Tableau aggregate measures? To display data at the lowest level of detail Because measures require less storage It requires a less powerful computer to process the measures To summarize the data

To summarize the data

In Tableau, which of the following best describes the marks card? Text boxes that appear when hovering over a mark on a sheet to give more information. Used to limit what data is displayed on the sheet. Where you determine which variables will go on what axis. Used to create a sheet that controls most of the visual elements in a sheet. Allows you to switch between different chart types (bar, line, symbol, filled map, and so), change colors and sizes, add labels, and change the level of detail.

Used to create a sheet that controls most of the visual elements in a sheet. Allows you to switch between different chart types (bar, line, symbol, filled map, and so), change colors and sizes, add labels, and change the level of detail.

In Tableau, which of the following best describes a filter? Where you determine which variables will go on what axis. Controls most of the visual elements in a sheet. Allows you to switch between different chart types (bar, line, symbol, filled map, and so), change colors and sizes, add labels, and change the level of detail. Text boxes that appear when hovering over a mark on a sheet to give more information. Used to limit what data is displayed on the sheet.

Used to limit what data is displayed on the sheet.

In Tableau, which of the following best describes the rows and columns shelf? Used to create a sheet that controls most of the visual elements in a sheet. Allows you to switch between different chart types (bar, line, symbol, filled map, and so), change colors and sizes, add labels, and change the level of detail. Where you determine which variables will go on what axis. Text boxes that appear when hovering over a mark on a sheet to give more information. Used to limit what data is displayed on the sheet.

Where you determine which variables will go on what axis.

A ______ can be used within a ______ or ______. Dashboard, worksheet, story Worksheet, dashboard, story Story, dashboard, workbook Story, dashboard, worksheet

Worksheet, dashboard, story

In Tableau, can you deploy a URL action on a dashboard object to open a Web Page within a dashboard rather than opening the system's web browser? Just like the song, "It's impossible" Yes, with the use of a Web Page object Yes, with the use of Tableau Server Yes, but if requires a plug-in

Yes, with the use of a Web Page object

Which of the following is false considering mapping in Tableau? You cannot show streets and highways on your maps. You can show streets and highways on your maps when zoomed in. You can used latitude and longitude to generate place names on your map. You can generate latitude and longitude if you have place names in your data.

You cannot show streets and highways on your maps.

This type level of detail expression computes total sales for the region, regardless of what dimensions are shown in the view. { FIXED [Region] : SUM([Sales]) } {SUM([Sales])} { EXACT [Region] : SUM([Sales]) } { ONLY [Region] : SUM([Sales]) }

{ FIXED [Region] : SUM([Sales]) }