ExamGecko
Home / Snowflake / COF-R02 / List of questions
Ask Question

Snowflake COF-R02 Practice Test - Questions Answers, Page 8

Question list
Search

Question 71

Report
Export
Collapse

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

Users
Users
Tables
Tables
Databases
Databases
Internal Stages
Internal Stages
Suggested answer: A, B, C
asked 23/09/2024
Mohammed Meddah
39 questions

Question 72

Report
Export
Collapse

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

CSV
CSV
JSON
JSON
Parquet
Parquet
XML
XML
Suggested answer: A

Explanation:

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

asked 23/09/2024
Steven Owens
40 questions

Question 73

Report
Export
Collapse

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

True
True
False
False
Suggested answer: A
asked 23/09/2024
Gabriel Ty
33 questions

Question 74

Report
Export
Collapse

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

True
True
False
False
Suggested answer: 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.

asked 23/09/2024
Tracy Nicholas
33 questions

Question 75

Report
Export
Collapse

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

True
True
False
False
Suggested answer: A

Explanation:

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

asked 23/09/2024
Steven Owens
36 questions

Question 76

Report
Export
Collapse

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

True
True
False
False
Suggested answer: B

Explanation:

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

asked 23/09/2024
Dennis Bruyn
39 questions

Question 77

Report
Export
Collapse

What are two ways to create and manage Data Shares in Snowflake? (Choose two.)

Via the Snowflake Web Interface (Ul)
Via the Snowflake Web Interface (Ul)
Via the data_share=true parameter
Via the data_share=true parameter
Via SQL commands
Via SQL commands
Via Virtual Warehouses
Via Virtual Warehouses
Suggested answer: A, C

Explanation:

Reference: https://docs.snowflake.com/en/user-guide/data-sharing-provider.html

asked 23/09/2024
Susan Brady
47 questions

Question 78

Report
Export
Collapse

True or False: Fail-safe can be disabled within a Snowflake account.

True
True
False
False
Suggested answer: B

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 .

asked 23/09/2024
Albert Tedjadiputra
35 questions

Question 79

Report
Export
Collapse

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

True
True
False
False
Suggested answer: A

Explanation:

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

asked 23/09/2024
khalid Hassan
33 questions

Question 80

Report
Export
Collapse

A virtual warehouse's auto-suspend and auto-resume settings apply to which of the following?

The primary cluster in the virtual warehouse
The primary cluster in the virtual warehouse
The entire virtual warehouse
The entire virtual warehouse
The database in which the virtual warehouse resides
The database in which the virtual warehouse resides
The Queries currently being run on the virtual warehouse
The Queries currently being run on the virtual warehouse
Suggested answer: B

Explanation:

https://docs.snowflake.com/en/user-guide/warehousesoverview.html#:~:text=Similarly%2C%20auto%2Dresume%20ensures%20that,individual%20clusters%20in%20the%20warehouse.

asked 23/09/2024
gregori carmona lorenzo
38 questions
Total 330 questions
Go to page: of 33