Exam Name: | SnowPro Core Certification Exam | ||
Exam Code: | COF-C02 Dumps | ||
Vendor: | Snowflake | Certification: | SnowPro Core Certification |
Questions: | 820 Q&A's | Shared By: | alvey |
What is the SNOWFLAKE.ACCOUNT_USAGE view that contains information about which objects were read by queries within the last 365 days (1 year)?
A single user of a virtual warehouse has set the warehouse to auto-resume and auto-suspend after 10 minutes. The warehouse is currently suspended and the user performs the following actions:
1. Runs a query that takes 3 minutes to complete
2. Leaves for 15 minutes
3. Returns and runs a query that takes 10 seconds to complete
4. Manually suspends the warehouse as soon as the last query was completed
When the user returns, how much billable compute time will have been consumed?
Which Snowflake function will interpret an input string as a JSON document, and produce a VARIANT value?