Practice Test GeeksTableau Practice Test
← All Tableau Flashcard Decks

Data Connections and Preparation Flashcards

7 cards from real Tableau practice questions. Tap to flip, then mark Knew It or Still Learning — missed cards come back until you master them.

Read the first 7 Data Connections and Preparation flashcards as text

  1. What is the effect of selecting 'Hide All Unused Fields' when publishing a data source in Tableau?

    Answer: Hides fields not currently used in any workbook sheet, reducing clutter for consumers

    'Hide All Unused Fields' hides fields that aren't actively used in any sheets, making the published data source easier to navigate without deleting data.

  2. Which of the following is NOT a supported connector in Tableau Desktop's built-in connector library?

    Answer: Apache Kafka (direct)

    Tableau does not have a native direct connector for Apache Kafka; connecting to Kafka typically requires a third-party solution or custom integration.

  3. When performing a left join between Table A (orders) and Table B (returns) in Tableau, what appears in the result for orders with no matching return record?

    Answer: Those order rows appear with NULL values for all return fields

    In a left join, all rows from the left table (orders) are preserved; where no match exists in the right table, the right table's fields contain NULL.

  4. What is the purpose of an 'Initial SQL' statement in a Tableau data connection?

    Answer: To run a SQL command on the database when the connection is first established

    Initial SQL runs a specified SQL command immediately when Tableau establishes the database connection, often used to set session variables or temporary tables.

  5. A Tableau workbook uses a live connection to a slow database. Which approach would most improve dashboard load time without changing the data source type?

    Answer: Convert the live connection to a Tableau extract

    Converting a slow live connection to a Tableau extract stores optimized data locally in a .hyper file, significantly improving query and dashboard load performance.

  6. Which of the following best describes 'schema on read' as it applies to Tableau's flexible data model with relationships?

    Answer: Related tables are only joined when a visualization actually requires fields from both tables

    With relationships, Tableau defers joining related tables until a visualization requires fields from multiple tables, dynamically determining the appropriate join at query time.

  7. When connecting Tableau to a flat file (CSV or Excel), how does Tableau determine the data type of each column?

    Answer: Tableau scans the first 10,000 rows and infers data types automatically

    Tableau automatically infers column data types by sampling the file's data (typically the first 10,000 rows), though these can be manually overridden in the data source view.