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. When connecting to a PDF file in Tableau Desktop, which of the following is a key limitation?

    Answer: Only text content is extracted; charts and images are ignored

    When Tableau connects to a PDF, it extracts tabular text data only; graphical charts and images within the PDF are not parsed into usable data.

  2. Which Tableau feature allows you to combine rows from two data sources that share the same fields and structure?

    Answer: Union

    Union stacks rows from tables with matching column structures into a single combined table, unlike joins which combine columns.

  3. In Tableau, what is the purpose of the 'Input' step in Tableau Prep Builder when building a flow?

    Answer: To specify the data source and initial connection settings

    The Input step in Tableau Prep Builder is where you connect to your data source and configure initial connection settings such as filters and sampling.

  4. What happens to NULL values when you create a wildcard union in Tableau?

    Answer: Columns that don't exist in a particular sheet are filled with NULL

    In a wildcard union, when sheets have differing columns, Tableau fills the missing column values with NULL for rows sourced from sheets that lack those columns.

  5. Which connection type should you choose if you want Tableau to store a copy of the data locally for faster performance?

    Answer: Extract connection

    An Extract connection saves a snapshot of the data in Tableau's .hyper format locally, enabling faster query performance independent of the original data source.

  6. When editing a relationship between two tables in Tableau's data model, what is the default join type used behind the scenes?

    Answer: Left outer join

    Relationships in Tableau use left outer joins by default, preserving all records from the primary table even when no match exists in the related table.

  7. A user wants to connect to a Google Sheets file in Tableau Desktop. Which authentication method is required?

    Answer: Google account OAuth sign-in

    Connecting to Google Sheets in Tableau Desktop requires authenticating via Google's OAuth flow using a Google account.