Question 1071 · 1323 in bank
True or False: Some queries can be answered through the metadata cache and do not require an active Virtual Warehouse.
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
True or False: Some queries can be answered through the metadata cache and do not require an active Virtual Warehouse.
Answer: A
What does the LATERAL modifier for the FLATTEN function do?
Answer: C
How can a Snowflake user validate data that is unloaded using the COPY INTO [location] command?
Answer: D
What role in Snowflake separates the management of users and roles from the management of all grants?
Answer: D
Which command will unload data from a table into an external stage?
Answer: C
Why is a federated environment used for user authentication in Snowflake?
Answer: C
What will happen if a Snowflake user increases the size of a suspended virtual warehouse?
Answer: C
The VALIDATE table function has which parameter as an input argument for a Snowflake user?
Answer: D
Which Snowflake edition supports Protected Health Information (PHI) data (in accordance with HIPAA and HITRUST CSF regulations), and has a dedicated metadata store and pool of compute resources?
Answer: D
Which Snowflake table types are used to manage costs for short-lived tables? (Choose two.)
Answer: DE
Keyboard:J Kmove between questionsA–Dselect an answerRshow or hide the answer← →change page
COF-C02 practice, question 1071. 1323 questions available.
Version 1.0.0. How we source questions