MENU
You have an on-premises Microsoft SQL Server 2019 instance named SQL1 that hosts a database named db1. You have an Azure subscription that contains an Azure SQL managed instance named MI1 and an Azure Storage account named storage1.
You need to ensure that you can back up db1 to storage1. The solution must meet the following requirements:
* Use block blob storage.
* Maximize security.
Suggested Answer: B
Get Premium DP-300 Questions
as Interactive Web-Based Practice Test or PDF
Real Exam Format
Detailed Explanations
Instant Access
Get Your Practice Test
12 comments · newest first
RE
Remona
11 months ago
Creating an access policy sounds like overkill for this.
LU
Lucy
11 months ago
I’m not sure a shared access signature is enough on its own.
AL
Alexia
12 months ago
Isn't enabling infrastructure encryption a must for security?
CO
Colby
12 months ago
I think rotating storage keys is also a good practice.
VA
Val
1 year ago
You definitely need a SAS for secure access!
CA
Carin
1 year ago
Rotating storage keys seems like a good security measure, but I feel like there might be a more direct way to handle the backup process itself.
DE
Dell
1 year ago
Creating an access policy sounds familiar from our practice questions, but I can't recall if it specifically applies to block blob storage.
CE
Celestina
1 year ago
I think enabling infrastructure encryption could be important for maximizing security, but I wonder if it directly relates to backing up the database.
EM
Emerson
1 year ago
I remember something about using SAS for secure access to Azure Storage, but I'm not entirely sure if it's the best option here.
MI
Ming
1 year ago
I've got a good strategy here - I'll eliminate the options I know are true, and then the remaining one must be the incorrect statement.
GE
Georgene
1 year ago
Hmm, this seems like a straightforward question about how assembly pricing works. I'll need to think carefully about the relationship between component costs and the final assembly price.
IZ
Izetta
1 year ago
I'm leaning towards A, but I want to double-check my notes just to make sure I'm not missing anything about the other options.