Which property needs to be added to the ALTER WAREHOUSE command to verify the additional compute resources for a virtual warehouse have been fully provisioned?
A. QUERY_ACCELERATION_MAX_SCALE_FACTOR
B. RESOURCE_MONITOR
C. SCALING_POLICY
D. WAIT_FOR_COMPLETION
Which loop type iterates until a condition is true?
A. FOR
B. LOOP
C. REPEAT
D. WHILE
What are the available Snowflake scaling modes for configuring multi-cluster virtual warehouses? (Choose two.)
A. Auto-Scale
B. Economy
C. Maximized
D. Scale-Out
E. Standard
By definition, a secure view is exposed only to users with what privilege?
A. IMPORT SHARE
B. OWNERSHIP
C. REFERENCES
D. USAGE
When floating-point number columns are unloaded to CSV or JSON files, Snowflake truncates the values to approximately what?
A. (12,2)
B. (10,4)
C. (14,8)
D. (15,9)
If queries start to queue in a multi-cluster virtual warehouse an additional compute cluster starts immediately under what setting?
A. Auto-scale mode
B. Maximized mode
C. Economy scaling policy
D. Standard scaling policy
What does the average_overlaps in the output of SYSTEM$CLUSTERING_INFORMATION refer to?
A. The average number of micro-partitions stored in Time Travel.
B. The average number of partitions physically stored in the same location.
C. The average number of micro-partitions which contain overlapping value ranges.
D. The average number of micro-partitions in the table associated with cloned objects.
What happens when a user exits Snowsight during a session that a query is running?
A. Snowflake executes the query during the same session immediately.
B. Snowflake cancels any queries submitted during this session that are still running.
C. Snowflake will cancel any queries submitted during this session after 24 hours.
D. Snowflake will continue to execute and complete upon the next login.
How long is the Fail-safe period for recovering historical data from permanent tables?
A. 1 day
B. 3 days
C. 7 days
D. 14 days
What is used to diagnose and troubleshoot network connections to Snowflake?
A. SnowCD
B. Snowpark
C. Snowsight
D. SnowSQL
Nowadays, the certification exams become more and more important and required by more and more enterprises when applying for a job. But how to prepare for the exam effectively? How to prepare for the exam in a short time with less efforts? How to get a ideal result and how to find the most reliable resources? Here on Vcedump.com, you will find all the answers. Vcedump.com provide not only Snowflake exam questions, answers and explanations but also complete assistance on your exam preparation and certification application. If you are confused on your SNOWPRO-CORE exam preparations and Snowflake certification application, do not hesitate to visit our Vcedump.com to find your solutions here.