[2023] Valid COF-C01 test answers & Snowflake COF-C01 exam pdf
Verified COF-C01 dumps Q&As - Pass Guarantee or Full Refund
NEW QUESTION 28
True or False: All Snowflake table types include fail-safe storage.
- A. True
- B. False
Answer: B
NEW QUESTION 29
Select the different types of Internal Stages: (Choose three.)
- A. User Stage
- B. Named Stage
- C. Table Stage
- D. Schema Stage
Answer: A,B,C
NEW QUESTION 30
How would you determine the size of the virtual warehouse used for a task?
- A. Since task infrastructure is based on running the task body on schedule, it's recommended to configure the virtual warehouse for automatic concurrency handling using Multi-cluster warehouse (MCW) to match the task schedule
- B. Root task may be executed concurrently (i.e. multiple instances), it is recommended to leave some margins in the execution window to avoid missing instances of execution
- C. Querying (select) the size of the stream content would help determine the warehouse size. For example, if querying large stream content, use a larger warehouse size
- D. If using the stored procedure to execute multiple SQL statements, it's best to test run the stored procedure separately to size the compute resource first
Answer: D
NEW QUESTION 31
Which of the following statements 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's based on an Oracle Architecture
- 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 32
What happens when a Data Provider revokes privileges to a Share on an object in their source database?
- A. Any additional data arriving after this point in time will not be visible to Data Consumers
- B. A static copy of the object at the time the privilege was revoked is created In the Data Consumers' accounts
- C. The object immediately becomes unavailable for all Data Consumers
- D. The Data Consumers stop seeing data updates and become responsible for storage charges for the object
Answer: C
NEW QUESTION 33
Credit Consumption by the Compute Layer (Virtual Warehouses) is based on: (Choose two.)
- A. Warehouse size
- B. Amount of data processed
- C. # of clusters for the Warehouse
- D. Number of users
Answer: A,C
NEW QUESTION 34
True or False: A table in Snowflake can only be queried using the Virtual Warehouse that was used to load the data.
- A. True
- B. False
Answer: B
NEW QUESTION 35
What is the minimum Snowflake edition that provides data sharing?
- A. Enterprise
- B. Premier
- C. Standard
- D. Business Critical Edition
Answer: C
NEW QUESTION 36
Which object allows you to limit the number of credits consumed within a Snowflake account?
- A. Account usage Tracking
- B. Resource Monitor
- C. Warehouse Limit Parameter
- D. Credit Consumption Tracker
Answer: B
NEW QUESTION 37
Which of the following best describes where Snowflake's metadata is stored?
- A. In the Cloud Services Layer
- B. Inside the Virtual Warehouses
- C. within the drivers
- D. Within the data files
Answer: A
NEW QUESTION 38
Why would a customer size a Virtual Warehouse from an X-Small to a Medium?
- A. To accommodate more queries
- B. To accommodate fluctuations in workload
- C. To accommodate a more complex workload
- D. To accommodate more users
Answer: C
NEW QUESTION 39
When a pipe is recreated using the CREATE on REPLAC PIPE command: Select one.
- A. Previously loaded files will be ignored
- B. All of the above
- C. The Pipe load history is reset to empty
- D. The REFRESH parameter is set to TRUE
Answer: C
NEW QUESTION 40
Which of the following items does the Cloud services Layer manage? Choose 4 answers
- A. Metadata
- B. external blob storage
- C. Data security
- D. user authentication
- E. Query compilation and optimization
Answer: A,C,D,E
NEW QUESTION 41
True or False: Data in Fail-safe can be deleted by a user or the Snowflake team before it expires.
- A. True
- B. False
Answer: B
NEW QUESTION 42
Data storage for individual tables can be monitored using which commands and/or object(s)? Choose 2 answers
- A. SHOW TABLES;
- B. SHOW STORAGE BY TABLE;
- C. Information Schema -> TASLE_HISTORY
- D. Information Schema -> TABLE_STORAGE_METRICS
Answer: A,D
NEW QUESTION 43
True or False: Loading data into Snowflake requires that source data files be no larger than 16MB.
- A. True
- B. False
Answer: B
NEW QUESTION 44
What is the maximum compressed row size in Snowflake?
- A. 50MB
- B. 16MB
- C. 4000GB
- D. 8KB
Answer: B
NEW QUESTION 45
True or False: You can resize a Virtual Warehouse while queries are running.
- A. True
- B. False
Answer: A
NEW QUESTION 46
......
COF-C01 Exam Questions – Valid COF-C01 Dumps Pdf: https://www.easy4engine.com/COF-C01-test-engine.html
COF-C01 PDF Dumps Recently Updated Questions: https://drive.google.com/open?id=1J8h8PAmXnWw6PPLfDpM4yWN6oiDCNBKU
