Tableau Desktop Specialist questions with complete solutions 2023

Live Data Connection - correct answer -default -creates slower performance -updates automatically Extract - correct answer -snapshot of data -better performance -refresh snapshot Data Source - correct answer -TDS -save all changes, metadata, default prop -don't save data itself -data sources-add to data sources Packaged Data Source - correct answer -TDSX -metadata + local copy of data TWB - correct answer -workbook -without data TWBX - correct answer -workbook -with data HHYPER - correct answer -extract Shadow Extracts - correct answer -up to 5 -hidden, temp files -helps process TB queries faster Relationships - correct answer -default/logical layer -drag table to right -dynamic, flexible way to combine data from multiple tables -results in 2 separate tables Results in 2 separate tables - correct answer relationships Joins - correct answer -physical layer -double click and on Data 1 + drag Data 2 -need common column connection -can create from a calc Merge 2 tables to 1 - correct answer Joins Cross-database join - correct answer -row-level join -diff databases Unions - correct answer -add rows not cols -tables should have same: col #, col name, data type -drag and drop Data 1, then Data 2 on top of or under Data 1 -double click new union unions add - correct answer rows Use blends when (4) - correct answer -cross-database join not supported -tables at diff LOD