An on-premises application references database tables using server, database, and table names. You need to migrate the application data to Azure without modifying the app’s table references. To which two Azure services can you migrate the data so the application continues to reference tables by server/database/table? (Select two.)
Choose an answer
Tap an option to check your answer.
Correct answer: SQL Server on an Azure virtual machine, Azure SQL Managed Instance.
Why this is the answer
SQL Server on an Azure virtual machine and Azure SQL Managed Instance both support the traditional server.database.schema.table naming convention that the on-premises application uses. This allows for a lift-and-shift migration without requiring changes to the application's database references. SQL Server Stretch Database is a hybrid solution for archiving cold data from an on-premises SQL Server to Azure SQL Database, not a full migration target for an entire application database. Azure SQL Database is a fully managed PaaS offering that uses a different naming convention (server.database.schema.table is not directly supported in the same way as on-premises SQL Server), which would necessitate application code changes to adapt to its serverless or single-database model.
Pass your exam — without the endless answer hunt
Get every verified question and explanation for this exam in one place, and save hours of prep. 1,000+ certifications · 20+ languages · free to start.
Pass your exam faster → No card needed