This page was exported from Free valid test braindumps [ http://free.validbraindumps.com ] Export date:Sat Apr 5 14:13:38 2025 / +0000 GMT ___________________________________________________ Title: Updated PDF (New 2023) Actual Snowflake COF-C02 Exam Questions [Q31-Q50] --------------------------------------------------- Updated PDF (New 2023) Actual Snowflake COF-C02 Exam Questions Verified COF-C02 Exam Dumps PDF [2023] Access using ValidBraindumps QUESTION 31If auto-suspend is enable for a Virtual Warehouse, he Warehouse is automatically suspended when:  All Snowflake sessions using the warehouse are terminated.  The last query using the warehouse completes.  There are no users loaned into Snowflake.  The Warehouse is inactive for a specified period of time. QUESTION 32Snowflake provides two mechanisms to reduce data storage costs for short-lived tables. These mechanisms are: Choose 2 answers  Temporary Tables  Transient Tables  Provisional Tables  Permanent Tables QUESTION 33What occurs when a pipe is recreated using the CREATE OR REPLACE PIPE command?  The Pipe load history is reset to empty.  The REFRESH command is executed.  The stage will be purged.  The destination table is truncated. QUESTION 34Which of the following Snowflake objects can be shared using a secure share? (Select TWO).  Materialized views  Sequences  Procedures  Tables  Secure User Defined Functions (UDFs) Secure Data Sharing enables sharing selected objects in a database in your account with other Snowflake accounts. The following Snowflake database objects can be shared:TablesExternal tablesSecure viewsSecure materialized viewsSecure UDFshttps://docs.snowflake.com/en/user-guide/data-sharing-intro.htmlQUESTION 35Which type of table corresponds to a single Snowflake session?  Temporary  Translent  Provisional  Permanent QUESTION 36True or False: Multi_Factor Authentication (MFA) in Snowflake is only supported in conjunction with single Sign-on (sso).  True  False QUESTION 37When reviewing the load for a warehouse using the load monitoring chart, the chart indicates that a high volume of Queries are always queuing in the warehouse According to recommended best practice, what should be done to reduce the Queue volume? (Select TWO).  Use multi-clustered warehousing to scale out warehouse capacity.  Scale up the warehouse size to allow Queries to execute faster.  Stop and start the warehouse to clear the queued queries  Migrate some queries to a new warehouse to reduce load  Limit user access to the warehouse so fewer queries are run against it. QUESTION 38Snowflake supports the use of external stages with which cloud platforms? (Choose three.)  Amazon Web Services  Docker  IBM Cloud  Microsoft Azure Cloud  Google Cloud Platform  Oracle Cloud QUESTION 39Increasing the maximum number of clusters in a Multi-Cluster Warehouse is an example of:  Scaling rhythmically  Scaling max  Scaling out  Scaling Up QUESTION 40Which of the following objects are contained within a schema? (Choose two.)  Role  Stream  Warehouse  External table  User  Share QUESTION 41Which of the following features are available with the Snowflake Enterprise edition? (Choose two.)  Database replication and failover  Automated index management  Customer managed keys (Tri-secret secure)  Extended time travel  Native support for geospatial data QUESTION 42Which statement about billing applies to Snowflake credits?  Credits are billed per-minute with a 60-minute minimum  Credits are used to pay for cloud data storage usage  Credits are consumed based on the number of credits billed for each hour that a warehouse runs  Credits are consumed based on the warehouse size and the time the warehouse is running QUESTION 43Each incremental increase in Virtual Warehouse size (e,g. Medium to Large) generally results in what?  More micro-partitions  Better query scheduling  Double the numbers of servers In the compute duster  Higher storage costs QUESTION 44Which 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>>; QUESTION 45What are value types that a VARIANT column can store? (Select TWO)  STRUCT  OBJECT  BINARY  ARRAY  CLOB QUESTION 46What features does Snowflake Time Travel enable?  Querying data-related objects that were created within the past 365 days  Restoring data-related objects that have been deleted within the past 90 days  Conducting point-in-time analysis for Bl reporting  Analyzing data usage/manipulation over all periods of time QUESTION 47True or False: When you create a custom role, it is a practice to immediately grant that roleto ACCOUNTADMIN.  True  False QUESTION 48True or False: A Virtual Warehouse can be resized while suspended.  True  False QUESTION 49Which object allows you to limit the number of credits consumed within a Snowflake account?  Account usage Tracking  Resource Monitor  Warehouse Limit Parameter  Credit Consumption Tracker QUESTION 50Which of the following statements is true of Snowflake?  It was built specifically for the cloud  It was built as an on-premises solution and then ported to the cloud  It was designed as a hybrid database to allow customers to store data either on premises or in the cloud  It was built for Hadoop architecture  It’s based on an Oracle Architecture  Loading … Try Best COF-C02 Exam Questions from Training Expert ValidBraindumps: https://www.validbraindumps.com/COF-C02-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: 2023-04-09 14:51:47 Post date GMT: 2023-04-09 14:51:47 Post modified date: 2023-04-09 14:51:47 Post modified date GMT: 2023-04-09 14:51:47