- (Topic 1)
What Snowflake role must be granted for a user to create and manage accounts?

1. A. ACCOUNTADMIN
2. B. ORGADMIN
3. C. SECURITYADMIN
4. D. SYSADMIN

Correct Answer: A
The ACCOUNTADMIN role is required for a user to create and manage accounts in Snowflake. This role has the highest level of privileges and is responsible for managing all aspects of the Snowflake account, including the ability to create and manage other user accounts1.
https://docs.snowflake.com/en/user-guide/security-access-control-considerations.html

- (Topic 2)
What versions of Snowflake should be used to manage compliance with Personal Identifiable Information (PII) requirements? (Choose two.)

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

Correct Answer: BC
To manage compliance with Personal Identifiable Information (PII) requirements, the Virtual Private Snowflake and Business Critical Editions of Snowflake should be used. These editions provide advanced security features necessary for handling sensitive data

- (Topic 3)
A user needs to create a materialized view in the schema MYDB.MYSCHEMA. Which statements will provide this access?

1. A. GRANT ROLE MYROLE TO USER USER1;GRANT CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO ROLE MYROLE;
2. B. GRANT ROLE MYROLE TO USER USER1;GRANT CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO USER USER1;
3. C. GRANT ROLE MYROLE TO USER USER1;GRANT CREATE MATERIALIZED VIEW ON SCHEMA MYD
4. D. K"-'SCHEMA TO USER! ;
5. E. GRANT ROLE MYROLE TO USER USER1;GRANT CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO MYROLE;

Correct Answer: A
To provide a user with the necessary access to create a materialized view in a schema, the user must be granted a role that has the CREATE MATERIALIZED VIEW privilege on that schema. First, the role is granted to the user, and then the privilege is granted to the role

- (Topic 5)
Which data formats are supported by Snowflake when unloading semi-structured data? (Select TWO).

1. A. Binary file in Avro
2. B. Binary file in Parquet
3. C. Comma-separated JSON
4. D. Newline Delimited JSON
5. E. Plain text file containing XML elements

Correct Answer: BD
Snowflake supports a variety of file formats for unloading semi-structured data, among which Parquet and Newline Delimited JSON (NDJSON) are two widely used formats.
✑ B. Binary file in Parquet: Parquet is a columnar storage file format optimized for large-scale data processing and analysis. It is especially suited for complex nested data structures.
✑ D. Newline Delimited JSON (NDJSON): This format represents JSON records separated by newline characters, facilitating the storage and processing of multiple, separate JSON objects in a single file.
These formats are chosen for their efficiency and compatibility with data analytics tools and ecosystems, enabling seamless integration and processing of exported data.
References:
✑ Snowflake Documentation: Data Unloading

- (Topic 5)
Which Snowflow object does not consume and storage costs?

1. A. Secure view
2. B. Materialized view
3. C. Temporary table
4. D. Transient table

Correct Answer: C
Temporary tables in Snowflake do not consume storage costs. They are designed for transient data that is needed only for the duration of a session. Data stored in temporary tables is held in the virtual warehouse's cache and does not persist beyond the session's lifetime, thereby not incurring any storage charges.
References:
✑ Snowflake Documentation: Temporary Tables