Snowflake SnowPro Core Practice Test - Questions Answers, Page 46
List of questions
Question 451
What are the benefits of the replication feature in Snowflake? (Select TWO).
Question 452
User1, who has the SYSADMIN role, executed a query on Snowsight. User2, who is in the same Snowflake account, wants to view the result set of the query executed by User1 using the Snowsight query history.
What will happen if User2 tries to access the query history?
Question 453
What is the Fail-safe retention period for transient and temporary tables?
Question 454
When floating-point number columns are unloaded to CSV or JSON files, Snowflake truncates the values to approximately what?
Question 455
How does a Snowflake stored procedure compare to a User-Defined Function (UDF)?
Question 456
Which URL provides access to files in Snowflake without authorization?
Question 457
What does the TableScan operator represent in the Query Profile?
Question 458
Which Snowflake data type is used to store JSON key value pairs?
Question 459
How does Snowflake reorganize data when it is loaded? (Select TWO).
Question 460
What activities can a user with the ORGADMIN role perform? (Select TWO).
Question