File Info
| Exam | SnowPro Core Certification |
| Number | COF-C02 |
| File Name | Snowflake.COF-C02.VCEplus.2023-01-08.30q.tqb |
| Size | 105 KB |
| Posted | Jan 08, 2023 |
| Download | Snowflake.COF-C02.VCEplus.2023-01-08.30q.tqb |
How to open VCEX & EXAM Files?
Files with VCEX & EXAM extensions can be opened by ProfExam Simulator.
Coupon: MASTEREXAM
With 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:
