Question

A retail analytics team enables Azure Synapse Link on a Cosmos DB for NoSQL container. The transactional data must be purged after 30 days to control storage costs, but the data science team needs to query up to 2 years of historical data through the analytical store via Synapse serverless SQL pools. How should the team configure retention to meet both requirements?

Accepted Answer

Set the container's transactional TTL to 30 days and set a separate analytical store TTL (AnalyticalStoreTimeToLiveInSeconds) to approximately 2 years.

Answer

Set the transactional TTL to 2 years so the analytical store retains the same data, then filter to 30 days in transactional queries.

Answer

Set the analytical store TTL to 30 days and rely on change feed to archive older records into blob storage for the 2-year requirement.

Answer

Disable TTL entirely because enabling Synapse Link automatically retains all analytical data for 2 years by default.