Which result shows efficient pruning?
A. Partitions scanned is greater than partitions total.
B. Partitions scanned is less than partitions total.
C. Partitions scanned is equal to the partitions total.
D. Partitions scanned is greater than or equal to the partitions total.
Which function is used to profile warehouse credit usage?
A. AUTOMATIC_CLUSTERING_HISTORY
B. MATERIALIZED_VIEW_REFRESH_HISTORY
C. WAREHOUSE_LOAD_HISTORY
D. WAREHOUSE_METERING_HISTORY
Which constraint type is enforced in Snowflake from the ANSI SQL standard?
A. UNIQUE
B. PRIMARY KEY
C. FOREIGN KEY
D. NOT NULL
Which table type is automatically deleted after a session is closed and has no Fail-safe or Time Travel cost?
A. Temporary
B. Transient
C. Permanent
D. External
What is to be expected when sharing worksheets in Snowsight?
A. Worksheets can be shared with users that are internal or external to any organization.
B. To run a shared worksheet, a user must be granted the role used for the worksheet session context.
C. Snowsight allows users to view and refresh results but not to edit shared worksheets.
D. Snowsight offers different sharing permissions at the worksheet, folder, and dashboard level.
A Snowflake user wants to share transactional data with retail suppliers. However, some of the suppliers do not use Snowflake.
According to best practice, what should the Snowflake user do? (Choose two.)
A. Provide each non-Snowflake supplier with their own reader account.
B. Deploy a single reader account to be shared by all of the non-Snowflake suppliers.
C. Create an ETL pipeline that uses select and inserts statements from the source to the target supplier accounts.
D. Use a data share for suppliers in the same cloud region and a replicated proxy share for other cloud deployments.
E. Extract the shared transactional data to an external stage and use cloud storage utilities to reload the suppliers' regions.
What is a characteristic of the Snowflake query profiler?
A. It can provide statistics on a maximum number of 100 queries per week.
B. It provides a graphic representation of the main components of the query processing.
C. It provides detailed statistics about which queries are using the greatest number of compute resources.
D. It can be used by third-party software using the query profiler API.
Which object type is granted permissions for reading a table?
A. User
B. Role
C. Attribute
D. Schema
Which statement about data sharing is true?
A. Accounts can share with other accounts regardless of their Snowflake edition, without requiring help from Snowflake Support.
B. Data sharing can cross regions, but not cloud providers.
C. The Data Consumer can only see objects in the Data Provider's source database that have been explicitly added to the share.
D. A Data Provider can only share with other Snowflake customers.
Which data types are valid in Snowflake? (Choose two.)
A. BLOB
B. Geography
C. JSON
D. CLOB
E. Variant
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.