Users with the ACCOUNTADMIN role can execute which of the following commands on existing users?
A. Can SHOW users DESCRIBE a given user, or ALTER or DROP a user
B. Can DEFINE users, DESCRIBE a given user, or ALTER or DELETE a user
C. Can SHOW users, INDEX a given user, or ALTER or DELETE a user
D. Can SHOW users, DEFINE a given user or ALTER, DROP, or MODIFY a user
What is a characteristic of data micro-partitioning in Snowflake?
A. Micro-partitioning may introduce data skew
B. Micro-partitioning requires the definition of a partitioning schema
C. Micro-partitioning happens when the data is loaded
D. Micro-partitioning can be disabled within a Snowflake account
According to Snowflake best practice recommendations, which system-defined roles should be used to create custom roles? (Choose two.)
A. ACCOUNTADMIN
B. SYSADMIN
C. SECURITYADMIN
D. USERADMIN
E. ORGADMIN
What are benefits of using the ACCESS_HISTORY view in the SNOWFLAKE database?
A. Identification of unused data
B. Identification of which roles have been used
C. Tracking of network policy usage
D. Highlighting of row access policy usage
E. Identification of who has read data
Snowflake virtual warehouses are part of which layer of the Snowflake architecture?
A. Compute layer
B. Storage layer
C. Database layer
D. Cloud services layer
Which of the following commands are valid options for the VALIDATION_MODE parameter within the Snowflake COPY_INTO command? (Choose two.)
A. TRUE
B. RETURN_ERROR_SUM
C. RETURN_ALL_ERRORS
D. RETURN__ROWS
E. RETURN_FIRST__ERRORS
What services are provided by the cloud services layer in Snowflake? (Choose two.)
A. Metadata management
B. Object authorization
C. Authentication
D. Query execution
E. Result caching
What is the default compression typo when unloading data from Snowflake?
A. Brotli
B. bzip2
C. Zstandard
D. gzip
Which of the following view types are available in Snowflake? (Choose two.)
A. Layered view
B. Secure view
C. External view
D. Embedded view
E. Materialized view
Which statement describes when a virtual warehouse can be resized?
A. A resize will affect running, queued, and new queries.
B. A resize can only be completed when the warehouse is in an auto-resume status.
C. A resize must be completed when the warehouse is suspended.
D. A resize can be completed at any time.
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.