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)- A6% (3)
- B2% (1)
- C12% (6)
- D80% (41)
Community Discussion
No community discussion yet for this question.