SnowPro-Core Free Practice Test

- (Exam Topic 1)
What services does Snowflake automatically provide for customer that they may have been responsible for with their on premise system? Select all the below that apply.

1. A. Installing and configuring hardware
2. B. Patching software
3. C. Physical security
4. D. Maintaining metadata and statists

Correct Answer: ABD

- (Exam Topic 3)
What affects whether the query results cache can be used?

1. A. If the query contains a deterministic function
2. B. If the virtual warehouse has been suspended
3. C. If the referenced data in the table has changed
4. D. If multiple users are using the same virtual warehouse

Correct Answer: B

- (Exam Topic 3)
Which parameter can be used to instruct a COPY command to verify data files instead of loading them into a specified table?

1. A. STRIP_NULL_VALUES
2. B. SKIP_BYTE_ORDER_MARK
3. C. REPLACE_INVALID_CHARACTERS
4. D. VALIDATION_MODE

Correct Answer: D
https://docs.snowflake.com/en/sql-reference/sql/copy-into-table.html
VALIDATION_MODE = RETURnN__ROWS | RETURN_ERRORS | RETURN_ALL_ERRORS
String (constant) that instructs the COPY command to validate the data files instead
of loading them into the
specified table; i.e. the COPY command tests the files for errors but does not load them. The command validates the data to be loaded and returns results based on the validation option specified:

- (Exam Topic 1)
If a Small Warehouse is made up of 2 servers/cluster, how many servers/cluster make up a Medium Warehouse?

1. A. 4
2. B. 16
3. C. 32
4. D. 128

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

- (Exam Topic 2)
A marketing co-worker has requested the ability to change a warehouse size on their medium virtual warehouse called mktg__WH.
Which of the following statements will accommodate this request?

1. A. ALLOW RESIZE ON WAREHOUSE MKTG__WH TO USER MKTG__LEAD;
2. B. GRANT MODIFY ON WAREHOUSE MKTG WH TO ROLE MARKETING;
3. C. GRANT MODIFY ON WAREHOUSE MKTG__WH TO USER MKTG__LEAD;
4. D. GRANT OPERATE ON WAREHOUSE MKTG WH TO ROLE MARKETING;

Correct Answer: B