Snowflake SnowPro Core SnowPro Core Certification Exam Online Training
Snowflake SnowPro Core Online Training
The questions for SnowPro Core were last updated at Nov 19,2024.
- Exam Code: SnowPro Core
- Exam Name: SnowPro Core Certification Exam
- Certification Provider: Snowflake
- Latest update: Nov 19,2024
What is the minimum Snowflake edition required to create a materialized view?
- A . Standard Edition
- B . Enterprise Edition
- C . Business Critical Edition
- D . Virtual Private Snowflake Edition
Which type of table corresponds to a single Snowflake session?
- A . Temporary
- B . Translent
- C . Provisional
- D . Permanent
True or False: It is possible to query data from an Internal or named External stage without loading the data into Snowflake.
- A . True
- B . False
What are ways to create and manage data shares in Snowflake? (Select TWO)
- A . Through the Snowflake web interface (Ul)
- B . Through the DATA_SHARE=TRUE parameter
- C . Through SQL commands
- D . Through the enable__share=true parameter
- E . Using the CREATE SHARE AS SELECT * TABLE command
What are the three things customers want most from their enterprise data warehouse solution? Choose 3 answers
- A . On-premise availability
- B . Simplicity
- C . Open source based
- D . Concurrency
- E . Performance
True or False: Snowflake charges a premium for storing semi-structured data.
- A . True
- B . False
Which of the following statements are true about Schemas in Snowflake? (Choose two.)
- A . A Schema may contain one or more Databases
- B . A Database may contain one or more Schemas
- C . A Schema is a logical grouping of Database Objects
- D . Each Schema is contained within a Warehouse
What is the minimum duration charged when starting a virtual warehouse?
- A . 1 second
- B . 1 minute
- C . 1 hour
- D . 1 day
The number of queries that a Virtual Warehouse can concurrently process is determined by: Choose 2 answers
- A . The complexity of each query
- B . The CONCURRENT_QUERY_UMIT parameter set on the Snowflake account
- C . The size of the data required for each query
- D . The tool that s executing the query
On which of the following cloud platform can a Snowflake account be hosted? Choose 2 answers
- A . Amazon Web Services
- B . Private Virtual Cloud
- C . Oracle Cloud
- D . Microsoft Azure Cloud