Data Sprawl — Learn free

Self-check

Questions 1–10 of 10

1. What does the term Data Sprawl refer to?
Question 1A. The physical distance between an organisation's data centresB. The staggering amount and variety of data produced by businesses every dayC. The growth of a single database table beyond its partition limitD. The spread of customer ages in a marketing datasetE. Unauthorised copying of data outside the company network
2. What is the main cause of Data Sprawl in a company?
Question 2A. Employees deleting old files too slowlyB. A shortage of database administratorsC. Storing all data in a single data warehouseD. The variety of enterprise software, mobile apps, storage systems and data formats each company relies onE. Over-use of standardised formats
3. Which of the following is NOT listed as one of the formats in which sprawling data appears?
Question 3A. ParquetB. VideoC. EmailD. PDFE. XML
4. In the analogy of doing your taxes with papers hidden in drawers, closets and couch cushions, what does the mixture of forms written in Greek, English and Spanish represent?
Question 4A. The need for multilingual support staffB. Data that has been encryptedC. Records lost through poor backupsD. Duplicate data held by different departmentsE. Data scattered across different formats and copies that must be reconciled before it is useful
5. Why does Data Sprawl make extracting information challenging or time-consuming?
Question 5A. Because sprawling data is always encryptedB. Because no database can hold more than one formatC. Because information cannot easily be extracted unless all the formats are converted into a standardised formatD. Because decision-makers refuse to use unstructured dataE. Because sprawling data is stored on tape
6. Which phrase captures the essence of addressing Data Sprawl?
Question 6A. Converting multi-format datasets into one unified formatB. Deleting all data older than one yearC. Storing every format in its native systemD. Replacing the data warehouse with a data lakeE. Restricting data creation to a single application
7. To mitigate the challenge of Data Sprawl for decision support, what must be done with semi-structured and unstructured datasets?
Question 7A. Archive them to cold storageB. Keep them in their original formats for auditorsC. Encrypt them before analysisD. Convert them into structured dataE. Discard them, since decisions only need structured data
8. Which system currently acts as the serving layer for decision-makers?
Question 8A. The email serverB. The Data WarehouseC. The mobile application back endD. The document management systemE. The operational database
9. Who is said to be affected by the problem of Data Sprawl?
Question 9A. Only social media companiesB. Only organisations without a data warehouseC. Only companies that store video and audioD. Only government tax agenciesE. Companies across the world
10. Which statement about Data Sprawl is NOT correct?
Question 10A. It involves data in many formats such as JSON, XML, Text and AudioB. It is driven by the variety of software and storage systems a company usesC. It is resolved simply by buying more storage capacityD. It makes information extraction time-consuming until formats are standardisedE. It is compared to tax papers scattered around a house