Question 1281 · 1323 in bank
Which view will show the MOST recent information about table-level storage utilization?
Show answer
Answer: C
SnowPro Core Certification1,323 questions across 133 pages are complete and free, with no account or card.
1323 questions in this bank
Free access · progress saved on this device
Which view will show the MOST recent information about table-level storage utilization?
Answer: C
Which virtual warehouse consideration can help lower compute resource credit consumption?
Answer: C
To use the OVERWRITE option on INSERT, which privilege must be granted to the role?
Answer: B
Correct. To use the OVERWRITE option on INSERT, you must use a role that has DELETE privilege on the table because OVERWRITE will delete the existing records in the table.
Source: Adapted from community discussion — KarthyJay
What happens when a suspended virtual warehouse is resized in Snowflake?
Answer: D
Which file format option should be used when unloading data into a stage to create a CSV or a JSON file?
Answer: C
How does Snowflake handle the data retention period for a table if a stream has not been consumed?
Answer: C
If the data retention period for a table is less than 14 days, and a stream has not been consumed, Snowflake temporarily extends this period to prevent it from going stale. The period is extended to the stream’s offset, up to a maximum of 14 days by default, regardless of the Snowflake edition for your account. The maximum number of days for which Snowflake can extend the data retention period is determined by the MAX_DATA_EXTENSION_TIME_IN_DAYS parameter value. When the stream is consumed, the extended data retention period is reduced to the default period for the table.
Source: Adapted from community discussion — KarthyJay
Which command can be used to determine if data from a file has been previously loaded?
Answer: A
Which URL identifies the database, schema, stage, and file path to a set of files for accessing the unstructured data files in Snowflake?
Answer: B
Which Snowflake feature or service is primarily used for managing and monitoring data and user activities?
Answer: A
How can data be securely shared across regions and cloud platforms in Snowflake?
Answer: B
Keyboard:J Kmove between questionsA–Dselect an answerRshow or hide the answer← →change page
COF-C02 practice, question 1281. 1323 questions available.
Version 1.0.0. How we source questions