A Data Analyst created two tables that are related by a foreign key, using the following commands:

Then the Analyst renamed the referenced table using the following command: ALTER TABLE mother RENAME TO father; What happens to the foreign key after the referenced table is renamed?

• A. The foreign key is updated to reference the renamed table.
• B. The foreign key is dropped because the reference is no longer valid.
• C. The foreign key becomes invalid because the referenced table no longer exists.
• D. The foreign key will not be used during the query rewrite.

A Data Analyst needs to temporarily hide a tile in a dashboard. The data will need to be available in the future, and additional data may be added. Which tile should be used?

• A. Delete
• B. Unplace
• C. Duplicate
• D. Show/Hide

A Data Analyst wants to use pandas code they have previously written to process a column of text and return multiple rows of parsed output for each input value. The Analyst wants to be able to join these results with other tables in a single transaction. Which type of extensibility feature should the Analyst use?

• A. User-Defined Function (UDF)
• B. Vectorized User-Defined Table Function (UDTF)
• C. External function
• D. Stored procedure

Which query will provide this data without incurring additional storage costs?

• A. CREATE TABLE DEV.PUBLIC.TRANS_HIST AS (SELECT * FROM PROD.PUBLIC.TRANS_HIST WHERE extract(year from (TRANS_DATE)) = 2019);
• B. CREATE TABLE DEV.PUBLIC.TRANS_HIST LIKE PROD.PUBLIC.TRANS_HIST;
• C. CREATE TABLE DEV.PUBLIC.TRANS_HIST CLONE PROD.PUBLIC.TRANS_HIST;
• D. CREATE TABLE DEV.PUBLIC.TRANS_HIST AS (SELECT * FROM PROD.PUBLIC.
  TRANS_HIST);