Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution. After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen. You have an Azure Synapse Analytics dedicated SQL pool that contains a table named Table1. You have files that are ingested and loaded into an Azure Data Lake Storage Gen2 container named container1. You plan to insert data from the files into Table1 and transform the data. Each row of data in the files will produce one row in the serving layer of Table1. You need to ensure that when the source data files are loaded to container1, the DateTime is stored as an additional column in Table1. Solution: You use an Azure Synapse Analytics serverless SQL pool to create an external table that has an additional DateTime column. Does this meet the goal?

The proposed solution is to create an external table using a serverless SQL pool. An external table in a serverless SQL pool is a metadata definition that allows you to query data directly from files in Azure Data Lake Storage. This action does not, by itself, load, insert, or move any data into Table1, which resides in a separate dedicated SQL pool. The primary goal is to populate Table1 in the dedicated SQL pool with the source data plus an additional DateTime column. Since the solution only defines a way to read the source data and does not perform the required data insertion into the target table, it fails to meet the goal.

A. The solution is incorrect because creating an external table is only a preparatory step for querying data in the lake; it does not accomplish the required task of loading the data into the dedicated SQL pool table.

1. Microsoft Documentation. (2023). Query storage files with serverless SQL pool in Azure Synapse Analytics. Microsoft Learn. Retrieved from https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/query-data-storage. This document clarifies that serverless SQL pools are for querying data in place ("schema-on-read")

not for loading it into other storage systems like dedicated pools.

2. Microsoft Documentation. (2023). Data loading strategies for dedicated SQL pool in Azure Synapse Analytics. Microsoft Learn. Retrieved from https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/design-elt-data-loading. This article outlines the correct methods for loading data into a dedicated SQL pool

such as using the COPY statement or PolyBase

none of which are mentioned in the proposed solution.

3. Microsoft Documentation. (2023). CREATE EXTERNAL TABLE (Transact-SQL). Microsoft Learn. Retrieved from https://learn.microsoft.com/en-us/sql/t-sql/statements/create-external-table-transact-sql?view=azure-sqldw-latest&preserve-view=true&tabs=serverless. The documentation specifies that this statement creates a table that references data stored externally

confirming it does not perform a data load operation.