COF-C01 Practice Exam and Study Guides - Verified By Prep4sures Updated 165 Questions
2023 Updated Verified Pass COF-C01 Study Guides & Best Courses
NEW QUESTION 16
True or False: All Snowflake table types include fail-safe storage.
- A. True
- B. False
Answer: B
NEW QUESTION 17
True or False: AWS Private Link provides a secure connection from the Customer's on-premise data center to the Snowflake.
- A. True
- B. False
Answer: B
NEW QUESTION 18
True or False: Snowflake bills for a minimum of five minutes each time a Virtual Warehouse is started.
- A. True
- B. False
Answer: B
NEW QUESTION 19
True or False: Snowpipe via RFST API can only reference External Stages as source.
- A. True
- B. False
Answer: A
NEW QUESTION 20
True or False: The COPY command must specify a File Format in order to execute.
- A. True
- B. False
Answer: B
NEW QUESTION 21
True or False: Multi_Factor Authentication (MFA) in Snowflake is only supported in conjunction with single Sign-on (sso).
- A. True
- B. False
Answer: B
NEW QUESTION 22
For a multi-cluster Warehouse, the number of credits billed is calculated on: Select one.
- A. The number of users who accessed the Warehouse.
- B. The sue of the Warehouse and the maximum number of clusters configured for the Warehouse.
- C. The number of queries that ran using the Warehouse.
- D. The size of the Warehouse and the number of clusters that ran within a given time period.
Answer: D
NEW QUESTION 23
Which of the following are valid Snowflake Virtual Warehouse Scaling Policies? (Choose two.)
- A. Custom
- B. Standard
- C. Optimized
- D. Economy
Answer: B,D
NEW QUESTION 24
Which of the following are true of multi-cluster Warehouses? Select all that apply below.
- A. A multi-cluster Warehouse can automatically turn itself off after a period of inactivity
- B. A multi-cluster Warehouse can add clusters automatically based on query activity
- C. A multi-cluster Warehouse can automatically turn itself on when a query is executed against it
- D. A multi-cluster Warehouse can scale down when query activity slows
Answer: A,B,C,D
NEW QUESTION 25
True or False: When you create a custom role, it is a best practice to immediately grant that role to ACCOUNTADMIN.
- A. True
- B. False
Answer: B
NEW QUESTION 26
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 27
Which of the following commands sets the Virtual Warehouse for a session?
- A. SET warehouse = <<warehouse name>>;
- B. COPT WAREHOUSE FROM <<Config file> ;
- C. USE WAREHOUSE <<warehouse name>>;
- D. USE VIRTUAL_WAREHOUSE <<warehouse name>>;
Answer: C
NEW QUESTION 28
Data storage for individual tables can be monitored using which commands and/or object(s)? Choose 2 answers
- A. Information Schema -> TABLE_STORAGE_METRICS
- B. SHOW STORAGE BY TABLE;
- C. SHOW TABLES;
- D. Information Schema -> TASLE_HISTORY
Answer: A,C
NEW QUESTION 29
Why would a customer size a Virtual Warehouse from an X-Small to a Medium?
- A. To accommodate a more complex workload
- B. To accommodate fluctuations in workload
- C. To accommodate more queries
- D. To accommodate more users
Answer: A
NEW QUESTION 30
Each incremental increase in Virtual Warehouse size (e,g. Medium to Large) generally results in what?
- A. Higher storage costs
- B. More micro-partitions
- C. Double the numbers of servers In the compute duster
- D. Better query scheduling
Answer: C
NEW QUESTION 31
What is the minimum Snowflake edition that provides data sharing?
- A. Business Critical Edition
- B. Standard
- C. Premier
- D. Enterprise
Answer: B
NEW QUESTION 32
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 33
Which of the following commands are not blocking operations?
Choose 2 answers
- A. INSERT
- B. UPDATE
- C. COPY
- D. MERGE
Answer: A,C
NEW QUESTION 34
True or False: Query ID's are unique across all Snowflake deployments and can be used in communication with Snowflake Support to help troubleshoot issues.
- A. True
- B. False
Answer: A
NEW QUESTION 35
......
Ultimate Guide to the COF-C01 - Latest Edition Available Now: https://freedownload.prep4sures.top/COF-C01-real-sheets.html