You have an Azure subscription that contains a user named User1 and an Azure SQL database named DB1. You configure long-term retention (LTR) for DB1. You need to ensure that User1 can delete LTR…

The correct answer is B. Owner. Manage Azure SQL Managed Instance long-term backup retention To delete LTR backups, you need to be a member of one of the following roles: Subscription Owner role or Custom role with the following permission…

Submitted by rachelw· Mar 6, 2026Implement a secure environment

Question

You have an Azure subscription that contains a user named User1 and an Azure SQL database named DB1. You configure long-term retention (LTR) for DB1. You need to ensure that User1 can delete LTR backups of DB1. The solution must follow the principle of least privilege. Which role should you assign to User1?

Options

ASQL Server Contributor
BOwner
CSQL Security Manager
DContributor

How the community answered

(31 responses)

A
6% (2)
B
74% (23)
C
3% (1)
D
16% (5)

Explanation

Manage Azure SQL Managed Instance long-term backup retention To delete LTR backups, you need to be a member of one of the following roles: Subscription Owner role or Custom role with the following permission: Microsoft.Sql/locations/longTermRetentionManagedInstances/longTermRetentionDatabases/long TermRetentionManagedInstanceBackups/delete https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/long-term-backup-retention-

Community Discussion

No community discussion yet for this question.

Full DP-300 Practice