62.5k views
0 votes
All of the following are advantages of a partitioned database except:

A) Improved performance
B) Enhanced security
C) Simplified data management
D) Increased data redundancy

User Cosmoloc
by
8.2k points

1 Answer

4 votes

Final answer:

The correct answer is D) Increased data redundancy, which is typically viewed as a disadvantage rather than an advantage in partitioned databases. Advantages of such databases include improved performance, enhanced security, and simplified data management.

Step-by-step explanation:

The question refers to the advantages and disadvantages of a partitioned database. Among the options provided, the one that is not an advantage is D) Increased data redundancy. Data redundancy in databases generally refers to the unnecessary duplication of data, which can lead to inconsistencies and inefficiencies. Therefore, increased data redundancy is typically seen as a disadvantage.

A partitioned database, on the other hand, aims to improve the performance of the system by allowing data to be stored in separate partitions, often across different locations or systems. This can significantly speed up query response times. Partitioning can also enhance security by restricting access to data based on partitions. The data management process can be simplified as various partitions can be managed and optimized independently.

Overall, while partitioning can have several benefits like improved performance, enhanced security, and simplified data management, it does not inherently aim to increase data redundancy.

User Datka
by
7.8k points