A company manages several on-premises Microsoft SQL Server databases. You need to migrate the databases to Microsoft Azure by using a backup process of Microsoft SQL Server. Which data technology should you use?
Suggested Answer:D🗳️
Managed instance is a new deployment option of Azure SQL Database, providing near 100% compatibility with the latest SQL Server on-premises (Enterprise Edition) Database Engine, providing a native virtual network (VNet) implementation that addresses common security concerns, and a business model favorable for on-premises SQL Server customers. The managed instance deployment model allows existing SQL Server customers to lift and shift their on-premises applications to the cloud with minimal application and database changes. References: https://docs.microsoft.com/en-us/azure/sql-database/sql-database-managed-instance
You can only do backup and restore to a managed instance. See page 60 https://azure.microsoft.com/mediahandler/files/resourcefiles/choosing-your-database-migration-path-to-azure/Choosing_your_database_migration_path_to_Azure.pdf
when ever you are choosing to migrate indirectly we would need to do it in a cost effective way which is possible through azure sql database managed instance.
The managed instance is the resource, which is closest to an on-prem SQL-server, whereas a SQL database is limited (e.g. support for R). The lift and shift is the least effort solution for a SQL server
Correct answer is D: Azure SQL Managed Instance.
Azure SQL Managed Instance is designed for customers looking to migrate a large number of apps from an on-premises or IaaS, self-built, or ISV provided environment to a fully managed PaaS cloud environment, with as low a migration effort as possible.
SQL Managed Instance allows existing SQL Server customers to lift and shift their on-premises applications to the cloud with minimal application and database changes. At the same time, SQL Managed Instance preserves all PaaS capabilities (automatic patching and version updates, automated backups, high availability) that drastically reduce management overhead and TCO.
Because there are several databases. Single db is only good for very few databases.
upvoted 5 times
...
...
This section is not available anymore. Please use the main Exam Page.DP-200 Exam Questions
Log in to ExamTopics
Sign in:
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.
skiwi
Highly Voted 5 years, 1 month agoNoor_S
Highly Voted 4 years, 12 months agodmnantilla9
Most Recent 4 years, 5 months agoPaulMD
4 years, 6 months agochaoxes
4 years, 6 months agoKakashiHatake
4 years, 6 months agoAbhishek_123
4 years, 6 months agoEgocentric
4 years, 6 months agojavaxxl
4 years, 8 months agoVijaya
4 years, 9 months agoavestabrzn
5 years, 3 months agoYuri1101
5 years, 2 months ago