SnowPro-Core Free Practice Test

- (Exam Topic 1)
Which is true of Snowflake network policies? A Snowflake network policy: (Choose two.)

1. A. Is available to all Snowflake Editions
2. B. Is only available to customers with Business Critical Edition
3. C. Restricts or enables access to specific IP addresses
4. D. Is activated using an “ALTER DATABASE” command

Correct Answer: AC
Reference: https://docs.snowflake.com/en/sql-reference/sql/create-network-policy.html

- (Exam Topic 1)
The Query History in the Snowflake Web Interface (UI) is kept for approximately:

1. A. 60 minutes
2. B. 24 hours
3. C. 14 days
4. D. 30 days
5. E. 1 year

Correct Answer: C
Reference: https://docs.snowflake.com/en/sql-reference/account-usage/query_history.html

- (Exam Topic 3)
How does Snowflake allow a data provider with an Azure account in central Canada to share data with a data consumer on AWS in Australia?

1. A. The data provider in Azure Central Canada can create a direct share to AWS Asia Pacific, if they are both in the same organization.
2. B. The data consumer and data provider can form a Data Exchange within the same organization to create a share from Azure Central Canada to AWS Asia Pacific.
3. C. The data provider uses the GET DATA workflow in the Snowflake Data Marketplace to create a share between Azure Central Canada and AWS Asia Pacific.
4. D. The data provider must replicate the database to a secondary account in AWS Asia Pacific within the same organization then create a share to the data consumer's account.

Correct Answer: C

- (Exam Topic 3)
Which command sets the Virtual Warehouse for a session?

1. A. COPY WAREHOUSE FROM <<config file>>;
2. B. SET WAREHOUSE = <>;
3. C. USE WAREHOUSE <>;
4. D. USE VIRTUAL_WAREHOUSE <>;

Correct Answer: C
Reference: https://docs.snowflake.com/en/user-guide/warehouses-tasks.html

- (Exam Topic 3)
Why does Snowflake recommend file sizes of 100-250 MB compressed when loading data?

1. A. Optimizes the virtual warehouse size and multi-cluster setting to economy mode
2. B. Allows a user to import the files in a sequential order
3. C. Increases the latency staging and accuracy when loading the data
4. D. Allows optimization of parallel operations

Correct Answer: D