SnowPro-Core Free Practice Test

- (Exam Topic 3)
What effect does WAIT_FOR_COMPLETION = TRUE have when running an ALTER WAREHOUSE command and changing the warehouse size?

1. A. The warehouse size does not change until all queries currently running in the warehouse have completed.
2. B. The warehouse size does not change until all queries currently in the warehouse queue have completed.
3. C. The warehouse size does not change until the warehouse is suspended and restarted.
4. D. It does not return from the command until the warehouse has finished changing its size.

Correct Answer: D

- (Exam Topic 3)
Which of the following describes a Snowflake stored procedure?

1. A. They can be created as secure and hide the underlying metadata from the user.
2. B. They can only access tables from a single database.
3. C. They can contain only a single SQL statement.
4. D. They can be created to run with a caller's rights or an owner's rights.

Correct Answer: A
Reference: https://docs.snowflake.com/en/sql-reference/stored-procedures-overview.html

- (Exam Topic 3)
What versions of Snowflake should be used to manage compliance with Personal Identifiable Information (PII) requirements? (Choose two.)

1. A. Custom Edition
2. B. Virtual Private Snowflake
3. C. Business Critical Edition
4. D. Standard Edition
5. E. Enterprise Edition

Correct Answer: BC

- (Exam Topic 2)
A user is loading JSON documents composed of a huge array containing multiple records into Snowflake. The user enables the strip outer_array file format option
What does the STRIP_OUTER_ARRAY file format do?

1. A. It removes the last element of the outer array.
2. B. It removes the outer array structure and loads the records into separate table rows,
3. C. It removes the trailing spaces in the last element of the outer array and loads the records into separate table columns
4. D. It removes the NULL elements from the JSON object eliminating invalid data and enables the ability to load the records

Correct Answer: B
Data Size Limitations
The VARIANT data type imposes a 16 MB size limit on individual rows.
For some semi-structured data formats (e.g. JSON), data sets are frequently a simple concatenation of multiple documents. The JSON output from some software is composed of a single huge array containing multiple records. There is no need to separate the documents with line breaks or commas, though both are supported.
If the data exceeds 16 MB, enable the STRIP_OUTER_ARRAY file format option for the COPY INTO

.json
file_format = (type = 'JSON' strip_outer_array = true); https://docs.snowflake.com/en/user-guide/semistructured-considerations.html

QUESTION 70

- (Exam Topic 1)
When a Pipe is recreated using the CREATE OR REPLACE PIPE command:

1. A. The Pipe load history is reset to empty
2. B. The REFRESH parameter is set to TRUE
3. C. Previously loaded files will be ignored
4. D. All of the above

Reveal Solution Next Question

Correct Answer: A
https://docs.snowflake.com/en/user-guide/data-load-snowpipe-manage.html#load-history "When a pipe is recreated, the load history is dropped."

• 1
• 2
• 3
• 4
• 5
• 6
• 7
• 8
• 9
• 10
• 11
• 12
• 13
• 14
• 15
• 16
• 17
• 18
• 19
• 20
• 21
• 22
• 23

Want to Unlock All Questions for this Exam?
98.4% Pass Rate

Full Exam Access

Practice Test

Use this for 1year and renew if you’re satisfied.

$19.95

Practice, PDF

Go to Shop