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 2)
In which scenarios would a user have to pay Cloud Services costs? (Select TWO).

1. A. Compute Credits = 50 Credits Cloud Services = 10
2. B. Compute Credits = 80 Credits Cloud Services = 5
3. C. Compute Credits = 10 Credits Cloud Services = 9
4. D. Compute Credits = 120 Credits Cloud Services = 10
5. E. Compute Credits = 200 Credits Cloud Services = 26

Correct Answer: BD

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

- (Exam Topic 2)
When reviewing the load for a warehouse using the load monitoring chart, the chart indicates that a high volume of Queries are always queuing in the warehouse
According to recommended best practice, what should be done to reduce the Queue volume? (Select TWO).

1. A. Use multi-clustered warehousing to scale out warehouse capacity.
2. B. Scale up the warehouse size to allow Queries to execute faster.
3. C. Stop and start the warehouse to clear the queued queries
4. D. Migrate some queries to a new warehouse to reduce load
5. E. Limit user access to the warehouse so fewer queries are run against it.

Correct Answer: AD

- (Exam Topic 2)
Which of the following Snowflake capabilities are available in all Snowflake editions? (Select TWO)

1. A. Customer-managed encryption keys through Tri-Secret Secure
2. B. Automatic encryption of all data
3. C. Up to 90 days of data recovery through Time Travel
4. D. Object-level access control
5. E. Column-level security to apply data masking policies to tables and views

Correct Answer: BD
https://docs.snowflake.com/en/user-guide/intro-editions.html