Practice Free SnowPro Core Exam Online Questions
At what levels can a resource monitor be configured? (Select TWO).
- A . Account
- B . Database
- C . Organization
- D . Schema
- E . Virtual warehouse
The Information Schema and Account Usage Share provide storage information for which of the following objects? (Choose three.)
- A . Users
- B . Tables
- C . Databases
- D . Internal Stages
What internal stages are available in Snowflake? (Choose three.)
- A . Schema stage
- B . Named stage
- C . User stage
- D . Stream stage
- E . Table stage
- F . Database stage
Which Snowflake feature is used for both querying and restoring data?
- A . Cluster keys
- B . Time Travel
- C . Fail-safe
- D . Cloning
When reviewing a query profile, what is a symptom that a query is too large to fit into the memory?
- A . A single join node uses more than 50% of the query time
- B . Partitions scanned is equal to partitions total
- C . An AggregateOperacor node is present
- D . The query is spilling to remote storage
What is a machine learning and data science partner within the Snowflake Partner Ecosystem?
- A . Informatica
- B . Power Bl
- C . Adobe
- D . Data Robot
Which TABLE function helps to convert semi-structured data to a relational representation?
- A . CHECK_JSON
- B . TO_JSON
- C . FLATTEN
- D . PARSE_JSON
Which query profile statistics help determine if efficient pruning is occurring? (Choose two.)
- A . Bytes sent over network
- B . Percentage scanned from cache
- C . Partitions total
- D . Bytes spilled to local storage
- E . Partitions scanned
Which of the following are best practices for loading data into Snowflake? (Choose three.)
- A . Aim to produce data files that are between 100 MB and 250 MB in size, compressed.
- B . Load data from files in a cloud storage service in a different region or cloud platform from the service or region containing the Snowflake account, to save on cost.
- C . Enclose fields that contain delimiter characters in single or double quotes.
- D . Split large files into a greater number of smaller files to distribute the load among the compute resources in an active warehouse.
- E . When planning which warehouse(s) to use for data loading, start with the largest warehouse possible.
- F . Partition the staged data into large folders with random paths, allowing Snowflake to determine the best way to load each file.
What are value types that a VARIANT column can store? (Select TWO)
- A . STRUCT
- B . OBJECT
- C . BINARY
- D . ARRAY
- E . CLOB