Snowflake Snowflake Certifications COF-R02 Questions & Answers

• Question 241:

  In which use cases does Snowflake apply egress charges?

  A. Data sharing within a specific region

  B. Query result retrieval

  C. Database replication

  D. Loading data into Snowflake

  Correct Answer: A

  Cloud providers apply data egress charges in either of the following use cases: Data is transferred from one region to another within the same cloud platform. Data is transferred out of the cloud platform.

  https://docs.snowflake.com/en/user-guide/billing-data-transfer.html#:~:text=Cloud%20providers%20apply%20data%20egress,out%20of%20the%20cloud%20platform.

• Question 242:

  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

  Correct Answer: B

  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 243:

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

  A. CSV

  B. JSON

  C. Parquet

  D. XML

  Correct Answer: A

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

• Question 244:

  True or False: A Virtual Warehouse can be resized while suspended.

  A. True

  B. False

  Correct Answer: A

  Reference: https://docs.snowflake.com/en/user-guide/warehouses-tasks.html#effects-of-resizing-a-suspended-warehouse

• Question 245:

  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

  Correct Answer: D

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

• Question 246:

  What happens to the underlying table data when a CLUSTER BY clause is added to a Snowflake table?

  A. Data is hashed by the cluster key to facilitate fast searches for common data values

  B. Larger micro-partitions are created for common data values to reduce the number of partitions that must be scanned

  C. Smaller micro-partitions are created for common data values to allow for more parallelism

  D. Data may be colocated by the cluster key within the micro-partitions to improve pruning performance

  Correct Answer: D

• Question 247:

  A user has unloaded data from Snowflake to a stage

  Which SQL command should be used to validate which data was loaded into the stage?

  A. list @file__stage

  B. show @file__stage

  C. view @file__stage

  D. verify @file__stage

  Correct Answer: A

• Question 248:

  What happens when a virtual warehouse is resized?

  A. When increasing the size of an active warehouse the compute resource for all running and queued queries on the warehouse are affected

  B. When reducing the size of a warehouse the compute resources are removed only when they are no longer being used to execute any current statements.

  C. The warehouse will be suspended while the new compute resource is provisioned and will resume automatically once provisioning is complete.

  D. Users who are trying to use the warehouse will receive an error message until the resizing is complete

  Correct Answer: B

• Question 249:

  Which copy INTO command outputs the data into one file?

  A. SINGLE=TRUE

  B. MAX_FILE_NUMBER=1

  C. FILE_NUMBER=1

  D. MULTIPLE=FAISE

  Correct Answer: A

• Question 250:

  A user is loading JSON documents composed of a huge array containing multiple records into Snowflake. The user enables the strip__outer_array file format option What does the STRIP_OUTER_ARRAY file format do?

  A. It removes the last element of the outer array.

  B. It removes the outer array structure and loads the records into separate table rows,

  C. It removes the trailing spaces in the last element of the outer array and loads the records into separate table columns

  D. It removes the NULL elements from the JSON object eliminating invalid data and enables the ability to load the records

  Correct Answer: B

  Data Size Limitations The VARIANT data type imposes a 16 MB size limit on individual rows. For some semi-structured data formats (e.g. JSON), data sets are frequently a simple concatenation of multiple documents. The JSON output from some software is composed of a single huge array containing multiple records. There is no need to separate the documents with line breaks or commas, though both are supported. If the data exceeds 16 MB, enable the STRIP_OUTER_ARRAY file format option for the COPY INTO [table] command to remove the outer array structure and load the records into separate table rows: copy into [table] from @~/[file].json file_format = (type = 'JSON' strip_outer_array = true);

  https://docs.snowflake.com/en/user-guide/semistructured-considerations.html