Snowflake COF-C02 Online Practice Questions and Exam Preparation

Snowflake COF-C02 Online Questions & Answers

• Question 1161:

  Which type of workload is recommended for Snowpark-optimized virtual warehouses?

  A. Workloads with ad hoc analytics
  B. Workloads that have large memory requirements
  C. Workloads with unpredictable data volumes for each query
  D. Workloads that are queried with small table scans and selective filters
  B. Workloads that have large memory requirements

  ---

  Explanation

• Question 1162:

  Which function can be used to convert semi-structured data into a relational representation?

  A. FLATTEN
  B. OBJECT_KEYS
  C. PARSE_JSON
  D. ARRAYS_TO_OBJECT
  A. FLATTEN

  ---

  Explanation

• Question 1163:

  In Snowflake's data security framework, how does column-level security contribute to the protection of sensitive information? (Choose two.)

  A. Implementation of column-level security will optimize query performance.
  B. Column-level security supports encryption of the entire database.
  C. Column-level security ensures that only the table owner can access the data.
  D. Column-level security limits access to specific columns within a table based on user privileges.
  E. Column-level security allows the application of a masking policy to a column within a table or view.
  D. Column-level security limits access to specific columns within a table based on user privileges.
  E. Column-level security allows the application of a masking policy to a column within a table or view.

  ---

  Explanation

• Question 1164:

  What is the maximum total Continuous Data Protection (CDP) charges incurred for a temporary table?

  A. 30 days
  B. 7 days
  C. 48 hours
  D. 24 hours
  D. 24 hours

  ---

  Explanation

• Question 1165:

  A large JSON file contains a single array with many 10 MB JSON objects that include NULLs. The NULLs are meaningful and do not indicate any missing values.

  What file format parameters will ensure that all of the data is loaded into Snowflake?

  A. TYPE = JSON, STRIP_OUTER_ARRAY = TRUE, STRIP_NULL_VALUES = TRUE
  B. TYPE = JSON, STRIP_OUTER_ARRAY = TRUE, STRIP_NULL_VALUES = FALSE
  C. TYPE = JSON, STRIP_OUTER_ARRAY = FALSE, STRIP_NULL_VALUES = TRUE
  D. TYPE = JSON, STRIP_OUTER_ARRAY = FALSE, STRIP_NULL_VALUES = FALSE
  B. TYPE = JSON, STRIP_OUTER_ARRAY = TRUE, STRIP_NULL_VALUES = FALSE

  ---

  Explanation

• Question 1166:

  How can data be securely shared across regions and cloud platforms in Snow ake?

  A. Use Cross-Cloud Auto-Ful llment.
  B. Use replication.
  C. Use the CREATE SHARE command.
  D. Use the GRANT command to share selected objects.
  B. Use replication.

  ---

  Explanation

• Question 1167:

  How long is the Fail-safe period for temporary and transient tables?

  A. There is no Fail-safe period for these tables.
  B. 1 day
  C. 7 days
  D. 31 days
  E. 90 days
  A. There is no Fail-safe period for these tables.

  ---

  Explanation

  https://docs.snowflake.com/en/user-guide/tables-temp-transient.html

• Question 1168:

  How are micro-partitions typically generated in Snowflake?

  A. Automatically
  B. ORDER BY ;
  C. PARTITION BY ;
  D. GROUP BY ;
  A. Automatically

  ---

  Explanation

• Question 1169:

  Which operations are handled in the Cloud Services layer of Snowflake? (Choose two.)

  A. Security
  B. Data storage
  C. Data visualization
  D. Query computation
  E. Metadata management
  A. Security
  E. Metadata management

  ---

  Explanation

• Question 1170:

  When will Snowflake charge credits for the use of the Cloud Services layer?

  A. Credits will be charged whenever the Cloud Services layer is used.
  B. Credits will be charged only when running a Snow ake-provisioned compute warehouse COMPUTE_WH.
  C. Credits will be charged when the daily consumption of cloud services resources exceeds 10% of the daily warehouse usage.
  D. Credits will be charged only when a virtual warehouse consumes serverless compute services.
  A. Credits will be charged whenever the Cloud Services layer is used.

  ---

  Explanation