SnowPro-Core Free Practice Test

- (Exam Topic 2)
Which semi-structured file formats are supported when unloading data from a table? (Select TWO).

1. A. ORC
2. B. XML
3. C. Avro
4. D. Parquet
5. E. JSON

Correct Answer: DE
Semi-structured JSON, Parquet
https://docs.snowflake.com/en/user-guide/data-unload-prepare.html#:~:text=Supported File Formats,-Th

- (Exam Topic 2)
Which of the following Snowflake objects can be shared using a secure share? (Select TWO).

1. A. Materialized views
2. B. Sequences
3. C. Procedures
4. D. Tables
5. E. Secure User Defined Functions (UDFs)

Correct Answer: DE
Secure Data Sharing enables sharing selected objects in a database in your account with other Snowflake accounts. The following Snowflake database objects can be shared:
Tables
External tables
Secure views
Secure materialized views
Secure UDFs
https://docs.snowflake.com/en/user-guide/data-sharing-intro.html

- (Exam Topic 3)
What impacts the credit consumption of maintaining a materialized view? (Choose two.)

1. A. Whether or not it is also a secure view
2. B. How often the underlying base table is queried
3. C. How often the base table changes
4. D. Whether the materialized view has a cluster key defined
5. E. How often the materialized view is queried

Correct Answer: DE

- (Exam Topic 3)
Which privilege is required for a role to be able to resume a suspended warehouse if auto-resume is not enabled?

1. A. USAGE
2. B. OPERATE
3. C. MONITOR
4. D. MODIFY

Correct Answer: B
Reference:
https://community.snowflake.com/s/question/0D50Z00008yHYdqSAG/auto-resume-operate-warehouse-privileg

- (Exam Topic 1)
In which layer of its architecture does Snowflake store its metadata statistics? Select one.

1. A. Storage Layer
2. B. Compute Layer
3. C. Database Layer
4. D. Cloud Service Layer

Correct Answer: D
Reference: https://hevodata.com/blog/snowflake-architecture-cloud-data-warehouse/