- (Topic 6)
Which table function should be used to view details on a Directed Acyclic Graphic (DAG) run that is presently scheduled or is executing?

1. A. TASK_HISTORY
2. B. TASK_DEPENDENTS
3. C. CURRENT_TASK_GRAPHS
4. D. COMPLETE_TASK_GRAPHS

Correct Answer: C
TheCURRENT_TASK_GRAPHStable function is designed to provide information on Directed Acyclic Graphs (DAGs) that are currently scheduled or executing within Snowflake. This function offers insights into the structure and status of task chains, enabling users to monitor and troubleshoot task executions. DAGs in Snowflake represent sequences of tasks with dependencies, and understanding their current state is crucial for managing complex workflows.References:Snowflake Documentation on Task Management

- (Topic 2)
Which of the following is a data tokenization integration partner?

1. A. Protegrity
2. B. Tableau
3. C. DBeaver
4. D. SAP

Correct Answer: A
Protegrity is listed as a data tokenization integration partner for Snowflake. This partnership allows Snowflake users to utilize Protegrity??s tokenization solutions within the Snowflake environment3.
References = [COF-C02] SnowPro Core Certification Exam Study Guide, Snowflake Documentation

- (Topic 6)
What action should be taken if a Snowflake user wants to share a newly created object in a database with consumers?

1. A. Use the automatic sharing feature for seamless access.
2. B. Drop the object and then re-add it to the database to trigger sharing.
3. C. Recreate the object with a different name in the database before sharing.
4. D. Use the grant privilege ... TO share command to grant the necessary privileges.

Correct Answer: D
When a Snowflake user wants to share a newly created object in a database with consumers, the correct action to take is to use theGRANTprivilege ... TO SHARE command to grant the necessary privileges for the object to be shared. This approach allows the object owner or a user with the appropriate privileges to share database objects such as tables, secure views, and streams with other Snowflake accounts by granting access to a named share.
TheGRANTstatement specifies which privileges are granted on the object to the share. The object remains in its original location; sharing does not duplicate or move the object. Instead, it allows the specified share to access the object according to the granted privileges.
For example, to share a table, the command would be: GRANTSELECTONTABLEnew_tableTOSHARE consumer_share;
This command grants the SELECT privilege on a table namednew_tableto a share named
consumer_share, enabling the consumers of the share to query the table. Automatic sharing, dropping and re-adding the object, or recreating the object with a different name are not required or recommended practices for sharing objects in Snowflake. The use of theGRANTstatement to a share is the direct and intended method for this purpose.
Reference: Snowflake Documentation on Sharing Data
(https://docs.snowflake.com/en/user-guide/data-sharing-intro.html)

- (Topic 5)
The VALIDATE table function has which parameter as an input argument for a Snowflake user?

1. A. Last_QUERY_ID
2. B. CURRENT_STATEMENT
3. C. UUID_STRING
4. D. JOB_ID

Correct Answer: C
The VALIDATE table function in Snowflake would typically use a unique identifier, such as a UUID_STRING, as an input argument. This function is designed to validate the data within a table against a set of constraints or conditions, often requiring a specific identifier to reference the particular data or job being validated.
References:
✑ There is no direct reference to a VALIDATE table function with these specific parameters in Snowflake documentation. It seems like a theoretical example for understanding function arguments. Snowflake documentation on UDFs andsystem functions can provide guidance on how to create and use custom functions for similar purposes.

- (Topic 6)
Which SQL statement will require a virtual warehouse to run?

1. A. SELECT COUNT{*) FROM TBL_EMPLOYEE;
2. B. ALTER TABLE TBL_EMPLOYEE ADD COLUMN EMP_REGI0N VARCHAR(20);
3. C. INSERT INTO TBL_EMPLOYEE(EMP_ID, EMP_NAME, EMP_SALARY, DEPT)VALUES(1,'Adam*,20000,* Finance');
4. D. CREATE OR REPLACE TABLE TBL_EMPLOYEE ( EMP_ID NUMBER,EMP_NAME VARCHAR(30),EMP_SALARY NUMBER, DEPT VARCHAR{20));

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