Credit charges for Snowflake virtual warehouses are calculated based on which of the following considerations? (Choose two.)
A. The number of queries executed
B. The number of active users assigned to the warehouse
C. The size of the virtual warehouse
D. The length of time the warehouse is running
E. The duration of the queries that are executed
A user has unloaded data from a Snowflake table to an external stage.
Which command can be used to verify if data has been uploaded to the external stage named my_stage?
A. view @my_stage
B. list @my_stage
C. show @my_stage
D. display @my_stage
Which cache type is used to cache data output from SQL queries?
A. Metadata cache
B. Result cache
C. Remote cache
D. Local file cache
How long is the Fail-safe period for temporary and transient tables?
A. There is no Fail-safe period for these tables.
B. 1 day
C. 7 days
D. 31 days
E. 90 days
Which account__usage views are used to evaluate the details of dynamic data masking? (Select TWO)
A. ROLES
B. POLICY_REFERENCES
C. QUERY_HISTORY
D. RESOURCE_MONIT ORS
E. ACCESS_HISTORY
F. MASKING_POLICIES
What happens when an external or an internal stage is dropped? (Select TWO).
A. When dropping an external stage, the files are not removed and only the stage is dropped
B. When dropping an external stage, both the stage and the files within the stage are removed
C. When dropping an internal stage, the files are deleted with the stage and the files are recoverable
D. When dropping an internal stage, the files are deleted with the stage and the files are not recoverable
E. When dropping an internal stage, only selected files are deleted with the stage and are not recoverable
How would you determine the size of the virtual warehouse used for a task?
A. 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
B. 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
C. 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
D. 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
Which of the following can be executed/called with Snowpipe?
A. A User Defined Function (UDF)
B. A stored procedure
C. A single copy_into statement
D. A single insert__into statement
Which Snowflake object enables loading data from files as soon as they are available in a cloud storage location?
A. Pipe
B. External stage
C. Task
D. Stream
What features does Snowflake Time Travel enable?
A. Querying data-related objects that were created within the past 365 days
B. Restoring data-related objects that have been deleted within the past 90 days
C. Conducting point-in-time analysis for Bl reporting
D. Analyzing data usage/manipulation over all periods of time
Nowadays, the certification exams become more and more important and required by more and more enterprises when applying for a job. But how to prepare for the exam effectively? How to prepare for the exam in a short time with less efforts? How to get a ideal result and how to find the most reliable resources? Here on Vcedump.com, you will find all the answers. Vcedump.com provide not only Snowflake exam questions, answers and explanations but also complete assistance on your exam preparation and certification application. If you are confused on your COF-C02 exam preparations and Snowflake certification application, do not hesitate to visit our Vcedump.com to find your solutions here.