SnowPro-Core Free Practice Test

- (Exam Topic 3)
Which formats does Snowflake store unstructured data in? (Choose two.)

1. A. GeoJSON
2. B. Array
3. C. XML
4. D. Object
5. E. BLOB

Correct Answer: DE

- (Exam Topic 3)
Where can a user find and review the failed logins of a specific user for the past 30 days?

1. A. The USERS view in ACCOUNT_USAGE
2. B. The LOGIN_HISTORY view in ACCOUNT_USAGE
3. C. The ACCESS_HISTORY view in ACCOUNT_USAGE
4. D. The SESSIONS view in ACCOUNT_USAGE

Correct Answer: B

- (Exam Topic 1)
Why would a customer size a Virtual Warehouse from an X-Small to a Medium?

1. A. To accommodate more queries
2. B. To accommodate more users
3. C. To accommodate fluctuations in workload
4. D. To accommodate a more complex workload

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

- (Exam Topic 1)
True or False: Data Providers can share data with only the Data Consumer.

1. A. True
2. B. False

Correct Answer: B

- (Exam Topic 3)
Which statements are correct concerning the leveraging of third-party data from the Snowflake Data Marketplace? (Choose two.)

1. A. Data is live, ready-to-query, and can be personalized.
2. B. Data needs to be loaded into a cloud provider as a consumer account.
3. C. Data is not available for copying or moving to an individual Snowflake account.
4. D. Data is available without copying or moving.
5. E. Data transformations are required when combining Data Marketplace datasets with existing data in Snowflake.

Correct Answer: AD