True or False: All rows from both tables are returned in an INNER JOIN
Answer(s): B
The INNER JOIN keyword selects all rows from both tables as long as there is a match between the columns. Consider 2 tables "Orders" and "Customers".If there are records in the "Orders" table that do not have matches in "Customers", these orders will not be shown!
https://www.w3schools.com/sql/sql_join_inner.asp
Is SUM a table calculation?
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.The most common Table calculations are: Running TotalPercent Difference Difference Percent of Total RankPercentileThese can be calculated using: Table(across), Cell, or Specific dimensions!
https://help.tableau.com/current/pro/desktop/en-us/calculations_tablecalculations_definebasic_runningtotal.htm
By default, measures placed in a view are aggregated by ____________.
Answer(s): D
By default, measures placed in a view are aggregated by SUM, which means that the data for that field in all of the rows is combined. Measures can also be aggregated as average, median, count, or count distinct.
https://help.tableau.com/current/pro/desktop/en-us/calculations_aggregation.htm
_____________ refers to the level of detail for a piece of data, wherever you are looking.
Data is generated and analyzed at many different levels of granularity. Granularity is the level of detail of the data. For example, when looking at graduation data, granularity would describe whether a row in the data set represents a single person or the graduating class of a university.
https://www.tableau.com/about/blog/2018/6/data-prep-101-what-aggregate-function-and-how-do-you-combine-aggregated-data-89244
Post your Comments and Discuss Tableau Desktop-Specialist exam with other Community members:
baba Commented on January 03, 2025 want to learn Anonymous