Snowflake COF-C02 Online Practice Questions and Exam Preparation

Snowflake COF-C02 Online Questions & Answers

• Question 1411:

  Which Snowflake keywords help retrieve data without the need to completely scan a table? (Choose two.)

  A. TOP
  B. LIMIT
  C. FETCH
  D. SAMPLE
  E. TABLESAMPLE
  D. SAMPLE
  E. TABLESAMPLE

  ---

  Explanation

• Question 1412:

  Which database objects can be shared with the Snowflake secure data sharing feature? (Choose two.)

  A. Files
  B. External tables
  C. Secure User-Defined Functions (UDFs)
  D. Sequences
  E. Streams
  B. External tables
  C. Secure User-Defined Functions (UDFs)

  ---

  Explanation

• Question 1413:

  Which semi-structured data function interprets an input string as a JSON document that produces a VARIANT value?

  A. PARSE_JSON
  B. CHECK_JSON
  C. JSON_EXTRACT_PATH_TEXT
  D. PARSE_XML
  A. PARSE_JSON

  ---

  Explanation

• Question 1414:

  If a virtual warehouse runs for 61 seconds, shuts down, and then restarts and runs for 30 seconds, for how many seconds is it billed?

  A. 60
  B. 91
  C. 120
  D. 121
  C. 120

  ---

  Explanation

• Question 1415:

  Which statements are correct concerning the leveraging of third-party data from the Snowflake Data Marketplace? (Choose two.)

  A. Data is live, ready-to-query, and can be personalized.
  B. Data needs to be loaded into a cloud provider as a consumer account.
  C. Data is not available for copying or moving to an individual Snowflake account.
  D. Data is available without copying or moving.
  E. Data transformations are required when combining Data Marketplace datasets with existing data in Snowflake.
  A. Data is live, ready-to-query, and can be personalized.
  D. Data is available without copying or moving.

  ---

  Explanation

• Question 1416:

  When should a user consider disabling auto-suspend for a virtual warehouse? (Choose two.)

  A. When users will be using compute at different times throughout a 24/7 period
  B. When managing a steady workload
  C. When the compute must be available with no delay or lag time
  D. When the user does not want to have to manually turn on the warehouse each time it is needed
  E. When the warehouse is shared across different teams
  B. When managing a steady workload
  C. When the compute must be available with no delay or lag time

  ---

  Explanation

• Question 1417:

  What are the three things customers want most from their enterprise data warehouse solution? (Choose three)

  A. On-premise availability
  B. Simplicity
  C. Open source based
  D. Concurrency
  E. Performance
  B. Simplicity
  D. Concurrency
  E. Performance

  ---

  Explanation

• Question 1418:

  Which Snowflake object contains all the information required to share a database?

  A. Private listing
  B. Secure view
  C. Sequence
  D. Share
  D. Share

  ---

  Explanation

• Question 1419:

  In Snowflake, the use of federated authentication enables which Single Sign-On (SSO) workflow activities? (Choose two.)

  A. Authorizing users
  B. Initiating user sessions
  C. Logging into Snowflake
  D. Logging out of Snowflake
  E. Performing role authentication
  C. Logging into Snowflake
  D. Logging out of Snowflake

  ---

  Explanation

  https://docs.snowflake.com/en/user-guide/admin-security-fed-auth-overview

• Question 1420:

  While loading data from a JSON file, what enables the removal of the outer array structure from the file and loads the records into separate table rows?

  A. SKIP_BYTE_ORDER_MARK
  B. STRIP_NULL_VALUE
  C. STRIP_OUTER_ARRAY
  D. STRIP_OUTER_ELEMENT
  C. STRIP_OUTER_ARRAY

  ---

  Explanation