SnowPro-Core Free Practice Test

- (Exam Topic 3)
Which of the following features are available with the Snowflake Enterprise edition? (Choose two.)

1. A. Database replication and failover
2. B. Automated index management
3. C. Customer managed keys (Tri-secret secure)
4. D. Extended time travel
5. E. Native support for geospatial data

Correct Answer: AD

- (Exam Topic 1)
When creating a user it is advisable sable to:
Choose 2 answers

1. A. Set the user to be initially disabled
2. B. Force an immediate password change
3. C. Set a default role for the user
4. D. Set the number of minutes to unlock to 15 minutes
5. E. Set the users access to expire within a specified timeframe

Correct Answer: BC

- (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