Which is the non-supportable JavaScript UDF data types?
Correct Answer: C
Question 47
Which of the below concepts/functions helps while implementing advanced Column-level Security?
Correct Answer: A,B,C
Explanation Column-level Security supports using Context Functions in the conditions of the masking policy body to enforce whether a user has authorization to see data. To determine whether a user can see data in a given SQL statement, it is helpful to consider: Masking policy conditions using CURRENT_ROLE target the role in use for the current session. Masking policy conditions using INVOKER_ROLE target the executing role in a SQL statement. Role hierarchy Determine if a specified role in a masking policy condition (e.g. ANALYST custom role) is a lower privilege role in the CURRENT_ROLE or INVOKER_ROLE role hierarchy. If so, then the role returned by the CURRENT_ROLE or INVOKER_ROLE functions inherits the privileges of the specified role.
Question 48
Streams cannot be created to query change data on which of the following objects? [Select All that Apply]
Correct Answer: D
Explanation Streams supports all the listed objects except Query Log tables.
Question 49
Stuart, a Lead Data Engineer in MACRO Data Company created streams on set of External tables. He has been asked to extend the data retention period of the stream for 90 days, which parameter he can utilize to enable this extension?
Correct Answer: D
Explanation External tables do not have data retention period applicable. Good to Understand other Options available. DATA_RETENTION_TIME_IN_DAYS Type: Object (for databases, schemas, and tables) - Can be set for Account - Database - Schema - Table Description: Number of days for which Snowflake retains historical data for performing Time Trav-el actions (SELECT, CLONE, UNDROP) on the object. A value of 0 effectively disables Time Travel for the specified database, schema, or table. Values: 0 or 1 (for Standard Edition) 0 to 90 (for Enterprise Edition or higher) Default: 1 MAX_DATA_EXTENSION_TIME_IN_DAYS Type: Object (for databases, schemas, and tables) - Can be set for Account - Database - Schema - Table Description: Maximum number of days for which Snowflake can extend the data retention period for tables to prevent streams on the tables from becoming stale. By default, if the DA-TA_RETENTION_TIME_IN_DAYS setting for a source table is less than 14 days, and a stream has not been consumed, Snowflake temporarily extends this period to the stream's offset, up to a maximum of 14 days, regardless of the Snowflake Edition for your account. The MAX_DATA_EXTENSION_TIME_IN_DAYS parameter enables you to limit this automatic ex-tension period to control storage costs for data retention or for compliance reasons. This parameter can be set at the account, database, schema, and table levels. Note that setting the parameter at the account or schema level only affects tables for which the parameter has not already been explicitly set at a lower level (e.g. at the table level by the table owner). A value of 0 effective-ly disables the automatic extension for the specified database, schema, or table. Values: 0 to 90 (i.e. 90 days) - a value of 0 disables the automatic extension of the data retention period. To increase the maximum value for tables in your account, Client needs to contact Snowflake Sup-port. Default:14
Question 50
What are characteristics of Snowpark Python packages? (Select THREE). Third-party packages can be registered as a dependency to the Snowpark session using the session, import () method.
Correct Answer: A,D,E
Explanation The characteristics of Snowpark Python packages are: Third-party packages can be registered as a dependency to the Snowpark session using the session.import() method. The SQL command DESCRIBE FUNCTION will list the imported Python packages of the Python User-Defined Function (UDF). Querying information_schema.packages will provide a list of supported Python packages and versions. These characteristics indicate how Snowpark Python packages can be imported, inspected, and verified in Snowflake. The other options are not characteristics of Snowpark Python packages. Option B is incorrect because Python packages can be loaded in both local and remote environments using Snowpark. Option C is incorrect because third-party supported Python packages are not locked down to prevent hitting external endpoints, but rather restricted by network policies and security settings.
