What is the default Time Travel retention period?
A. 1 day
B. 7 days
C. 45 days
D. 90 days
Which object types are protected by Fail-safe? (Choose two.)
A. Permanent Tables
B. Temporary Tables
C. External Tables
D. Materialized Views
E. Transient Tables
What is the purpose of enabling Federated Authentication on a Snowflake account?
A. Disables the ability to use key pair and basic authentication (e.g., username/password) when connecting
B. Allows dual Multi-Factor Authentication (MFA) when connecting to Snowflake
C. Forces users to connect through a secure network proxy
D. Allows users to connect using secure single sign-on (SSO) through an external identity provider
Which schema has the RESOURCE_MONITORS view?
A. ACCOUNT_USAGE
B. READER_ACCOUNT_USAGE
C. INFORMATION_SCHEMA
D. WAREHOUSE_USAGE_SCHEMA
To add or remove search optimization for a table, a user must have which of the following privileges or roles? (Choose two.)
A. The MODIFY privilege on the table
B. The OWNERSHIP privilege on the table
C. A SECURITYADMIN role
D. The ADD SEARCH OPTIMIZATION privilege on the schema that contains the table
E. The SELECT privilege on the table
According to Snowflake best practice recommendations, which role should be used to create databases?
A. ACCOUNTADMIN
B. SYSADMIN
C. SECURITYADMIN
D. USERADMIN
Snowflake's approach to the management of system access combines which of the following models? (Choose two.)
A. Security Assertion Markup Language (SAML)
B. Role-Based Access Control (RBAC)
C. Identity Access Management (AM)
D. Create, Read, Update, and Delete (CRUD)
E. Discretionary Access Control (DAC)
F. Mandatory Access Control (MAC)
Which of the following query profiler variables will indicate that a virtual warehouse is not sized correctly for the query being executed?
A. Bytes sent over the network
B. Synchronization
C. Initialization
D. Remote spillage
While using a COPY command with a Validation_mode parameter, which of the following statements will return an error?
A. Statements that insert a duplicate record during a load
B. Statements that have a specific data type in the source
C. Statements that have duplicate file names
D. Statements that transform data during a load
What is used to limit the credit usage of a virtual warehouse within a Snowflake account?
A. Load monitor
B. Resource monitor
C. Query Profile
D. Stream
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.