Snowflake COF-C02 Online Practice Questions and Exam Preparation

Snowflake COF-C02 Online Questions & Answers

• Question 241:

  A running virtual warehouse is suspended. What is the MINIMUM amount of time that the warehouse will incur charges for when it is restarted?

  A. 1 second
  B. 60 seconds
  C. 5 minutes
  D. 60 minutes
  B. 60 seconds

  ---

  Explanation

• Question 242:

  Which of the following Snowflake capabilities are available in all Snowflake editions? (Select TWO)

  A. Customer-managed encryption keys through Tri-Secret Secure
  B. Automatic encryption of all data
  C. Up to 90 days of data recovery through Time Travel
  D. Object-level access control
  E. Column-level security to apply data masking policies to tables and views
  B. Automatic encryption of all data
  D. Object-level access control

  ---

  Explanation

  https://docs.snowflake.com/en/user-guide/intro-editions.html

• Question 243:

  What does an integration between Snowflake and Microsoft Private Link or AWS PrivateLink support?

  A. The isolation of data within a Snowflake account.
  B. The use of Secure Data Sharing among Snowflake accounts.
  C. A Virtual Private Network (VPN) between a user and Snowflake.
  D. A secure, direct connection to Snowflake that does not use the internet.
  D. A secure, direct connection to Snowflake that does not use the internet.

  ---

  Explanation

• Question 244:

  What does the worksheet and database explorer feature in Snowsight allow users to do?

  A. Add or remove users from a worksheet.
  B. Move a worksheet to a folder or a dashboard.
  C. Combine multiple worksheets into a single worksheet.
  D. Tag frequently accessed worksheets for ease of access.
  B. Move a worksheet to a folder or a dashboard.

  ---

  Explanation

  The worksheet and database explorer feature in Snowsight, Snowflake's web-based SQL editor and data visualization tool, allows users to organize and manage their worksheets effectively. While the other options mentioned (A, C, and D) are not specific to the worksheet and database explorer feature, moving a worksheet to a folder or a dashboard is a key functionality provided by Snowsight.

  By using the worksheet and database explorer, users can easily organize their worksheets by creating folders or dashboards and moving worksheets into them. This helps in maintaining a structured and organized workspace, making it easier to locate and access specific worksheets when needed.

• Question 245:

  What happens when a Snowflake user changes the data retention period at the schema level?

  A. All child objects will retain data for the new retention period.
  B. All child objects that do not have an explicit retention period will automatically inherit the new retention period.
  C. All child objects with an explicit retention period will be overridden with the new retention period.
  D. All explicit child object retention periods will remain unchanged.
  B. All child objects that do not have an explicit retention period will automatically inherit the new retention period.

  ---

  Explanation

  If you change the data retention period for a database or schema, the change only affects active objects contained within the database or schema. Any objects that have been dropped (for example, tables) remain unaffected.

  For example, if you have a schema s1 with a 90-day retention period and table t1 is in schema s1, table t1 inherits the 90-day retention period. If you drop table s1.t1, t1 is retained in Time Travel for 90 days. Later, if you change the schema's data retention period to 1 day, the retention period for the dropped table t1 is unchanged. Table t1 will still be retained in Time Travel for 90 days. https://docs.snowflake.com/en/user-guide/data-time-travel#specifying-the-data-retention-periodfor-an-object:~:text=through%20Time%20Travel.-,Note,-If%20you %20change

• Question 246:

  What is the impact of selecting one Snowflake edition over another? (Choose two.)

  A. The edition will impact the unit costs for storage.
  B. The edition will impact which regions can be accessed by the accounts.
  C. The edition will determine the unit costs for the compute credits.
  D. The edition will impact the total allowed storage space.
  E. The edition will set a limit on the number of compute credits that can be consumed.
  A. The edition will impact the unit costs for storage.
  C. The edition will determine the unit costs for the compute credits.

  ---

  Explanation

• Question 247:

  Which commands can only be executed using SnowSQL? (Choose two.)

  A. COPY INTO
  B. GET
  C. LIST
  D. PUT
  E. REMOVE
  B. GET
  D. PUT

  ---

  Explanation

• Question 248:

  What role has the privileges to create and manage data shares by default?

  A. ACCOUNTADMIN
  B. SECURITYADMIN
  C. SYSADMIN
  D. USERADMIN
  A. ACCOUNTADMIN

  ---

  Explanation

• Question 249:

  What Snowflake features are recommended to restrict unauthorized users from accessing Personal Identi able Information (PI)? (Choose two.)

  A. Dynamic Data Masking
  B. Transient tables
  C. Secure views
  D. Multi-Factor Authentication (MFA)
  E. Data encryption
  A. Dynamic Data Masking
  C. Secure views

  ---

  Explanation

• Question 250:

  A JSON document is stored in the source_column of type VARIANT. The document has an array called elements. The array contains the name key that has a string value. How can a Snowflake user extract the name from the first element?

  A. source_column.elements[1]:name
  B. source_column.elements[0]:name
  C. source_column:elements[1].name
  D. source_column:elements[0].name
  D. source_column:elements[0].name

  ---

  Explanation