AZ-305 · Question #149
A company has the following on-premise data stores: - A Microsoft SQL Server 2012 database - A Microsoft SQL Server 2008 database The data needs to be migrated to Azure. - Requirement 1 - The data…
The correct answer is D. Data Migration Assistant. The Data Migration assistant can be used to migrate the data. It has support for various versions of Microsoft SQL Server as shown below: Option A is incorrect since this works with data in Azure storage accounts Option B is incorrect since this is used for migration of data to…
Question
Exhibit
Options
- AAzCopy
- BAzure CosmosDB Data Migration tool
- CData Management Gateway
- DData Migration Assistant
How the community answered
(48 responses)- A2% (1)
- B2% (1)
- C6% (3)
- D90% (43)
Explanation
The Data Migration assistant can be used to migrate the data. It has support for various versions of Microsoft SQL Server as shown below: Option A is incorrect since this works with data in Azure storage accounts Option B is incorrect since this is used for migration of data to CosmosDB Option C is incorrect since this is used for building a gateway with the on-premise infrastructure https://docs.microsoft.com/en-us/sql/dma/dma-overview?view=sql-server-2017
Community Discussion
No community discussion yet for this question.