Exam DP-500 topic 1 question 69 discussion

I took the exam a few days ago (14/8/2023) and I passed the exam with a score of 915. My answer was: Apache Parquet

From Chatgpt: By using Apache Parquet format for the external table, you can minimize the query execution time for serverless SQL pools in Azure Synapse Analytics because: Columnar storage: Apache Parquet stores data in a columnar format, which allows for highly efficient and fast data access. This means that queries against the external table can be executed faster because only the relevant columns are read. Compression: Apache Parquet uses a highly efficient compression algorithm, which reduces the size of the data on disk. Smaller data size means less data to transfer, which results in faster query execution time. Partitioning: Apache Parquet supports partitioning, which allows you to subdivide the external table into smaller, more manageable files. When querying the table, only the relevant partitions are scanned, which makes query execution faster. Overall, by using Apache Parquet for the external table, you can significantly reduce the amount of time it takes for a serverless SQL pool to execute a query against the table, making it a more performant solution for analyzing large datasets.

Well, this link doesn't give the answer directly, but MS indirectly states that you should use Apache Parquet files for your SQL serverless pool. https://learn.microsoft.com/en-us/azure/synapse-analytics/get-started-analyze-sql-on-demand

D is correct