A development team has requested the ability to refresh database contents for existing pre-production SQL servers managed by vRealize Automation. The developers have provided the cloud architect with a T-SQL script suitable for performing this task.
Which design recommendation would address the requirements of this scenario?
A. Build a software component to run the T-SQL script.
B. Design an XaaS blueprint based on a custom Orchestrator workflow.
C. Design a blueprint and use custom properties to run the T-SQL script.
D. Build a resource action and publish it to the developers.
@Morti, I understand a DB refresh may be required multiple times in real life. But in the context of this question, this will be an assumption, so A seems right.
A is wrong, you maybe want to run the script more often than just once and also it is no software to be installed on the system.
Such Day 2 operations should be handled by actions. So I say D