- (Exam Topic 1)
Which of the following objects can be cloned? (Choose four.)

1. A. Tables
2. B. Named File Formats
3. C. Schemas
4. D. Shares
5. E. Databases
6. F. Users

Correct Answer: ABCE
Which Objects Can Be Cloned?
Data Containment Objects. Databases. Schemas. Tables. Streams.
Data Configuration and Transformation Objects. Stages. File Formats. Sequences. Tasks

- (Exam Topic 1)
True or False: Micro-partition metadata enables some operations to be completed without requiring Compute.

1. A. True
2. B. False

Correct Answer: A
Reference: https://blog.ippon.tech/innovative-snowflake-features-caching/

- (Exam Topic 1)
Increasing the size of a Virtual Warehouse from an X-Small to an X-Large is an example of:

1. A. Scaling rhythmically
2. B. Scaling max
3. C. Scaling out
4. D. Scaling up

Correct Answer: D

- (Exam Topic 3)
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

- (Exam Topic 1)
How would you execute a series of SQL statements using Task?

1. A. 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 ..
2. B. 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);
3. C. A stored procedure executing multiple SQL statements and invoke the stored procedure from the task.CREATE TASK mytask.... AS callstored_proc_multiple_statements_inside():
4. D. Create a task for each SQL statement (e.
5. E. resulting in task1. task2, etc) and string the series of SQL statements by having a control task calling task 1, task 2 sequentially.

Correct Answer: C