dp-300 Practice Question 2006
Exam: dp-300
Domain: Plan and implement data platform resources
Topic: Deploy resources by using manual methods
Difficulty: medium
When configuring storage for an Azure SQL Managed Instance, which of the following actions is necessary to ensure optimal performance and compliance with data governance policies?
Answer Options
A
Ensure the managed instance is in the same region as the storage account.
B
Configure the storage account with the appropriate access tier and performance level.
C
Enable encryption on the managed instance.
D
Set the storage account to use geo-redundant storage (GRS).
Correct Answer
B: Configure the storage account with the appropriate access tier and performance level.
Explanation
The correct answer is B because configuring the storage account with the appropriate access tier and performance level ensures optimal performance and helps comply with data governance policies. Option A is incorrect as it does not mention the importance of setting the access tier and performance level. Option C is incorrect because it focuses on the wrong aspect; the primary concern is the storage account configuration rather than the managed instance itself. Option D is incorrect as it suggests enabling encryption without mentioning the need for setting the access tier and performance level.