SOL-C01 Exam Dumps | You are tasked with creating a table `EMPLOYEES in Snowflake to store employee data. The table should

<< Prev Question Next Question >>

Question 7/155

You are tasked with creating a table `EMPLOYEES in Snowflake to store employee data. The table should have columns for 'employee_id' (INT, primary key), 'first_name' (VARCHAR(50)),
'last_name' (VARCHAR(50)), 'email' (VARCHAR(IOO)), and 'hire_date' (DATE). You want to ensure that when loading data, any rows with duplicate 'employee_id' values are rejected without failing the entire load . Furthermore, you need to automatically generate surrogate keys for any new departments added to the 'DEPARTMENTS' table, which is not currently populated but will be loaded later. Which of the following approaches correctly combines these requirements?

A. Create the 'EMPLOYEES table with a unique constraint on 'employee_id' and use a COPY INTO statement with the 'ON_ERROR = SKIP_FILE' option. Use a SEQUENCE object and a DEFAULT constraint to generate department keys.

B. Create the 'EMPLOYEES' table with 'employee_id' as the primary key. Use a COPY INTO statement with the 'ON_ERROR = CONTINUE option. Use an IDENTITY column for department keys.

C. Create the 'EMPLOYEES' table with 'employee_id' as the primary key. Use a COPY INTO statement with the 'ON_ERROR = SKIP_FILE option. Use a SEQUENCE object and a DEFAULT constraint to generate department keys.

D. Create the 'EMPLOYEES' table without a primary key constraint. Use a COPY INTO statement with the 'ON_ERROR = ABORT_STATEMENT option. Use a Snowflake Task to periodically check for new departments and generate keys.

E. Create the `EMPLOYEES table with a unique constraint on 'employee_id'. IJse a COPY INTO statement with the 'ON ERROR = SKIP FILE option and VALIDATION_MODE = RETURN_ERRORS. Use an IDENTITY column for department keys.

Question 7/155

LEAVE A REPLY

Download PDF File