Big Data II

Q17. What is the maximum number of Columns in a Table

16 columns

26. Which of the following fields will have AGG in front of it when you add it to the view?

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

Q13. Which of the descriptions below describes a Tableau Story

A contains a sequence of worksheets or dashboards that work together to convey information

19. Which of the following is true?

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

25. 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 dimension

11. Which of the following can you use to create a calculated field that shows the change from the prior month total? Select all that apply

A table calculation.

25. 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?

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.

3. After setting up two data source connections, how can you create a blend?

Add at least one field from the primary data source to your view. Then, in the Data pane, click the data source that you want to designate as the secondary data source and click the broken link icon.

27. Which of the following will increase the granularity of the view?

Adding a dimension to the marks area

13. Which of the following will result in an error

Aggregation on a field that is already aggregated

Q19. In a Calculated Field, the following will be interpreted as a comment

Anything after // will be treated as a comment

4. Which of the following uses a primary and secondary data source?

Blending

Q11. In the Data Pane, Discrete values are which color?

Blue

11. Which types of plots are most often used to visualize the distribution of a single continuous measure? (select all that apply)

Box Plot.Histogram.

28. Which of the following functions can be used on string to create a measure?

COUNTD

13. Bins can be created for which type of field?

Continuous Measure

Q7. In the Data Pane, what sections do you have?

Dimensions, Measures, Sets and Parameters

Q18. Which of the following is NOT a Mark Type

Doughnut

Q1. As of Tableau 2018.3, Tableau is only available on a Windows Operating System?

FALSE because it is availabe in other Operating Systems

Q9. When creating Hierarchies in Tableau, you are limited to three levels of hierarchy

FALSE, you ae not limited to three levels

2. When creating a union between tables, what will happen if the field names do not match?

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

21. 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)

Filter Action.Highlight Action.

Q8. Which of the following is NOT a Tableau Field data type?

Float

9. In the Southern Region Superstore data, the Product Category, Product Subcategory, and Product Name might be combined using which of the following:

Hierarchy

23. You start with a blank worksheet and add a continuous field to the row shelf. How will this new field change your view?

It will add a vertical axis

4. This type of join will include all values from the left table:

Left

1. 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:

Live Connection

Q6. In Tableau, Data Blending is where you?

Merge data from two (or more) data sources within a Tableau Worksheet

29. You have SUM([Minutes of Delay]) in your view. If aggregate measures is unchecked, what will the view show instead of SUM([Minutes of Delay])?

Minutes of Delay

2. Which file type can include an extract? Select all that apply.

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

Q12. Which of the following Data Pane items cannot be dragged onto the Filters Shelf

Parameters

12. A bullet chart combines a bar chart with:

Reference lines

10. Which chart type will best visualize the relationship between two continuous measures?

Scatter Plot

24. 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)

Size.Color.

3. Which of the following is not a default property which can be set for a measure?

Sort

11. Which of the following is a table calculation?

TOTAL

Q14. You can add additional Color palettes to Tableau

TRUE, You can add additional Color schema to Tableau by editing your Preferences.tps file.

Q20. We can extend the functionality of Tableau through Third-Party companies

TRUE, it can be extended

Q5. A Tableau Workbook can contain multiple data sources from different source systems?

TRUE, it can contain multiple data sources

Q15. When using data source Fields in Calculated Fields, the Square brackets are optional

TRUE, this is actually optional providing there are no spaces in the Field name.

Q10. In the Data Pane, you can choose "Group by Folders" or "Group Data Source Table"

TRUE, we can chose either

Q2. Which of the following is NOT a Tableau Desktop application?

Tableau Express

29. Your view has a numeric field set as a discrete measure and a dimension. Which of the following visualizations can you create with these fields? (select all that apply)

Text tables

21. Editing the font at the worksheet level applies the changes you make to all text fields in view except for which of the following? (select all that apply)

Tooltip

20. The most important items on a dashboard should be positioned where?

Upper Left

Q16. If you want to replace one Field with another without breaking your worksheet

Use the Replace References feature

24. Which of the following describes the Measure Names field (select all that apply)

When you create a view with multiple measures on a single continuous axis, Tableau will automatically add Measure Names to the view.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.

1. Which of the following is an example of metadata that can be managed in Tableau? Select all that apply.

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

1. Which of the following is the best reason to create a saved data source as a .TDS file

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

2. Which feature will allow you to show more relevant or descriptive dimension values in your view than what the original data provides?

alias

Q3. Which of the following files types contains a Tableau Workbook along with local data?

twbx

27. A histogram shows the distribution of ________ data by creating bins that are _________.

continuous, discrete

Q4. Which of the following is not a Tableau file type?

tdx