Popular Vendors
Want more questions? Get Premium Access. (Click to see details)
Which object can be used with Secure Data Sharing?
Answer : A
Viewscan be used with Secure Data Sharing in Snowflake.Materialized views, external tables, and UDFs are not typically shared directly for security and performance reasons2.
Which Snowflake table objects can be shared with other accounts? (Select TWO).
Answer : B, D
In Snowflake,permanent tablesandexternal tablescan be shared with other accounts using Secure Data Sharing.Temporary tables, transient tables, and UDTFs are not shareable objects
What transformations are supported when loading data into a table using the COPY INTO
Answer : A, B
TheCOPY INTO <table>command in Snowflake supports column reordering and column omission as part of its data transformation capabilities during the load process45.
Which Snowflake database object can be used to track data changes made to table data?
Answer : C
AStreamobject in Snowflake is used for change data capture (CDC), which records data manipulation language (DML) changes made to tables, including inserts, updates, and deletes3.
While working with unstructured data, which file function generates a Snowflake-hosted file URL to a staged file using the stage name and relative file path as inputs?
TheBUILD_STAGE_FILE_URLfunction generates a Snowflake-hosted file URL to a staged file using the stage name and relative file path as inputs2.
Which Snowflake function will parse a JSON-null into a SQL-null?
Answer : D
TheSTRIP_NULL_VALUEfunction in Snowflake is used to convert a JSON null value into a SQL NULL value1.
What happens when a Snowflake user changes the data retention period at the schema level?
Answer : B
When the data retention period is changed at the schema level, all child objects that do not have an explicit retention period set will inherit the new retention period from the schema4.