When working on a shared project, a collaborator has inserted a formula in a spreadsheet that accesses data from an attached file. What security measure should be implemented to protect sensitive information?
option_A: Remove the formula and replace it with manual data to prevent access to sensitive information
option_B: Save the spreadsheet on a local device without internet connection to avoid any security risks
option_C: Move the attached file to a public location to facilitate access for all collaborators
option_D: Set limited access permissions on the spreadsheet and the attached file, allowing only authorized users to access the data
option_E: Share the spreadsheet with all team members without access restrictions
explanation: The correct option is D because it implements the principle of least privilege, ensuring that only authorized users can access the sensitive information. This measure protects confidential data while allowing the necessary collaboration. The other options are insecure or unnecessarily restrictive.
Want adaptive practice that measures your real level?