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?
Options
Discussion
No comments yet. Be the first to comment.
Be respectful. No spam.
Correct Answer:
C
Q: 12
A data provider wants to share data with a consumer who does not have a Snowflake account. The
provider creates a reader account for the consumer following these steps:
1. Created a user called "CONSUMER"
2. Created a database to hold the share and an extra-small warehouse to query the data
3. Granted the role PUBLIC the following privileges: Usage on the warehouse, database, and schema,
and SELECT on all the objects in the share
Based on this configuration what is true of the reader account?
Options
Discussion
No comments yet. Be the first to comment.
Be respectful. No spam.
Correct Answer:
C
Explanation
:
Q: 13
What type of query benefits the MOST from search optimization?
The Snowflake cloud services layer is responsible for which tasks? (Choose two.)
Options
Discussion
No comments yet. Be the first to comment.
Be respectful. No spam.
Correct Answer:
C, D
Explanation
:
Q: 15
What file formats does Snowflake support for loading semi-structured data? (Choose three.)
Options
Discussion
No comments yet. Be the first to comment.
Be respectful. No spam.
Correct Answer:
B, D, E
Explanation
:
Q: 16
Which stages are used with the Snowflake PUT command to upload files from a local file system?
(Choose three.)
Options
Discussion
No comments yet. Be the first to comment.
Be respectful. No spam.
Correct Answer:
A, E, F
Explanation
:
Q: 17
What happens to historical data when the retention period for an object ends?
Options
Discussion
No comments yet. Be the first to comment.
Be respectful. No spam.
Correct Answer:
D
Explanation
:
Q: 18
A table needs to be loaded. The input data is in JSON format and is a concatenation of multiple JSON
documents. The file size is 3 GB. A warehouse size small is being used. The following COPY INTO
command was executed:
COPY INTO SAMPLE FROM @~/SAMPLE.JSON (TYPE=JSON)
The load failed with this error:
Max LOB size (16777216) exceeded, actual size of parsed column is 17894470.
How can this issue be resolved?
Options
Discussion
No comments yet. Be the first to comment.
Be respectful. No spam.
Correct Answer:
A
Explanation
:
Q: 19
How should a virtual warehouse be configured if a user wants to ensure that additional multi-clusters
are resumed with no delay?
Options
Discussion
No comments yet. Be the first to comment.
Be respectful. No spam.
Correct Answer:
B
Explanation
:
Q: 20
How many days is load history for Snowpipe retained?
