Question 791 · 1323 in bank
There are 300 concurrent users on a production Snowflake account using a single cluster virtual warehouse. The queries are small, but the response time is very slow. What is causing this to occur?
Show answer
Answer: A
SnowPro Core Certification1,323 questions across 133 pages are complete and free, with no account or card.
1323 questions in this bank
Free access · progress saved on this device
There are 300 concurrent users on a production Snowflake account using a single cluster virtual warehouse. The queries are small, but the response time is very slow. What is causing this to occur?
Answer: A
Which Snowflake edition offers the highest level of security for organizations that have the strictest requirements?
Answer: D
Virtual Private Snowflake (VPS) Virtual Private Snowflake offers our highest level of security for organizations that have the strictest requirements https://docs.snowflake.com/en/user-guide/intro-editions#feature-edition-matrix
Source: Adapted from community discussion — Makabaka
What is the MAXIMUM size limit for a record of a VARIANT data type?
Answer: B
What criteria does Snowflake use to determine the current role when initiating a session? (Choose two.)
Answer: AB
What command should be used to move data from a Snowflake database table into one or more files in an external stage?
Answer: B
How does a Snowflake user reference a directory table created on stage mystage in a SQL query?
Answer: B
Why would a Snowflake user create a secure view instead of a standard view?
Answer: B
Answer should be B Why Should I Use Secure Views? For a non-secure view, internal optimizations can indirectly expose data. Some of the internal optimizations for views require access to the underlying data in the base tables for the view. This access might allow data that is hidden from users of the view to be exposed through user code, such as user-defined functions, or other programmatic methods. Secure views do not utilize these optimizations, ensuring that users have no access to the underlying data.
Source: Adapted from community discussion — muks86
Which command can be added to the COPY command to make it load all files, whether or not the load status of the files is known?
Answer: A
A is correct. https://docs.snowflake.com/en/sql-reference/sql/copy-into-table To force the COPY command to load all files regardless of whether the load status is known, use the FORCE option instead.
Source: Adapted from community discussion — ahadh7621
How can a Snowflake user improve long-running query performance?
Answer: B
Which Snowflake feature allows administrators to identify unused data that may be archived or deleted?
Answer: A
Each row in the ACCESS_HISTORY view contains a single record per SQL statement. The record describes the columns the query accessed directly and indirectly (i.e. the underlying tables that the data for the query comes from). These records facilitate regulatory compliance auditing and provide insights on popular and frequently accessed tables and columns since there is a direct link between the user (i.e. query operator), the query, the table or view, the column, and the data
Source: Adapted from community discussion — MultiCloudIronMan
Keyboard:J Kmove between questionsA–Dselect an answerRshow or hide the answer← →change page
COF-C02 practice, question 791. 1323 questions available.
Version 1.0.0. How we source questions