Exam AZ-301 All Questions

View all questions & answers for the AZ-301 exam

Exam AZ-301 topic 13 question 1 discussion

Actual exam question from Microsoft's AZ-301

Question #: 1
Topic #: 13

You need to recommend a backup solution for the data store of the payment processing system.
What should you include in the recommendation?

A. Microsoft System Center Data Protection Manager (DPM)
B. Azure SQL long-term backup retention
C. Azure Backup Server
D. a Recovery Services vault
E. Azure Managed Disks

Show Suggested Answer

Suggested Answer: B 🗳️
References:
https://docs.microsoft.com/en-us/azure/sql-database/sql-database-long-term-backup-retention-configure

by Oz at Nov. 7, 2019, 6:04 a.m.

Comments

Submit Cancel

Oz

Highly Voted 5 years, 6 months ago

I think the answer comes from the backup and retention requirements for the payment system. Only Azure SQL single database \ elastic pools can store backups for up to 10 years as part of the Long-Term Retention.

upvoted 7 times

tartar

4 years, 7 months ago

B is ok

upvoted 2 times

...

bootyholeman

Highly Voted 5 years, 2 months ago

This question depends on which DB type we are going to choose to migrate our DB to(another question). If it's managed instance, it doesn't support LTR. And it's most likely managed instance because SQL Agent.... Not strong in SQL but I think it's storage account because it's the only type supported by managed instance

upvoted 5 times

Protonenpaule

5 years ago

LTR for managed instances is at least in public preview: https://docs.microsoft.com/en-us/azure/sql-database/sql-database-long-term-retention#managed-instance-support

upvoted 2 times

...

sanketshah

Most Recent 4 years, 4 months ago

B is correct answer.

upvoted 1 times

...

jivom

4 years, 9 months ago

"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 read-access geo-redundant storage for up to 10 years. You can then restore any backup as a new database."

upvoted 3 times

...

gboyega