Snowflake COF-R02 Practice Test - Questions Answers, Page 8
List of questions
Related questions
Question 71

The Information Schema and Account Usage Share provide storage information for which of the following objects? (Choose three.)
Question 72

What is the default File Format used in the COPY command if one is not specified?
Explanation:
Reference: https://docs.snowflake.com/en/sql-reference/sql/copy-into-location.html
Question 73

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

True or False: Loading data into Snowflake requires that source data files be no larger than 16MB.
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.
Question 75

True or False: A Virtual Warehouse can be resized while suspended.
Explanation:
Reference: https://docs.snowflake.com/en/user-guide/warehouses-tasks.html#effects-of-resizing-asuspended-warehouse
Question 76

True or False: When you create a custom role, it is a best practice to immediately grant that role to ACCOUNTADMIN.
Explanation:
Reference: https://docs.snowflake.com/en/user-guide/security-access-control-considerations.html
Question 77

What are two ways to create and manage Data Shares in Snowflake? (Choose two.)
Explanation:
Reference: https://docs.snowflake.com/en/user-guide/data-sharing-provider.html
Question 78

True or False: Fail-safe can be disabled within a Snowflake account.
Explanation:
Reference: https://docs.snowflake.com/en/user-guide/data-failsafe.html
Separate and distinct from Time Travel, Fail-safe ensures historical data is protected in the event of a system failure or other catastrophic event, e.g. a hardware failure or security breach. Fail safe feature cannot be enabled or disabled from the user end .
Question 79

True or False: It is possible for a user to run a query against the query result cache without requiring an active Warehouse.
Explanation:
Query result cache is all about fetching the data from cloud services layer and saving the cost by not running the virtual warehouse.
Question 80

A virtual warehouse's auto-suspend and auto-resume settings apply to which of the following?
Explanation:
https://docs.snowflake.com/en/user-guide/warehousesoverview.html#:~:text=Similarly%2C%20auto%2Dresume%20ensures%20that,individual%20clusters%20in%20the%20warehouse.
Question