Which parameter prevents streams on tables from becoming stale?
A. MAX_DATA_EXTENSION_TIME_IN_DAYS
B. MIN_DATA_RETENSION_TIME_IN_DAYS
C. LOCK_TIMEOUT
D. STALE_AFTER
A Snowflake user has been granted the CREATE DATA EXCHANGE LISTING privilege with their role.
Which tasks can this user now perform on the Data Exchange? (Choose two.)
A. Rename listings
B. Delete provider profiles
C. Modify listings properties
D. Modify incoming listing access requests
E. Submit listings for approval/publishing
When should a stored procedure be created with caller's rights?
A. When the caller needs to be prevented from viewing the source code of the stored procedure
B. When the caller needs to run a statement that could not execute outside of the stored procedure
C. When the stored procedure needs to run with the privileges of the role that called the stored procedure
D. When the stored procedure needs to operate on objects that the caller does not have privileges on
If a virtual warehouse runs for 30 seconds after it is provisioned, how many seconds will the customer be billed for?
A. 30 seconds
B. 60 seconds
C. 121 seconds
D. 1 hour
What Snowflake objects can be added to a share? (Choose two.)
A. Views
B. Tables
C. Stored procedures
D. Streams
E. Secure views
Which Data Definition Language (DDL) commands are supported by Snowflake to manage tags? (Choose two.)
A. ALTER TAG
B. DESCRIBE TAG
C. DROP TAG
D. GRANT ... TO TAG
E. GRANT TAG
What type of function can be used to estimate the approximate number of distinct values from a table that has trillions of rows?
A. MD5
B. Window
C. External
D. HyperLogLog (HLL)
What JavaScript delimiters are available in Snowflake stored procedures? (Choose two.)
A. Double quotes (
Which data governance control has Snowflake embedded in the application?
A. Network policies
B. Credit computation
C. Data storage
D. Attribute-based access control
A Query Profile shows a UnionAll operator with an extra Aggregate operator on top.
What does this signify?
A. Exploding joins
B. Inefficient pruning
C. UNION without ALL
D. Queries that are too large to fit in memory
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.