ExamQuestions.com

Register
Login
Data Engineering on Microsoft Azure (DP-203) Exam Questions

Microsoft

Data Engineering on Microsoft Azure (DP-203)

227 / 240

Question 227:

Martin is a Cloud Security Engineer of Whizlabs Inc. As a best practice; he implemented the option to change the access key of the Blob storage regularly. Consequently, the storage keys of Blob storage (Polybase) are also required to rotate which is the underlying storage of the dedicated SQL pool of Azure Synapse analytics. 
For each storage account, whose key is required to change? He issued the following T-SQL statement. 
<pre class="brush:java;">ALTER DATABASE SCOPED CONFIGURATION {
SET &lt;set_options&gt;
}[;]
&lt;set_options&gt;::=
{
DW_COMPATIBILITY_LEVEL = {AUTO| 10|20}
}</pre>
Does the above T-SQL statement match the requirements of this scenario?

Answer options:

A.Yes
B.No