SnowPro Core Certification Free Practice Exam Questions

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

1. Question 739: Which object-level parameters can be set to help control query processing and concurrency? (Choose two).
2. Question 740: What metadata does Snowflake store for rows in micro-partitions? (Choose two.)
3. Question 741: What are valid sub-clauses to the OVER clause for a window function? (Choose two.)
4. Question 742: Which kind of Snowflake table stores file-level metadata for each file in a stage?
5. Question 743: What column type does a Kafka connector store formatted information in a single column?
6. Question 744: Which SQL command will list the files in a named stage?
7. Question 745: What is the effect of configuring a virtual warehouse auto-suspend value to ‘0’?
8. Question 746: Which data types can be used in Snowflake to store semi-structured data? (Choose two.)
9. Question 747: Which types of subqueries does Snowflake support? (Choose two.)
10. Question 748: While attempting to avoid data duplication, which COPY INTO [location] option should be used to load files with expired load metadata?