You can process by elemination:
Site recovery and geo-replication are out of scope
We can think that automatic backup can be sufficient but Microsoft recommendation for Long Term Retention is to use LTR feature:
https://docs.microsoft.com/en-us/azure/azure-sql/database/automated-backups-overview?tabs=single-database
Then A is correct
Given Answer A is correct
I though Automatic backup were sufficient but BILL GATES said otherwise LTR
https://learn.microsoft.com/en-us/azure/azure-sql/database/automated-backups-overview?view=azuresql
I guess you configure it in the auto backup!!
Not B .-> Is backup recovery, not retention
Not C -> from 1 to 35 days (https://learn.microsoft.com/en-us/azure/azure-sql/database/long-term-retention-overview?view=azuresql)
Not D -> This is recovery, not backup
A is the answer.
https://learn.microsoft.com/en-us/azure/azure-sql/database/long-term-retention-overview?view=azuresql
Many applications have regulatory, compliance, or other business purposes that require you to retain database backups beyond the 7-35 days provided by Azure SQL Database and Azure SQL Managed Instance automatic backups. By using the long-term retention (LTR) feature, you can store specified SQL Database and SQL Managed Instance full backups in Azure Blob storage with configured redundancy for up to 10 years. LTR backups can then be restored as a new database.
It is not clear that idea is that the customer migrates to Azure SQL Database. Assuming that is the idea then answer is correct. Otherwise, long term retention policy is not available to SQL on Azure VM. But I can't see answer that fits if SQL remains hosted on a VM.
I agree, one of the requirements is to leverage licensing, the company has SA, they could use hybrid licensing for their SQL. This suggests to me they migrate the SQL instance as a VM, I'd say Azure VM backup (if it was a possible answer!)
I'm not a DBA by any means.
But as per the following article, you can use hybrid benefits for V-CORE based SQL databases ( and can be done without any downtime )
So, Answer A should be correct.
https://docs.microsoft.com/en-us/azure/azure-sql/azure-hybrid-benefit?view=azuresql&tabs=azure-portal
upvoted 5 times
...
...
...
Log in to ExamTopics
Sign in:
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.
Eltooth
Highly Voted 3 years agojkklim
2 years, 10 months agowsrudmen
Highly Voted 2 years, 9 months agoSeMo0o0o0o
Most Recent 3 weeks, 6 days agoLazylinux
7 months, 2 weeks agobabakeyfgir
1 year agomalcubierre
1 year, 1 month agozellck
1 year, 9 months agohonzar
1 year, 11 months agoGor
2 years, 6 months agoTeringzooi
2 years, 7 months agoJustin0020
2 years, 9 months agoPaulwryan
2 years, 11 months agoDoolyMilly
2 years, 10 months agoMr_wippy
2 years, 7 months ago