Administering Relational Databases on Microsoft Azure (DP-300) Test 1
© examsiri.com
Question : 13 of 39
Marks:
+1,
-0
DRAG DROP
You have SQL Server 2019 on an Azure virtual machine that contains an SSISDB database.
A recent failure causes the master database to be lost.
You discover that all Microsoft SQL Server integration Services (SSIS) packages fail to run on the virtual machine.
Which four actions should you perform in sequence to resolve the issue? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct.
Select and Place:
Actions :
1. Add a certificate to an Azure key vault
2. Enable Transparent Data Encryption (TDE)
3. Encrypt a copy of the master key by using the service master key
4. Turn on the TRUSTWORTHY property and the CLR property
5. Attach the SSISDB database
6. Open the master key for the SSISDB database
You have SQL Server 2019 on an Azure virtual machine that contains an SSISDB database.
A recent failure causes the master database to be lost.
You discover that all Microsoft SQL Server integration Services (SSIS) packages fail to run on the virtual machine.
Which four actions should you perform in sequence to resolve the issue? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct.
Select and Place:
Actions :
1. Add a certificate to an Azure key vault
2. Enable Transparent Data Encryption (TDE)
3. Encrypt a copy of the master key by using the service master key
4. Turn on the TRUSTWORTHY property and the CLR property
5. Attach the SSISDB database
6. Open the master key for the SSISDB database
Go to Question: