As part of the AnalyticsPOC project, you need to determine the most suitable type of data store for the workspace. The chosen data store must meet the following criteria:
- Support for semi-structured and unstructured data.
- Capability to store files in Parquet format that comply with Delta Lake specifications.
- Accessibility for read operations using either T-SQL or Python.
- Provision of row-level security (RLS) specifically for T-SQL queries.
- Capability to handle both raw data and cleansed data transformations.
Which type of data store would you recommend?