SALESFORCE TABLEAU
DESKTOP FOUNDATIONS
PRACTICE TEST 40
QUESTIONS
Question 1: A sales dashboard must re�ect transactions entered in the source database within seconds of a refresh of the view. Which connection type is most appropriate when the database can handle the query load?
Choices:
1) A Tableau extract refreshed once per day 2) A packaged workbook with embedded data 3) A static CSV export 4) A live connection
Correct Answer: A live connection
Explanation: A live connection queries the source system when Tableau requests data, so it is the best choice when the view needs the most current source values and the database can support the workload.Page 1
Question 2: An analyst wants to save connection information and default �eld properties such as number formats for reuse, but does not need to package the underlying data. Which Tableau �le type is designed for this purpose?
Choices:
1) .twbx 2) .hyper 3) .tds 4) .csv
Correct Answer: .tds
Explanation: A Tableau Data Source �le (.tds) stores connection and metadata information, including �eld properties. It does not package the underlying data the way a packaged data source can.Question 3: A workbook uses a large cloud table that is slow to query repeatedly.The analyst can tolerate data that is refreshed each morning. What is the best reason to create a Tableau extract?
Choices:
1) To force every �eld to become discrete 2) To replace all calculations with source columns 3) To improve query performance while using a scheduled snapshot of the data 4) To convert the workbook automatically into a story Correct Answer: To improve query performance while using a scheduled snapshot of the data Explanation: An extract stores a snapshot of data in Tableau's extract format and can improve analytical performance. The tradeo� is that the extract must be refreshed to re�ect source changes.Page 2
Question 4: Orders are stored at order-line detail while Targets are stored once per month and region. The analyst wants to combine them while minimizing duplicated target values. Which modeling approach is generally preferred?
Choices:
1) Inner join the tables on Region only 2) Relate the logical tables at the appropriate matching �elds 3) Union the two tables 4) Cross join the tables Correct Answer: Relate the logical tables at the appropriate matching �elds Explanation: Relationships keep logical tables distinct and allow Tableau to query them at the level of detail needed by the visualization. This helps avoid row duplication that a physical join can introduce when tables have di�erent granularities.Question 5: Two monthly CSV tables have the same columns: Order ID, Order Date, Customer, and Sales. The analyst wants one table containing the rows from both months. Which operation should be used?
Choices:
1) Union 2) Join 3) Relationship 4) Data blend
Correct Answer: Union
Explanation: A union appends rows from one table to another when the tables have compatible structures. Joins and relationships combine tables by matching �elds rather than stacking rows.Page 3