Ultimate access to all questions.
You have an Azure Storage account containing 100 GB of files with rows of text and numerical values. Seventy-five percent of the rows contain description data averaging 1.1 MB in length. You need to prepare the files to ensure a fast copy to an enterprise data warehouse in Azure Synapse Analytics.
Proposed Solution: Copy the files to a table that has a columnstore index.
Does this solution meet the goal?