Snowflake SnowPro Core Certification 認定 COF-C01 試験問題:

1. True or False: When a user creates a role, they are initially assigned ownership of the role and they maintain ownership until it is transferred to another user.

A) True
B) False

2. Which of the following best describes where Snowflake's metadata is stored?

A) In the Cloud Services Layer
B) Inside the Virtual Warehouses
C) within the drivers
D) Within the data files

3. The Information Schema and Account Usage Share provide storage information for which of the following objects? (Choose three.)

A) Users
B) Databases
C) Internal Stages
D) Tables

4. How would you execute a series of SQL statements using Task?

A) A stored procedure can have only one DML statement per stored procedure invocation and therefore you should sequence stored procedures calls in the task definition CREATE TASK mytask.... AS call stored_prc1(); call stored_proc2t);
B) A stored procedure executing multiple SQL statements and invoke the stored procedure from the task. CREATE TASK mytask.... AS call stored_proc_multiple_statements_inside():
C) include the SQL statements in the body of the task create task mytask.. as insert into target1 select., from stream_s1 where ..INSERT INTO target2 SELECT .. FROM stream .s1 where ..
D) Create a task for each SQL statement (e.g. resulting in task1. task2, etc) and string the series of SQL statements by having a control task calling task 1, task 2 sequentially.

5. True or False: It is possible to query data from an Internal or named External stage without loading the data into Snowflake.

A) True
B) False

質問と回答：