SCA-C01 practice question 12 of 25

Which of the following IS NOT a correct strategy to maximize backup efficiency in Tableau Server?

Full set: 186 questions
Answer options
A: Co-locating the Data Server with the Administration Controller node Correct answer
B: Co-locating File Store on the same node as the Administration Controller
C: Co-locating the repository (pgsql) with the Administration Controller node
Correct Answer:
A. Co-locating the Data Server with the Administration Controller node
Explanation

The Tableau Server backup process primarily involves creating a snapshot of the PostgreSQL repository and the File Store. To maximize efficiency, these components should be on the same node as the Administration Controller, which orchestrates the backup. This co-location minimizes network latency and data transfer time. The Data Server process manages connections to data sources but does not contain the primary data (extracts) or metadata that constitute the bulk of the backup. Therefore, co-locating the Data Server with the Administration Controller does not provide a direct efficiency gain for the backup process itself.

Why Incorrect

B. Co-locating File Store is a correct strategy. It contains large data extracts, and local access during backup significantly reduces network overhead and time.
C. Co-locating the repository is a correct strategy. It avoids network latency when dumping the PostgreSQL database, which is a critical part of the backup.

References

1. Tableau Server Help. "Optimize a Backup". In the section "Optimize a backup with process co-location," it states: "The backup process puts a heavy load on the repository and file store... To get the best performance for backups, you should configure the repository and file store (if you are running it) on the same node as the TSM Controller (Administration Controller)." This explicitly recommends B and C, and omits A. (Document Version: 2023.3)

2. Tableau Server Help. "Tableau Server Processes". This document describes the function of each process. The description for Data Server does not mention any role in the tsm maintenance backup process, unlike the descriptions for Repository and File Store. (Document Version: 2023.3)

Scroll to Top