DP-300: Administering Microsoft Azure SQL Solutions

By Microsoft · Question Mode

QuestionQ40

Monitor, configure, and optimize database resources

You have an Azure SQL Managed Instance.

You need to restore a database named DB1 by using Transact-SQL. Which command should you run?

Select
RESTORE  DB1 FROM
Explanation

Azure SQL Managed Instance restores a native database backup from Azure Blob Storage by using RESTORE DATABASE ... FROM URL. RESTORE FILE and RESTORE LOG do not restore the database itself, and disk or tape backup devices are not the applicable source for this Azure Blob backup URL.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!