SnowPro-Core Free Practice Test

- (Exam Topic 3)
Which of the following is an example of an operation that can be completed without requiring compute, assuming no queries have been executed previously?

1. A. SELECT SUM (ORDER_AMT) FROM SALES;
2. B. SELECT AVG(ORDER_QTY) FROM SALES;
3. C. SELECT MIN(ORDER_AMT) FROM SALES;
4. D. SELECT ORDER_AMT * ORDER_QTY FROM SALES;

Correct Answer: B

- (Exam Topic 2)
A developer is granted ownership of a table that has a masking policy. The developer's role is not able to see the masked data. Will the developer be able to modify the table to read the masked data?

1. A. Yes, because a table owner has full control and can unset masking policies.
2. B. Yes, because masking policies only apply to cloned tables.
3. C. No, because masking policies must always reference specific access roles.
4. D. No, because ownership of a table does not include the ability to change masking policies

Correct Answer: A

- (Exam Topic 3)
Which of the following describes a Snowflake stored procedure?

1. A. They can be created as secure and hide the underlying metadata from the user.
2. B. They can only access tables from a single database.
3. C. They can contain only a single SQL statement.
4. D. They can be created to run with a caller's rights or an owner's rights.

Correct Answer: A
Reference: https://docs.snowflake.com/en/sql-reference/stored-procedures-overview.html

- (Exam Topic 2)
Where would a Snowflake user find information about query activity from 90 days ago?

1. A. Account___usage . query history view
2. B. account___usage.query___history___archive View
3. C. information___schema . cruery_history view
4. D. information___schema - query history_by_ses s i on view

Correct Answer: A

- (Exam Topic 1)
True or False: Query ID’s are unique across all Snowflake deployments and can be used in communication with Snowflake Support to help troubleshoot issues.

1. A. True
2. B. False

Correct Answer: A