Snowflake COF-C02 Online Practice Questions and Exam Preparation

Snowflake COF-C02 Online Questions & Answers

• Question 1421:

  Which type of URL gives permanent access to files in cloud storage?

  A. Pre-signed URL
  B. Account URL
  C. Scoped URL
  D. File URL
  A. Pre-signed URL

  ---

  Explanation

  A Pre-signed URL provides temporary or permanent access to specific files in cloud storage (e.g., S3, Azure Blob, or Google Cloud Storage) by embedding credentials or access permissions into the URL. In Snowflake, pre-signed URLs are

  commonly used to securely access files in external stages or other cloud storage without sharing permanent credentials.

  Why Pre-signed URL?

  Why Other Options Are Incorrect:

  B. Account URL: Refers to the URL for accessing Snowflake accounts, not files in cloud storage.

  C. Scoped URL: Not a valid term in Snowflake or cloud storage.

  D. File URL: Not a specific type of secure URL.

  References:

  Using Pre-signed URLs with Snowflake

• Question 1422:

  Which type of role can be granted to a share?

  A. Account role
  B. Custom role
  C. Database role
  D. Secondary role
  C. Database role

  ---

  Explanation

• Question 1423:

  What are reasons for using the VALIDATE function in Snowflake after a COPY INTO command execution? (Choose two.)

  A. To validate the files that have been loaded earlier using the COPY INTO command
  B. To fix errors that were made during the execution of the COPY INTO command
  C. To return errors encountered during the execution of the COPY INTO command
  D. To identify potential issues in the COPY INTO command before it is executed
  E. To count the number of errors encountered during the execution of the COPY INTO command
  A. To validate the files that have been loaded earlier using the COPY INTO command
  C. To return errors encountered during the execution of the COPY INTO command

  ---

  Explanation

• Question 1424:

  Data in Fail-safe can be deleted by a user or the Snowflake team before it expires.

  A. True
  B. False
  B. False

  ---

  Explanation

  https://blog.knoldus.com/ksnow-time-travel-and-fail-safe-in-snowflake/

• Question 1425:

  Which REST API can be used with unstructured data?

  A. insertFiles
  B. insertReport
  C. GET /api/files/
  D. loadHistoryScan
  C. GET /api/files/

  ---

  Explanation

• Question 1426:

  When active, a pipe requires a dedicated Virtual Warehouse to execute.

  A. True
  B. False
  B. False

  ---

  Explanation

• Question 1427:

  A Snowflake user executed a query and received the results. Another user executed the same query 4 hours later. The data had not changed. What will occur?

  A. No virtual warehouse will be used, data will be read from the result cache.
  B. No virtual warehouse will be used, data will be read from the local disk cache.
  C. The default virtual warehouse will be used to read all data.
  D. The virtual warehouse that is defined at the session level will be used to read all data.
  A. No virtual warehouse will be used, data will be read from the result cache.

  ---

  Explanation

• Question 1428:

  Which services does the Snowflake Cloud Services layer manage? (Select TWO).

  A. Compute resources
  B. Query execution
  C. Authentication
  D. Data storage
  E. Metadata
  C. Authentication
  E. Metadata

  ---

  Explanation

  https://docs.snowflake.com/en/user-guide/intro-key-concepts.html The cloud services layer is a collection of services that coordinate activities across Snowflake. These services tie together all of the different components of Snowflake in order to process user requests, from login to query dispatch. The cloud services layer also runs on compute instances provisioned by Snowflake from the cloud provider. Services managed in this layer include: Authentication Infrastructure management Metadata management Query parsing and optimization Access control

• Question 1429:

  A JSON object is loaded into a column named data using a Snowflake variant datatype. The root node of the object is BIKE. The child attribute for this root node is BIKEID.

  Which statement will allow the user to access BIKEID?

  A. select data:BIKEID
  B. select data.BIKE.BIKEID
  C. select data:BIKE.BIKEID
  D. select data:BIKE:BIKEID
  C. select data:BIKE.BIKEID

  ---

  Explanation

• Question 1430:

  Which statistics are displayed in a Query Profile that indicate that intermediate results do not fit in memory? (Choose two.)

  A. Bytes scanned
  B. Partitions scanned
  C. Bytes spilled to local storage
  D. Bytes spilled to remote storage
  E. Percentage scanned from cache
  C. Bytes spilled to local storage
  D. Bytes spilled to remote storage

  ---

  Explanation