nerdexam
Nutanix

NCP-DB-6.10 · Question #219

An administrator needs to register a SQL Server Single Node Database Server VM with NDB. Which condition must exist prior to the administrator completing this task?

The correct answer is B. The login account provided must be a member of the sysadmin role. Before registering a SQL Server Single Node Database Server VM with NDB, it is necessary that the login account provided for this task must be a member of the sysadmin role. This ensures the necessary permissions are in place for managing and administering the SQL Server…

Perform Database Administration

Question

An administrator needs to register a SQL Server Single Node Database Server VM with NDB. Which condition must exist prior to the administrator completing this task?

Options

  • ADatabase files must exist in the Windows OS boot drive.
  • BThe login account provided must be a member of the sysadmin role.
  • CThe SQL service account should not have read privileges on the mount points.
  • DSQL Server instance must be in single-user mode.

How the community answered

(24 responses)
  • B
    92% (22)
  • C
    4% (1)
  • D
    4% (1)

Explanation

Before registering a SQL Server Single Node Database Server VM with NDB, it is necessary that the login account provided for this task must be a member of the sysadmin role. This ensures the necessary permissions are in place for managing and administering the SQL Server instance.

Topics

#SQL Server registration#sysadmin role#prerequisites#NDB onboarding

Community Discussion

No community discussion yet for this question.

Full NCP-DB-6.10 Practice