- (Topic 6)
What does Snowflake recommend for a user assigned the ACCOUNTADMIN role?

1. A. The ACCCUKTMKIN role should be set as tie user's default role.
2. B. The user should use federated authentication instead of a password
3. C. The user should be required to use Multi-Factor Authentication (MFA).
4. D. There should be just one user with the ACCOUNTADMIN role in each Snowflake account.

Correct Answer: C
For users assigned theACCOUNTADMINrole, Snowflake recommends enforcing Multi-Factor Authentication (MFA) to enhance security. TheACCOUNTADMIN role has extensive permissions, making it crucial to secure accounts held by such users against unauthorized access. MFA adds an additional layer of security by requiring a second form of verification beyond just the username and password, significantly reducing the risk of account compromise.References:Snowflake Security Best Practices

- (Topic 1)
Which feature is only available in the Enterprise or higher editions of Snowflake?

1. A. Column-level security
2. B. SOC 2 type II certification
3. C. Multi-factor Authentication (MFA)
4. D. Object-level access control

Correct Answer: A
Column-level security is a feature that allows fine-grained control over access to specific columns within a table. This is particularly useful for managing sensitive data and ensuring that only authorized users can view or manipulate certain pieces of information. According to my last update, this feature was available in the Enterprise Edition or higher editions of Snowflake.
References: Based on my internal data as of 2021, column-level security is an advanced feature typically reserved for higher-tiered editions like the Enterprise Edition in data warehousing solutions such as Snowflake.
https://docs.snowflake.com/en/user-guide/intro-editions.html

- (Topic 1)
What is the MOST performant file format for loading data in Snowflake?

1. A. CSV (Unzipped)
2. B. Parquet
3. C. CSV (Gzipped)
4. D. ORC

Correct Answer: B
Parquet is a columnar storage file format that is optimized for performance in Snowflake. It is designed to be efficient for both storage and query performance, particularly for complex queries on large datasets. Parquet files support efficient compression and encoding schemes, which can lead to significant savings in storage and speed in query processing, making it the most performant file format for loading data into Snowflake.
References:
✑ [COF-C02] SnowPro Core Certification Exam Study Guide
✑ Snowflake Documentation on Data Loading1

- (Topic 2)
Which Snowflake architectural layer is responsible for a query execution plan?

1. A. Compute
2. B. Data storage
3. C. Cloud services
4. D. Cloud provider

Correct Answer: C
In Snowflake??s architecture, the Cloud Services layer is responsible for generating the query execution plan. This layer handles all the coordination, optimization, and management tasks, including query parsing, optimization, and compilation into an execution plan that can be processed by the Compute layer.

- (Topic 6)
Which Snowflake table type is only visible to the user who creates it, can have the same name as permanent tables in the same schema, and is dropped at the end of the session?

1. A. Temporary
2. B. Local
3. C. User
4. D. Transient

Correct Answer: A
In Snowflake, aTemporarytable is a type of table that is only visible to the user who creates it, can have the same name as permanent tables in the same schema, and is automatically dropped at the end of the session in which it was created. Temporary tables are designed for transient data processing needs, where data is needed for the duration of a specific task or session but not beyond. Since they are automatically cleaned up at the end of the session, they help manage storage usage efficiently and ensure that sensitive data is not inadvertently persisted.
References:
✑ Snowflake Documentation on Temporary Tables: Temporary Tables