Which Snowflake layer can be configured?
A. Database Storage
B. Cloud Services
C. Query Processing
D. Application Services
Which statement is true about Multi-Factor Authentication (MFA) in Snowflake?
A. MFA can be enforced or applied for a given role.
B. Snowflake users are automatically enrolled in MFA.
C. Users enroll in MFA by submitting a request to Snowflake Support.
D. MFA is an integrated Snowflake feature.
What is a core benefit of clustering?
A. To guarantee uniquely identifiable records in the database
B. To increase scan efficiency in queries by improving pruning
C. To improve performance by creating a separate file for point lookups
D. To provide data redundancy by duplicating micro-partitions
The information schema provides storage information for which of the following objects? (Choose two.)
A. Users
B. Databases
C. Internal stages
D. Resource monitors
E. Pipes
What should be considered when deciding to use a Secure View? (Choose two.)
A. No details of the query execution plan will be available in the query profiler.
B. Once created there is no way to determine if a view is secure or not.
C. Secure views do not take advantage of the same internal optimizations as standard views.
D. It is not possible to create secure materialized views.
E. The view definition of a secure view is still visible to users by way of the information schema.
What data type should be used to store JSON data natively in Snowflake?
A. JSON
B. String
C. Object
D. VARIANT
When unloading data to an external stage, which compression format can be used for Parquet files with the COPY INTO command?
A. BROTLI
B. GZIP
C. LZO
D. ZSTD
Which data type is supported by Snowflake data classification?
A. Binary
B. Float
C. Geography
D. Variant
Which Query Profile result indicates that a warehouse is sized too small?
A. There are a lot of filter nodes.
B. Bytes are spilling to external storage.
C. The number of processed rows is very high.
D. The number of partitions scanned is the same as partitions total.
Which SQL command can be used to verify the privileges that are granted to a role?
A. SHOW GRANTS ON ROLE
B. SHOW ROLES
C. SHOW GRANTS TO ROLE
D. SHOW GRANTS FOR ROLE
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.