Get Instant Access of 100% Real Snowflake COF-C01 Exam Questions with Verified Answers
Exam Dumps for the Preparation of Latest COF-C01 Exam Questions
NEW QUESTION 75
Which of the following roles is recommended to be used to create and manage users and roles?
- A. SYSADMIN
- B. SECURITYADMIN
- C. PUBLIC
- D. ACCOUNTADMIN
Answer: D
NEW QUESTION 76
True or False: Micro-partition metadata enables some operations to be completed without requiring Compute.
- A. True
- B. False
Answer: A
NEW QUESTION 77
Each incremental increase in Virtual Warehouse size (e,g. Medium to Large) generally results in what?
- A. More micro-partitions
- B. Higher storage costs
- C. Double the numbers of servers In the compute duster
- D. Better query scheduling
Answer: C
NEW QUESTION 78
True or False: When data share is established between a Data Provider and a data Consumer, the Data Consumer can extend that data share to other Data Consumers.
- A. True
- B. False
Answer: B
NEW QUESTION 79
True or False: A 4X-Large Warehouse may, at times, take longer to provision than a X-Small Warehouse.
- A. True
- B. False
Answer: B
NEW QUESTION 80
Account-level storage usage can be monitored via:
- A. The Account usage Schema - > ACCOUNT_USAGE_METRICS View
- B. The Information Schema -> ACCOUNT_USAGE_HISTORY View
- C. The snowflake wet Interface (UI) in the Databases section.
- D. The Snowflake web interface (UI) in the Account -> Billing a usage section
Answer: A
NEW QUESTION 81
Which of the following are examples of operations that require a Virtual Warehouse to complete, assuming no quires have been executed previously? Choose 3 answers
- A. SUM(<< column value >>)
- B. MIN(< < column value>>)
- C. UPDATE
- D. COPY
Answer: A,C,D
NEW QUESTION 82
When a Pipe is recreated using the CREATE OR REPLACE PIPE command:
- A. The REFRESH parameter is set to TRUE
- B. The Pipe load history is reset to empty
- C. Previously loaded files will be ignored
- D. All of the above
Answer: B
NEW QUESTION 83
What are the three layers that make up Snowflake's architecture? Choose 3 answer
- A. Compute
- B. Tri-Secret Secure
- C. Storage
- D. Cloud Services
Answer: A,C,D
NEW QUESTION 84
Which of the following statements is true of Snowflake?
- A. It's based on an Oracle Architecture
- B. It was built for Hadoop architecture
- C. It was designed as a hybrid database to allow customers to store data either on premises or in the cloud
- D. It was built as an on-premises solution and then ported to the cloud
- E. It was built specifically for the cloud
Answer: E
NEW QUESTION 85
Which of the following DML commands isn't supported by Snowflake?
- A. UPSERT
- B. UPDATE
- C. TRUNCATE TABLE
- D. MERGE
Answer: A
NEW QUESTION 86
True or False: Fail-safe can be disabled within a Snowflake account.
- A. True
- B. False
Answer: B
NEW QUESTION 87
What is the lowest Snowflake edition that offers Time Travel up to 90 days.
- A. Premier Edition
- B. standard Edition
- C. Business Critical Edition
- D. Enterprise Edition
Answer: D
NEW QUESTION 88
True or False: It is possible to query data from an Internal or named External stage without loading the data into Snowflake.
- A. True
- B. False
Answer: A
NEW QUESTION 89
When can a Virtual Warehouse start running queries?
- A. After replication
- B. Only during administrator defined time slots
- C. When its provisioning is complete
- D. 12am-5am
Answer: C
NEW QUESTION 90
If a Small Warehouse is made up of 2 servers/cluster, how many servers/cluster make up a Medium Warehouse?
- A. 0
- B. 1
- C. 2
- D. 3
Answer: D
NEW QUESTION 91
True or False: Once created, a micro-partition will never be changed.
- A. True
- B. False
Answer: A
NEW QUESTION 92
Which of the following are main sections of the top navigation of the Snowflake web Interface (UI)?
- A. Database
- B. Tables
- C. Worksheets
- D. Warehouses
Answer: A,C,D
NEW QUESTION 93
What is the recommended Snowflake data type to store semi-structured data like JSON?
- A. LOB
- B. RAW
- C. VARCHAR
- D. VARIANT
Answer: D
NEW QUESTION 94
True or False: Reader Accounts incur no additional Compute costs to the Data Provider since they are simply reading the shared data without making changes.
- A. True
- B. False
Answer: B
NEW QUESTION 95
Which of the following terms best describes Snowflake's database architecture?
- A. Cloud-native shared memory
- B. Multi-cluster, shared data
- C. Shared disk
- D. Columnar shared nothing
Answer: B
NEW QUESTION 96
......
Download Latest & Valid Questions For Snowflake COF-C01 exam: https://pass4sure.trainingquiz.com/COF-C01-training-materials.html
