SnowPro-Core 試験問題を無料オンラインアクセス

Authorization to execute CREATE <object> statements comes only from which role?

• A.Primary role
• B.Secondary role
• C.Application role
• D.Database role

What actions will prevent leveraging of the ResultSet cache? (Choose two.)

• A.Clustering of the data used by the query
• B.Executing the RESULTS_SCAN() table function
• C.Changing a column that is not in the cached query
• D.Stopping the virtual warehouse that the query is running against
• E.Removing a column from the query SELECT list

What are the default Time Travel and Fail-safe retention periods for transient tables?

• A.Time Travel - 1 day. Fail-safe - 0 days
• B.Time Travel - 0 days. Fail-safe - 1 day
• C.Time Travel - 1 day. Fail-safe - 1 day
• D.Transient tables are retained in neither Fail-safe nor Time Travel

Which native data types are used for storing semi-structured data in Snowflake? (Select TWO)

• A.NUMBER
• B.VARIANT
• C.STRING
• D.OBJECT
• E.VARCHAR

What computer language can be selected when creating User-Defined Functions (UDFs) using the Snowpark API?

• A.Python
• B.SQL
• C.JavaScript
• D.Swift