Free COF-R02 Exam Braindumps (page: 20)

Page 19 of 83

True or False: Reader Accounts are able to extract data from shared data objects for use outside of Snowflake.

  1. True
  2. False

Answer(s): A



True or False: Loading data into Snowflake requires that source data files be no larger than 16MB.

  1. True
  2. False

Answer(s): B

Explanation:

By default, COPY INTO location statements separate table data into a set of output files to take advantage of parallel operations. The maximum size for each file is set using the MAX_FILE_SIZE copy option. The default value is 16777216 (16 MB) but can be increased to accommodate larger files. The maximum file size supported is 5 GB for Amazon S3, Google Cloud Storage, or Microsoft Azure stages. To unload data to a single output file (at the potential cost of decreased performance), specify the SINGLE = true copy option in your statement. You can optionally specify a name for the file in the path.



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

  1. True
  2. False

Answer(s): A


Reference:

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



True or False: When you create a custom role, it is a best practice to immediately grant that role to ACCOUNTADMIN.

  1. True
  2. False

Answer(s): B


Reference:

https://docs.snowflake.com/en/user-guide/security-access-control-considerations.html






Post your Comments and Discuss Snowflake COF-R02 exam with other Community members:

COF-R02 Discussions & Posts