Snowflake COF-C02 Online Practice Questions and Exam Preparation

Snowflake COF-C02 Online Questions & Answers

• Question 261:

  Which command can be used to unload data into an external named stage in Snowflake?

  A. PUT
  B. CREATE
  C. COPY INTO
  D. COPY INTO
  D. COPY INTO

  ---

  Explanation

  To unload data into an external named stage, the command COPY INTO is used.

  Example Syntax:

  sql

  CopyEdit

  COPY INTO 's3://mybucket/mypath/'

  FROM my_table

  STORAGE_INTEGRATION = my_s3_integration;

  This command exports data from Snowflake tables into external storage like AWS S3, Azure Blob Storage, or Google Cloud Storage.

  References:

  Snowflake Documentation: COPY INTO Command

• Question 262:

  What is the hierarchical key model in order of precedence?

  Select the objects from the list on the left, drag and put them into the correct order on the right. Level1 is the highest, level 4 is the lowest.

  Select and Place:

  

  

• Question 263:

  Which view should be checked to ensure that data has loaded successfully before removing staged files?

  A. LOAD_HISTORY
  B. STAGE_STORAGE_USAGE_HISTORY
  C. COPY_HISTORY
  D. DATA TRANSFER HISTORY
  C. COPY_HISTORY

  ---

  Explanation

• Question 264:

  What is a core benefit of clustering?

  A. To guarantee uniquely identifiable records in the database
  B. To increase scan efficiency in queries by improving pruning
  C. To improve performance by creating a separate file for point lookups
  D. To provide data redundancy by duplicating micro-partitions
  B. To increase scan efficiency in queries by improving pruning

  ---

  Explanation

• Question 265:

  What optional properties can a Snowflake user set when creating a virtual warehouse? (Choose two.)

  A. Auto-suspend
  B. Cache size
  C. Default role
  D. Resource monitor
  E. Storage size
  A. Auto-suspend
  D. Resource monitor

  ---

  Explanation

• Question 266:

  Which of the following operations require the use of a running virtual warehouse? (Choose two.)

  A. Downloading data from an internal stage
  B. Listing files in a stage
  C. Executing a stored procedure
  D. Altering a table
  E. Querying data from a materialized view
  C. Executing a stored procedure
  E. Querying data from a materialized view

  ---

  Explanation

• Question 267:

  Which command will create an ARRAY output from inputs 'a' and 'b'?

  A. ARRAY_CONSTRUCT('a', 'b');
  B. TO_ARRAY('a', 'b');
  C. AS_ARRAY('a', 'b');
  D. LISTAGG('a', 'b');
  D. LISTAGG('a', 'b');

  ---

  Explanation

• Question 268:

  Which function is used to retrieve the filename for a file stored on a stage?

  A. GET_RELATIVE_PATH
  B. GET_STAGE_LOCATION
  C. BUILD_STAGE_FILE_URL
  D. GET_OBJECT_REFERENCES
  A. GET_RELATIVE_PATH

  ---

  Explanation

• Question 269:

  Which Snowflake table supports unstructured data?

  A. Directory
  B. Transient
  C. Temporary
  D. Permanent
  A. Directory

  ---

  Explanation

• Question 270:

  Which SnowFlake edition enables data sharing only through Snowflake Support?

  A. Virtual Private Snowflake
  B. Business Critical
  C. Enterprise
  D. Standard
  A. Virtual Private Snowflake

  ---

  Explanation