Exam DP-300 topic 6 question 38 discussion

Actual exam question from Microsoft's DP-300

Question #: 38
Topic #: 6

You have an Azure subscription that contains two Azure SQL managed instances named SQLMI1 and SQLMI2. SQLMI1 contains a database named DB1 and a user named User1.

User1 drops DB1.

You need to perform a point-in-time restore of DB1 to SQLMI2.

What should you use to perform the restore?

A. Azure CLI
B. Transact-SQL
C. the Azure portal
D. Azure PowerShell

Show Suggested Answer

Suggested Answer: C 🗳️

by louisaok at Jan. 31, 2023, 8:18 a.m.

Comments

Submit Cancel

voodoo_sh

3 months, 3 weeks ago

Selected Answer: C

C - Azure portal. Go to SQLMI2 - New Database - Select data source -> PITR Restore -> SQLMI1 -> pick Deleted DB1

upvoted 1 times

...

Dalamain

7 months, 2 weeks ago

What an awful question as most of the answers are possible: https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/point-in-time-restore?view=azuresql&tabs=azure-portal

upvoted 3 times

...

vcloudpmp

1 year, 4 months ago

https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/point-in-time-restore?view=azuresql-mi&tabs=azure-portal You can use point-in-time restore to restore a database in these scenarios: From an existing database From a deleted database To the same managed instance or to a different managed instance To a managed instance in the same subscription or to a managed instance in a different subscription

upvoted 1 times

...

KIET2131

1 year, 9 months ago

C - the Azure portal.

upvoted 2 times

...

louisaok

1 year, 10 months ago

AZ Portal is easier than other options

upvoted 1 times

...