Databricks Certified Data Engineer - Associate
Get started today
Ultimate access to all questions.
Comments
Loading comments...
Ultimate access to all questions.
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.