Snowflake Snowflake Certifications COF-R02 Questions & Answers

• Question 91:

  Which of the following statements describes a schema in Snowflake?

  A. A logical grouping of objects that belongs to a single database

  B. A logical grouping of objects that belongs to multiple databases

  C. A named Snowflake object that includes all the information required to share a database

  D. A uniquely identified Snowflake account within a business entity

  Correct Answer: A

• Question 92:

  Which of the following are characteristics of Snowflake virtual warehouses? (Choose two.)

  A. Auto-resume applies only to the last warehouse that was started in a multi-cluster warehouse.

  B. The ability to auto-suspend a warehouse is only available in the Enterprise edition or above.

  C. SnowSQL supports both a configuration file and a command line option for specifying a default warehouse.

  D. A user cannot specify a default warehouse when using the ODBC driver.

  E. The default virtual warehouse size can be changed at any time.

  Correct Answer: A

• Question 93:

  The bulk data load history that is available upon completion of the COPY statement is stored where and for how long?

  A. In the metadata of the target table for 14 days

  B. In the metadata of the pipe for 14 days

  C. In the metadata of the target table for 64 days

  D. In the metadata of the pipe for 64 days

  Correct Answer: A

• Question 94:

  A user has a standard multi-cluster warehouse auto-scaling policy in place.

  Which condition will trigger a cluster to shut-down?

  A. When after 2-3 consecutive checks the system determines that the load on the most-loaded cluster could be redistributed.

  B. When after 5-6 consecutive checks the system determines that the load on the most-loaded cluster could be redistributed.

  C. When after 5-6 consecutive checks the system determines that the load on the least-loaded cluster could be redistributed.

  D. When after 2-3 consecutive checks the system determines that the load on the least-loaded cluster could be redistributed.

  Correct Answer: D

• Question 95:

  A table needs to be loaded. The input data is in JSON format and is a concatenation of multiple JSON documents. The file size is 3 GB. A warehouse size small is being used. The following COPY INTO command was executed:

  COPY INTO SAMPLE FROM @~/SAMPLE.JSON (TYPE=JSON)

  The load failed with this error:

  Max LOB size (16777216) exceeded, actual size of parsed column is 17894470.

  How can this issue be resolved?

  A. Compress the file and load the compressed file.

  B. Split the file into multiple files in the recommended size range (100 MB-250 MB).

  C. Use a larger-sized warehouse.

  D. Set STRIP_OUTER_ARRAY=TRUE in the COPY INTO command.

  Correct Answer: A

• Question 96:

  User INQUISITIVE_PERSON has been granted the role DATA_SCIENCE. The role DATA_SCIENCE has privileges OWNERSHIP on the schema MARKETING of the database ANALYTICS_DW.

  Which command will show all privileges granted to that schema?

  A. SHOW GRANTS ON ROLE DATA_SCIENCE

  B. SHOW GRANTS ON SCHEMA ANALYTICS_DW.MARKETING

  C. SHOW GRANTS TO USER INQUISITIVE_PERSON

  D. SHOW GRANTS OF ROLE DATA_SCIENCE

  Correct Answer: B

• Question 97:

  Which formats does Snowflake store unstructured data in? (Choose two.)

  A. GeoJSON

  B. Array

  C. XML

  D. Object

  E. BLOB

  Correct Answer: DE

• Question 98:

  Which commands should be used to grant the privilege allowing a role to select data from all current tables and any tables that will be created later in a schema? (Choose two.)

  A. grant USAGE on all tables in schema DB1.SCHEMA to role MYROLE;

  B. grant USAGE on future tables in schema DB1.SCHEMA to role MYROLE;

  C. grant SELECT on all tables in schema DB1.SCHEMA to role MYROLE;

  D. grant SELECT on future tables in schema DB1.SCHEMA to role MYROLE;

  E. grant SELECT on all tables in database DB1 to role MYROLE;

  F. grant SELECT on future tables in database DB1 to role MYROLE;

  Correct Answer: CD

• Question 99:

  Which data types are supported by Snowflake when using semi-structured data? (Choose two.)

  A. VARIANT

  B. VARRAY

  C. STRUCT

  D. ARRAY

  E. QUEUE

  Correct Answer: AD

• Question 100:

  Which file formats are supported for unloading data from Snowflake? (Choose two.)

  A. Avro

  B. JSON

  C. ORC

  D. XML

  E. Delimited (CSV, TSV, etc.)

  Correct Answer: CE

  Reference: https://docs.snowflake.com/en/user-guide/data-unload-prepare.html#:~:text=Supported%20File%20Formats,-The%20following%20fileandtext=Delimited%20(CSV%2C%20TSV%2C%20etc,is%20comma%20(i.e.%20CSV).andtext=File %20format%20options%20specify%20the,the%20 format%20of%20the%20data