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 data type is supported by Snowflake data classification?
Answer: B
https://docs.snowflake.com/en/user-guide/governance-classify-concepts.html#what-is-classification You can classify table and view columns for all supported data types except for the following data types: GEOGRAPHY BINARY VARIANT
Source: Adapted from community discussion — halol
When unloading data to an external stage, which compression format can be used for Parquet files with the COPY INTO command?
Answer: C
None if the above. by default it should be Snappy. "When unloading data, files are compressed using the Snappy algorithm by default. You can optionally specify this value." https://docs.snowflake.com/en/sql-reference/sql/create-file-format#type-parquet:~:text=When%20unloading%20data%2C%20files%20are%20compressed%20using%20the%20Snappy%20algorithm%20by%20default.%20You%20can%20optionally%20specify%20this%20value.
Source: Adapted from community discussion — SexyPotato
Which SQL command can be used to verify the privileges that are granted to a role?
Answer: C
Which Query Profile result indicates that a warehouse is sized too small?
Answer: B
What is the default Time Travel retention period?
Answer: A
No tasks are required to enable Time Travel. It is automatically enabled with the standard, 1-day retention period. However, you may wish to upgrade to Snowflake Enterprise Edition to enable configuring longer data retention periods of up to 90 days for databases, schemas, and tables.
Source: Adapted from community discussion — learner2023
Which of the following are best practice recommendations that should be considered when loading data into Snowflake? (Choose two.)
Answer: CD
Which schema has the RESOURCE_MONITORS view?
Answer: B
RESOURCE_MONITORS View: This Account Usage view displays the resource monitors that have been created in the reader accounts managed by the account. Note This view is only available in the READER_ACCOUNT_USAGE schema. https://docs.snowflake.com/en/sql-reference/account-usage/resource_monitors
Source: Adapted from community discussion — Avi0407
What is the purpose of enabling Federated Authentication on a Snowflake account?
Answer: D
In a federated environment, user authentication is separated from user access through the use of one or more external entities that provide independent authentication of user credentials. The authentication is then passed to one or more services, enabling users to access the services through SSO. A federated environment consists of the following components:
Source: Adapted from community discussion — bibisa
The PUT command: (Choose two.)
Answer: CD
Uploaded files are automatically encrypted with 128-bit or 256-bit keys. AUTO_COMPRESS is TRUE by default and by default it uses GZIP. https://docs.snowflake.com/en/sql-reference/sql/put.html
Source: Adapted from community discussion — SV1122
Which Snowflake partner category is represented at the top of this diagram (labeled 1)?
Answer: D
Keyboard:J Kmove between questionsA–Dselect an answerRshow or hide the answer← →change page
COF-C02 practice, question 441. 1323 questions available.
Version 1.0.0. How we source questions