SnowPro-Core Free Practice Test

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

1. A. External Tokenization
2. B. External Tables
3. C. Materialized Views
4. D. User-Defined Table Functions (UDTF)

Correct Answer: A

- (Exam Topic 1)
When scaling up Virtual Warehouse by increasing Virtual Warehouse t-shirt size, you are primarily scaling for improved:
Select one.

1. A. Concurrency
2. B. Performance

Correct Answer: B
Reference:
https://docs.snowflake.com/en/user-guide/warehouses-considerations.html#warehouse-resizing-improves-perfor

- (Exam Topic 3)
Assume there is a table consisting of five micro-partitions with values ranging from A to Z. Which diagram indicates a well-clustered table?

1. A. C:\Users\Admin\Desktop\Data\Odt data\Untitled.jpg
2. B. C:\Users\Admin\Desktop\Data\Odt data\Untitled.jpg
3. C. C:\Users\Admin\Desktop\Data\Odt data\Untitled.jpg
4. D. C:\Users\Admin\Desktop\Data\Odt data\Untitled.jpg

Correct Answer: A

- (Exam Topic 3)
A user has unloaded data from a Snowflake table to an external stage.
Which command can be used to verify if data has been uploaded to the external stage named my_stage?

1. A. view @my_stage
2. B. list @my_stage
3. C. show @my_stage
4. D. display @my_stage

Correct Answer: B

- (Exam Topic 3)
If a Snowflake user decides a table should be clustered, what should be used as the cluster key?

1. A. The columns that are queried in the select clause.
2. B. The columns with very high cardinality.
3. C. The columns with many different values.
4. D. The columns most actively used in the select filters.

Correct Answer: D