This page was exported from Free valid test braindumps [ http://free.validbraindumps.com ] Export date:Sat Apr 5 14:11:10 2025 / +0000 GMT ___________________________________________________ Title: SnowPro-Core PDF Pass Leader, SnowPro-Core Latest Real Test [Q60-Q79] --------------------------------------------------- SnowPro-Core PDF Pass Leader, SnowPro-Core Latest Real Test Valid SnowPro-Core Test Answers & SnowPro-Core Exam PDF NEW QUESTION 60Credit Consumption by the Compute Layer (Virtual Warehouses) is based on: (Choose two.)  Number of users  Warehouse size  Amount of data processed  # of clusters for the Warehouse Explanationhttps://docs.snowflake.com/en/user-guide/credits.html#virtual-warehouse-credit-usage “Snowflake credits are charged based on the number of virtual warehouses you use, how long they run, and their size.”NEW QUESTION 61What is the maximum compressed row size in Snowflake?  8KB  16MB  50MB  4000GB ExplanationMAX size for compressed data for semi-structured data type is also 16 MB. That means if our table has a semi-structured data type column with 16MB data other columns will have NULL data.NEW QUESTION 62True or False: Data in Fail-safe can be deleted by a user or the Snowflake team before it expires.  True  False NEW QUESTION 63True or False: Fail-safe can be disabled within a Snowflake account.  True  False NEW QUESTION 64True or False: Data Providers can share data with only the Data Consumer.  True  False NEW QUESTION 65Which of the following objects can be cloned? (Choose four.)  Tables  Named File Formats  Schemas  Shares  Databases  Users NEW QUESTION 66When scaling out by adding clusters to a multi-cluster warehouse, you are primarily scaling for improved:  Concurrency  Performance NEW QUESTION 67Select the three types of tables that exist within Snowflake.Choose 3 answers  Temporary  Transient  Provisioned  Permanent NEW QUESTION 68When loading data into Snowflake, the COPY command supports:Choose 2 answers  Joins  Fitters  Data type conversions  Column reordering  Aggregates NEW QUESTION 69Increasing the maximum number of clusters in a Multi-Cluster Warehouse is an example of:  Scaling rhythmically  Scaling max  Scaling out  Scaling Up NEW QUESTION 70What is the minimum Snowflake edition that provides data sharing?  Standard  Premier  Enterprise  Business Critical Edition NEW QUESTION 71Which of the following objects is not covered by Time Travel?  Tables  Schemas  Databases  Stages NEW QUESTION 72True or False: A single database can exist in more than one Snowflake account.  True  False NEW QUESTION 73The Query History in the Snowflake Web Interface (UI) is kept for approximately:  60 minutes  24 hours  14 days  30 days  1 year NEW QUESTION 74Which of the following commands sets the Virtual Warehouse for a session?  COPY WAREHOUSE FROM <<config file>>;  SET WAREHOUSE = <<warehouse name>>;  USE WAREHOUSE <<warehouse name>>;  USE VIRTUAL_WAREHOUSE <<warehouse name>>; Explanation/Reference: https://docs.snowflake.com/en/user-guide/warehouses-tasks.htmlNEW QUESTION 75A deterministic query is run at 8am, takes 5 minutes, and the results are cached. Which of the following statements are true? (Choose two.)  The exact query will ALWAYS return the precomputed result set for the RESULT_CACHE_ACTIVE = time period  The same exact query will return the precomputed results if the underlying data hasn’t changed and the results were last accessed within previous 24 hour period  The same exact query will return the precomputed results even if the underlying data has changed as long as the results were last accessed within the previous 24 hour period  The “24 hour” timer on the precomputed results gets renewed every time the exact query is executed NEW QUESTION 76Which of the following commands sets the Virtual Warehouse for a session?  COPT WAREHOUSE FROM <<Config file> ;  SET warehouse = <<warehouse name>>;  USE WAREHOUSE <<warehouse name>>;  USE VIRTUAL_WAREHOUSE <<warehouse name>>; NEW QUESTION 77Which statements are true of micro-partitions?Choose 2 answers  They are approximately 16MB in size  They are stored compressed only if COMPRESS=TRUE on Table  They are Immutable  They are only encrypted in the Enterprise edition and above NEW QUESTION 78Which object allows you to limit the number of credits consumed within a Snowflake account?Select one.  Account usage Tracking  Resource Monitor  Warehouse Limit Parameter  Credit Consumption Tracker NEW QUESTION 79Which of the following are options when creating a virtual Warehouse?Choose 2 answers  Auto-drop  Auto resize  Auto-resume  Auto-suspend  Loading … SnowPro-Core Dumps Ensure Your Passing: https://www.validbraindumps.com/SnowPro-Core-exam-prep.html --------------------------------------------------- Images: https://free.validbraindumps.com/wp-content/plugins/watu/loading.gif https://free.validbraindumps.com/wp-content/plugins/watu/loading.gif --------------------------------------------------- --------------------------------------------------- Post date: 2022-07-06 10:58:08 Post date GMT: 2022-07-06 10:58:08 Post modified date: 2022-07-06 10:58:08 Post modified date GMT: 2022-07-06 10:58:08