Snowflake COF-C02 Online Practice Questions and Exam Preparation

Snowflake COF-C02 Online Questions & Answers

• Question 571:

  Which command is used to download data from Snowflake to a client machine?

  A. COPY INTO
  B. PUT
  C. DROP
  D. GET
  D. GET

  ---

  Explanation

• Question 572:

  Awarding a user which privileges on all virtual warehouses is equivalent to granting the user the global MANAGE WAREHOUSES privilege?

  A. MODIFY, MONITOR and OPERATE privileges
  B. OWNERSHIP and USAGE privileges
  C. APPLYBUDGET and AUDIT privileges
  D. MANAGE LISTING AUTOFULFILLMENT and RESOLVE ALL privileges
  A. MODIFY, MONITOR and OPERATE privileges

  ---

  Explanation

• Question 573:

  Which Snowflake data types can be used to build nested hierarchical data? (Choose two.)

  A. INTEGER
  B. OBJECT
  C. VARIANT
  D. VARCHAR
  E. LIST
  B. OBJECT
  C. VARIANT

  ---

  Explanation

• Question 574:

  Which COPY INTO command options impact the number of files generated? (Select TWO).

  A. SINGLE
  B. RECORD_DELIMITER
  C. MAX_FILE_SIZE
  D. INCLUDE_QUERY_ID
  E. DETAILED_OUTPUT
  A. SINGLE
  C. MAX_FILE_SIZE

  ---

  Explanation

• Question 575:

  Which loop type iterates until a condition is true?

  A. FOR
  B. LOOP
  C. REPEAT
  D. WHILE
  C. REPEAT

  ---

  Explanation

• Question 576:

  Which function can be used to convert semi-structured data into rows and columns?

  A. TABLE
  B. FLATTEN
  C. PARSE_JSON
  D. JSON_EXTRACT_PATH_TEXT
  B. FLATTEN

  ---

  Explanation

  FLATTEN can be used to convert semi-structured data to a relational representation.

• Question 577:

  Which use case does the search optimization service support?

  A. Disjuncts (OR) in join predicates
  B. LIKE/ILIKE/RLIKE join predicates
  C. Join predicates on VARIANT columns
  D. Conjunctions (AND) of multiple equality predicates
  D. Conjunctions (AND) of multiple equality predicates

  ---

  Explanation

  Search optimization can improve the performance of these types of queries:

  1)Equality or IN Predicates

  2)Substrings and Regular Expressions (LIKE/ILIKE/RLIKE/CONTAINS,... )

  3)Fields in VARIANT Columns

  4)Geospatial Functions

  5)Conjunctions of Supported Predicates (AND)

  6)Disjunctions of Supported Predicates (OR)

  ----------------------------------------------------------------------------------- The search optimization service does not directly improve the performance of joins.

  https://docs.snowflake.com/en/user-guide/search-optimization-service#label-search-optimization-service-queries

• Question 578:

  Which copy INTO command outputs the data into one file?

  A. SINGLE=TRUE
  B. MAX_FILE_NUMBER=1
  C. FILE_NUMBER=1
  D. MULTIPLE=FAISE
  A. SINGLE=TRUE

  ---

  Explanation

• Question 579:

  In a managed access schema, who can grant privileges on objects in the schema to other roles? (Choose two.)

  A. The schema owner role
  B. The ORGADMIN system role
  C. The USERADMIN system role
  D. The role with the MANAGE GRANTS privilege
  E. The role that owns the object in the schema
  A. The schema owner role
  D. The role with the MANAGE GRANTS privilege

  ---

  Explanation

• Question 580:

  For which use case will transient tables be MOST cost-effective?

  A. The table data does not require Fail-safe.
  B. The table data requires long-term storage.
  C. The table data is frequently accessed and modified.
  D. The table data is frequently shared with external accounts.
  A. The table data does not require Fail-safe.

  ---

  Explanation