Which operations are handled in the Cloud Services layer of Snowflake? (Choose two.)
A. Security
B. Data storage
C. Data visualization
D. Query computation
E. Metadata management
Which constraint is enforced in Snowflake?
A. FOREIGN KEY
B. NOT NULL
C. PRIMARY KEY
D. UNIQUE KEY
Which pages are included in the Activity area of Snowsight? (Choose two.)
A. Contacts
B. Sharing settings
C. Copy History
D. Query History
E. Automatic Clustering History
When should a user consider disabling auto-suspend for a virtual warehouse? (Choose two.)
A. When users will be using compute at different times throughout a 24/7 period
B. When managing a steady workload
C. When the compute must be available with no delay or lag time
D. When the user does not want to have to manually turn on the warehouse each time it is needed
E. When the warehouse is shared across different teams
What can a Snowflake user do in the Activity section in Snowsight?
A. Create dashboards.
B. Write and run SQL queries.
C. Explore databases and objects.
D. Explore executed query performance.
Which clients does Snowflake support Multi-Factor Authentication (MFA) token caching for? (Choose two.)
A. GO driver
B. Node.js driver
C. ODBC driver
D. Python connector
E. Spark connector
What is the Snowflake recommended Parquet file size when querying from external tables to optimize the number of parallel scanning operations?
A. 1-16 MB
B. 16-128 MB
C. 100-250 MB
D. 256-512 MB
Which data types can be used in a Snowflake table that holds semi-structured data? (Choose two.)
A. ARRAY
B. BINARY
C. TEXT
D. VARIANT
E. VARCHAR
What does Snowflake's search optimization service support?
A. External tables
B. Materialized views
C. Tables and views that are not protected by row access policies
D. Casts on table columns (except for fixed-point numbers cast to strings)
Which table type is no longer available after the close of the session and therefore has no Fail-safe or Time Travel recovery option?
A. External
B. Permanent
C. Temporary
D. Transient
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.