Download SnowPro Core Certification.COF-C02.VCEplus.2023-01-08.30q.vcex
| Vendor: | Snowflake |
| Exam Code: | COF-C02 |
| Exam Name: | SnowPro Core Certification |
| Date: | Jan 08, 2023 |
| File Size: | 21 KB |
How to open VCEX files?
Files with VCEX extension can be opened by ProfExam Simulator.
Discount: 20%
Demo Questions
Question 1
The fail-safe retention period is how many days?
- 1 day
- 7 days
- 45 days
- 90 days
Correct answer: B
Explanation:
Reference: https://docs.snowflake.com/en/user-guide/data-failsafe.html Reference: https://docs.snowflake.com/en/user-guide/data-failsafe.html
Question 2
True or False: A 4X-Large Warehouse may, at times, take longer to provision than a X-Small Warehouse.
- True
- False
Correct answer: A
Explanation:
You can experiment the same with snowflake UI. You can experiment the same with snowflake UI.
Question 3
How would you determine the size of the virtual warehouse used for a task?
- Root task may be executed concurrently (i.e. multiple instances), it is recommended to leave some margins in the execution window to avoid missing instances of execution
- Querying (select) the size of the stream content would help determine the warehouse size. For example, if querying large stream content, use a larger warehouse size
- If using the stored procedure to execute multiple SQL statements, it's best to test run the stored procedure separately to size the compute resource first
- Since task infrastructure is based on running the task body on schedule, it's recommended to configure the virtual warehouse for automatic concurrency handling using Multi-cluster warehouse (MCW) to match the task schedule
Correct answer: C
Explanation:
Question 4
The Information Schema and Account Usage Share provide storage information for which of the following objects? (Choose three.)
- Users
- Tables
- Databases
- Internal Stages
Correct answer: ABC
Question 5
What is the default File Format used in the COPY command if one is not specified?
- CSV
- JSON
- Parquet
- XML
Correct answer: A
Explanation:
Reference: https://docs.snowflake.com/en/sql-reference/sql/copy-into-location.html Reference: https://docs.snowflake.com/en/sql-reference/sql/copy-into-location.html
Question 6
True or False: Reader Accounts are able to extract data from shared data objects for use outside of Snowflake.
- True
- False
Correct answer: A
Explanation:
Question 7
True or False: Loading data into Snowflake requires that source data files be no larger than 16MB.
- True
- False
Correct 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. 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 8
True or False: A Virtual Warehouse can be resized while suspended.
- True
- False
Correct answer: A
Explanation:
Reference: https://docs.snowflake.com/en/user-guide/warehouses-tasks.html#effects-of-resizing-asuspended-warehouse Reference: https://docs.snowflake.com/en/user-guide/warehouses-tasks.html#effects-of-resizing-asuspended-warehouse
Question 9
True or False: When you create a custom role, it is a best practice to immediately grant that role to ACCOUNTADMIN.
- True
- False
Correct answer: B
Explanation:
Reference: https://docs.snowflake.com/en/user-guide/security-access-control-considerations.html Reference: https://docs.snowflake.com/en/user-guide/security-access-control-considerations.html
Question 10
What are two ways to create and manage Data Shares in Snowflake? (Choose two.)
- Via the Snowflake Web Interface (Ul)
- Via the data_share=true parameter
- Via SQL commands
- Via Virtual Warehouses
Correct answer: AC
Explanation:
Reference: https://docs.snowflake.com/en/user-guide/data-sharing-provider.html Reference: https://docs.snowflake.com/en/user-guide/data-sharing-provider.html
HOW TO OPEN VCE FILES
Use VCE Exam Simulator to open VCE files
HOW TO OPEN VCEX AND EXAM FILES
Use ProfExam Simulator to open VCEX and EXAM files
ProfExam at a 20% markdown
You have the opportunity to purchase ProfExam at a 20% reduced price
Get Now!