ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam AZ-305 All Questions

View all questions & answers for the AZ-305 exam
Go to Exam

Exam AZ-305 topic 2 question 12 discussion

Actual exam question from Microsoft's AZ-305
Question #: 12
Topic #: 2
[All AZ-305 Questions]

DRAG DROP -
You plan to import data from your on-premises environment to Azure. The data is shown in the following table.

What should you recommend using to migrate the data? To answer, drag the appropriate tools to the correct data sources. Each tool may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
Select and Place:

Show Suggested Answer Hide Answer
Suggested Answer:
Box 1: Data Migration Assistant -
The Data Migration Assistant (DMA) helps you upgrade to a modern data platform by detecting compatibility issues that can impact database functionality in your new version of SQL Server or Azure SQL Database. DMA recommends performance and reliability improvements for your target environment and allows you to move your schema, data, and uncontained objects from your source server to your target server.
Incorrect:
AzCopy is a command-line utility that you can use to copy blobs or files to or from a storage account.
Box 2: Azure Cosmos DB Data Migration Tool
Azure Cosmos DB Data Migration Tool can used to migrate a SQL Server Database table to Azure Cosmos.
Reference:
https://docs.microsoft.com/en-us/sql/dma/dma-overview
https://docs.microsoft.com/en-us/azure/cosmos-db/cosmosdb-migrationchoices
by Gowind at Sept. 2, 2022, 1:47 p.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
memo454
Highly Voted 1 year, 7 months ago
This question is on today's exam. The exam is easier than AZ-104.
upvoted 26 times
Spoon3r
1 year, 7 months ago
My hero <3
upvoted 4 times
tgfakhrul
1 year, 2 months ago
No he's not
upvoted 7 times
...
...
...
Gowind
Highly Voted 2 years, 7 months ago
Correct. 1. https://docs.microsoft.com/en-us/azure/azure-sql/migration-guides/database/sql-server-to-sql-database-overview?view=azuresql Data migration services 2. https://docs.microsoft.com/en-us/azure/cosmos-db/cosmosdb-migrationchoices
upvoted 23 times
...
[Removed]
Most Recent 5 months, 2 weeks ago
CORRECT
upvoted 2 times
...
Thanveer
5 months, 3 weeks ago
Box 1: Data Migration Assistant Box 2: Azure Cosmos DB Data Migration Tool
upvoted 1 times
...
_punky_
6 months, 1 week ago
FYI: this guy has 96% of correct answers so there i no need to update: 23169fd
upvoted 3 times
...
23169fd
10 months, 1 week ago
From the SQL Server 2012 database to an Azure SQL database: Data Migration Assistant: This tool helps assess, migrate, and validate the data from SQL Server to Azure SQL Database. From the table in the SQL Server 2014 database to an Azure Cosmos DB account that uses the SQL API: Azure Cosmos DB Data Migration Tool: This tool is specifically designed for migrating data to Azure Cosmos DB, supporting various source data formats.
upvoted 6 times
23169fd
10 months, 1 week ago
AzCopy: This tool is primarily used for copying data to and from Azure Storage (blobs, files, and tables) but not for migrating SQL Server databases. Data Management Gateway: This tool is used for connecting on-premises data sources to Azure Data Factory for data integration and ETL processes. It's not specifically designed for SQL Server to Azure SQL Database or Cosmos DB migrations. Data Migration Assistant: This tool is the appropriate choice for migrating SQL Server databases to Azure SQL Database. Azure Cosmos DB Data Migration Tool: This tool is suitable for migrating data from various sources to Azure Cosmos DB.
upvoted 3 times
...
...
Lazylinux
1 year ago
Given answer is correct
upvoted 1 times
...
JimmyYop
1 year, 3 months ago
appeared in Exam 01/2024
upvoted 5 times
...
Exams_Prep_2021
1 year, 7 months ago
Got this on Sept. 29, 2023
upvoted 7 times
...
Forex19
1 year, 7 months ago
I had question at 24th Sep 2023
upvoted 6 times
...
NotMeAnyWay
1 year, 9 months ago
Answers: 1. From the SQL server 2012 database to Azure SQL Database: Data Migration Assistant. The Data Migration Assistant (DMA) helps you upgrade to a modern data platform by detecting compatibility issues that can impact database functionality in your new version of SQL Server or Azure SQL Database. DMA recommends performance and reliability improvements for your target environment and allows you to move your schema, data, and uncontained objects from your source server to your target server. 2. From the table in the SQL server 2014 database to Azure Cosmos DB: Azure Cosmos DB Data Migration tool. The Azure Cosmos DB Data Migration tool is an open-source solution that imports data to Azure Cosmos DB from a variety of sources, including SQL Server. For the SQL API, the tool supports import from JSON files, MongoDB, SQL Server, CSV files, Azure Table storage, Amazon DynamoDB, and other Azure Cosmos DB databases.
upvoted 8 times
...
au95_aznieto
2 years, 1 month ago
If helps I found github project from Azure about cosmos db data migration tool, it seems to be active https://github.com/Azure/azure-documentdb-datamigrationtool
upvoted 1 times
...
OPT_001122
2 years, 3 months ago
Answer is correct Box 1: Data Migration Assistant Box 2: Azure Cosmos DB Data Migration Tool
upvoted 3 times
...
OPT_001122
2 years, 3 months ago
Thanks all who have mentioned the exam dates
upvoted 4 times
...
ssgg100
2 years, 3 months ago
I think there is a mistake in this question - there is no Azure Cosmos DB for SQL API.The supported APIs are: Azure Cosmos DB for NoSQL Azure Cosmos DB for MongoDB Azure Cosmos DB for PostgreSQL Azure Cosmos DB for Cassandra Azure Cosmos DB for Gremlin Azure Cosmos DB for Table If question means Azure Cosmos DB for NoSQL API, then if we look in the table in https://docs.microsoft.com/en-us/azure/cosmos-db/cosmosdb-migrationchoices the tool should be Azure Data Factory. Azure Cosmos DB Data Migration tool is not mentioned in related article. I found other article about this tool https://azure.microsoft.com/en-us/updates/documentdb-data-migration-tool/ but it is old and I think that tool is obsolete, as well as the question.
upvoted 3 times
rvnz45
2 years, 3 months ago
PostgreSQL is one kind of SQL
upvoted 1 times
...
sw1000
1 year, 11 months ago
It's mentioned here that SQL Servers are supported with the Desktop Migration Tool: https://learn.microsoft.com/en-gb/azure/cosmos-db/how-to-migrate-desktop-tool?tabs=azure-cli
upvoted 1 times
...
...
Darkx
2 years, 6 months ago
appeared on 11th Oct 2022
upvoted 6 times
...
Racinely
2 years, 7 months ago
The Data management gateway is a client agent that you must install in your on-premises environment to copy data between cloud and on-premises data stores
upvoted 1 times
...
Load full discussion...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago