Snowflake SnowPro Core SnowPro Core Certification Exam Online Training
Snowflake SnowPro Core Online Training
The questions for SnowPro Core were last updated at Jan 06,2025.
- Exam Code: SnowPro Core
- Exam Name: SnowPro Core Certification Exam
- Certification Provider: Snowflake
- Latest update: Jan 06,2025
What is a machine learning and data science partner within the Snowflake Partner Ecosystem?
- A . Informatica
- B . Power Bl
- C . Adobe
- D . Data Robot
What is a key feature of Snowflake architecture?
- A . Zero-copy cloning creates a mirror copy of a database that updates with the original
- B . Software updates are automatically applied on a quarterly basis
- C . Snowflake eliminates resource contention with its virtual warehouse implementation
- D . Multi-cluster warehouses allow users to run a query that spans across multiple clusters
- E . Snowflake automatically sorts DATE columns during ingest for fast retrieval by date
Which of the following roles is recommended to be used to create and manage users and roles?
- A . SYSADMIN
- B . SECURITYADMIN
- C . PUBLIC
- D . ACCOUNTADMIN
Which of the following statements are true of VALIDATION_MODE in Snowflake? (Choose two.)
- A . The validation_mode option is used when creating an Internal Stage
- B . validation_mode=return_all_errors is a parameter of the copy command
- C . The validation_mode option will validate data to be loaded by the copy statement while completing the load and will return the rows that could not be loaded without error
- D . The validation_mode option will validate data to be loaded by the copy statement without completing the load and will return possible errors
True or False: Once created, a micro-partition will never be changed.
- A . True
- B . False
To run a Multi-Cluster Warehouse in auto-scale mode, a user would:
- A . Configure the Maximum Clusters setting to “Auto-Scale”
- B . Set the Warehouse type to “Auto”
- C . Set the Minimum Clusters and Maximum Clusters settings to the same value
- D . Set the Minimum Clusters and Maximum Clusters settings to the different values
Which of the following describes how clustering keys work in Snowflake?
- A . Clustering keys update the micro-partitions in place with a full sort, and impact the DML operations.
- B . Clustering keys sort the designated columns over time, without blocking DML operations
- C . Clustering keys create a distributed, parallel data structure of pointers to a table’s rows and columns
- D . Clustering keys establish a hashed key on each node of a virtual warehouse to optimize joins at run-time
Which of the following are benefits of micro-partitioning? (Select TWO)
- A . Micro-partitions cannot overlap in their range of values
- B . Micro-partitions are immutable objects that support the use of Time Travel.
- C . Micro-partitions can reduce the amount of I/O from object storage to virtual warehouses
- D . Rows are automatically stored in sorted order within micro-partitions
- E . Micro-partitions can be defined on a schema-by-schema basis
Which interfaces can be used to create and/or manage Virtual Warehouses?
- A . The Snowflake Web Interface (UI)
- B . SQL commands
- C . Data integration tools
- D . All of the above
When scaling out by adding clusters to a multi-cluster warehouse, you are primarily scaling for improved:
- A . Concurrency
- B . Performance
Latest SnowPro Core Dumps Valid Version with 427 Q&As
Latest And Valid Q&A | Instant Download | Once Fail, Full Refund
