Snowflake COF-R02 Online Practice Questions and Exam Preparation

Snowflake COF-R02 Online Questions & Answers

• Question 191:

  Which of the following accurately describes shares?

  A. Tables, secure views, and secure UDFs can be shared
  B. Shares can be shared
  C. Data consumers can clone a new table from a share
  D. Access to a share cannot be revoked once granted
  A. Tables, secure views, and secure UDFs can be shared

• Question 192:

  A sales table FCT_SALES has 100 million records.

  The following Query was executed

  SELECT COUNT (1) FROM FCT__SALES;

  How did Snowflake fulfill this query?

  A. Query against the result set cache
  B. Query against a virtual warehouse cache
  C. Query against the most-recently created micro-partition
  D. Query against the metadata excite
  D. Query against the metadata excite

• Question 193:

  What happens when an external or an internal stage is dropped? (Select TWO).

  A. When dropping an external stage, the files are not removed and only the stage is dropped
  B. When dropping an external stage, both the stage and the files within the stage are removed
  C. When dropping an internal stage, the files are deleted with the stage and the files are recoverable
  D. When dropping an internal stage, the files are deleted with the stage and the files are not recoverable
  E. When dropping an internal stage, only selected files are deleted with the stage and are not recoverable
  A. When dropping an external stage, the files are not removed and only the stage is dropped
  C. When dropping an internal stage, the files are deleted with the stage and the files are recoverable

• Question 194:

  What is the default File Format used in the COPY command if one is not specified?

  A. CSV
  B. JSON
  C. Parquet
  D. XML
  A. CSV

  ---

  Explanation/Reference:

  Reference: https://docs.snowflake.com/en/sql-reference/sql/copy-into-location.html

• Question 195:

  Query parsing and compilation occurs in which architecture layer of the Snowflake Cloud Data Platform?

  A. Cloud services layer
  B. Compute layer
  C. Storage layer
  D. Cloud agnostic layer
  B. Compute layer

  ---

  Explanation/Reference:

  Reference: https://www.projectpro.io/article/snowflake-architecture-what-does-snowflake-do/556

• Question 196:

  What features does Snowflake Time Travel enable?

  A. Querying data-related objects that were created within the past 365 days
  B. Restoring data-related objects that have been deleted within the past 90 days
  C. Conducting point-in-time analysis for Bl reporting
  D. Analyzing data usage/manipulation over all periods of time
  B. Restoring data-related objects that have been deleted within the past 90 days

  ---

  Explanation/Reference:

  Snowflake Time Travel enables accessing historical data (i.e. data that has been changed or deleted) at any point within a defined period. It serves as a powerful tool for performing the following tasks:

  Restoring data-related objects (tables, schemas, and databases) that might have been accidentally or intentionally deleted. Duplicating and backing up data from key points in the past. Analyzing data usage/manipulation over specified

  periods of time.

  https://docs.snowflake.com/en/user-guide/data-time-travel.html

• Question 197:

  Which columns are part of the result set of the Snowflake LATERAL FLATTEN command? (Choose two.)

  A. CONTENT
  B. PATH
  C. BYTE_SIZE
  D. INDEX
  E. DATATYPE
  B. PATH
  C. BYTE_SIZE

• Question 198:

  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
  D. Load the data in one large file

• Question 199:

  A user has an application that writes a new Tile to a cloud storage location every 5 minutes. What would be the MOST efficient way to get the files into Snowflake?

  A. Create a task that runs a copy into operation from an external stage every 5 minutes
  B. Create a task that puts the files in an internal stage and automate the data loading wizard
  C. Create a task that runs a GET operation to intermittently check for new files
  D. Set up cloud provider notifications on the Tile location and use Snowpipe with auto-ingest
  D. Set up cloud provider notifications on the Tile location and use Snowpipe with auto-ingest

  ---

  Explanation/Reference:

  https://docs.snowflake.com/en/user-guide/data-load-snowpipe-intro.html

• Question 200:

  A company strongly encourages all Snowflake users to self-enroll in Snowflake's default Multi-Factor Authentication (MFA) service to provide increased login security for users connecting to Snowflake.

  Which application will the Snowflake users need to install on their devices in order to connect with MFA?

  A. Okta Verify
  B. Duo Mobile
  C. Microsoft Authenticator
  D. Google Authenticator
  B. Duo Mobile

  ---

  Explanation/Reference:

  https://docs.snowflake.com/en/user-guide/security-mfa.html