A data analyst is working with a database databricks video
data-analyst video for a data analyst is working with a database in Databricks and needs to update a table named SalesData . The analyst has a new batch of data
Answer
Full Certification Question
A data analyst is working with a database in Databricks and needs to update a table named SalesData . The analyst has a new batch of data that includes some records already present in SalesData and some new records. They must decide between using MERGE INTO , INSERT INTO , and COPY INTO commands. Considering the functions and typical use cases of these commands, which of the following statements is true?