(Sep-2023) COF-C02 Exam Dumps Contains FREE Real Quesions from the Actual Exam [Q56-Q75]

Q56. Which of the following activities consume virtual warehouse credits in the Snowflake environment? (Choose two.)

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

Q58. Which privilege is required for a role to be able to resume a suspended warehouse if auto-resume is not enabled?

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

Q60. During periods of warehouse contention which parameter controls the maximum length of time a warehouse will hold a query for processing?

Q61. What is the purpose of using the OBJECT_CONSTRUCT function with me COPY INTO command?

Q62. When reviewing the load for a warehouse using the load monitoring chart, the chart indicates that a high volume of Queries are always queuing in the warehouse.
According to recommended best practice, what should be done to reduce the Queue volume? (Select TWO).

Q63. Which of the following are valid Snowflake Virtual Warehouse Scaling Policies? (Choose two.)

Q64. Which type of table corresponds to a single Snowflake session?

Q65. Which copy INTO command outputs the data into one file?

Q66. What role is required to use Partner Connect?

Q67. Which object allows you to limit the number of credits consumed within a Snowflake account?

Q68. Which of the following is a valid source for an external stage when the Snowflake account is located on Microsoft Azure?

Q69. True or False: All Snowflake table types include fail-safe storage.

Q70. Query parsing and compilation occurs in which architecture layer of the Snowflake Cloud Data Platform?

Q71. Which of the following compute resources or features are managed by Snowflake? (Select TWO).

Q72. A user has 10 files in a stage containing new customer data.
The ingest operation completes with no errors, using the following command:
COPY INTO my__table FROM @my__stage;
The next day the user adds 10 files to the stage so that now the stage contains a mixture of new customer data and updates to the previous data. The user did not remove the 10 original files.
If the user runs the same copy into command what will happen?

Q73. Which of the following describes how clustering keys work in Snowflake?

Q74. A company strongly encourages all Snowflake users to self-enroll in Snowflake’s default Multi-Factor Authentication (MFA) service to provide increased login security for users connecting to Snowflake.
Which application will the Snowflake users need to install on their devices in order to connect with MFA?

Q75. Which of the following features, associated with Continuous Data Protection (CDP), require additional Snowflake-provided data storage? (Choose two.)