Question 201 · 1323 in bank
Select 2Which Snowflake keywords help retrieve data without the need to completely scan a table? (Choose two.)
Show answer
Answer: AE
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
Which Snowflake keywords help retrieve data without the need to completely scan a table? (Choose two.)
Answer: AE
A complex query has been running in Snowsight for more than one hour. At the same time, several other queries from other worksheets ran successfully. What is FASTEST way to cancel the long-running query?
Answer: B
https://docs.snowflake.com/en/user-guide/querying-cancel-statements The recommended way to cancel a statement is to use the interface of the application in which the query is running (e.g. the Worksheet in the Snowflake web interface) or the cancellation API provided by the Snowflake ODBC or JDBC driver. However, in some cases, it is necessary to cancel a query using SQL. Snowflake provides the following functions to support using SQL to cancel running/active statements: SYSTEM$CANCEL_ALL_QUERIES SYSTEM$CANCEL_QUERY I say B.
Source: Adapted from community discussion — 37ceea2
How does the search optimization service improve query performance?
Answer: B
How can a Data Exchange Administrator provide a user with account access to a Data Exchange?
Answer: C
https://docs.snowflake.com/en/user-guide/data-exchange-using#access-consumer-listings All users can browse listings in the Data Exchange, but only users with the ACCOUNTADMIN role or the IMPORT SHARE privilege can get or request data. Indeed, the B answer is correct, but I do not think that the question is looking for such simple reply. It is clear that first step for getting access to data in DATA EXCHANGE is the user to be added. I expect that the question assumed that this was already done. Answer is C.
Source: Adapted from community discussion — 37ceea2
The Information Schema and Account Usage Share provide storage information for which of the following objects? (Choose three.)
Answer: BCD
Couldn't find any information where storage of a user is explained/showed. Tables in Account Usage view related to storage are (database, stage, table): DATABASE_STORAGE_USAGE_HISTORY, STAGE_STORAGE_USAGE_HISTORY, STORAGE_USAGE, TABLE_STORAGE_METRICS
Source: Adapted from community discussion — William_20
Which features can be used with the Snowflake Standard edition? (Choose two.)
Answer: BD
What are valid values for the FIELD_OPTIONALLY_ENCLOSED_BY option in the COPY INTO [location] command used during data unloading? (Choose two.)
Answer: AD
What identifiers are supported when creating a Snowflake account hostname? (Choose two.)
Answer: AD
Which virtual warehouse auto-suspend configurations will result in a warehouse that runs continually, 24 hours a day, 7 days a week? (Choose two.)
Answer: BE
What kind of value does a User-Defined Function (UDF) return? (Choose two.)
Answer: DE
Keyboard:J Kmove between questionsA–Dselect an answerRshow or hide the answer← →change page
COF-C02 practice, question 201. 1323 questions available.
Version 1.0.0. How we source questions