exam questions

Exam DP-300 All Questions

View all questions & answers for the DP-300 exam

Exam DP-300 topic 1 question 36 discussion

Actual exam question from Microsoft's DP-300
Question #: 36
Topic #: 1
[All DP-300 Questions]

You have an on-premises Microsoft SQL server that uses the FileTables and Filestream features.
You plan to migrate to Azure SQL.
Which service should you use?

  • A. Azure SQL Database
  • B. SQL Server on an Azure Virtual Machine
  • C. Azure SQL Managed Instance
  • D. Azure Database for MySQL
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️

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
eric0718
Highly Voted 3 years ago
Selected Answer: B
https://docs.microsoft.com/en-us/azure/azure-sql/migration-guides/database/sql-server-to-sql-database-overview?view=azuresql If one of the following conditions applies to your business, consider moving to a SQL Server virtual machine (VM) instead: You have strict dependency on features that are still not supported, such as FileStream/FileTable, PolyBase, and cross-instance transactions.
upvoted 10 times
...
bingomutant
Most Recent 7 months, 2 weeks ago
I would say B - Azure SQL Database and Azure SQL Managed Instance do not support these specific features.
upvoted 1 times
...
orionduo
1 year, 10 months ago
Your business might have requirements that make SQL Server on Azure Virtual Machines a more suitable target than Azure SQL Database. You require direct access to the operating system or file system, such as to install third-party or custom agents on the same virtual machine with SQL Server. You have strict dependency on features that are still not supported, such as FileStream/FileTable, PolyBase, and cross-instance transactions. You need to stay at a specific version of SQL Server (2012, for example). Your compute requirements are much lower than a managed instance offers (one vCore, for example), and database consolidation is not an acceptable option.
upvoted 1 times
...
victorlie
1 year, 10 months ago
It´s tricky because it mentions ¨migrate to Azure SQL¨ instead of ¨migrate to Azure¨.
upvoted 2 times
eleeitor
1 year, 7 months ago
yes but as the answer explains, if you need to maintain the use of FileTable + Filestream in azure, it has to be on an SQL Server, wich has to ve on a VM(only possible setup to run SQL Server on azure). Azure sql or sql managed does't support it.
upvoted 1 times
...
...
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
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago