Salesforce Certified Tableau Consultant Practice Questions

Salesforce Certified Tableau Consultant exam preparation

Salesforce Certified Tableau Consultant practice questions in English: 180 questions with explanations. The mock exam has 60 questions and 105 minutes.

Salesforce Certified Tableau Consultant free question 9 / 10 · Domain 4: Establish Governance and Support Published Content

An auditor asks how long Tableau Server keeps historical user activity in the repository by default and which setting controls that period. Which answer matches the Help page?

  1. 183 days by default, set with wgserver.audit_history_expiration_days for the hist_ tables
  2. 183 days by default, set with auditing.enabled for the hist_ tables
  3. About 30 days by default, set with wgserver.audit_history_expiration_days for the hist_ tables
  4. 7 days by default, cleared with tsm maintenance cleanup for the hist_ tables
Show the answer and explanation

Answer: A

Why this is correct
All hist_ tables, which hold the history of events, are controlled by the tsm configuration set option wgserver.audit_history_expiration_days. That option controls how many days of event history are kept in the repository, and its default value is 183 days. Whether Tableau Server collects historical user activity at all is controlled by a different option, auditing.enabled, which is enabled by default.

Why the other options are wrong
"About 30 days by default, set with wgserver.audit_history_expiration_days for the hist_ tables" … The period of 30 days belongs to the _background_tasks table, which is cleaned automatically. The hist_ tables have a default value of 183 days.
"183 days by default, set with auditing.enabled for the hist_ tables" … The auditing.enabled option controls whether historical user activity is collected at all, and it is enabled by default. The number of days is set by another option.
"7 days by default, cleared with tsm maintenance cleanup for the hist_ tables" … The 7-day cleanup applies to the _http_requests table, when the cleanup runs with the --http-requests-table option. It does not apply to the hist_ tables.

Key points
Collecting historical events affects the size of the backup file (.tsbak). The _background_tasks table keeps data for the last 30 days, and the _http_requests table is cleaned by a separate cleanup option.

Go to the Salesforce Certified Tableau Consultant practice app (10 free questions; purchase unlocks all questions)

See the full practice set