Free Snowflake COF-C01 Study Guides Exam Questions and Answer
COF-C01 Exam Dumps, COF-C01 Practice Test Questions
NEW QUESTION 98
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: A
NEW QUESTION 99
True or False: The COPY command must specify a File Format in order to execute.
- A. False
- B. True
Answer: A
NEW QUESTION 100
True or False: You can query the files in an External Stage directly without having to load the data into a table.
- A. False
- B. True
Answer: B
NEW QUESTION 101
How many shares can be consumed by single Data Consumer?
- A. Unlimited
- B. 100, but can be increased by contacting support
- C. 0
- D. 1
Answer: A
NEW QUESTION 102
True or False: It is possible for a user to run a query against the query result cache without requiring an active Warehouse.
- A. False
- B. True
Answer: A
NEW QUESTION 103
True or False: A Virtual Warehouse can be resized while suspended.
- A. False
- B. True
Answer: B
NEW QUESTION 104
True or False: Pipes can be suspended and resumed.
- A. False
- B. True
Answer: B
NEW QUESTION 105
True or False: Snowflake supports federated authentication in all editions.
- A. False
- B. True
Answer: B
NEW QUESTION 106
True or False: When a new Snowflake object is created, it is automatically owned by the user who created it.
- A. False
- B. True
Answer: B
NEW QUESTION 107
Increasing the size of a Virtual Warehouse from an X-Small to an X-Large is an example of:
- A. Scaling up
- B. Scaling rhythmically
- C. Scaling max
- D. Scaling out
Answer: A
NEW QUESTION 108
Which of the following statements are true of VALIDATION_MODE in Snowflake? (Choose two.)
- A. validation_mode=return_all_errors is a parameter of the copy command
- B. The validation_mode option will validate data to be loaded by the copy statement without completing the load and will return possible errors
- C. The validation_mode option is used when creating an Internal Stage
- D. The validation_mode option will validate data to be loaded by the copy statement while completing the load and will return the rows that could not be loaded without error
Answer: A,D
NEW QUESTION 109
True or False: You can resize a Virtual Warehouse while queries are running.
- A. False
- B. True
Answer: B
NEW QUESTION 110
Which of the following statements describes a benefit of Snowflake's separation of compute and storage? (Choose all that apply.)
- A. Compute can be scaled up or down without the requirement to add more storage
- B. Multiple compute clusters can access stored data without contention
- C. Growth of storage and compute are tightly coupled together
- D. Storage expands without the requirement to add more compute
Answer: A,B,D
NEW QUESTION 111
True or false: it is best practice to define a clustering key on every table.
- A. False
- B. True
Answer: A
NEW QUESTION 112
Which of the following is true of Snowpipe via REST API? Choose 2 answers
- A. Snowpipe keeps track of which files it has loaded
- B. you can only use it on internal Stages
- C. All COPY INTO options are available fluting pipe creation
- D. Snowflake automatically manages the compute required to execute the Pipe's copy into commands
Answer: A,D
NEW QUESTION 113
Snowflake provides two mechanisms to reduce data storage costs for short-lived tables. These mechanisms are: Choose 2 answers
- A. Provisional Tables
- B. Permanent Tables
- C. Temporary Tables
- D. Transient Tables
Answer: C,D
NEW QUESTION 114
The PUT command: (Choose two.)
- A. Automatically encrypts files
- B. Automatically creates a File Format object
- C. Automatically compresses files using Gzip
- D. Automatically uses the last Stage created
Answer: A,C
NEW QUESTION 115
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 116
......
Latest COF-C01 Actual Free Exam Questions Updated 165 Questions: https://www.test4cram.com/COF-C01_real-exam-dumps.html