Get Special Discount Offer on COF-C02 Dumps PDF [UPDATED Feb-2023]

PDF Download Snowflake Test To Gain Brilliante Result!

NEW QUESTION 68
Which of the following is a data tokenization integration partner?

• A. SAP
• B. DBeaver
• C. Protegrity
• D. Tableau

Answer: C

 

NEW QUESTION 69
Which of the following are best practice recommendations that should be considered when loading data into Snowflake? (Select TWO).

• A. Remove semi-structured data types
• B. Avoid using embedded characters such as commas for numeric data types
• C. Load files that are approximately 100-250 MB (or larger)
• D. Load files that are approximately 25 MB or smaller.
• E. Remove all dates and timestamps.

Answer: B,C

 

NEW QUESTION 70
Which of the following are characteristics of Snowflake virtual warehouses? (Choose two.)

• A. The ability to auto-suspend a warehouse is only available in the Enterprise edition or above.
• B. SnowSQL supports both a configuration file and a command line option for specifying a default warehouse.
• C. A user cannot specify a default warehouse when using the ODBC driver.
• D. The default virtual warehouse size can be changed at any time.
• E. Auto-resume applies only to the last warehouse that was started in a multi-cluster warehouse.

Answer: E

 

NEW QUESTION 71
Which of the following Snowflake objects can be shared using a secure share? (Select TWO).

• A. Sequences
• B. Secure User Defined Functions (UDFs)
• C. Tables
• D. Procedures
• E. Materialized views

Answer: B,C

 

NEW QUESTION 72
A user has unloaded data from a Snowflake table to an external stage.
Which command can be used to verify if data has been uploaded to the external stage named my_stage?

• A. view @my_stage
• B. list @my_stage
• C. show @my_stage
• D. display @my_stage

Answer: B

 

NEW QUESTION 73
Which is true of Snowflake network policies? A Snowflake network policy: (Choose two.)

• A. Is available to all Snowflake Editions
• B. Is only available to customers with Business Critical Edition
• C. Is activated using an "ALTER DATABASE" command
• D. Restricts or enables access to specific IP addresses

Answer: A,D

 

NEW QUESTION 74
Where would a Snowflake user find information about query activity from 90 days ago?

• A. information__schema . cruery_history view
• B. information__schema - query history_by_ses s i on view
• C. account__usage . query history view
• D. account__usage.query__history__archive View

Answer: C

 

NEW QUESTION 75
What happens when a virtual warehouse is resized?

• A. When increasing the size of an active warehouse the compute resource for all running and queued queries on the warehouse are affected
• B. Users who are trying to use the warehouse will receive an error message until the resizing is complete
• C. The warehouse will be suspended while the new compute resource is provisioned and will resume automatically once provisioning is complete.
• D. When reducing the size of a warehouse the compute resources are removed only when they are no longer being used to execute any current statements.

Answer: D

 

NEW QUESTION 76
What is the minimum Snowflake edition that has column-level security enabled?

• A. Business Critical
• B. Enterprise
• C. Virtual Private Snowflake
• D. Standard

Answer: B

 

NEW QUESTION 77
What is the MOST performant file format for loading data in Snowflake?

• A. CSV (Unzipped)
• B. CSV (Gzipped)
• C. Parquet
• D. ORC

Answer: A

 

NEW QUESTION 78
Which SQL commands, when committed, will consume a stream and advance the stream offset? (Choose two.)

• A. BEGIN COMMIT
• B. INSERT INTO TABLE SELECT FROM STREAM
• C. SELECT FROM STREAM
• D. ALTER TABLE AS SELECT FROM STREAM
• E. UPDATE TABLE FROM STREAM

Answer: B,D

 

NEW QUESTION 79
Which item in the Data Warehouse migration process does not apply in Snowflake>

• A. Build the Data pipeline
• B. Migrate Schemas
• C. Migrate Users
• D. Migrate Indexes

Answer: D

 

NEW QUESTION 80
Which of the following indicates that it may be appropriate to use a clustering key for a table? (Select TWO).

• A. The table contains a column that has very low cardinality
• B. The table has a small number of micro-partitions
• C. DML statements that are being issued against the table are blocked
• D. Queries on the table are running slower than expected
• E. The clustering depth for the table is large

Answer: A,E

 

NEW QUESTION 81
A single user of a virtual warehouse has set the warehouse to auto-resume and auto-suspend after 10 minutes. The warehouse is currently suspended and the user performs the following actions:
1. Runs a query that takes 3 minutes to complete
2. Leaves for 15 minutes
3. Returns and runs a query that takes 10 seconds to complete
4. Manually suspends the warehouse as soon as the last query was completed When the user returns, how much billable compute time will have been consumed?

• A. 4 minutes
• B. 10 minutes
• C. 14 minutes
• D. 24 minutes

Answer: C

 

NEW QUESTION 82
Increasing the maximum number of clusters in a Multi-Cluster Warehouse is an example of:

• A. Scaling rhythmically
• B. Scaling out
• C. Scaling Up
• D. Scaling max

Answer: B

 

NEW QUESTION 83
Which statements are true of micro-partitions? Choose 2 answers

• A. They are Immutable
• B. They are stored compressed only if COMPRESS=TRUE on Table
• C. They are only encrypted in the Enterprise edition and above
• D. They are approximately 16MB in size

Answer: A,D

 

NEW QUESTION 84
Which of the following objects are contained within a schema? (Choose two.)

• A. Warehouse
• B. Stream
• C. User
• D. Share
• E. Role
• F. External table

Answer: A,F

 

NEW QUESTION 85
True or False: An active warehouse is required to run a COPY INTO statement.

• A. True
• B. False

Answer: A

 

NEW QUESTION 86
What happens to the underlying table data when a CLUSTER BY clause is added to a Snowflake table?

• A. Data is hashed by the cluster key to facilitate fast searches for common data values
• B. Smaller micro-partitions are created for common data values to allow for more parallelism
• C. Data may be colocated by the cluster key within the micro-partitions to improve pruning performance
• D. Larger micro-partitions are created for common data values to reduce the number of partitions that must be scanned

Answer: C

 

NEW QUESTION 87
True or False: During data unloading, only JSON and CSV files can be compressed.

• A. True
• B. False

Answer: B

 

NEW QUESTION 88
Which of the following commands are not blocking operations? Choose 2 answers

• A. COPY
• B. MERGE
• C. INSERT
• D. UPDATE

Answer: A,C

 

NEW QUESTION 89
Assume there is a table consisting of five micro-partitions with values ranging from A to Z.
Which diagram indicates a well-clustered table?

• A.
• B.
• C.
• D.

Answer: D

 

NEW QUESTION 90
......

COF-C02 Dumps are Available for Instant Access: https://passguide.braindumpsit.com/COF-C02-latest-dumps.html