House Keeping — Learn free

Self-check

Questions 1–10 of 10

1. What does housekeeping refer to in the data world?
Question 1A. The physical cleaning of server roomsB. The routine maintenance, organisation and management tasks needed to ensure data quality, integrity and efficiencyC. The onboarding of new data analystsD. The negotiation of cloud storage contractsE. The design of new database schemas
2. Approximately what proportion of operational costs can effective housekeeping measures save, on an optimistic outlook?
Question 2A. About 5%B. About 15%C. About 30%D. About 50%E. About 75%
3. Fixing typos in student names, standardising date formats and filling in missing grades are examples of which housekeeping task?
Question 3A. Data archivingB. Data purgingC. IndexingD. Data cleaningE. Data encryption
4. What is the purpose of data archiving as a housekeeping task?
Question 4A. Encrypting sensitive data against unauthorised accessB. Creating indexes to speed up queriesC. Documenting the meaning and format of each columnD. Removing data to comply with retention policiesE. Moving older or less frequently used data to long-term storage to optimise performance of the primary storage system
5. Which housekeeping task accelerates data retrieval and query performance?
Question 5A. IndexingB. Data deletionC. Backup and recoveryD. Metadata managementE. Data masking
6. Creating a spreadsheet that documents the meaning and format of each column in a dataset is an example of which housekeeping task?
Question 6A. Data cleaningB. Metadata managementC. Performance optimisationD. Data purgingE. Backup and recovery
7. How does data purging differ from general data deletion in the housekeeping examples?
Question 7A. Purging only removes duplicate rowsB. Purging moves data to long-term storage rather than removing itC. Purging removes data that is no longer needed, especially in compliance with data retention policiesD. Purging applies only to encrypted dataE. Purging is performed only before a backup
8. What does the backup and recovery housekeeping task involve?
Question 8A. Compressing data to save spaceB. Deleting records of students who have left the schoolC. Adjusting settings to improve app performanceD. Regularly creating copies of data to prevent loss and establishing procedures for recovery after accidental deletion or system failureE. Overlaying a logo on documents
9. Which housekeeping task is illustrated by adjusting settings in a gaming app to improve its performance on a smartphone?
Question 9A. Data encryptionB. Data archivingC. IndexingD. Metadata managementE. Performance optimisation
10. Which of the following is NOT listed as a data housekeeping task?
Question 10A. Recruiting new database administratorsB. Data encryptionC. Data deletionD. IndexingE. Data archiving