AWS Exams GCP Exams Azure Exams GitHub Exams Jira Exams ISC2 Exams

Video: An analyst is tasked with loading and databricks video

Question 1 Be Honest
« Back   Next databricks data-analyst Exam Question »
Answer

Full Certification Question

An analyst is tasked with loading and updating data in a Delta Lake table called customer_data . They are considering using MERGE INTO , INSERT INTO , or COPY INTO based on different requirements. Given the scenarios below, which option correctly matches the statement with its most appropriate use case? Scenarios: Scenario 1: The analyst needs to update existing records and insert new records into customer_data from a staging table, ensuring that duplicates are handled based on a matching condition. Scenario 2: The analyst has a set of new data files that need to be bulk-loaded into customer_data , appending the data without modifying any existing records. Scenario 3: The analyst needs to append new records from another table into customer_data , with the source table already matching the structure of the target table.