How is table data compressed in Snowflake?
A. Each column is compressed as it is stored in a micro-partition.
B. Each micro-partition is compressed as it is written into cloud storage using GZIP.
C. The micro-partitions are stored in compressed cloud storage and the cloud storage handles compression.
D. The text data in a micro-partition is compressed with GZIP but other types are not compressed.
Which Snowflake SQL command is used to get a subset of rows randomly from a table?
A. GENERATOR
B. LATERAL
C. PIVOT
D. SAMPLE
Which statement accurately describes Snowflake's architecture?
A. It uses a local data repository for all compute nodes in the platform.
B. It is a blend of shared-disk and shared-everything database architectures.
C. It is a hybrid of traditional shared-disk and shared-nothing database architectures.
D. It reorganizes loaded data into internal optimized, compressed, and row-based format.
What allows a user to limit the number of credits consumed within a Snowflake account?
A. Tracking account usage
B. Creating resource monitors
C. Automatic virtual warehouse scaling
D. Automatic clustering
How does a Snowflake user enable Multi-Factor Authentication (MFA)?
A. The user must enroll themselves through the web interface.
B. The user must submit their encrypted private key to Snowflake.
C. The user must sign up with Duo Mobile for approval to use the service.
D. The user must configure Snowflake to use Single Sign-On (SSO).
What is the Fail-safe period for a transient table in the Snowflake Enterprise edition and higher?
A. 0 days
B. 1 day
C. 7 days
D. 14 days
What does Snowflake recommend as a best practice for using secure views?
A. Use sequence-generated values.
B. Programmatically reveal the identifiers.
C. Use secure views solely for query convenience.
D. Do not expose the sequence-generated column(s).
Which COPY INTO statement accurately describes how to unload data from a Snowflake table?
A. The default value for the SINGLE option is set to TRUE.
B. By default, COPY INTO statements do not separate table data into a set of output files.
C. The OBJECT_CONSTRUCT function can be combined with the COPY command to convert the rows in a relational table to a single VARIANT column.
D. If the COMPRESSION option is set to TRUE, a file's name can be specified with the appropriate file extension so that the output file can be compressed.
What command is used to download data from a Snowflake stage?
A. PUT
B. INSERT
C. GET
D. COPY
By default, which role has privileges to create tables and views in an account?
A. PUBLIC
B. SECURITYADMIN
C. SYSADMIN
D. USERADMIN
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.