- (Topic 4)
What Snowflake feature provides a data hub for secure data collaboration, with a selected group of invited members?

1. A. Data Replication
2. B. Secure Data Sharing
3. C. Data Exchange
4. D. Snowflake Marketplace

Correct Answer: C
Snowflake??s Data Exchange feature provides a data hub for secure data collaboration. It allows providers to publish data that can be discovered and accessed by a selected group of invited members, facilitating secure and controlled data sharing within a collaborative environment3. References: [COF-C02] SnowPro Core Certification Exam Study Guide

- (Topic 6)
Which type of workload is recommended for Snowpark-optimized virtual warehouses?

1. A. Workloads with ad hoc analytics
2. B. Workloads that have large memory requirements
3. C. Workloads with unpredictable data volumes for each query
4. D. Workloads that are queried with small table scans and selective filters

Correct Answer: B
Snowpark-optimized virtual warehouses in Snowflake are designed to efficiently handle workloads with large memory requirements. Snowpark is a developer framework that allows users to write code in languages like Scala, Java, and Python to process data in Snowflake. Given the nature of these programming languages and the types of data processing tasks they are typically used for, having a virtual warehouse that can efficiently manage large memory-intensive operations is crucial.
✑ Understanding Snowpark-Optimized Virtual Warehouses:
✑ Large Memory Requirements:
✑ Other Considerations:
References:
✑ Snowflake Documentation: Introduction to Snowpark
✑ Snowflake Documentation: Virtual Warehouses

- (Topic 5)
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?

1. A. If User2 has the sysadmin role they will be able to see the results.
2. B. If User2 has the securityadmin role they will be able to see the results.
3. C. If User2 has the ACCOUNTADMIN role they will be able to see the results.
4. D. User2 will be unable to view the result set of the query executed by User1.

Correct Answer: C
In Snowflake, the query history and the results of queries executed by a user are accessible based on the roles and permissions. If User1 executed a query with the SYSADMIN role, User2 would be able to view the result set of that query executed by User1 only if User2 has the ACCOUNTADMIN role. The ACCOUNTADMIN role has the broadest set of privileges, including the ability to access all aspects of the account's operation, data, and query history, thus enabling User2 to view the results of queries executed by other users.
References:
✑ Snowflake Documentation: Understanding Snowflake Roles

- (Topic 3)
Using variables in Snowflake is denoted by using which SQL character?

1. A. @
2. B. &
3. C. $
4. D. #

Correct Answer: C
VeryComprehensiveExplanation=InSnowflake,variablesaredenotedbyadollarsign().Variable s can be used in SQL statements where a literal constant is allowed, and they must be prefixed with a $ sign to distinguish them from bind values and column names.

- (Topic 2)
What is the minimum Snowflake edition that has column-level security enabled?

1. A. Standard
2. B. Enterprise
3. C. Business Critical
4. D. Virtual Private Snowflake

Correct Answer: B
Column-level security, which allows for the application of masking policies to columns in tables or views, is available starting from the Enterprise edition of Snowflake1. References = [COF-C02] SnowPro Core Certification Exam Study Guide, Snowflake Documentation1