An administrator has created a new SQL Server software profile version to apply the latest cumulative update. What should the administrator do to make it available to all users?

The correct answer is B. Update the software profile version and set the status to Published. When an administrator creates a new SQL Server software profile version to apply the latest cumulative update, they should update the software profile version and set the status to Published. This makes the new profile version available to all users. NDB will show available…

Perform Database Administration

Question

Options

ASet the status of the existing software profile version to Unpublished.
BUpdate the software profile version and set the status to Published.
CDeprecate the existing software profile version and use the new one.
DSelect the software profile version with the update and optimization,

How the community answered

(22 responses)

B
91% (20)
C
5% (1)
D
5% (1)

Explanation

When an administrator creates a new SQL Server software profile version to apply the latest cumulative update, they should update the software profile version and set the status to Published. This makes the new profile version available to all users. NDB will show available updates for any database server using the software profile as soon as the new profile version is

Topics

#software profile#profile version#published status#SQL Server patching

Community Discussion

No community discussion yet for this question.

Full NCP-DB-6.10 Practice