Free Microsoft Azure DP-300 Actual Exam Questions - Question 1 Discussion
HOTSPOT You have an Azure SQL managed instance. You need to restore a database named DB1 by using Transact-SQL. Which command should you run? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. 
B works since RESTORE isn’t supported on managed instances anyway.
I’d pick option B as well. Since managed instances don’t support RESTORE like on regular SQL Server, the way to restore is by creating a new database as a copy of a backup or existing database. The CREATE DATABASE AS COPY OF syntax fits this scenario perfectly because it’s designed for managed instances, letting you basically clone the DB without needing RESTORE commands. Definitely not A or C since those use RESTORE which isn’t supported here.
They don't allow RESTORE on managed instances, so option B fits better.
CREATE DATABASE DB1 AS COPY OF fits managed instance restore rules.
CREATE DATABASE DB1 AS COPY OF for managed instances only.
You can't use RESTORE DATABASE on managed instances, use CREATE DATABASE with AS COPY OF.
RESTORE DATABASE