Snowflake Snowflake Certifications COF-C02 Questions & Answers

• Question 221:

  In which scenarios would a user have to pay Cloud Services costs? (Select TWO).

  A. Compute Credits = 50 Credits Cloud Services = 10

  B. Compute Credits = 80 Credits Cloud Services = 5

  C. Compute Credits = 10 Credits Cloud Services = 9

  D. Compute Credits = 120 Credits Cloud Services = 10

  E. Compute Credits = 200 Credits Cloud Services = 26

  Correct Answer: AE

• Question 222:

  The following settings are configured:

  THE MIN_DATA_RETENTION_TIME_IN_DAYS is set to 5 at the account level. THE DATA_RETENTION_TIME_IN_DAYS is set to 2 at the object level.

  For how many days will the data be retained at the object level?

  A. 2

  B. 3

  C. 5

  D. 7

  Correct Answer: C

• Question 223:

  Which data type can be used to load semi-structured data files directly, without explicitly describing the hierarchical structure of the data?

  A. TEXT

  B. VARIANT

  C. VARCHAR

  D. VARBINARY

  Correct Answer: B

• Question 224:

  A developer is granted ownership of a table that has a masking policy. The developer's role is not able to see the masked data. Will the developer be able to modify the table to read the masked data?

  A. Yes, because a table owner has full control and can unset masking policies.

  B. Yes, because masking policies only apply to cloned tables.

  C. No, because masking policies must always reference specific access roles.

  D. No, because ownership of a table does not include the ability to change masking policies

  Correct Answer: D

• Question 225:

  What Snowflake features allow virtual warehouses to handle high concurrency workloads? (Select TWO)

  A. The ability to scale up warehouses

  B. The use of warehouse auto scaling

  C. The ability to resize warehouses

  D. Use of multi-clustered warehouses

  E. The use of warehouse indexing

  Correct Answer: BD

• Question 226:

  Which of the following describes external functions in Snowflake?

  A. They are a type of User-defined Function (UDF).

  B. They contain their own SQL code.

  C. They call code that is stored inside of Snowflake.

  D. They can return multiple rows for each row received

  Correct Answer: A

  External functions are user-defined functions that are stored and executed outside of Snowflake. External functions make it easier to access external API services such as geocoders, machine learning models, and other custom code running outside of Snowflake. This feature eliminates the need to export and reimport data when using third-party services, significantly simplifying your data pipelines.

  https://docs.snowflake.com/en/sql-reference/external-functions.html#:~:text=External%20functions%20are%20user%2Ddefined,code%20running%20outside% 20of%20Snowflake.

• Question 227:

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

  A. Compute resources

  B. Query execution

  C. Authentication

  D. Data storage

  E. Metadata

  Correct Answer: CE

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

  True or False: It is possible for a user to run a query against the query result cache without requiring an active Warehouse.

  A. True

  B. False

  Correct Answer: A

  Query result cache is all about fetching the data from cloud services layer and saving the cost by not running the virtual warehouse.

• Question 229:

  Which semi-structured file format is a compressed, efficient, columnar data representation?

  A. Avro

  B. JSON

  C. TSV

  D. Parquet

  Correct Answer: D

• Question 230:

  What does Snowflake attempt to do if any of the compute resources for a virtual warehouse fail to provision during start-up?

  A. Repair the failed resources.

  B. Restart failed resources.

  C. Queue the failed resources

  D. Provision the failed resources

  Correct Answer: A