SnowPro Core Certification Free Practice Exam Questions

1321 real SnowPro Core Certification exam questions with answers and AI explanations. Snowflake certification prep — page 61 of 133.

1. Question 608: What is the MINIMUM role required to set the value for the parameter ENABLE_ACCOUNT_DATABASE_REPLICATION?
2. Question 609: Which columns are available in the output of a Snowflake directory table? (Choose two.)
3. Question 610: By definition, a secure view is exposed only to users with what privilege?
4. Question 611: What happens when a user exits Snowsight during a session that a query is running?
5. Question 612: Which native data types are used for storing semi-structured data in Snowflake? (Choose two.)
6. Question 613: What is used to diagnose and troubleshoot network connections to Snowflake?
7. Question 614: By default, the COPY INTO [location] statement will separate table data into a set of output files to take advantage of which Snowflake feature?
8. Question 615: Which file functions are non-deterministic? (Choose two.)
9. Question 616: When floating-point number columns are unloaded to CSV or JSON files, Snowflake truncates the values to approximately what?
10. Question 617: If queries start to queue in a multi-cluster virtual warehouse an additional compute cluster starts immediately under what setting?