- (Exam Topic 3)
Which Snowflake feature allows a user to substitute a randomly generated identifier for sensitive data, in order to prevent unauthorized users access to the data, before loading it into Snowflake?

1. A. External Tokenization
2. B. External Tables
3. C. Materialized Views
4. D. User-Defined Table Functions (UDTF)

Correct Answer: A

- (Exam Topic 3)
Which file formats are supported for unloading data from Snowflake? (Choose two.)

1. A. Avro
2. B. JSON
3. C. ORC
4. D. XML
5. E. Delimited (CSV, TSV, etc.)

Correct Answer: CE
Reference:
https://docs.snowflake.com/en/user-guide/data-unload-prepare.html#:~:text=Supported%20File%20Formats,-Th
%20comma%20(i.e.%20CSV).&text=File%20format%20options%20specify%20the,the%20format%20of%20th

- (Exam Topic 1)
What happens when a Data Provider revokes privileges to a Share on an object in their source database?

1. A. The object immediately becomes unavailable for all Data Consumers
2. B. Any additional data arriving after this point in time will not be visible to Data Consumers
3. C. The Data Consumers stop seeing data updates and become responsible for storage charges for the object
4. D. A static copy of the object at the time the privilege was revoked is created In the Data Consumers' accounts

Correct Answer: A

- (Exam Topic 1)
Which of the following statements are true of Snowflake releases: (Choose two.)

1. A. They happen approximately weekly
2. B. They roll up and release approximately monthly, but customers can request early release application
3. C. During a release, new customer requests/queries/connections transparently move over to the newer version
4. D. A customer is assigned a 30 minute window (that can be moved anytime within a week) during which thesystem will be unavailable and customer is upgraded

Correct Answer: AC
https://docs.snowflake.com/en/user-guide/intro-releases.html

- (Exam Topic 3)
The Snowflake cloud services layer is responsible for which tasks? (Choose two.)

1. A. Local disk caching
2. B. Authentication and access control
3. C. Metadata management
4. D. Query processing
5. E. Database storage

Correct Answer: CD