Multiple choice technology databases

You are in the process of deploying Analysis Services Database in the production environment. You are using the Analysis Services Deployment Wizard to perform this deployment. The project will be named Deploy_Prod1.During the deployment process, you want to retain the existing roles and role members on the destination server.Which input file should you modify to accomplish the objective?

  1. <Deploy_Prod1>.asdatabase

  2. <Deploy_Prod1>.deploymenttargets

  3. <Deploy_Prod1>.configsettings

  4. <Deploy_Prod1>.deploymentoptions

Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

The .deploymentoptions input file controls deployment behavior settings for Analysis Services. To retain existing roles and role members on the destination server, you must modify this file and set the appropriate options (typically 'Retain Roles' or similar settings) to prevent overwriting security configurations during deployment.