Exam DP-300 topic 1 question 2 discussion

1. Attach the SSISDB database (E) 2. Open the master key for the SSISDB database (F) 3. Encrypt a copy of the master key by using the service master key © 4. Turn on the TRUSTWORTHY property and the CLR property (D) turning on the TRUSTWORTHY property and the CLR property (D) should be done after opening the master key for the SSISDB database (F) and encrypting a copy of the master key by using the service master key ©. This is because the TRUSTWORTHY property and CLR property are related to security and encryption, so it’s important to ensure that the master key is properly encrypted before enabling these properties.

Isn't this the right order? Turn on the TRUSTWORTHY property and the CLR property Attach the SSISDB database Open the master key for the SSISDB database Encrypt a copy of the master key by using the service master key

I believe this question should refer to the SSISDB being restored to another SQL Server as part of the answer is "Turn on trustworthy property and CLR property"

The correct url iss: https://docs.microsoft.com/en-us/sql/integration-services/catalog/ssis-catalog?view=sql-server-ver15#to-restore-the-ssis-database

What would be the correct order?

It means master database lost with relevant information also lost so recreate a new SSIS catalog?

Odd question.

This is such a weird question, it doesn't address the problem at hand which is a failure causing the master table being deleted. Why would that even happen? I would want to figure that out

Attaching the database and enabling CLR can be done at any order. In this MS documentation, they first enable CLR, then attach/restore the database: https://docs.microsoft.com/en-us/sql/integration-services/catalog/ssis-catalog?view=sql-server-ver15

Link is 404, this is a correct one https://docs.microsoft.com/en-us/sql/integration-services/catalog/ssis-catalog