nerdexam
IBM

C2090-610 · Question #20

A table named EMPLOYEE was created as follows: Which action will prevent unauthorized users from accessing SSN data?

The correct answer is D. Create a view for the EMPLOYEE table that does not contain the SSN column and require. See the full explanation below for the reasoning.

Question

A table named EMPLOYEE was created as follows:

Which action will prevent unauthorized users from accessing SSN data?

Options

  • AAssign the SSN column to a restricted role that only authorized users can access.
  • BOnly grant ACCESSCTRL authority for the SSN column to users who need to access SSN data.
  • CAlter the table definition so that SSN data is stored in a separate schema that only authorized
  • DCreate a view for the EMPLOYEE table that does not contain the SSN column and require

How the community answered

(51 responses)
  • A
    6% (3)
  • B
    2% (1)
  • C
    12% (6)
  • D
    80% (41)

Community Discussion

No community discussion yet for this question.

Full C2090-610 Practice