Exam DP-203 topic 2 question 101 discussion

Given answer is wrong. It should be BEGIN TRAN as SQL pool in Azure Synapse Analytics does not support distributed transaction. https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-develop-transactions "Limitations SQL pool does have a few other restrictions that relate to transactions. They are as follows: No distributed transactions No nested transactions permitted No save points allowed No named transactions No marked transactions No support for DDL such as CREATE TABLE inside a user-defined transaction " Distributed Transactions are only allowed in SQL Server and Azure SQL Managed Instance: https://learn.microsoft.com/de-de/sql/t-sql/language-elements/begin-distributed-transaction-transact-sql?view=sql-server-ver16

Its BEGIN TRAN then ROLLBACK TRAN

The answers they provide here are a joke. The soltuion is Begin Tran not Begin Distributed Transaction. https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/develop-transactions

ChatGPT 4o code: BEGIN TRANSACTION; BEGIN TRY -- Insert data from staging table to target table INSERT INTO target_table (column1, column2, ...) SELECT column1, column2, ... FROM staging_table; -- Commit the transaction if no error occurs COMMIT TRANSACTION; END TRY BEGIN CATCH -- Rollback the transaction if an error occurs ROLLBACK TRANSACTION; -- Optionally, you can log the error or re-throw it -- SELECT ERROR_MESSAGE() AS ErrorMessage; -- THROW; END CATCH;

BEGIN TRAN ROLLBACK TRAN

BEGIN TRAN & ROLLBACK TRAN

It should be BEGIN TRAN and ROLLBACK TRAN

BEGIN TRAN ROLLBACK TRAN