Question 991 · 1323 in bank
If a size Small virtual warehouse costs two credits per hour, what is the credit cost per hour of a size Large virtual warehouse?
Show answer
Answer: B
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
If a size Small virtual warehouse costs two credits per hour, what is the credit cost per hour of a size Large virtual warehouse?
Answer: B
Which SQL command will list the files in a named stage?
Answer: C
correct C To list files that have been uploaded to a Snowflake stage, you can use the LIST command C correct - @~ is used only when you shortcut even list command, so "ls @~" should work as well
Source: Adapted from community discussion — Heetec
Which of the following are valid approaches to loading data into a Snowflake table? (Choose all that apply.)
Answer: ABD
bulk loading from internal stage is also possible. A B C D all are correct and supprted by snowflake https://docs.snowflake.com/en/user-guide/data-load-local-file-system
Source: Adapted from community discussion — Roohee
What is the effect of configuring a virtual warehouse auto-suspend value to ‘0’?
Answer: A
Which data types can be used in Snowflake to store semi-structured data? (Choose two.)
Answer: AE
While attempting to avoid data duplication, which COPY INTO [location] option should be used to load files with expired load metadata?
Answer: A
To load files whose metadata has expired, set the LOAD_UNCERTAIN_FILES copy option to true. The copy option references load metadata, if available, to avoid data duplication, but also attempts to load files with expired load metadata.
Source: Adapted from community discussion — romega2
What service is provided as an integrated Snowflake feature to enhance Multi-Factor Authentication (MFA) support?
Answer: A
A correct - MFA provides increased login security for users connecting to Snowflake. MFA support is provided as an integrated Snowflake feature, powered by the Duo Security service, which is managed completely by Snowflake. https://docs.snowflake.com/en/user-guide/ui-snowsight-profile
Source: Adapted from community discussion — Heetec
What is the impact on queries that are being executed when a resource monitor set to the “Notify & Suspend” threshold level is exceeded?
Answer: D
D correct - Notify & Suspend Send a notification (to all account administrators with notifications enabled) and suspend all assigned warehouses after all statements being executed by the warehouse(s) have completed. Notify & Suspend Immediately Send a notification (to all account administrators with notifications enabled) and suspend all assigned warehouses immediately, which cancels any statements being executed by the warehouses at the time.
Source: Adapted from community discussion — Heetec
What tasks can an account administrator perform in the Data Exchange? (Choose two.)
Answer: AC
AC correct By default, only an account administrator (a user with the ACCOUNTADMIN role) in the Data Exchange administrator account can manage a Data Exchange, which includes the following tasks: Add or remove members. Approve or deny listing approval requests. Approve or deny provider profile approval requests. docs.snowflake.com/en/user-guide/data-exchange-marketplace-privileges
Source: Adapted from community discussion — Heetec
Which types of subqueries does Snowflake support? (Choose two.)
Answer: BE
BE correct Snowflake currently supports the following types of subqueries: Uncorrelated scalar subqueries in any place that a value expression can be used. Correlated scalar subqueries in WHERE clauses. EXISTS, ANY / ALL, and IN subqueries in WHERE clauses. These subqueries can be correlated or uncorrelated. https://docs.snowflake.com/en/user-guide/querying-subqueries
Source: Adapted from community discussion — Heetec
Keyboard:J Kmove between questionsA–Dselect an answerRshow or hide the answer← →change page
COF-C02 practice, question 991. 1323 questions available.
Version 1.0.0. How we source questions