Question 621 · 1323 in bank
Select 2Which of the following are characteristics of schemas used in Snowflake? (Choose two.)
Show answer
Answer: BC
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 are characteristics of schemas used in Snowflake? (Choose two.)
Answer: BC
Which Snowflake objects can be used to reduce data storage costs for short-lived tables? (Choose two.)
Answer: BC
A user has unloaded data from Snowflake to a stage. Which SQL command should be used to validate which data was loaded into the stage?
Answer: A
What are benefits of using the ACCESS_HISTORY view in the SNOWFLAKE database?
Answer: AE
A E C - no, use this instead: https://docs.snowflake.com/en/sql-reference/account-usage/network_policies B - I would probably use QUERY_HISTORY for that instead https://docs.snowflake.com/en/sql-reference/account-usage/query_history D - I would use this instead: ROW_ACCESS_POLICIES https://docs.snowflake.com/en/sql-reference/account-usage/row_access_policies
Source: Adapted from community discussion — 0e504b5
Which of the following view types are available in Snowflake? (Choose two.)
Answer: BE
Which item in the Data Warehouse migration process does not apply in Snowflake?
Answer: C
Which of the following statements describes a benefit of Snowflake’s separation of compute and storage? (Choose two.)
Answer: BC
For Snowflake, this is not an issue. You can grow and shrink the environment dynamically. The data storage grows and shrinks as you add or remove data, while the compute nodes can be ramped up or down, or turned off, as you require. You are not forced to pay for capacity up front, or kick other workloads off, or plan downtimes when ramping up your data warehouse capacity. That is the promise of cloud. This is why Snowflake is the real elastic Data Warehouse as a Service.
Source: Adapted from community discussion — learner2023
Which of the following languages can be used to implement Snowflake User Defined Functions (UDFs)? (Choose two.)
Answer: BC
What is the default compression typo when unloading data from Snowflake?
Answer: D
By default, all unloaded data files are compressed using gzip, unless compression is explicitly disabled or one of the other supported compression methods is explicitly specified. https://docs.snowflake.com/en/user-guide/intro-summary-unloading.html#:~:text=By%20default%2C%20all%20unloaded%20data,compression%20methods%20is%20explicitly%20specified.
Source: Adapted from community discussion — SV1122
Which statement describes when a virtual warehouse can be resized?
Answer: D
Keyboard:J Kmove between questionsA–Dselect an answerRshow or hide the answer← →change page
COF-C02 practice, question 621. 1323 questions available.
Version 1.0.0. How we source questions