SnowPro-Core Free Practice Test

- (Exam Topic 2)
When reviewing a query profile, what is a symptom that a query is too large to fit into the memory?

1. A. A single join node uses more than 50% of the query time
2. B. Partitions scanned is equal to partitions total
3. C. An AggregateOperacor node is present
4. D. The query is spilling to remote storage

Correct Answer: D

- (Exam Topic 1)
What are the three things customers want most from their enterprise data warehouse solution? Choose 3 answers

1. A. On-premise availability
2. B. Simplicity
3. C. Open source based
4. D. Concurrency
5. E. Performance

Correct Answer: BDE

- (Exam Topic 1)
Which of the following are examples of operations that require a Virtual Warehouse to complete, assuming no quires have been executed previously?
Choose 3 answers

1. A. MIN(< < column value>>)
2. B. COPY
3. C. SUM(<< column>>)
4. D. UPDATE

Correct Answer: BCD

- (Exam Topic 3)
Which of the following statements describes a schema in Snowflake?

1. A. A logical grouping of objects that belongs to a single database
2. B. A logical grouping of objects that belongs to multiple databases
3. C. A named Snowflake object that includes all the information required to share a database
4. D. A uniquely identified Snowflake account within a business entity

Correct Answer: A

- (Exam Topic 1)
Data storage for individual tables can be monitored using which commands and/or object(s)? Choose 2 answers

1. A. SHOW TABLES;
2. B. SHOW STORAGE BY TABLE;
3. C. Information Schema -> TABLE_STORAGE_METRICS
4. D. Information Schema -> TASLE_HISTORY

Correct Answer: AC