Snowflake COF-C02 Online Practice Questions and Exam Preparation

Snowflake COF-C02 Online Questions & Answers

• Question 1001:

  What object does Snowflake recommend using when planning to unload similarly-formatted data on a regular basis?

  A. Stream
  B. Task
  C. Storage integration
  D. Named le format
  D. Named le format

  ---

  Explanation

• Question 1002:

  In which layer of its architecture does Snowflake store its metadata statistics?

  A. Storage Layer
  B. Compute Layer
  C. Database Layer
  D. Cloud Service Layer
  D. Cloud Service Layer

  ---

  Explanation

  https://hevodata.com/blog/snowflake-architecture-cloud-data-warehouse/

• Question 1003:

  Which of the following statements are true of Snowflake releases: (Choose two.)

  A. They happen approximately weekly
  B. They roll up and release approximately monthly, but customers can request early release application
  C. During a release, new customer requests/queries/connections transparently move over to the newer version
  D. A customer is assigned a 30 minute window (that can be moved anytime within a week) during which the system will be unavailable and customer is upgraded
  A. They happen approximately weekly
  C. During a release, new customer requests/queries/connections transparently move over to the newer version

  ---

  Explanation

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

• Question 1004:

  Which property needs to be added to the ALTER WAREHOUSE command to verify the additional compute resources for a virtual warehouse have been fully provisioned?

  A. QUERY_ACCELERATION_MAX_SCALE_FACTOR
  B. RESOURCE_MONITOR
  C. SCALING_POLICY
  D. WAIT_FOR_COMPLETION
  D. WAIT_FOR_COMPLETION

  ---

  Explanation

• Question 1005:

  What is the COPY INTO command option default for unloading data into multiple files?

  A. SINGLE = 0
  B. SINGLE = NULL
  C. SINGLE = TRUE
  D. SINGLE = FALSE
  D. SINGLE = FALSE

  ---

  Explanation

• Question 1006:

  A user is preparing to load data from an external stage. Which practice will provide the MOST efficient loading performance?

  A. Organize files into logical paths
  B. Store the files on the external stage to ensure caching is maintained
  C. Use pattern matching for regular expression execution
  D. Load the data in one large file
  A. Organize files into logical paths

  ---

  Explanation

• Question 1007:

  What statement describes Snowflake data architecture?

  A. NoSQL warehouse as a service
  B. Single-node, isolated data
  C. Multi-cluster, shared data
  D. Centralized data storage and processing
  C. Multi-cluster, shared data

  ---

  Explanation

• Question 1008:

  Which role allows a Snowflake user to view table-level storage utilization information from the TABLE_STORAGE_METRICS view by default?

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

  ---

  Explanation

• Question 1009:

  What is generally the FASTEST way to bulk load data files from a stage?

  A. Specifying a list of specific files to load
  B. Loading by path (internal stages) / prefix
  C. Using the Snowpipe REST API
  D. Using pattern matching to identify specific files by pattern
  A. Specifying a list of specific files to load

  ---

  Explanation

• Question 1010:

  A query runs significantly slower than expected. Which Query Profile metrics will help identify the issue? (Select TWO).

  A. Processing
  B. Resource usage
  C. Query Plan execution steps
  D. Bytes scanned
  E. Partitions scanned
  C. Query Plan execution steps
  E. Partitions scanned

  ---

  Explanation