Which of the following describes a Snowflake stored procedure?
A. They can be created as secure and hide the underlying metadata from the user.
B. They can only access tables from a single database.
C. They can contain only a single SQL statement.
D. They can be created to run with a caller's rights or an owner's rights.
Correct Answer: D
Question 822:
The is the minimum Fail-safe retention time period for transient tables?
A. 1 day
B. 7 days
C. 12 hours
D. 0 days
Correct Answer: D
Question 823:
Which of the following activities consume virtual warehouse credits in the Snowflake environment? (Choose two.)
A. Caching query results
B. Running EXPLAIN and SHOW commands
C. Cloning a database
D. Running a custom query
E. Running COPY commands
Correct Answer: DE
A warehouse provides the required resources, such as CPU, memory, and temporary storage, to perform the following operations in a Snowflake session:
Executing SQL SELECT statements that require compute resources (e.g. retrieving rows from tables and views).
Performing DML operations, such as:
Updating rows in tables (DELETE , INSERT , UPDATE).
Loading data into tables (COPY INTO
).
Unloading data from tables (COPY INTO ).
Note - To perform these operations, a warehouse must be running and in use for the session. While a warehouse is running, it consumes Snowflake credits.
Users are responsible for data storage costs until what occurs?
A. Data expires from Time Travel
B. Data expires from Fail-safe
C. Data is deleted from a table
D. Data is truncated from a table
Correct Answer: B
Question 825:
What do the terms scale up and scale out refer to in Snowflake? (Choose two.)
A. Scaling out adds clusters of the same size to a virtual warehouse to handle more concurrent queries.
B. Scaling out adds clusters of varying sizes to a virtual warehouse.
C. Scaling out adds additional database servers to an existing running cluster to handle more concurrent queries.
D. Snowflake recommends using both scaling up and scaling out to handle more concurrent queries.
E. Scaling up resizes a virtual warehouse so it can handle more complex workloads.
F. Scaling up adds additional database servers to an existing running cluster to handle larger workloads.
Correct Answer: AE
Question 826:
A virtual warehouse is created using the following command: Create warehouse my_WH with warehouse_size = MEDIUM min_cluster_count = 1 max_cluster_count = 1 auto_suspend = 60 auto_resume = true; The image below is a graphical representation of the warehouse utilization across two days.
What action should be taken to address this situation?
A. Increase the warehouse size from Medium to 2XL.
B. Increase the value for the parameter MAX_CONCURRENCY_LEVEL.
C. Configure the warehouse to a multi-cluster warehouse.
D. Lower the value of the parameter STATEMENT_QUEUED_TIMEOUT_IN_SECONDS.
Correct Answer: C
Question 827:
Which URL type allows users to access unstructured data without authenticating into Snowflake or passing an authorization token?
A. Pre-signed URL
B. Scoped URL
C. Signed URL
D. File URL
Correct Answer: A
Pre-signed URLs are used to download or access files, via a web browser for example, without authenticating into Snowflake or passing an authorization token. These URLs are ideal for business intelligence applications or reporting tools that need to display the unstructured file contents.
Question 828:
What affects whether the query results cache can be used?
A. If the query contains a deterministic function
B. If the virtual warehouse has been suspended
C. If the referenced data in the table has changed
D. If multiple users are using the same virtual warehouse
Correct Answer: C
Question 829:
Network policies can be set at which Snowflake levels? (Choose two.)
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.
