A Citrix Administrator has created a new Delivery Controller and needs to join it to an existing Site to increase site redundancy. Which SQL permissions will the administrator need?

The correct answer is B. securityadmin and db_owner. The new Delivery Controller must have the securityadmin fixed server role on the SQL Server instance (to create and manage database logins) and the db_owner fixed database role on the existing Site databases (to join and configure the site schema).

Manage and Maintain a Citrix Site

Question

Options

Adb_owner and db_datawriter
Bsecurityadmin and db_owner
Csecurityadmin and dbm_monitor
Ddbcreator and db_accessadmin

How the community answered

(42 responses)

A
5% (2)
B
86% (36)
C
7% (3)
D
2% (1)

Explanation

The new Delivery Controller must have the securityadmin fixed server role on the SQL Server instance (to create and manage database logins) and the db_owner fixed database role on the existing Site databases (to join and configure the site schema).

Topics

#SQL permissions#Delivery Controller#site redundancy#database access

Community Discussion

No community discussion yet for this question.

Full 1Y0-204 Practice