What are the possible values within a METADATASACTION column in a Snowflake stream? (Select TWO).
Correct Answer: A,C
In Snowflake streams, the METADATASACTION column indicates the type of data manipulation operation that has occurred. The possible values include INSERT and DELETE. INSERT: Indicates that a new row has been inserted into the table. DELETE: Indicates that a row has been deleted from the table. Reference: Snowflake Documentation: Change Data Capture (CDC) with Streams Snowflake Documentation: Stream Data Capture
Question 832
Which Snowflake object contains all the information required to share a database?
Correct Answer: D
In Snowflake, a Share is the object that contains all the information required to share a database with other Snowflake accounts. Shares are used to securely share data stored in Snowflake tables and views, enabling data providers to grant data consumers access to their datasets without duplicating data. When a database is shared, it can include one or more schemas, and each schema can contain tables, views, or both. References: * Snowflake Documentation on Shares: Shares
Question 833
Which statement MOST accurately describes clustering in Snowflake?
Correct Answer: B
Clustering in Snowflake refers to the organization of data within micro-partitions, which are contiguous units of storage within Snowflake tables. Clustering keys can be defined to co-locate similar rows in the same micro-partitions, improving scan efficiency and query performance12.
Question 834
How can staged files be removed during data loading once the files have loaded successfully?
Correct Answer: B
To remove staged files during data loading after they have been successfully loaded, thePURGEcopy option is used in Snowflake. * PURGE Option: This option automatically deletes files from the stage after they have been successfully copied into the target table. * Usage: FROM @my_stage FILE_FORMAT = (type = 'csv') PURGE = TRUE; : Snowflake Documentation on COPY INTO
Question 835
A user needs to MINIMIZE the cost of large tables that are used to store transitory dat a. The data does not need to be protected against failures, because the data can be reconstructed outside of Snowflake. What table type should be used?
Correct Answer: B
For minimizing the cost of large tables that are used to store transitory data, which does not need to be protected against failures because it can be reconstructed outside of Snowflake, the best table type to use is Transient. Transient tables in Snowflake are designed for temporary or transitory data storage and offer reduced storage costs compared to permanent tables. However, unlike temporary tables, they persist across sessions until explicitly dropped. Why Transient Tables: Transient tables provide a cost-effective solution for storing data that is temporary but needs to be available longer than a single session. They have lower data storage costs because Snowflake does not maintain historical data (Time Travel) for as long as it does for permanent tables. Creating a Transient Table: To create a transient table, use the TRANSIENT keyword in the CREATE TABLE statement: CREATE TRANSIENT TABLE my_transient_table (...); Use Case Considerations: Transient tables are ideal for scenarios where the data is not critical, can be easily recreated, and where cost optimization is a priority. They are suitable for development, testing, or staging environments where data longevity is not a concern.
