SnowPro-Core Free Practice Test

- (Exam Topic 2)
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;CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO ROLE MYROLE;
2. B. GRANT ROLE MYROLE TO USER USER1;CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO USER USER1;
3. C. GRANT ROLE MYROLE TO USER USER1;CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO USER1;
4. D. GRANT ROLE MYROLE TO USER USER1;CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO MYROLE;

Correct Answer: B

- (Exam Topic 1)
True or False: An active warehouse is required to run a COPY INTO statement.

1. A. True
2. B. False

Correct Answer: A

- (Exam Topic 1)
Select the three types of tables that exist within Snowflake. Choose 3 answers

1. A. Temporary
2. B. Transient
3. C. Provisioned
4. D. Permanent

Correct Answer: ABD
Reference: https://community.snowflake.com/s/article/Making-Transient-table-by-Default

- (Exam Topic 3)
When loading data into Snowflake, how should the data be organized?

1. A. Into single files with 100-250 MB of compressed data per file
2. B. Into single files with 1-100 MB of compressed data per file
3. C. Into files of maximum size of 1 GB of compressed data per file
4. D. Into files of maximum size of 4 GB of compressed data per file

Correct Answer: A

- (Exam Topic 3)
Which of the following activities consume virtual warehouse credits in the Snowflake environment? (Choose two.)

1. A. Caching query results
2. B. Running EXPLAIN and SHOW commands
3. C. Cloning a database
4. D. Running a custom query
5. E. Running COPY commands

Correct Answer: AD