Snowflake COF-R02 Online Practice Questions and Exam Preparation

Snowflake COF-R02 Online Questions & Answers

• Question 41:

  Which of the following compute resources or features are managed by Snowflake? (Select TWO).

  A. Execute a COPY command
  B. Updating data
  C. Snowpipe
  D. AUTOMATIC__CLUSTERING
  E. Scaling up a warehouse
  A. Execute a COPY command
  D. AUTOMATIC__CLUSTERING

• Question 42:

  What actions will prevent leveraging of the ResultSet cache? (Choose two.)

  A. Removing a column from the query SELECT list
  B. Stopping the virtual warehouse that the query is running against
  C. Clustering of the data used by the query
  D. Executing the RESULTS_SCAN() table function
  E. Changing a column that is not in the cached query
  A. Removing a column from the query SELECT list
  D. Executing the RESULTS_SCAN() table function

• Question 43:

  The PUT command: (Choose two.)

  A. Automatically creates a File Format object
  B. Automatically uses the last Stage created
  C. Automatically compresses files using Gzip
  D. Automatically encrypts files
  C. Automatically compresses files using Gzip
  D. Automatically encrypts files

  ---

  Explanation/Reference:

  Reference: https://docs.snowflake.com/en/sql-reference/sql/put.html

• Question 44:

  Which of the following connectors allow Multi-Factor Authentication (MFA) authorization when connecting? (Choose all that apply.)

  A. JDBC
  B. SnowSQL
  C. Snowflake Web Interface (UI)
  D. ODBC
  E. Python
  F. PlaceHolder
  A. JDBC
  B. SnowSQL
  C. Snowflake Web Interface (UI)
  D. ODBC
  E. Python

• Question 45:

  True or False: The user has to specify which cluster a query will run on in multi-clustering Warehouse.

  A. True
  B. False
  B. False

  ---

  Explanation/Reference:

  Reference: https://docs.snowflake.com/en/user-guide/warehouses-multicluster.html

• Question 46:

  Which command can be used to load data into an internal stage?

  A. LOAD
  B. copy
  C. GET
  D. PUT
  D. PUT

  ---

  Explanation/Reference:

  https://medium.com/@divyanshsaxenaofficial/snowflake-loading-unloading-of-data-part-1-internal-stages-7121cc3cc9

• Question 47:

  Why does Snowflake recommend file sizes of 100-250 MB compressed when loading data?

  A. Optimizes the virtual warehouse size and multi-cluster setting to economy mode
  B. Allows a user to import the files in a sequential order
  C. Increases the latency staging and accuracy when loading the data
  D. Allows optimization of parallel operations
  D. Allows optimization of parallel operations

• Question 48:

  Assume there is a table consisting of five micro-partitions with values ranging from A to Z.

  Which diagram indicates a well-clustered table?

  

  A. Option A
  B. Option B
  C. Option C
  D. Option D
  A. Option A

• Question 49:

  How does Snowflake allow a data provider with an Azure account in central Canada to share data with a data consumer on AWS in Australia?

  A. The data provider in Azure Central Canada can create a direct share to AWS Asia Pacific, if they are both in the same organization.
  B. The data consumer and data provider can form a Data Exchange within the same organization to create a share from Azure Central Canada to AWS Asia Pacific.
  C. The data provider uses the GET DATA workflow in the Snowflake Data Marketplace to create a share between Azure Central Canada and AWS Asia Pacific.
  D. The data provider must replicate the database to a secondary account in AWS Asia Pacific within the same organization then create a share to the data consumer's account.
  C. The data provider uses the GET DATA workflow in the Snowflake Data Marketplace to create a share between Azure Central Canada and AWS Asia Pacific.

• Question 50:

  Which methods can be used to delete staged files from a Snowflake stage? (Choose two.)

  A. Use the DROP command after the load completes.
  B. Specify the TEMPORARY option when creating the file format.
  C. Specify the PURGE copy option in the COPY INTO command.
  D. Use the REMOVE command after the load completes.
  E. Use the DELETE LOAD HISTORY command after the load completes.
  C. Specify the PURGE copy option in the COPY INTO command.
  D. Use the REMOVE command after the load completes.