You have an on-premises Microsoft SQL Server database named DB1. You plan to migrate DB1 to an Azure SQL database named DB2 by using the Data Migration Assistant (DMA). What will be migrated?

The correct answer is B. functions, stored procedures, views, and roles. The Data Migration Assistant (DMA) primarily migrates SQL Server databases. It helps assess and migrate on-premises SQL Server databases to newer versions of SQL Server or to Azure SQL Database. Specifically, DMA moves the schema, data, and uncontained objects from a source…

Submitted by rohit_dlh· Mar 6, 2026Plan and implement data platform resources

Question

You have an on-premises Microsoft SQL Server database named DB1. You plan to migrate DB1 to an Azure SQL database named DB2 by using the Data Migration Assistant (DMA). What will be migrated?

Options

Afunctions, roles, trace flags, and views
Bfunctions, stored procedures, views, and roles
Cagent jobs, functions, stored procedures, and views
Dfunctions, operators, stored procedures, and views

How the community answered

(26 responses)

A
4% (1)
B
73% (19)
C
15% (4)
D
8% (2)

Explanation

The Data Migration Assistant (DMA) primarily migrates SQL Server databases. It helps assess and migrate on-premises SQL Server databases to newer versions of SQL Server or to Azure SQL Database. Specifically, DMA moves the schema, data, and uncontained objects from a source server to a target server. The migration workflow helps you to migrate the following components: Schema of databases SQL Server and Windows logins https://learn.microsoft.com/en-us/sql/dma/dma-overview?view=sql-server-ver17

Topics

#Data Migration Assistant#schema migration#database objects#DMA capabilities

Community Discussion

No community discussion yet for this question.

Full DP-300 Practice