Tableau Desktop Specialist Prep

Which of the following fields will have AGG in front of it when you add it to the view? a. A calculated field with the formula SUM([Profit]) b. A measure called Profit c. A date field d. A calculated field with the formula 5 * [Profit]

a. A calculated field with the formula SUM([Profit])

Which of the following is true? a. A dashboard cannot include a story, but a story can include a dashboard b. A dashboard can include a story, but a story cannot include a dashboard c. A dashboard can include a story, and a story can include a dashboard d. A dashboard cannot include a story, and a story cannot include a dashboard

a. A dashboard cannot include a story, but a story can include a dashboard

[Assign a geographic role to a data field] Which of the following are predefined geographic roles? [select two] a. Airport b. Train terminal c. Seaport d. Geo code e. Zip code

a. Airport e. Zip code

[Add a reference line] What steps can be used in creating a view with a reference line? [select two] a. On the analytics pane, click on reference line and drag into the view. b. On the toolbar, choose Analysis, then Reference Line and select Show Reference Line c. On the toolbar, choose Format, then Reference Line and change the value from None to solid. d. On the Show Me menu, select bullet graph e. On the Show Me menu, select box plot

a. On the analytics pane, click on reference line and drag into the view. d. On the Show Me menu, select bullet graph

Which type of filter usually works best with date fields? a. Slider filters b. List filters c. Checkboxes d. Text search

a. Slider filters

With a data source that uses relationships, which describes what is shown in the data source preview pane when you're viewing the logical layer? a. A list of the field names, tables, and data types b. A preview of the data for the table currently selected c. A preview of all related tables d. A preview of the combined (via join or union) tables

b. A preview of the data for the table currently selected

Which of the following can you use to create a calculated field that shows the change from the prior month total? a. An aggregate calculation b. A table calculation c. A basic calculation d. A subtraction calculation

b. A table calculation

Which of the following will result in an error a. A calculation that includes more than one aggregation b. Aggregation on a field that is already aggregated c. A table calculation on a field that is already aggregated d. An aggregation on a level of detail expression

b. Aggregation on a field that is already aggregated

For which of the following tasks would it make the most sense to use a parameter? a. Allow the user to choose between user to toggle between a dashboard view of the most recent extract or a live connection to the database b. Allow the user to expand related dimensions. For example, to expand product categories to see the subcategories and products within those categories. c. Allow the user to change the measure shown in the view. For example, to switch from seeing sale per order to seeing the count of distinct customers. d. Allow the user to view the top 10 products with the highest total sales value given the current filters

c. Allow the user to change the measure shown in the view. For example, to switch from seeing sale per order to seeing the count of distinct customers.

You start with a blank worksheet and add a continuous field to the row shelf. How will this new field change your view? a. It will add a horizontal axis b. It will add a horizontal header c. It will add a vertical axis d. It will add a vertical header

c. It will add a vertical axis

This type of join will include all values from the left table: a. Inner b. Right c. Left d. Blend

c. Left

[Add a manual or computed sort] What sort type should be used to have sort order Low, Medium, High? a. Computed b. Alphabetic c. Manual d. Data source order e. Nested

c. Manual

When the Use as Filter option is selected for a worksheet in a dashboard, what is the default for how the action is run? a. On right-click b. On hover c. On select d. On menu e. On highlight

c. On select

Which of the following mark types cannot be adjusted using the Size slider? a. Line b. Pie c. Bar d. Area

d. Area

Which of the following uses a primary and secondary data source? a. Cross-database joins b. Unions c. Aggregation d. Blending

d. Blending

Which of the following can have an alias? [select two] a. Parameter b. Measures c. Field names d. Dimensions e. Dates

d. Dimensions

Which of the following field types will create a color palette? a. Measure b. Dimension c. Continuous d. Discrete

d. Discrete

What steps should you take to add a phone view to a dashboard? a. Instruct the those viewing the dashboard on mobile to put "m." in front of the dashboard URL to get the mobile-friendly view. b. Select Layout, then adjust the dimensions until they are appropriate for a phone (750x1334) c. On the "Show Me" menu, click the Phone icon d. Select Device Preview, then select Phone for Device Type, then click the button labeled "Add Phone Layout"

d. Select Device Preview, then select Phone for Device Type, then click the button labeled "Add Phone Layout"

Which of the following is not a default property which can be set for a measure? a. Number Format b. Color c. Aggregation d. Sort

d. Sort

[Create a data source that uses multiple connections] What is required to combine columns from an Excel worksheet with columns from a database table? a. two connections and two data sources b. one connections and two data sources c. one connection and one data source d. two connections and one data source

d. two connections and one data source

Which of the following will create a dashboard action? a. Click the "More Options" arrow on the worksheet included in the dashboard layout, then select "use as filter" b. Click the "More Options" arrow on the worksheet included in the dashboard layout, then select "Filter" and the field you wish to use in the filter action c. Right-click on a header value shown in the worksheet in the dashboard layout and select "exclude" or "keep only" d. Click the "More Options" arrow on the worksheet included in the dashboard layout, then select "action," add action, and Filter

a. Click the "More Options" arrow on the worksheet included in the dashboard layout, then select "use as filter"

Which of the following is automatically organized in a hierarchy? a. Date fields b. Geographic fields c. Fields from primary tables with blend to secondary table d. Fields with the "sub" prefix e. Multiple dimensions on the row or column shelf

a. Date fields

Which of the following does Tableau automatically put into a hierarchy? a. Date fields (year > month > day) b. Geographic fields (country > city > state) c. Field with field name containing the keyword "sub-" (product category, product sub-category) d. Numeric fields (Millions > Thousands > Ones)

a. Date fields (year > month > day)

Which dashboard layouts are created automatically by default? [select two] a. Default b. Tablet c. Desktop d. Web e. Phone

a. Default e. Phone

Which field types are more common? a. Discrete dimension, continuous measure b. Continuous dimension, continuous measure c. Discrete dimension, discrete measure d. Continuous dimension, discrete measure

a. Discrete dimension, continuous measure

[Rename a data field] Which of the following can be renamed? [select 3] a. Field names b. Column values c. Parameters d. The Measure Names generated field e. Sets

a. Field names c. Parameters e. Sets

You have a dashboard and you want to add a feature so that selecting an element on one of the worksheets on the dashboard causes a change on another worksheet in the same dashboard. What features will do this? (select all that apply) a. Filter Action b. Url Action c. Highlight Action d. Drilldown Action

a. Filter Action c. Highlight Action

Which of the following is a geographic role available in Tableau? [select 3] a. Latitude b. Airport c. Continent d. FIPS code e. County

a. Latitude b. Airport e. County

Which of the following should be used if, for security purposes, you'd like users to enter their database credentials in order to access the workbook: a. Live connection b. Extract c. Hyper d. Packaged data source

a. Live connection

[Add joins and unions] Which describes how to create a union of two tables? [select two] a. On the data source page, drag the first table into the canvas. Then drag a second table onto the canvas, below the first table. b. On the data source page, drag the first table into the canvas. Then drag a second table onto the canvas, to the right of the first table. c. On the data source page, drag the first table into the canvas. Double-click the first table to go to the physical layer. Then drag a second table onto the canvas, to the right of the first table. d. On the data source page, double-click the "New Union" icon. A Union menu will appear. Drag both tables to the Union menu, then click OK

a. On the data source page, drag the first table into the canvas. Then drag a second table onto the canvas, below the first table. d. On the data source page, double-click the "New Union" icon. A Union menu will appear. Drag both tables to the Union menu, then click OK

[Format marks as shapes] Which of the following visualizations allow you to set the shape of marks? a. Scatter plots b. Heat maps c. Symbol Maps d. Circle views e. Packed bubbles

a. Scatter plots d. Circle views

Which of the following is most likely to reduce the size of the extract? a. Selecting the Physical Tables Data Storage option b. Using the incremental refresh option c. Materialize calculations with the "Compute Calculations Now" option d. Removing an filter

a. Selecting the Physical Tables Data Storage option

[Change default properties for a data field (number format, aggregation, color, date format, etc.)] Which of the following are default properties which can be assigned to a dimension? [select three] a. Shape b. Size c. Color d. Path e. Sort

a. Shape c. Color e. Sort

Which of the following is a table calculation? a. SUM b. TOTAL c. AVG d. STDEV

b. TOTAL

The visualization shows ship date and order date. Are the dates discrete or continuous? a. Ship date is discrete, order date is continuous b. Ship date is discrete, order date is discrete c. Ship date is continuous, order date is discrete d. Ship date is continuous, order date is continuous

a. Ship date is discrete, order date is continuous

Which of the following can be configured when creating an extract? [select three] a. Whether to store logical or physical tables b. Whether the extract should be refreshed on a schedule c. Whether to limit the data extracted using filters d. Whether to change the default aggregation for measures e. Whether to aggregate measures for visible dimensions

a. Whether to store logical or physical tables c. Whether to limit the data extracted using filters e. Whether to aggregate measures for visible dimensions

[Explain when to use a join versus a relationship] In which of the following situations would an outer join be preferred to a blend? a. when you need to include all rows from both tables, even when the join or blend criteria is not met b. when the data is at different level of granularity c. when you need to append rows from one table to rows in another table d. when the tables are stored in different databases

a. when you need to include all rows from both tables, even when the join or blend criteria is not met

If you have bar chart with a single bar, but you want to subdivide that bar into multiple categories, what should you add to your view? a. A measure b. A dimension c. A discrete field d. A continuous field

b. A dimension

Groups are best described by which of the following? [select two] a. A method for organizing multiple dimensions based on higher and lower levels b. A method for combining values of a measure c. A method for combining values of a dimension d. A method for concatenating existing fields to create a new field e. A method for determining which values of a dimension are in the Top N or Bottom N based on a related measure

b. A method for combining values of a measure c. A method for combining values of a dimension

Which of the following functions can be used on string to create a measure? a. SUM b. COUNTD c. + d. DATEDIFF

b. COUNTD

Which of the following are dashboard actions? [select two] a. Change Group b. Change Set Values c. Change Bin d. Change Parameter e. Change Map Zoom Area

b. Change Set Values d. Change Parameter

[Show and hide legends] Which of the following will remove a legend on a dashboard? [select three] a. Click the arrow on the legend and select "Hide card" b. Click the x to remove it from the dashboard c. Click the arrow on the legend and select "Remove from dashboard" d. Select the legend by clicking and drag it out of the dashboard canvas e. Select the legend's container, right click, and select "remove container."

b. Click the x to remove it from the dashboard c. Click the arrow on the legend and select "Remove from dashboard" d. Select the legend by clicking and drag it out of the dashboard canvas

Which of the following can use anchor dates? a. The DATEPART function b. Filters c. Sets d. Reference lines e. Parameters

b. Filters

Which steps can be followed to create a tds file? a. Select Server, then Publish Data Source, then select the data source b. On Data pane, right-click the data source, and then select Add to Saved Data Sources. c. Select File on the toolbar, then select Export Packaged Workbook d. Select File on the toolbar, then select Export Data Source, then select the data source

b. On Data pane, right-click the data source, and then select Add to Saved Data Sources.

Which file type can include an extract? Select all that apply. a. Data Source (.tds) b. Packaged Data Source (.tdsx) c. Packaged Workbooks (.twbx) d. Workbooks (.twb)

b. Packaged Data Source (.tdsx) c. Packaged Workbooks (.twbx)

How would you change the font color of the tooltip? (Select all that apply) a. Click on "color" in the marks area, select "tooltip" in the dropdown, and select the desired color. b. Right-click on the view, select "Format" and select the dropdown next to tooltip. Then select the color. c. Click on the tooltip button in the Marks area, highlight the text, and select the desired color using the dropdown d. Right-click on the view, select "Format" and you will see several tabs in the formatting menu - "Sheets," "Rows," Columns" and "Tooltip." Select the tootip tab and then use the formatting menu to select the color.

b. Right-click on the view, select "Format" and select the dropdown next to tooltip. Then select the color. c. Click on the tooltip button in the Marks area, highlight the text, and select the desired color using the dropdown

Which chart type will best visualize the relationship between two continuous measures? a. Bar chart b. Scatter Plot c. Line Chart d. Stacked Bar

b. Scatter Plot

A relative date filter works relative to: a. A parameter or field you select when creating the filter b. The anchor date c. The data the workbook was created or updated d. The current date when the workbook is viewed

b. The anchor date

[Configure viz animations] Which of the following describes the effect of changing the filters for a sorted bar chart with sequential animation is turned on? a. The animation will show the bars reordering according to the sort, then show the bar sizes changing b. The animation will show the bar sizes changing, then shows the bars reordering according to the sort c. The animation shows the bar sizes changing and at the same time shows the bars reordering according to the sort d. The sort order and bar size will change immediately without animation

b. The animation will show the bar sizes changing, then shows the bars reordering according to the sort

[Add relationships to a data source] Relationships are created in which layer? a. The data model Layer b. The logical layer c. The physical layer d. The map layer

b. The logical layer

If a Tableau workbook does not include the fields Latitude (generated) and Longitude (generated) this indicates which of the following: a. The workbook does not include a map b. The workbook does not include any fields with a geographic role such as state, city, country, or zip code c. The workbook does not include custom geocoding d. All locations are ambiguous or unknown

b. The workbook does not include any fields with a geographic role such as state, city, country, or zip code

[Explain when to use a parameter] In which case would you most likely want to use a parameter? a. To allow the viewer to select which dates range to show on a line chart b. To allow the viewer to select which measure to show in a bar chart c. To group all values containing a specified string d. To make the value of a dimension display in the view with a different label

b. To allow the viewer to select which measure to show in a bar chart

The most important items on a dashboard should be positioned where? a. Center b. Upper Left c. Upper Right d. Bottom

b. Upper Left

Which of the following describes the Measure Names field (select all that apply) a. It is a Measure automatically created by Tableau b. When you create a view with multiple measures on a single continuous axis, Tableau will automatically add Measure Names to the view. c. When you add Measure Names to a view, all of the measure names appear as row or column headers in the view. The headers include each measure name. This feature becomes useful when you are working with a text table that shows multiple measures. d. Measure Names is a system generated field that contains the names of all the measures in your Tableau workbook, including the system generated measures such as Latitude and Longitude.

b. When you create a view with multiple measures on a single continuous axis, Tableau will automatically add Measure Names to the view. c. When you add Measure Names to a view, all of the measure names appear as row or column headers in the view. The headers include each measure name. This feature becomes useful when you are working with a text table that shows multiple measures.

Which of the following is an example of metadata that can be managed in Tableau? Select all that apply. a. The data type of the data in the source database b. Which fields are hidden c. The number of rows in the data d. The default aggregation for a field

b. Which fields are hidden d. The default aggregation for a field

Which of the following is the best reason to create a saved data source as a .TDS file a. Those who wish to use the data do not have access to the underlying data. b. You want to save the default field properties such as number formats and sort order. c. You want to save a snapshot of the data that will not update even when the underlying data changes. d. You need to apply an aggregation that takes too long when using a live connection

b. You want to save the default field properties such as number formats and sort order.

While file types preserve connection properties such as file locations and database server addresses? [select two] a. twb b. tds c. tdsx d. hyper

b. tds c. tdsx

[Use color from the marks card] If a continuous measure with all positive values is added to the Color area of the Marks card, what is the default? a. A diverging color gradient b. A categorical palette c. A sequential color gradient d. A stepped color gradient

c. A sequential color gradient

Which types of plots are most often used to visualize the distribution of a single continuous measure? (select all that apply) a. Scatter Plot b. Tree Maps c. Box Plot d. Histogram

c. Box Plot d. Histogram

[Configure fonts] Which option can be used to change only the font size the numeric values shown in the view below? [select all that apply] a. On the format menu, select Font and then make the change on the Measures dropdown b. Right click SUM(Profit) and SUM(Sales) and select Format c. Click Text on the Marks card d. On the format menu, select Font and then make the change on the Pane dropdown

c. Click Text on the Marks card d. On the format menu, select Font and then make the change on the Pane dropdown

[Create sets by using marks and the data pane] You have a scatter plot showing sales and profit by product subcategory. You wish to create a set from a cluster of high values sub-categories. What steps should you take? a. Hold down the control key and click on the sub-categories of interest. Then right-click the data pane and select "Create set" b. Highlight the sub-categories of interest. Then in the Marks card click "Set" and "Create Set" c. Click and hold down the mouse, drawing a rectangle to select the sub-categories of interest. Right click and select 'create set' d. Select the sub-categories in the color legend, then right click and select "set" then "Create Set"

c. Click and hold down the mouse, drawing a rectangle to select the sub-categories of interest. Right click and select 'create set'

[Add worksheets to a dashboard] Which method can be used to replacing a worksheet in a dashboard with an different worksheet: a. Click the replace icon next to the new worksheet on the layout pane b. Click the down arrow for more options on the current worksheet in the dashboard canvas, then select replace and select the alternate worksheet c. Click the swap sheet icon next to the new worksheet on the dashboard pane d. Select and drag the different worksheet on top of the worksheet in the dashboard canvas

c. Click the swap sheet icon next to the new worksheet on the dashboard pane

You would like to create a view showing the top 5 products by sum of sales for a given state or states. A set is used to select the top 5 products by sales. What type of filter should be used with state? a. Multiselect Filter b. Dimension Filter c. Context Filter d. Wildcard Filter

c. Context Filter

Bins can be created for which type of field? a. Dimension b. Discrete c. Continuous measure d. Date

c. Continuous measure

[Add joins and unions] When creating a union between tables, what will happen if the field names do not match? a. Tableau will return an error message, explaining that you must modify the tables so that all tables used in the union have the same field names. b. Tableau will automatically merge the fields, combining fields with similar field names. c. Fields in the union that do not have matching field names will contain null values. d. Fields with non-matching field names will be dropped, so that the union will contain only those fields with matching field names

c. Fields in the union that do not have matching field names will contain null values.

In the Southern Region Superstore data, the Product Category, Product Subcategory, and Product Name might be combined using which of the following: a. Set b. Group c. Hierarchy d. Parameter

c. Hierarchy

Which chart type is best for viewing the distribution of a measure? a. Line charts b. Scatter plots c. Histograms d. Tree maps e. Stacked bar chart

c. Histograms

[Explain when to use a parameter] Which of the following could best be accomplished using a parameter? [choose two] a. In a view with a date range filter, allow the viewer to select the anchor date b. Combining related values of a dimension c. In a view showing the top customers, allow the user to show how many customers to show d. Allow the worksheet view to adjust the number of decimals displayed for a measure e. Allow the worksheet viewer to adjust the bin size for a histogram

c. In a view showing the top customers, allow the user to show how many customers to show e. Allow the worksheet viewer to adjust the bin size for a histogram

[View and export underlying data] Which options can be used to export data as a CSV file? a. From the toolbar, select Worksheet, then Export then Export Data to CSV b. On the Data Source page, select the table you want to export on the physical layer canvas, click the arrow, and select Export Data to CSV c. On the Data Source page, select Data. Then select Export Data to CSV d. Right-click the data source name in the data pane, then select "Export data to CSV" e. On a worksheet tab, click the View Data icon in the Data pane, and click the Export All button.

c. On the Data Source page, select Data. Then select Export Data to CSV d. Right-click the data source name in the data pane, then select "Export data to CSV" e. On a worksheet tab, click the View Data icon in the Data pane, and click the Export All button.

You would like the person using your dashboard to select the year, and based on the year to adjust the interest rate in some related calculated fields. You will like the year selection to limit the data in the view. What Tableau element should you to let the user select the interest rate? a. Dimension Filter b. Context Filter c. Parameter d. Change Set values Dashboard Action

c. Parameter

A bullet chart combines a bar chart with: a. Scatter plot b. Filled bubbles c. Reference lines d. Circle views

c. Reference lines

Which of the following are options for mark sizes? [Select two] a. Stepped b. By calculation c. Reversed d. By parameter e. By range

c. Reversed e. By range

[Display totals on a worksheet] How would you add the overall sales for all segments to the text table shown below? a. Right click the Sales pill, select Quick Table Calculation, then select Grand Total b. Select Analysis on the toolbar, select Totals, then show Row Grand Totals c. Select Analysis on the toolbar, select Totals, then show Column Grand Totals d. Select Analysis on the toolbar, select Totals, then show All Grand Totals e. Select Analysis on the toolbar, select Create Calculated field, enter TOTAL([Sales]) as the calculation, then double click the new calculation to add it to the view

c. Select Analysis on the toolbar, select Totals, then show Column Grand Totals

You would like to divide your customers into two categories - those with sales above a certain threshold and those with sales below that threshold. Which of the following tools will allow you to do this? Select all that apply. a. Hierarchy b. Parameter c. Set d. Calculation

c. Set d. Calculation

Which of the following action types can be used to create proportional brushing? a. URL Action b. Filter Action c. Set Action d. Sheet Action

c. Set Action

You want to create a dual axis chart showing the monthly average "Open" and "Close" values for a stock. The y-axis shows the opening stock price and the x-axis shows the date. What steps should you take? a. Drag and drop the field "Close" to the x-axis. b. Drag and drop the field "Close" to the y-axis. c. Drag the field "Close" to the path mark. d. Drag the field "Close" to the row shelf, then select dual lines on the show me menu

d. Drag the field "Close" to the row shelf, then select dual lines on the show me menu

Your data has a column which should be treated as a date, but when you change the data type to date you see a lot of null values or obviously incorrect dates like 12/30/1899. What can you do next since the date conversion did not work? a. Edit your computer's date settings to that they correspond to the format of the date you're trying to use in Tableau b. Instead of setting the field to Date, set to Date & Time c. Set the type back to string, then try date conversion functions like DateParse and Date d. Switch the metadata grid, then right click the field and select "date format settings"

c. Set the type back to string, then try date conversion functions like DateParse and Date

You have a scatter plot showing sales on the x-axis and profit on the y-axis, with each dot representing a different product subcategory. You want to show how the points on the scatter plot vary based on Net Profit, a third continuous variable. Which would be most appropriate? (Select all that apply) a. Tooltip b. Label c. Size d. Color

c. Size d. Color

[Add relationships to a data source] Which of the following describes a relationship? a. Tables are connected by a flexible noodle in the physical layer b. Tables are connected by a venn diagram in the physical layer c. Tables are connected by a flexible noodle in the logical layer d. Tables are connected by a venn diagram in the logical layer e. Tables are kept as separate data sources, with the highlighted paperclip icon linking them

c. Tables are connected by a flexible noodle in the logical layer

[Display totals on a worksheet] A worksheet with a text table has the dimension PRODUCTS and the measure AVG(Discount). If totals are added to the worksheet, what default method will be used to calculate the totals? a. The total value of discount divided by the number of rows in the text table b. The average of the values in the text table c. The average of discount per row in the underlying data source d. The sum of the values in the text table

c. The average of discount per row in the underlying data source

You connect Tableau to an Excel file which includes a column that has mostly numeric data, but has a few date and text values mixed in. Tableau set the data type for this field as Number. What happens to the date and text values when the data is imported to Tableau? a. The date and text values are both set to null b. The date and text values are both set to zero c. The date values are set to the number of days since 1/1/1900 and the text value is set to null. d. The date values are set to the number of days since 1/1/1900 and the text value is set to zero.

c. The date values are set to the number of days since 1/1/1900 and the text value is set to null

[Assign an alias to a data value] Which of the following can have an alias? a. Field Names b. Values of a continuous measure c. Values of a discrete dimensions d. Values of a discrete measure e. Values of a date field

c. Values of a discrete dimensions

[Explain when to use a join versus a relationship] Which of the following is the best reason to use a relationship instead of a join? a. You are working with multiple tables that you'd like to combine into a single table for analysis b. You know that you'd like unmatched values to be dropped from the secondary tables c. You wish to avoid data duplication when combining tables with different granularity d. You are combining tables based on geographic fields

c. You wish to avoid data duplication when combining tables with different granularity

Which feature will allow you to show more relevant or descriptive dimension values in your view than what the original data provides? a. field renaming b. hierarchy c. alias d. group

c. alias

A histogram shows the distribution of ________ data by creating bins that are _________. a. numeric, continuous b. discrete, continuous c. continuous, discrete d. date, discrete

c. continuous, discrete

[Add joins and unions] Which of the following describes the result of a full outer join? a. The source tables are located on an external source rather than on the Tableau server b. The join is deferred until analysis. The join is executed when a view is created which uses fields from both tables. c. A table that contains values that have matches in both tables. Rows without matches are not included in the result. d. A table that contains all values from both tables. When there is no match on the join criteria, the columns for the table where the match could not be found will have null values. e. The symbol for this join is a Venn diagram with only the overlapping portion filled.

d. A table that contains all values from both tables. When there is no match on the join criteria, the columns for the table where the match could not be found will have null values.

You add two fields to your Tableau view, "Profit" and "Average Profit." When you add Profit to the view, you see a pill with the label, "SUM(Profit)" but when you add Average Profit to the view, you see a pill with the label, "AGG(Average Profit)." Why does one field have SUM and another AGG? a. Each field has default properties, including default aggregation. Profit had SUM set as its default aggregation, while Average Profit had AGG set as its default. b. AGG is applied by default to discrete fields, while SUM is applied to continuous fields. Average Profit was set to discrete, while Profit was set to continuous. c. AGG is applied by default to dimensions, while SUM is applied to measures. Average Profit is a dimension, while Profit is a measure. d. AGG indicates that the "Average Profit" already includes some type of aggregation. "Profit" does not include aggregation, so an aggregate function is applied when the field is added to the view.

d. AGG indicates that the "Average Profit" already includes some type of aggregation. "Profit" does not include aggregation, so an aggregate function is applied when the field is added to the view.

[Create groups by using marks, headers, and the data pane] Which feature would be most helpful in combining all values of a field containing a given string? a. Set b. Bin c. Parameter d. Group e. Where clause

d. Group

Which visualization always represents a measure using color? a. Bar chart b. Scatter plot c. Combo chart d. Highlight table

d. Highlight table

[Display totals on a worksheet] What Total All Using option was chosen for the following view? a. First b. Sum c. Average d. Minimum e. Automatic

d. Minimum

Examine the following view and describe the most likely field type for Order Priority and Sum(Sales) a. Order Priority is a discrete measure, and Sum(Sales) is a discrete dimension. b. Order Priority is a discrete measure, and Sum(Sales) is a continuous measure. c. Order Priority is a discrete dimension, and Sum(Sales) is a continuous dimension. d. Order Priority is a discrete dimension, and Sum(Sales) is a discrete measure.

d. Order Priority is a discrete dimension, and Sum(Sales) is a discrete measure

Which mark type cannot have its size adjusted? a. Circle b. Text c. Line d. Polygon e. Pie

d. Polygon

[Use a quick table calculation] What steps would you follow to create a cumulative sum of the values shown in the view? a. On the analytics pane, click totals and drag into the view. The Add to totals menu will appear. Release on the "Running Total" option. b. On the analytics pane, click totals and drag into the view. The Add to totals menu will appear. Release on the "Cumulative sum" option. c. Right-click the pill for the measure in the view, select quick table calculation and then select "cumulative sum" d. Right-click the pill for the measure in the view, select quick table calculation and then select "running total"

d. Right-click the pill for the measure in the view, select quick table calculation and then select "running total"

Which type of visualization is not typically effective in showing change over time? a. Bar Chart b. Line Chart c. Area Chart d. Scatter Plot

d. Scatter Plot

[Use a quick table calculation] A worksheet has a line graph showing sales by month. How could this be modified to show total sales to date for each month? a. Right-click Sales, then select the Quick Table calculation menu option, then select YTD b. Right-click Sales, hover over Measure(Sum) and then change the aggregation to cumulative sum c. Right-click Sales, hover over Measure(Sum) and then change the aggregation to running total d. Right-click Sales, then select the Quick Table calculation menu option, then select cumulative sum e. Right-click Sales, then select the Quick Table calculation menu option, then select running total

e. Right-click Sales, then select the Quick Table calculation menu option, then select running total

[Explain when to use a join versus a relationship] Which of the following are reasons to use a join rather than a relationship? a. To ensure that each worksheet queries only the tables necessary to create the view. b. To combine data at different levels of granularity without introducing duplication c. To specify on table as primary and another as secondary d. To append rows from one table to rows from another table e. To create an extract using the denormalized table

e. To create an extract using the denormalized table