SnowPro-Core Snowflake Exam Questions and Free Practice Test

Question 31

- (Exam Topic 3)
Which snowflake objects will incur both storage and cloud compute charges? (Select TWO)

A. Materialized view

B. Sequence

C. Secure view

D. Transient table

E. Clustered table

Correct Answer:DE

Question 32

- (Exam Topic 3)
Which Snowflake feature allows a user to substitute a randomly generated identifier for sensitive data, in order to prevent unauthorized users access to the data, before loading it into Snowflake?

A. External Tokenization

B. External Tables

C. Materialized Views

D. User-Defined Table Functions (UDTF)

Correct Answer:A

Question 33

- (Exam Topic 1)
What privileges are required to execute a task?

A. To execute a task, you need the EXECUTE TASK.

B. A task is an account-level object and can only be executed by the Account Admin role.

C. Tasks run automatically and do run under any rote.

D. Tasks are stored in a special database called the utility database and require EXECUTE TASK privilege in the utility database.

Correct Answer:A

Question 34

- (Exam Topic 1)
Which object allows you to limit the number of credits consumed within a Snowflake account? Select one.

A. Account usage Tracking

B. Resource Monitor

C. Warehouse Limit Parameter

D. Credit Consumption Tracker

Correct Answer:B
The time travel data retention can be overwritten at the table level "When creating a table, schema, or database, the account default can be overridden using the DATA_RETENTION_TIME_IN_DAYS parameter in the command."

Question 35

- (Exam Topic 3)
Which of the following accurately describes shares?

A. Tables, secure views, and secure UDFs can be shared

B. Shares can be shared

C. Data consumers can clone a new table from a share

D. Access to a share cannot be revoked once granted

Correct Answer:A

Question 36

- (Exam Topic 2)
Which cache type is used to cache data output from SQL queries?

A. Metadata cache

B. Result cache

C. Remote cache

D. Local file cache

Correct Answer:B
https://community.snowflake.com/s/article/Caching-in-Snowflake-Data-Warehouse

START SnowPro-Core EXAM