Certified Marketing Cloud Administrator Exam: Retention of Inactive Data in Data Extensions

Clearing Inactive Data in Data Extensions - Best Practices

Question

To prevent retention of stagnant data, Northern Trail Outfitters wants any inactive data stored in data extensions to be cleared after 12 months.

What action should be taken?

Answers

Explanations

Click on the arrows to vote for the correct answer

A. B. C.

A

The best option to address Northern Trail Outfitters' requirement of clearing inactive data stored in data extensions after 12 months is to apply Row-Based Retention to each data extension as it is created, set to 12 months.

Option A is the correct answer as it offers the most precise solution to meet the business requirements. By applying Row-Based Retention, Marketing Cloud will automatically remove data rows that meet the specified criteria from the data extension. In this case, data rows that are inactive for more than 12 months will be deleted. This solution ensures that only inactive data is deleted, which optimizes data storage and reduces data management overheads.

Option B is not the best choice because it configures the business unit's data retention setting for all data extensions in the unit. This approach could lead to the loss of useful data that may be needed for future analysis or business purposes.

Option C is not an appropriate solution as it only clears the data after one year, but it doesn't remove it entirely. Thus, it is not a feasible solution for a company that wants to optimize data storage and reduce data management overheads.

In conclusion, the recommended action for Northern Trail Outfitters to prevent retention of stagnant data is to apply a Row-Based Retention to each data extension as it is created, set to 12 months.