EMC Proven Professional – Data Science and Big Data Analytics — Question 25

Which word or phrase completes the statement? A spreadsheet is to a data island as a centralized database for reporting is to a ________?

Answer options

• A. Data Warehouse
• B. Data Repository
• C. Analytic Sandbox
• D. Data Mart

Correct answer: A

Explanation

The correct answer is 'Data Warehouse' because it represents a centralized storage solution for reporting, similar to how a spreadsheet is a localized data island. The other options, while related to data storage, serve different purposes; a Data Repository is a more generic term, an Analytic Sandbox is typically for testing and analysis, and a Data Mart is a subset of a Data Warehouse focused on a specific business line.