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 object types are protected by Fail-safe? (Choose two.)
Answer: AD
Snowflake documentation only mentions fail-safe for permanent tables. No mention of materialized views of external tables. Don't know how to pick 2 answers here. https://docs.snowflake.com/en/user-guide/data-failsafe.html
Source: Adapted from community discussion — SV1122
Snowflake's approach to the management of system access combines which of the following models? (Choose two.)
Answer: B
B. Role-Based Access Control (RBAC) - Allows other than owners to access/use. E. Discretionary Access Control (DAC) - Allows ownership.
Source: Adapted from community discussion — Mike722
According to Snowflake best practice recommendations, which role should be used to create databases?
Answer: B
The system administrator (SYSADMIN) role includes the privileges to create warehouses, databases, and all database objects (schemas, tables, etc.). https://docs.snowflake.com/en/user-guide/security-access-control-considerations.html#:~:text=The%20system%20administrator%20(SYSADMIN)%20role,%2C%20tables%2C%20etc.).
Source: Adapted from community discussion — SV1122
To add or remove search optimization for a table, a user must have which of the following privileges or roles? (Choose two.)
Answer: BD
To add, configure, or remove search optimization for a table, you must have the following privileges: You must have OWNERSHIP privilege on the table. You must have ADD SEARCH OPTIMIZATION privilege on the schema that contains the table. https://docs.snowflake.com/en/user-guide/search-optimization-service.html#what-access-control-privileges-are-needed-for-the-search-optimization-service
Source: Adapted from community discussion — SV1122
While using a COPY command with a Validation_mode parameter, which of the following statements will return an error?
Answer: D
When is the result set cache no longer available? (Choose two.)
Answer: C
What is the recommended file sizing for data loading using Snowpipe?
Answer: A
Loading data files roughly 100-250 MB in size or larger reduces the overhead charge relative to the amount of total data loaded to the point where the overhead cost is immaterial.
Source: Adapted from community discussion — Kate0204
Which statements are true concerning Snowflake’s underlying cloud infrastructure? (Choose three.)
Answer: DEF
Snowflake is provided as Software-as-a-Service (SaaS) that runs completely on cloud infrastructure. This means that all three layers of Snowflake’s architecture (storage, compute, and cloud services) are deployed and managed entirely on a selected cloud platform. In addition, Snowflake’s virtual warehouses and cloud services layers are similarly deployed across three availability zones in a region.
Source: Adapted from community discussion — Kate0204
A user unloaded a Snowflake table called mytable to an internal stage called mystage. Which command can be used to view the list of files that has been uploaded to the stage?
Answer: D
Which type of table corresponds to a single Snowflake session?
Answer: A
Temporary tables only exist within the session in which they were created and persist only for the remainder of the session. https://docs.snowflake.com/en/user-guide/tables-temp-transient.html#temporary-tables
Source: Adapted from community discussion — sdnv89
Keyboard:J Kmove between questionsA–Dselect an answerRshow or hide the answer← →change page
COF-C02 practice, question 451. 1323 questions available.
Version 1.0.0. How we source questions