Analytics-DA-201 - Connect to and Transform Data (24% of the exam) - Section 1.1
Connect to files, relational databases, extracts, and published data sources, choose between live connections and extracts, and replace the data source for an existing sheet.
Practice question for this objective
lock_openFree sampleConnect to and Transform Datamedium
An analyst finishes a dashboard built on a development extract file and now needs it to run against a published data source on Tableau Server that exposes an identically structured table. They open Replace Data Source and choose the published source as the replacement. Which detail most determines whether every worksheet keeps working after the replace?
AWhether the original development extract and the published source share the same file path on disk, so Tableau can relink the .hyper location.
BWhether the replacement source contains exactly the same number of rows as the development extract, so the row counts reconcile during the replace.
CWhether the analyst first converts the published source back to a live connection, because replace cannot target a published data source.
DWhether the published replacement source exposes field names that match those the worksheets and calculations already reference, so the references resolve cleanly.check_circle Correct
Replace Data Source remaps references by field name, so matching field names in the replacement keep worksheets and calculations working. When you replace a data source, Tableau rebinds each worksheet and calculated field to fields in the new source by matching names; references resolve cleanly only when the replacement exposes the same field names the workbook already uses.
Why A is wrong: A published data source has no local file path to match; replace works by remapping field references, not by aligning extract file locations.
Why B is wrong: Row counts are irrelevant to whether references resolve; replace cares about matching fields, and views happily show whatever rows the new source returns.
Why C is wrong: A published data source is a valid replacement target, and no conversion is needed; the deciding factor is field-name matching, not connection type.
Why D is correct: Replace Data Source remaps references by matching field names; when the replacement exposes the same field names, worksheets and calculations bind to them and keep working.
Answers that look right on this material and are not. Each one is a distractor from a different question in the Analytics-DA-201 bank for this domain.
Delete each worksheet and rebuild it from scratch against a fresh connection to the production server.
errorWhy it is wrong: Rebuilding discards the existing layout and calculations unnecessarily; replacing the data source preserves the work when the structure matches, so a full rebuild is wasted effort.
Only the dashboard layout containers, while every worksheet built on the old source is deleted and must be rebuilt from scratch.
errorWhy it is wrong: Replace Data Source keeps the worksheets and remaps them rather than deleting them. Layout containers are not the only thing retained, so this overstates the loss.
The replacement source must contain exactly the same number of rows as the original, or the replace operation refuses to complete.
errorWhy it is wrong: Replace Data Source maps fields, not rows, so a differing row count is allowed and does not block the operation, making this tempting but wrong.