- (Topic 1)
Which is the MINIMUM required Snowflake edition that a user must have if they want to use AWS/Azure Privatelink or Google Cloud Private Service Connect?

1. A. Standard
2. B. Premium
3. C. Enterprise
4. D. Business Critical

Correct Answer: D
https://docs.snowflake.com/en/user-guide/admin-security-privatelink.html

- (Topic 3)
How long does Snowflake retain information in the ACCESS HISTORY view?

1. A. 7 days
2. B. 14 days
3. C. 28 days
4. D. 365 days

Correct Answer: D
Snowflake retains information in the ACCESS HISTORY view for 365 days. This allows users to query the access history of Snowflake objects within the last year1.

- (Topic 3)
For the ALLOWED VALUES tag property, what is the MAXIMUM number of possible string values for a single tag?

1. A. 10
2. B. 50
3. C. 64
4. D. 256

Correct Answer: D
For the ALLOWED VALUES tag property, the maximum number of possible string values for a single tag is 256. This allows for a wide range of values to be assigned to a tag when it is set on an object

- (Topic 2)
What is true about sharing data in Snowflake? (Choose two.)

1. A. The Data Consumer pays for data storage as well as for data computing.
2. B. The shared data is copied into the Data Consumer account, so the Consumer can modify it without impacting the base data of the Provider.
3. C. A Snowflake account can both provide and consume shared data.
4. D. The Provider is charged for compute resources used by the Data Consumer to query the shared data.
5. E. The Data Consumer pays only for compute resources to query the shared data.

Correct Answer: CE
In Snowflake??s data sharing model, any full Snowflake account can both provide and consume shared data. Additionally, the data consumer pays only for the compute resources used to query the shared data. No actual data is copied or transferred between accounts, and shared data does not take up any storage in a consumer account, so the consumer does not pay for data storage1.
References = Introduction to Secure Data Sharing | Snowflake Documentation

- (Topic 1)
When unloading to a stage, which of the following is a recommended practice or approach?

1. A. Set SINGLE: = true for larger files
2. B. Use OBJECT_CONSTRUCT ( * ) when using Parquet
3. C. Avoid the use of the CAST function
4. D. Define an individual file format

Correct Answer: D
When unloading data to a stage, it is recommended to define an individual file format. This ensures that the data is unloaded in a consistent and expected format, which can be crucial for downstream processing and analysis2