- (Exam Topic 3)
How are serverless features billed?

1. A. Per second multiplied by an automatic sizing for the job
2. B. Per minute multiplied by an automatic sizing for the job, with a minimum of one minute
3. C. Per second multiplied by the size, as determined by the SERVERLESS_FEATURES_SIZE account parameter
4. D. Serverless features are not billed, unless the total cost for the month exceeds 10% of the warehouse credits, on the account

Correct Answer: D

- (Exam Topic 2)
How would you determine the size of the virtual warehouse used for a task?

1. A. Root task may be executed concurrently (i.
2. B. multiple instances), it is recommended to leave some margins in the execution window to avoid missing instances of execution
3. C. Querying (select) the size of the stream content would help determine the warehouse siz
4. D. For example, if querying large stream content, use a larger warehouse size
5. E. If using the stored procedure to execute multiple SQL statements, it's best to test run the stored procedure separately to size the compute resource first
6. F. Since task infrastructure is based on running the task body on schedule, it's recommended to configure the virtual warehouse for automatic concurrency handling using Multi-cluster warehouse (MCW) to match the task schedule

Correct Answer: C

- (Exam Topic 1)
True or false: Snowflake enforces unique, primary key, and foreign key constraints during DML operations.

1. A. True
2. B. False

Correct Answer: B
Reference: https://docs.snowflake.com/en/sql-reference/constraints-overview.html

- (Exam Topic 2)
What are the default Time Travel and Fail-safe retention periods for transient tables?

1. A. Time Travel - 1 da
2. B. Fail-safe - 1 day
3. C. Time Travel - 0 day
4. D. Fail-safe - 1 day
5. E. Time Travel - 1 da
6. F. Fail-safe - 0 days
7. G. Transient tables are retained in neither Fail-safe nor Time Travel

Correct Answer: C
https://docs.snowflake.com/en/user-guide/data-cdp-storage-costs.html#:~:text=Temporary%20and%20Transient

- (Exam Topic 3)
What features that are part of the Continuous Data Protection (CDP) feature set in Snowflake do not require additional configuration? (Choose two.)

1. A. Row level access policies
2. B. Data masking policies
3. C. Data encryption
4. D. Time Travel
5. E. External tokenization

Correct Answer: CD