Salesforce Analytics-Admn-201 Exam - Topic 4 Question 5 Discussion

In Tableau, data sources can be embedded (stored within a workbook) or published (stored separately on Tableau Server). Let's define these and analyze the advantages:

Embedded Data Source: The connection details and any extract are bundled in the .twb or .twbx file. Each workbook manages its own copy.

Published Data Source: The connection or extract is hosted on Tableau Server, reusable across multiple workbooks.

Now, let's evaluate the options:

Option C (Centralized data management is easier): Correct. Published data sources allow:

Single source of truth: One data source can serve multiple workbooks, ensuring consistency.

Unified updates: Refresh schedules, permissions, and metadata (e.g., calculated fields) are managed in one place via the Server UI.

Governance: Administrators can control access and monitor usage centrally.

In contrast, embedded data sources require individual updates per workbook, leading to duplication and management overhead.

Option D (Storage space is conserved and resource usage during data refreshes is optimized): Correct. With published data sources:

Storage: A single extract on the Server (e.g., a .hyper file) is shared across workbooks, avoiding redundant copies stored in each embedded workbook.

Refreshes: One refresh job updates the shared extract, reducing CPU and memory usage compared to multiple refreshes for duplicate embedded extracts.

Embedded data sources replicate extracts, increasing disk space and refresh load.

Option A (Data is protected so that it is only available in one workbook): Incorrect. This describes embedded data sources, not published ones. Published data sources are shared, not restricted to one workbook---permissions control access, not exclusivity.

Option B (Drivers are automatically installed on each client's machine): Incorrect. Drivers (e.g., for SQL Server, PostgreSQL) must be installed on the Server hosting the published data source, not client machines. This is unrelated to the published vs. embedded distinction.

Why This Matters: Published data sources enhance scalability and efficiency in enterprise deployments, making them a cornerstone of Tableau Server's data strategy.