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 of the following features are available with the Snowflake Enterprise edition? (Choose two.)
Answer: DE
A. Database replication and fail over and C. Customer managed keys (Tri-secret secure) are supported Business Critical and above only. https://docs.snowflake.com/en/user-guide/intro-editions.html
Source: Adapted from community discussion — tejarun
What is the default file size when unloading data from Snowflake using the COPY command?
Answer: C
By default, COPY INTO location statements separate table data into a set of output files to take advantage of parallel operations. The maximum size for each file is set using the MAX_FILE_SIZE copy option. The default value is 16777216 (16 MB) but can be increased to accommodate larger files. https://docs.snowflake.com/en/user-guide/data-unload-considerations.html
Source: Adapted from community discussion — SV1122
What features that are part of the Continuous Data Protection (CDP) feature set in Snowflake do not require additional configuration? (Choose two.)
Answer: CD
Which Snowflake layer is always leveraged when accessing a query from the result cache?
Answer: D
Which connectors are available in the downloads section of the Snowflake web interface (UI)? (Choose two.)
Answer: AC
A Snowflake Administrator needs to ensure that sensitive corporate data in Snowflake tables is not visible to end users, but is partially visible to functional managers. How can this requirement be met?
Answer: B
Masking policy administrators can implement a masking policy such that analysts (i.e. users with the custom ANALYST role) can only view the last four digits of a phone number and none of the social security number, while customer support representatives (i.e. users with the custom SUPPORT role) can view the entire phone number and social security number for customer verification use cases. https://docs.snowflake.com/en/user-guide/security-column-intro.html#what-are-masking-policies
Source: Adapted from community discussion — SV1122
Users are responsible for data storage costs until what occurs?
Answer: B
Storage is calculated and charged for data regardless of whether it is in the Active, Time Travel, or Fail-safe state. Because these life-cycle states are sequential, updated/deleted data protected by CDP will continue to incur storage costs until the data leaves the Fail-safe state. https://docs.snowflake.com/en/user-guide/tables-storage-considerations.html
Source: Adapted from community discussion — halol
A user has an application that writes a new file to a cloud storage location every 5 minutes. What would be the MOST efficient way to get the files into Snowflake?
Answer: D
What affects whether the query results cache can be used?
Answer: C
Answer: C Result Cache: Which holds the results of every query executed in the past 24 hours. These are available across virtual warehouses, so query results returned to one user is available to any other user on the system who executes the same query, provided the underlying data has not changed.
Source: Adapted from community discussion — Naah
Which of the following is an example of an operation that can be completed without requiring compute, assuming no queries have been executed previously?
Answer: C
Keyboard:J Kmove between questionsA–Dselect an answerRshow or hide the answer← →change page
COF-C02 practice, question 361. 1323 questions available.
Version 1.0.0. How we source questions