Question 1121 · 1323 in bank
What is used to denote a pre-computed data set derived from a SELECT query specification and stored for later use?
Show answer
Answer: C
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
What is used to denote a pre-computed data set derived from a SELECT query specification and stored for later use?
Answer: C
A Snowflake user wants to temporarily bypass a network policy by configuring the user object property MINS_TO_BYPASS_NETWORK_POLICY. What should they do?
Answer: D
What would cause different results to be returned when running the same query twice?
Answer: B
What is the default access of a securable object until other access is granted?
Answer: A
From what stage can a Snowflake user omit the FROM clause while loading data into a table?
Answer: B
Confirmed, B, according to docs: "Note that when copying data from files in a table stage, the FROM clause can be omitted because Snowflake automatically checks for files in the table stage."
Source: Adapted from community discussion — Isio05
What is used during the FIRST execution of SELECT COUNT(*) FROM ORDER?
Answer: D
What is the purpose of a resource monitor in Snowflake?
Answer: D
The FLATTEN function is used to query which type of data in Snowflake?
Answer: C
You can pass structured ARRAYs, structured OBJECTs, and MAPs to the FLATTEN function. https://docs.snowflake.com/en/sql-reference/data-types-structured#label-structured-types-working-flatten FLATTEN can be used to convert semi-structured data to a relational representation. https://docs.snowflake.com/en/sql-reference/functions/flatten So the answer is C. Both of the above
Source: Adapted from community discussion — aemilka
Which data formats are supported by Snowflake when unloading semi-structured data? (Choose two.)
Answer: BD
How can a 5 GB table be downloaded into a single file MOST efficiently?
Answer: C
Keyboard:J Kmove between questionsA–Dselect an answerRshow or hide the answer← →change page
COF-C02 practice, question 1121. 1323 questions available.
Version 1.0.0. How we source questions