In Advanced DBMS, what is meant by normalization trade-off?

A. normalization reduces redundancy but may require joins that affect performance B. normalization applies only to MongoDB indexes C. normalization always eliminates all joins D. normalization is only a security technique