Which columns are available in the output of a Snowflake directory table? (Choose two.)
A. CATALOG_NAME
B. FILE_NAME
C. LAST_MODIFIED
D. RELATIVE_PATH
E. STAGE_NAME
Which native data types are used for storing semi-structured data in Snowflake? (Choose two.)
A. NUMBER
B. OBJECT
C. STRING
D. VARCHAR
E. VARIANT
By default, the COPY INTO statement will separate table data into a set of output files to take advantage of which Snowflake feature?
A. Query acceleration
B. Query plan caching
C. Parallel processing
D. Time Travel
What Snowflake object records Data Manipulation Language (DML) changes so that actions can be taken using the changed data?
A. Pipe
B. Stream
C. Task
D. View
Which account usage view in Snowflake can be used to identify the most-frequently accessed tables?
A. Access_History
B. Object_Dependencies
C. Table_Storage_Metrics
D. Tables
What is the MINIMUM role required to set the value for the parameter ENABLE_ACCOUNT_DATABASE_REPLICATION?
A. ACCOUNTADMIN
B. SECURITYADMIN
C. SYSADMIN
D. ORGADMIN
How can a Snowflake user optimize query performance in Snowflake? (Choose two.)
A. Create a view.
B. Cluster a table.
C. Enable the search optimization service.
D. Enable Time Travel.
E. Index a table.
Which file functions are non-deterministic? (Choose two.)
A. BUILD_SCOPED_FILE_URL
B. BUILD_STAGE_FILE_URL
C. GET_ABSOLUTE_PATH
D. GET_PRESIGNED_URL
E. GET_RELATIVE_PATH
Which command can be used to view the allowed and blocked IP list of a network policy?
A. ALTER NETWORK POLICY
B. CREATE NETWORK POLICY
C. DESCRIBE NETWORK POLICY
D. SHOW NETWORK POLICIES
Which command should be used to unload all the rows from a table into one or more files in a named stage?
A. COPY INTO
B. GET
C. INSERT INTO
D. PUT
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.