How are URLs that access unstructured data in external stages retrieved?
A. From the Snowsight navigation menu
B. By querying a directory table
C. By creating an external function
D. By using the INFORMATION_USAGE schema
How can an administrator check for updates (for example, SCIM API requests) sent to Snowflake by the identity provider?
A. ACCESS_HYSTORY
B. LOAD_HYSTORY
C. QUERY_HISTORY
D. REST_EVENT_HISTORY
Which view in SNOWFLAKE.ACCOUNT_USAGE shows from which IP address a user connected to Snowflake?
A. ACCESS_HYSTORY
B. LOGIN_HYSTORY
C. SESSIONS
D. QUERY_HISTORY
What MINIMUM privilege is required on the external stage for any role in the GET REST API to access unstructured data files using a file URL?
A. READ
B. OWNERSHIP
C. USAGE
D. WRITE
Why should a user select the economy scaling policy for a multi-cluster warehouse?
A. To prevent/minimize query queuing
B. To increase performance of the clusters
C. To reduce queuing concurrent user queries
D. To conserve credits by keeping running clusters fully loaded
A Snowflake user is writing a User-Defined Function (UDF) with some unqualified object names.
How will those object names be resolved during execution?
A. Snowflake will resolve them according to the SEARCH_PATH parameter.
B. Snowflake will only check the schema the UDF belongs to.
C. Snowflake will first check the current schema, and then the schema the previous query used.
D. Snowflake will first check the current schema, and then the PUBLIC schema of the current database.
What unit of storage supports efficient query processing in Snowflake?
A. Blobs
B. JSON
C. Block storage
D. Micro-partitions
Snowflake Partner Connect is limited to users with a verified email address and which role?
A. SYSADMIN
B. SECURITYADMIN
C. ACCOUNTADMIN
D. USERADMIN
What is the advantage of using a reader account?
A. It can be used by a client that does not have a Snowflake account
B. It is read-only and prevents the shared data from being updated by the provider.
C. It can be connected to a Snowflake account in a different region.
D. It provides limited access to the data share and is therefore cheaper for the data provider.
What is the MAXIMUM Time Travel retention period for a transient table?
A. 0 days
B. 1 day
C. 7 days
D. 90 days
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.