VMware vRealize Operations Manager Advanced — Question 38

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?

Answer options

• 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.

Correct answer: A

Explanation

The correct answer is A because building a software component specifically to run the T-SQL script directly addresses the developers' need to refresh database contents. Other options, such as custom Orchestrator workflows or blueprints with custom properties, may introduce unnecessary complexity without directly executing the provided script.