Ultimate access to all questions.
Upgrade Now 🚀
Sign in to unlock AI tutor
Discuss the importance of using the COPY INTO command in scenarios where data is being loaded from various external sources into a Delta Lake table. How does this command help in maintaining data consistency and preventing duplication?
A
COPY INTO allows for schema evolution and complete table replacement, ensuring data consistency.
B
COPY INTO supports conditional loading and can skip existing records, preventing duplication.
C
COPY INTO is faster than other commands for large datasets, ensuring timely data consistency.
D
COPY INTO can handle complex transformations directly in the database, maintaining data consistency.
