Tableau Desktop Specialist Certification Exam | Complete Questions & Answers (Rated A+)

Tableau Desktop Specialist Certification Exam | Complete Questions & Answers (Rated A+) Tableau Desktop Specialist Certification Exam | Complete Questions & Answers (Rated A+) Live vs. extracts data connection - ANSWER - LIVE - changes will be shown automatically - creates slower performance for huge data - Server availability could be a problem - Best to use when numbers HAVE to be correct EXTRACT - creates a static snapshot of your data - better performance and portability - save and refresh the snapshot - best to use when numbers aren't as important How to save metadata properties in a .TDS - ANSWER - 1. go to the sheet 2. right click on the data source 3. select 'Add to Saved Data Sources' 4. make sure the end of the file ends in .TDS When is it best to use a blend? - ANSWER - 1. Cross-database join is not supported 2. Tables are at different LOD 3. Joins create duplicate data or data cleaning is required 4. If you have a lot of data and the join is time consuming How do you rename a data field? - ANSWER - Right click on the data field and select 'rename' How to assign an alias to a data value? - ANSWER - Right click a dimension and select 'Aliases". In the edit aliases dialog box, under value, select a member and enter a new name How to assign a geographic role to a data field? - ANSWER - click the data type icon next to the field and select 'geographic role'. then select the geographic role you want to assign to that field Change data type for a data field (number, date, string, boolean, etc) - ANSWER - A. On the data source page, click on the icon associated with the field and select the new data type B. In the data pane, if you right click on the field and scroll down to 'change data type' Change default properties for a data field (number format, aggregation, color, date, format, etc) - ANSWER - In the data pane, right click on the field, scroll down to 'default properties' and change the desired value