DEA-C02 Exam Dumps | A company is using Snowflake's web app interface to manage its data'. A data engineer needs to create

<< Prev Question Next Question >>

Question 73/149

A company is using Snowflake's web app interface to manage its data'. A data engineer needs to create a new table, load data into it from a CSV file stored in an internal stage, and then grant SELECT privileges on the table to a specific role using the web app. Which sequence of actions within the Snowflake web app represents the most efficient and secure way to accomplish this task?

A. 1. Use the SQL worksheet to execute CREATE TABLE statement. 2. Use the Data Load Data wizard to load the CSV file. 3. Use the SQL worksheet to execute GRANT SELECT ON TABLE statement.

B. 1. Use the Database Tables interface to create the new table using the table editor. 2. Use the Data Load Data wizard to load the CSV file. 3. Use the Database -> Tables interface, select the table, and use the 'Privileges' tab to grant SELECT privilege to the role.

C. 1. Use the Database Tables interface to create the new table using the table editor. 2. Upload the CSV file directly to the table using the 'Load Data' option. 3. Use the SQL worksheet to execute GRANT SELECT ON TABLE statement.

D. 1. Use the SQL worksheet to execute CREATE TABLE statement. 2. Use the Database -> Tables interface, select the table, and use the 'Load Data' option to load the CSV file. 3. Use the Database -> Tables interface, select the table, and use the 'Privileges' tab to grant SELECT privilege to the role.

E. 1. Use the Database Tables interface to create the new table using the table editor. 2. Use the Data Load Data wizard to load the CSV file. 3. Use the SQL worksheet to execute GRANT SELECT ON TABLE statement.

Question 73/149

LEAVE A REPLY

Download PDF File