Which SQL statement will require a virtual warehouse to run?
Correct Answer: C
A virtual warehouse in Snowflake is used to perform data processing tasks that require computational resources, such as queries that modify data or perform significant computation. Of the options provided: * C. INSERT INTO TBL_EMPLOYEE(EMP_ID, EMP_NAME, EMP_SALARY, DEPT) VALUES(1,'Adam',20000,'Finance');This SQL statement performs a data modification operation (DML) by inserting a new record into theTBL_EMPLOYEEtable, which requires computational resources provided by a virtual warehouse to execute. References: * Snowflake Documentation: Understanding Virtual Warehouses
Question 182
What COPY INTO SQL command should be used to unload data into multiple files?
Correct Answer: D
The COPY INTO SQL command with the option SINGLE=FALSE is used to unload data into multiple files. This option allows the data to be split into multiple files during the unload process. References: SnowPro Core Certification COPY INTO SQL command unload multiple files
Question 183
Which SQL statement will require a virtual warehouse to run?
Correct Answer: C
A virtual warehouse in Snowflake is used to perform data processing tasks that require computational resources, such as queries that modify data or perform significant computation. Of the options provided: C). INSERT INTO TBL_EMPLOYEE(EMP_ID, EMP_NAME, EMP_SALARY, DEPT) VALUES(1,'Adam', 20000,'Finance');This SQL statement performs a data modification operation (DML) by inserting a new record into theTBL_EMPLOYEEtable, which requires computational resources provided by a virtual warehouse to execute. References: Snowflake Documentation: Understanding Virtual Warehouses
Question 184
What are characteristic of Snowsight worksheet? (Select TWO.)
Correct Answer: A,E
Characteristics of Snowsight worksheets in Snowflake include: * A. Worksheets can be grouped under folders, and a folder of folders: This organizational feature allows users to efficiently manage and categorize their worksheets within Snowsight, Snowflake's web-based UI, enhancing the user experience by keeping related worksheets together. * E. Users can import worksheets and share them with other users: Snowsight supports the sharing of worksheets among users, fostering collaboration by allowing users to share queries, analyses, and findings. This feature is crucial for collaborative data exploration and analysis workflows. References: * Snowflake Documentation: Snowsight (UI for Snowflake)
Question 185
Which of the following objects can be shared through secure data sharing?
Correct Answer: D
Explanation Secure Data Sharing enables sharing selected objects in a database in your account with other Snowflake accounts. The following Snowflake database objects can be shared: * Tables * External tables * Secure views * Secure materialized views * Secure UDFs Snowflake enables the sharing of databases through shares, which are created by data providers and "imported" by data consumers. https://docs.snowflake.com/en/user-guide/data-sharing-intro.html#:~:text=Secure%20Data%20Sharing%20enabl