Which DBC view should be used to generate this list?

An Administrator has been given a task to generate a list of users who have not changed their password in the last 90 days.

Which DBC view should be used to generate this list?
A . DBC.LOGONOFFV
B . DBC.USERSV
C . DBC.SECURITYDEFAULTSV
D . DBC.ACCESSLOGV

View Answer

Answer: B

Explanation:

DBC.USERSV contains information about users, including the passwordlastmodified column, which records the date and time the user last changed their password. By querying this view, the Administrator can identify users who have not updated their password within the specified time frame (in this case, 90 days).

Option A (DBC.LOGONOFFV) logs user logon and logoff events, but it does not track password changes.

Option C (DBC.SECURITYDEFAULTSV) contains system-wide security defaults, but it does not track individual user password activity.

Option D (DBC.ACCESSLOGV) logs access control events, like who accessed which database objects, but it doesn’t track password changes either.

Therefore, DBC.USERSV is the appropriate view to use for this task.