- (Topic 6)
Which Snowflake object can be used to record DML changes made to a table?
Correct Answer:C
Snowflake Streams are used to track and record Data Manipulation Language (DML) changes made to a table. Streams capture changes such as inserts, updates, and deletes, which can then be processed by other Snowflake objects or external applications.
✑ Creating a Stream:
CREATE OR REPLACE STREAM my_stream ON TABLE my_table;
✑ Using Streams:Streams provide a way to process changes incrementally, making it easier to build efficient data pipelines.
✑ Consuming Stream Data:The captured changes can be consumed using SQL queries or Snowflake tasks.
References:
✑ Snowflake Documentation: Using Streams
✑ Snowflake Documentation: Change Data Capture (CDC) with Streams
- (Topic 2)
What are supported file formats for unloading data from Snowflake? (Choose three.)
Correct Answer:BCF
The supported file formats for unloading data from Snowflake include JSON, Parquet, and CSV. These formats are commonly used for their flexibility and compatibility with various data processing tools
- (Topic 3)
Network policies can be applied to which of the following Snowflake objects? (Choose two.)
Correct Answer:DE
Network policies in Snowflake can be applied to users and accounts. These policies control inbound access to the Snowflake service and internal stages, allowing or denying access based on the originating network identifiers12.
References: [COF-C02] SnowPro Core Certification Exam Study Guide
- (Topic 3)
Which database objects can be shared with the Snowflake secure data sharing feature? (Choose two.)
Correct Answer:BC
Snowflake??s secure data sharing feature allows sharing of certain database objects with other Snowflake accounts. Among the options provided, external tables and secure UDFs can be shared
- (Topic 6)
What are the main differences between the account usage views and the information schema views? (Select TWO).
Correct Answer:CD
The account usage views in Snowflake provide historical usage data about the Snowflake account, and they retain this data for a period of up to 1 year. These views include information about dropped objects, enabling audit and tracking activities. On the other hand, information schema views provide metadata about database objects currently in use, such as tables and views, but do not include dropped objects. The retention of data in information schema views varies, but it is generally shorter than the retention for account usage views, ranging from 7 daysto a maximum of 6 months, depending on the specific view.References:Snowflake Documentation on Account Usage and Information Schema