Practice Free SnowPro Core Exam Online Questions
Which statements are true concerning Snowflake’s underlying cloud infrastructure? (Select THREE),
- A . Snowflake data and services are deployed in a single availability zone within a cloud provider’s region.
- B . Snowflake data and services are available in a single cloud provider and a single region, the use of multiple cloud providers is not supported.
- C . Snowflake can be deployed in a customer’s private cloud using the customer’s own compute and storage resources for Snowflake compute and storage
- D . Snowflake uses the core compute and storage services of each cloud provider for its own compute and storage
- E . All three layers of Snowflake’s architecture (storage, compute, and cloud services) are deployed and managed entirely on a selected cloud platform
- F . Snowflake data and services are deployed in at least three availability zones within a cloud provider’s region
Which Snowflake object helps evaluate virtual warehouse performance impacted by query queuing?
- A . Resource monitor
- B . Account_usage. query_history
- C . Information_schema.warehouse_load_history
- D . Information schema.warehouse metering history
When should a user consider disabling auto-suspend for a virtual warehouse? (Select 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 is used to diagnose and troubleshoot network connections to Snowflake?
- A . SnowCD
- B . Snowpark
- C . Snowsight
- D . SnowSQL
Which Snowflake URL type allows users or applications to download or access files directly from Snowflake stage without authentication?
- A . Directory
- B . File
- C . Pre-signed
- D . Scoped
When loading data into Snowflake, how should the data be organized?
- A . Into single files with 100-250 MB of compressed data per file
- B . Into single files with 1-100 MB of compressed data per file
- C . Into files of maximum size of 1 GB of compressed data per file
- D . Into files of maximum size of 4 GB of compressed data per file
When is the result set cache no longer available? (Select TWO)
- A . When another warehouse is used to execute the query
- B . When another user executes the query
- C . When the underlying data has changed
- D . When the warehouse used to execute the query is suspended
- E . When it has been 24 hours since the last query
What is the recommended file sizing for data loading using Snowpipe?
- A . A compressed file size greater than 100 MB, and up to 250 MB
- B . A compressed file size greater than 100 GB, and up to 250 GB
- C . A compressed file size greater than 10 MB, and up to 100 MB
- D . A compressed file size greater than 1 GB, and up to 2 GB
How would a user run a multi-cluster warehouse in maximized mode?
- A . Configure the maximum clusters setting to "Maximum."
- B . Turn on the additional clusters manually after starting the warehouse.
- C . Set the minimum Clusters and maximum Clusters settings to the same value.
- D . Set the minimum clusters and maximum clusters settings to different values.
How would a user run a multi-cluster warehouse in maximized mode?
- A . Configure the maximum clusters setting to "Maximum."
- B . Turn on the additional clusters manually after starting the warehouse.
- C . Set the minimum Clusters and maximum Clusters settings to the same value.
- D . Set the minimum clusters and maximum clusters settings to different values.