[Jan-2023] Latest Snowflake COF-C02 exam dumps and online Test Engine
Snowflake COF-C02: Selling SnowPro Core Products and Solutions
NEW QUESTION 64
Which of the following statement is true of Snowflake?
- A. It was designed as a hybrid database to allow customers to store data either on premises or in the cloud
- B. It was built for Hadoop architecture
- C. it was built as an on-premises solution and then potted to the cloud
- D. It's based on an Oracle Architecture
- E. It was built specifically for the cloud
Answer: E
NEW QUESTION 65
How can a user change which columns are referenced in a view?
- A. Modify the columns in the underlying table
- B. Materialize the view to perform the changes
- C. Use the ALTER VIEW command to update the view
- D. Recreate the view with the required changes
Answer: C
NEW QUESTION 66
A running virtual warehouse is suspended.
What is the MINIMUM amount of time that the warehouse will incur charges for when it is restarted?
- A. 1 second
- B. 60 minutes
- C. 5 minutes
- D. 60 seconds
Answer: D
NEW QUESTION 67
Which of the following are true of multi-cluster Warehouses? Select all that apply below.
- A. A multi-cluster Warehouse can add clusters automatically based on query activity
- B. A multi-cluster Warehouse can automatically turn itself off after a period of inactivity
- C. A multi-cluster Warehouse can scale down when query activity slows
- D. A multi-cluster Warehouse can automatically turn itself on when a query is executed against it
Answer: A,B,C,D
NEW QUESTION 68
A marketing co-worker has requested the ability to change a warehouse size on their medium virtual warehouse called mktg__WH.
Which of the following statements will accommodate this request?
- A. GRANT MODIFY ON WAREHOUSE MKTG__WH TO USER MKTG__LEAD;
- B. GRANT MODIFY ON WAREHOUSE MKTG WH TO ROLE MARKETING;
- C. ALLOW RESIZE ON WAREHOUSE MKTG__WH TO USER MKTG__LEAD;
- D. GRANT OPERATE ON WAREHOUSE MKTG WH TO ROLE MARKETING;
Answer: B
NEW QUESTION 69
What COPY INTO SQL command should be used to unload data into multiple files?
- A. SINGLE=TRUE
- B. MULTIPLE=TRUE
- C. SINGLE=FALSE
- D. MULTIPLE=FALSE
Answer: D
NEW QUESTION 70
To run a Multi-Cluster Warehouse in auto-scale mode, a user would:
- A. Set the Warehouse type to "Auto"
- B. Set the Minimum Clusters and Maximum Clusters settings to the different values
- C. Set the Minimum Clusters and Maximum Clusters settings to the same value
- D. Configure the Maximum Clusters setting to "Auto-Scale"
Answer: B
NEW QUESTION 71
When 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).
- A. Limit user access to the warehouse so fewer queries are run against it.
- B. Migrate some queries to a new warehouse to reduce load
- C. Use multi-clustered warehousing to scale out warehouse capacity.
- D. Stop and start the warehouse to clear the queued queries
- E. Scale up the warehouse size to allow Queries to execute faster.
Answer: B,C
NEW QUESTION 72
Which data types does Snowflake support when querying semi-structured data? (Select TWO)
- A. XML
- B. VARIANT
- C. BLOB
- D. ARRAY
- E. VARCHAR
Answer: B,D
Explanation:
https://docs.snowflake.com/en/user-guide/semistructured-intro.html#label-loading-semi-structured-data A VARIANT stores semi-structured data in Snowflake. It can store a value of any other type, including OBJECT and ARRAY.
The maximum length of a VARIANT is 16 MB.
A Snowflake ARRAY is similar to an array in many other programming languages. An ARRAY contains 0 or more pieces of data. Each element is accessed by specifying its position in the array.
NEW QUESTION 73
Data storage for individual tables can be monitored using which commands and/or objects? (Choose two.)
- A. Information Schema -> TABLE_STORAGE_METRICS
- B. Information Schema -> TABLE_HISTORY
- C. Information Schema -> TABLE_FUNCTION
- D. SHOW STORAGE BY TABLE;
- E. SHOW TABLES;
Answer: A,D
NEW QUESTION 74
What are the three things customers want most from their enterprise data warehouse solution? Choose 3 answers
- A. On-premise availability
- B. Open source based
- C. Simplicity
- D. Performance
- E. Concurrency
Answer: C,D,E
NEW QUESTION 75
Which of the following is a valid source for an external stage when the Snowflake account is located on Microsoft Azure?
- A. A Windows server file share on Azure
- B. An HTTPS server with WebDAV
- C. A Google Cloud storage bucket
- D. An FTP server with TLS encryption
Answer: C
NEW QUESTION 76
During periods of warehouse contention which parameter controls the maximum length of time a warehouse will hold a query for processing?
- A. STATEMENT_TIMEOUT__IN__SECONDS
- B. QUERY_TIMEOUT_IN_SECONDS
- C. STATEMENT_QUEUED_TIMEOUT_IN_SECONDS
- D. MAX_CONCURRENCY__LEVEL
Answer: C
Explanation:
The parameter STATEMENT_QUEUED_TIMEOUT_IN_SECONDS sets the limit for a query to wait in the queue in order to get its chance of running on the warehouse. The query will quit after reaching this limit. By default, the value of this parameter is 0 which mean the queries will wait indefinitely in the waiting queue
https://community.snowflake.com/s/article/Warehouse-Concurrency-and-Statement-Timeout-Parameters#:~:text=The%20parameter%20STATEMENT_QUEUED_TIMEOUT_IN_SECONDS%20sets%20the,indefinitely%20in%20the%20waiting%20queue.
NEW QUESTION 77
What features that are part of the Continuous Data Protection (CDP) feature set in Snowflake do not require additional configuration? (Choose two.)
- A. Data masking policies
- B. External tokenization
- C. Data encryption
- D. Row level access policies
- E. Time Travel
Answer: C,E
NEW QUESTION 78
Which of the following commands cannot be used within a reader account?
- A. CREATE SHARE
- B. DROP ROLE
- C. DESCRBE TABLE
- D. SHOW SCHEMAS
- E. ALTER WAREHOUSE
Answer: E
Explanation:
A reader account is intended primarily for querying data shared by the provider of the account. Adding new data to the account and/or updating shared data in the account is not supported. Changing the configuration of virtual warehouses is also not permitted as those resources are owned and managed by the provider of the account which is sharing the data.
NEW QUESTION 79
When scaling out by adding clusters to a multi-cluster warehouse, you are primarily scaling for improved:
- A. Performance
- B. Concurrency
Answer: B
NEW QUESTION 80
Which of the following connectors are available in the Downloads section of the Snowflake web Interface (UI) Choose 2 answers
- A. HIVE
- B. SnowSQL
- C. ODBC
- D. R
Answer: B,C
NEW QUESTION 81
What are value types that a VARIANT column can store? (Select TWO)
- A. OBJECT
- B. BINARY
- C. CLOB
- D. ARRAY
- E. STRUCT
Answer: A,D
NEW QUESTION 82
True or False: It is possible to query data from an Internal or named External stage without loading the data into Snowflake.
- A. False
- B. True
Answer: B
NEW QUESTION 83
True or False: Snowflake allows its customers to directly access the micro-partition files that make up its tables.
- A. True
- B. False
Answer: B
NEW QUESTION 84
Which of the following are best practices for loading data into Snowflake? (Choose three.)
- A. Enclose fields that contain delimiter characters in single or double quotes.
- B. Partition the staged data into large folders with random paths, allowing Snowflake to determine the best way to load each file.
- C. When planning which warehouse(s) to use for data loading, start with the largest warehouse possible.
- D. 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.
- E. Aim to produce data files that are between 100 MB and 250 MB in size, compressed.
- F. Split large files into a greater number of smaller files to distribute the load among the compute resources in an active warehouse.
Answer: A,C,D
NEW QUESTION 85
How would you execute a series of SQL statements using Task?
- A. A stored procedure executing multiple SQL statements and invoke the stored procedure from the task. CREATE TASK mytask.... AS call stored_proc_multiple_statements_inside():
- B. include the SQL statements in the body of the task create task mytask.. as insert into target1 select., from stream_s1 where .. INSERT INTO target2 SELECT .. FROM stream .s1 where ..
- C. A stored procedure can have only one DML statement per stored procedure invocation and therefore you should sequence stored procedures calls in the task definition CREATE TASK mytask.... AS call stored_prc1(); call stored_proc2t);
- D. Create a task for each SQL statement (e.g. resulting in task1. task2, etc) and string the series of SQL statements by having a control task calling task 1, task 2 sequentially.
Answer: A
NEW QUESTION 86
......
Snowflake COF-C02 Exam Syllabus Topics:
| Topic | Details |
|---|---|
| Topic 1 |
|
| Topic 2 |
|
| Topic 3 |
|
| Topic 4 |
|
| Topic 5 |
|
| Topic 6 |
|
New 2023 COF-C02 Test Tutorial (Updated 265 Questions): https://www.easy4engine.com/COF-C02-test-engine.html
Reliable COF-C02 Exam Tips Test Pdf Exam Material: https://drive.google.com/open?id=15sp66aoZSEa3rWESGEx65CyIwXBGDD85
