Ultimate access to all questions.
Upgrade Now 🚀
Sign in to unlock AI tutor
Discuss the implications of using CREATE OR REPLACE TABLE versus INSERT OVERWRITE in a data warehouse environment where data is frequently updated and schema changes are common. Which approach would be more suitable under these conditions, and why?
A
CREATE OR REPLACE TABLE is more suitable due to its ability to handle schema evolution seamlessly.
B
INSERT OVERWRITE is more suitable as it allows for selective data updates without affecting the schema.
C
Both commands are equally suitable as they can handle frequent updates and schema changes.
D
Neither command is suitable for environments with frequent updates and schema changes.
