What should the consultant do to create and publish the data?

A company has a data source for sales transactions.

The data source has the following characteristics:

– Millions of transactions occur weekly.

– The transactions are added nightly.

– Incorrect transactions are revised every week on Saturday.

– The end users need to see up-to-date data daily.

A consultant needs to publish a data source in Tableau Server to ensure that all the transactions in the data source are available.

What should the consultant do to create and publish the data?
A . Publish an incremental extract refresh every day and perform a full extract refresh every Saturday.
B . Publish a live connection to Tableau Server.
C . Publish an incremental refresh every Saturday.
D . Publish an incremental extract refresh every day and publish a secondary data set containing data revisions.

View Answer

Answer: A

Explanation:

Given the need for up-to-date data on a daily basis and weekly revisions, the best approach is to use an incremental extract refresh daily to update the data source with new transactions. On Saturdays, when incorrect transactions are revised, a full extract refresh should be performed to incorporate all revisions and ensure the data’s accuracy. This strategy allows end users to have access to the most current data throughout the week while also accounting for any necessary corrections12.

References: The solution is based on best practices for managing data sources in Tableau Server, which recommend using incremental refreshes for frequent updates and full refreshes when significant changes or corrections are made to the data12.