SnowPro Core Certification Exam Questions and Answers
Question 145
Which methods can be used to delete staged files from a Snowflake stage? (Choose two.)
Options:
A.
Use the DROP command after the load completes.
B.
Specify the TEMPORARY option when creating the file format.
C.
Specify the PURGE copy option in the COPY INTO
command.
D.
Use the REMOVE command after the load completes.
E.
Use the DELETE LOAD HISTORY command after the load completes.
Answer:
C, D
Explanation:
Explanation:
To delete staged files from a Snowflake stage, you can specify the PURGE option in the COPY INTO
command, which will automatically delete the files after they have been successfully loaded. Additionally, you can use the REMOVE command after the load completes to manually delete the files from the stage12.
References = DROP STAGE, REMOVE
Question 146
Which of the following features, associated with Continuous Data Protection (CDP), require additional Snowflake-provided data storage? (Choose two.)
Options:
A.
Tri-Secret Secure
B.
Time Travel
C.
Fail-safe
D.
Data encryption
E.
External stages
Answer:
B, C
Explanation:
Explanation:
The features associated with Continuous Data Protection (CDP) that require additional Snowflake-provided data storage are Time Travel and Fail-safe. Time Travel allows users to access historical data within a defined period, while Fail-safe provides an additional layer of data protection beyond the Time Travel period. References: [COF-C02] SnowPro Core Certification Exam Study Guide
Question 147
What impacts the credit consumption of maintaining a materialized view? (Choose two.)
Options:
A.
Whether or not it is also a secure view
B.
How often the underlying base table is queried
C.
How often the base table changes
D.
Whether the materialized view has a cluster key defined
How long is the Fail-safe period for temporary and transient tables?
Options:
A.
There is no Fail-safe period for these tables.
B.
1 day
C.
7 days
D.
31 days
E.
90 days
Answer:
A
Explanation:
Explanation:
Temporary and transient tables in Snowflake do not have a Fail-safe period. Once the session ends or the tables are dropped, the data is purged and not recoverable1.
