Hi Manoj,
From my experience, the main differences are:
- cost - you are charged for archive queries
- speed - since you're querying the archive data the latency will be much slower
- availability of data - the data you are querying is only the archived data, not the data in the log analytics workspace.
Also you would not use archived logs for anything in Sentinel except ad-hoc kql queries.
References:
https://azure.microsoft.com/en-us/pricing/details/monitor/
https://learn.microsoft.com/en-us/azure/azure-monitor/logs/restore?tabs=api-1