Question 6A data analyst creates a spreadsheet with five tabs. They want to share only tabs 1-4 with a client because tab 5 contains sensitive information. Which of the following tactics will enable them to keep tab 5 private? Select all that apply.1 pointHide tab 5, then share the spreadsheet with the client.Make a copy of the spreadsheet, delete tab 5, then share the new file with the client.Copy tabs 1-4 into a separate spreadsheet, then share the new file with the client.Rename tab 5 to include the word “private,” then share the spreadsheet with the client.

A data analyst adds sharing permissions to limit who can edit the data contained within a file. This is an example of what?1 pointData securityData integrityData ethicsData validation

When sharing a dashboard with stakeholders, what is the best way to handle sensitive or confidential data?Review LaterExclude the data from the dashboard entirelyEncrypt the data within the dashboardUse a password-protected Excel file and share the password only with authorized stakeholdersTrust that stakeholders won't share or misuse the sensitive data

Which of the following data security tools can be used to ensure only specific people can access, edit, and download a spreadsheet? Select all that apply.1 pointSharing permissionsTabsEncryptionFilters

What ways can you share the spreadsheet with your team members?

Question 7You’re in charge of the monthly inventory spreadsheet across all branches of your company. The spreadsheet has multiple pages, each of which denotes a branch. With branch managers needing to access these records, you decide to only give them access to their branch’s page. Applying these restrictions is an example of what?1 pointData securityData hygieneData integrityData preservation