DATABASE FUNDAMENTALS
BASICS OF BIG DATA
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Benefit
|
|
|
Drawback
|
|
|
Either A or B
|
|
|
None of the above
|
Detailed explanation-1: -The cost of data duplication Wasted time and effort. User frustration and poor adoption of software platforms. Poor customer service. Irritating customers with duplicated messages leading to a poor company image.
Detailed explanation-2: -Data aggregation and human typing errors are some of the sources of duplicate data. Customers may also provide a company with different information at different points in time. Hence, businesses should consider removing duplicate records from their Database.
Detailed explanation-3: -The most significant disadvantage of Post-Process Deduplication is that all data is stored in its entirety (often called fully hydrated). As a result, the data takes up the same amount of space as non-deduplicated data. Size reduction occurs only when the scheduled Deduplication operation has been completed.
Detailed explanation-4: -All occurrences of duplicated data must be maintained-if updated, all occurrences must be updated, and if deleted, all occurrences must be deleted. If this is not done, data integrity problems occur. Unfortunately, duplicated data lends itself of updated anomalies and therefore data integrity problems occur.