Which statistic displayed in a Query Profile is specific to external functions?
A. Bytes written
B. Total invocations
C. Partitions scanned
D. Bytes sent over the network
Which Snowflake object can be used to record DML changes made to a table?
A. Snowpipe
B. Stage
C. Stream
D. Task
Which statement accurately describes how a virtual warehouse functions?
A. Increasing the size of a virtual warehouse will always improve data loading performance.
B. Each virtual warehouse is an independent compute cluster that shares compute resources with other warehouses.
C. Each virtual warehouse is a compute cluster composed of multiple compute nodes allocated by Snowflake from a cloud provider.
D. All virtual warehouses share the same compute resources so performance degradation of one warehouse can significantly affect all the other warehouses.
How does a scoped URL expire?
A. When the data cache clears.
B. When the persisted query result period ends.
C. The encoded URL access is permanent.
D. The length of time is specified in the expiration_time argument.
What are the key characteristics of ACСOUNT_USAGE views? (Choose two.)
A. There is no data latency.
B. The data latency can vary from 45 minutes to 3 hours.
C. The historical data is not retained.
D. The historical data can be retained from 7 days to 6 months.
E. Records for dropped objects are included in each view.
How long is the load history stored in the metadata of the pipe in Snowpipe?
A. 2 days
B. 7 days
C. 14 days
D. 64 days
Which command is used to generate a zero-copy "snapshot" of any table, schema, or database?
A. ALTER
B. CREATE ... CLONE
C. COPY INTO
D. CREATE REPLICATION GROUP
If there is queueing in the virtual warehouse load monitoring chart, what should a Snowflake user do?
A. Decrease the warehouse size.
B. Decrease the MIN_CLUSTER_COUNT parameter.
C. Change the multi-cluster settings to add additional clusters.
D. Start a separate warehouse and move queued queries there.
What are the native data types that Snowflake provides to store semi-structured data? (Choose two.)
A. ARRAY
B. JSON
C. ORC
D. Parquet
E. VARIANT
How is enhanced authentication achieved in Snowflake? (Choose two.)
A. Snowflake-managed keys
B. Object level access control
C. Multi-Factor Authentication (MFA)
D. Federated authentication and Single Sign-On (SSO)
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.