- (Topic 4)
What happens when a Snowflake user changes the data retention period at the schema level?

1. A. All child objects will retain data for the new retention period.
2. B. All child objects that do not have an explicit retention period will automatically inherit thenew retention period.
3. C. All child objects with an explicit retention period will be overridden with the new retention period.
4. D. All explicit child object retention periods will remain unchanged.

Correct Answer: B
When the data retention period is changed at the schema level, all child objects that do not have an explicit retention period set will inherit the new retention period from the schema4.

- (Topic 4)
What is a directory table in Snowflake?

1. A. A separate database object that is used to store file-level metadata
2. B. An object layered on a stage that is used to store file-level metadata
3. C. A database object with grantable privileges for unstructured data tasks
4. D. A Snowflake table specifically designed for storing unstructured files

Correct Answer: B
A directory table in Snowflake is an object layered on a stage that is used to store file-level metadata. It is not a separate database object but is conceptually similar to an external table because it stores metadata about the data files in the stage5.

- (Topic 1)
Which of the following are valid methods for authenticating users for access into Snowflake? (Select THREE)

1. A. SCIM
2. B. Federated authentication
3. C. TLS 1.2
4. D. Key-pair authentication
5. E. OAuth
6. F. OCSP authentication

Correct Answer: BDE
Snowflake supports several methods for authenticating users, including federated authentication, key-pair authentication, and OAuth. Federated authentication allows users to authenticate using their organization??s identity provider. Key-pair authentication uses a public-private key pair for secure login, and OAuth is an open standard for access delegation commonly used for token-based authentication. References: Authentication policies | SnowflakeDocumentation, Authenticating to the server | Snowflake Documentation, External API authentication and secrets | Snowflake Documentation.

- (Topic 3)
Which TABLE function helps to convert semi-structured data to a relational representation?

1. A. CHECK_JSON
2. B. TO_JSON
3. C. FLATTEN
4. D. PARSE_JSON

Correct Answer: C
The FLATTEN table function in Snowflake is used to convert semi- structured data, such as JSON or XML, into a relational format. It expands nested arrays or objects into multiple rows, making the data suitable for relational querying3.

- (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