Which of the following operations require the use of a running virtual warehouse? (Choose two.)
A. Downloading data from an internal stage
B. Listing files in a stage
C. Executing a stored procedure
D. Altering a table
E. Querying data from a materialized view
When can a newly configured virtual warehouse start running SQL queries?
A. After 50% of the warehouse provisioning has completed
B. During the time slots defined by the ACCOUNTADMIN
C. When the warehouse provisioning is completed
D. After the warehouse replication is completed
What are the benefits of the replication feature in Snowflake? (Choose two.)
A. Disaster recovery
B. Time Travel
C. Fail-safe
D. Database failover and failback
E. Data security
What is the maximum length of time travel available in the Snowflake Standard Edition?
A. 1 Day
B. 7 Days
C. 30 Days
D. 90 Days
A user executes the following SQL query:
create table SALES_BKP like SALES;
What are the cost implications for processing this query?
A. Processing costs will be generated based on how long the query takes.
B. Storage costs will be generated based on the size of the data.
C. No costs will be incurred as the query will use metadata.
D. The cost for running the virtual warehouse will be charged by the second.
What actions are supported by Snowflake resource monitors? (Choose two.)
A. Alert
B. Notify
C. Notify and suspend
D. Abort
E. Suspend immediately
Masking policies can be applied to which of the following Snowflake objects? (Choose two.)
A. A materialized view
B. A stored procedure
C. A table
D. A stream
E. A pipe
F. A User-Defined Function (UDF)
If all virtual warehouse resources are maximized while processing a query workload, what will happen to new queries that are submitted to the warehouse?
A. All queries will terminate when the resources are maximized.
B. The warehouse will scale out automatically
C. The warehouse will move to a suspended state.
D. New queries will be queued and executed when capacity is available.
What columns are returned when performing a FLATTEN command on semi-structured data? (Choose two.)
A. KEY
B. NODE
C. VALUE
D. LEVEL
E. ROOT
Which of the following SQL statements will list the version of the drivers currently being used?
A. Execute SELECT CURRENT_ODBC_CLIENT(); from the Web UI
B. Execute SELECT CURRENT_JDBC_VERSION(); from SnowSQL
C. Execute SELECT CURRENT_CLIENT(); from an application
D. Execute SELECT CURRENT_VERSION(); from the Python Connector
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.