[2023] Free COF-C02 Exam Dumps to Pass Exam Easily
COF-C02 Exam Dumps, COF-C02 Practice Test Questions
NEW QUESTION 78
Which SQL commands, when committed, will consume a stream and advance the stream offset? (Choose two.)
- A. BEGIN COMMIT
- B. SELECT FROM STREAM
- C. UPDATE TABLE FROM STREAM
- D. INSERT INTO TABLE SELECT FROM STREAM
- E. ALTER TABLE AS SELECT FROM STREAM
Answer: D,E
NEW QUESTION 79
Which cache type is used to cache data output from SQL queries?
- A. Metadata cache
- B. Result cache
- C. Local file cache
- D. Remote cache
Answer: B
Explanation:
https://community.snowflake.com/s/article/Caching-in-Snowflake-Data-Warehouse
NEW QUESTION 80
A user is loading JSON documents composed of a huge array containing multiple records into Snowflake. The user enables the strip__outer_array file format option
What does the STRIP_OUTER_ARRAY file format do?
- A. It removes the NULL elements from the JSON object eliminating invalid data and enables the ability to load the records
- B. It removes the outer array structure and loads the records into separate table rows,
- C. It removes the last element of the outer array.
- D. It removes the trailing spaces in the last element of the outer array and loads the records into separate table columns
Answer: B
NEW QUESTION 81
What happens when an external or an internal stage is dropped? (Select TWO).
- A. When dropping an internal stage, the files are deleted with the stage and the files are recoverable
- B. When dropping an internal stage, the files are deleted with the stage and the files are not recoverable
- C. When dropping an external stage, both the stage and the files within the stage are removed
- D. When dropping an external stage, the files are not removed and only the stage is dropped
- E. When dropping an internal stage, only selected files are deleted with the stage and are not recoverable
Answer: A,D
NEW QUESTION 82
True or False: A single database can exist in more than one Snowflake account.
- A. True
- B. False
Answer: B
NEW QUESTION 83
Which of the following features are available with the Snowflake Enterprise edition? (Choose two.)
- A. Extended time travel
- B. Database replication and failover
- C. Native support for geospatial data
- D. Customer managed keys (Tri-secret secure)
- E. Automated index management
Answer: A,B
NEW QUESTION 84
A user has a standard multi-cluster warehouse auto-scaling policy in place.
Which condition will trigger a cluster to shut-down?
- A. When after 5-6 consecutive checks the system determines that the load on the least-loaded cluster could be redistributed.
- B. When after 2-3 consecutive checks the system determines that the load on the most-loaded cluster could be redistributed.
- C. When after 5-6 consecutive checks the system determines that the load on the most-loaded cluster could be redistributed.
- D. When after 2-3 consecutive checks the system determines that the load on the least-loaded cluster could be redistributed.
Answer: D
NEW QUESTION 85
The FLATEEN function is used to query which type of data in Snowflake?
- A. Structured data
- B. None of the above
- C. Both of the above
- D. Semi-structured data
Answer: D
NEW QUESTION 86
The number of queries that a Virtual Warehouse can concurrently process is determined by: Choose 2 answers
- A. The complexity of each query
- B. The CONCURRENT_QUERY_UMIT parameter set on the Snowflake account
- C. The tool that s executing the query
- D. The size of the data required for each query
Answer: A,D
NEW QUESTION 87
True or False: Fail-safe can be disabled within a Snowflake account.
- A. True
- B. False
Answer: B
NEW QUESTION 88
True or False: It is possible for a user to run a query against the query result cache without requiring an active Warehouse.
- A. True
- B. False
Answer: A
Explanation:
Query result cache is all about fetching the data from cloud services layer and saving the cost by not running the virtual warehouse.
NEW QUESTION 89
True or False: All Snowflake table types include fail-safe storage.
- A. True
- B. False
Answer: B
NEW QUESTION 90
Which of the following accurately represents how a table fits into Snowflake's logical container hierarchy?
- A. Account -> Schema -> Database -> Table
- B. Database -> Schema -> Table -> Account
- C. Database -> Table -> Schema -> Account
- D. Account -> Database -> Schema -> Table
Answer: D
NEW QUESTION 91
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's based on an Oracle Architecture
- C. it was built as an on-premises solution and then potted to the cloud
- D. It was built specifically for the cloud
- E. It was built for Hadoop architecture
Answer: D
NEW QUESTION 92
True or False: Data Providers can share data with only the Data Consumer.
- A. True
- B. False
Answer: B
NEW QUESTION 93
Which command should be used to download files from a Snowflake stage to a local folder on a client's machine?
- A. PUT
- B. COPY
- C. GET
- D. SELECT
Answer: C
NEW QUESTION 94
What happens when a virtual warehouse is resized?
- A. The warehouse will be suspended while the new compute resource is provisioned and will resume automatically once provisioning is complete.
- B. 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.
- C. Users who are trying to use the warehouse will receive an error message until the resizing is complete
- D. When increasing the size of an active warehouse the compute resource for all running and queued queries on the warehouse are affected
Answer: B
NEW QUESTION 95
How would a user run a multi-cluster warehouse in maximized mode?
- A. Set the minimum Clusters and maximum Clusters settings to the same value.
- B. Set the minimum clusters and maximum clusters settings to different values.
- C. Turn on the additional clusters manually after starting the warehouse.
- D. Configure the maximum clusters setting to "Maximum."
Answer: B
NEW QUESTION 96
Which of the following statements is true of data loading?
- A. The "deal file size for loading is 16MB to match micro-partition size
- B. Marry files in the 10-lOOMB range tend to land In the 'sweet spot" for load parallelism Once loaded, there is no option to force a reload of an already loaded file
- C. Resizing the virtual warehouse from x-Small to Small will process a single file twice as fast
Answer: B
NEW QUESTION 97
What file formats does Snowflake support for loading semi-structured data? (Choose three.)
- A. TSV
- B. PDF
- C. JSON
- D. Avro
- E. JPEG
- F. Parquet
Answer: C,D,F
NEW QUESTION 98
True or false: Snowflake enforces unique, primary key, and foreign key constraints during DML operations.
- A. True
- B. False
Answer: B
NEW QUESTION 99
......
Snowflake COF-C02 Exam Syllabus Topics:
| Topic | Details |
|---|---|
| Topic 1 |
|
| Topic 2 |
|
| Topic 3 |
|
| Topic 4 |
|
| Topic 5 |
|
| Topic 6 |
|
| Topic 7 |
|
| Topic 8 |
|
COF-C02 Exam Dumps, COF-C02 Practice Test Questions: https://www.exam4pdf.com/COF-C02-dumps-torrent.html
Free COF-C02 Study Guides Exam Questions and Answer: https://drive.google.com/open?id=1Qoeg58AaRTBHzq_qKBEa_VHEPenbEI3M
