You have an on-premises Oracle database named DB1. You have an Azure subscription that contains an Azure Synapse Analytics workspace named WS1. You need to migrate DB1 to a dedicated SQL pool in WS1.

The correct answer is A. SQL Server Migration Assistant (SSMA). Tools for Oracle data warehouse migration to Azure Synapse Analytics SQL Server Migration Assistant (SSMA) SQL Server Migration Assistant (SSMA) for Oracle can automate many parts of the migration process, including in some cases functions and procedural code. SSMA supports Azure

Submitted by klara.se· Mar 6, 2026Design data storage solutions

Question

You have an on-premises Oracle database named DB1. You have an Azure subscription that contains an Azure Synapse Analytics workspace named WS1. You need to migrate DB1 to a dedicated SQL pool in WS1. The solution must minimize migration effort. What should you use?

Options

ASQL Server Migration Assistant (SSMA)
BAzure Database Migration Service
CAzure Migrate
DData Migration Assistant (DMA)

How the community answered

(51 responses)

A
80% (41)
B
6% (3)
C
2% (1)
D
12% (6)

Explanation

Tools for Oracle data warehouse migration to Azure Synapse Analytics SQL Server Migration Assistant (SSMA) SQL Server Migration Assistant (SSMA) for Oracle can automate many parts of the migration process, including in some cases functions and procedural code. SSMA supports Azure Synapse as a target environment. SSMA for Oracle can help you migrate an Oracle data warehouse or data mart to Azure Synapse. SSMA is designed to automate the process of migrating tables, views, and data from an existing Oracle environment. https://learn.microsoft.com/en-us/azure/synapse-analytics/migration-guides/oracle/6-microsoft- third-party-migration-tools

Topics

#SSMA#Oracle migration#Azure Synapse Analytics#database migration tools

Community Discussion

No community discussion yet for this question.

Full AZ-305 Practice