[2022] Free COF-C01 Exam Dumps to Pass Exam Easily
COF-C01 Exam Dumps, COF-C01 Practice Test Questions
NEW QUESTION 30
On which of the following cloud platform can a Snowflake account be hosted? Choose 2 answers
- A. Private Virtual Cloud
- B. Amazon Web Services
- C. Microsoft Azure Cloud
- D. Oracle Cloud
Answer: B,C
NEW QUESTION 31
The number of queries that a Virtual Warehouse can concurrently process is determined by: Choose 2 answers
- A. The tool that s executing the query
- B. The size of the data required for each query
- C. The CONCURRENT_QUERY_UMIT parameter set on the Snowflake account
- D. The complexity of each query
Answer: B,D
NEW QUESTION 32
Which of the following are options when creating a virtual Warehouse? Choose 2 answers
- A. Auto resize
- B. Auto-resume
- C. Auto-drop
- D. Auto-suspend
Answer: B,D
NEW QUESTION 33
Which of the following statements are true of VALIDATION_MODE in Snowflake? (Choose two.)
- A. The validation_mode option will validate data to be loaded by the copy statement without completing the load and will return possible errors
- B. The validation_mode option is used when creating an Internal Stage
- C. validation_mode=return_all_errors is a parameter of the copy command
- 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: C,D
NEW QUESTION 34
True or False: Each worksheet in the Snowflake Web Interface (UI) can be associated with different roles, databases, schemas, and Virtual Warehouses.
- A. True
- B. False
Answer: A
NEW QUESTION 35
Which of the following are common use cases for zero-copy cloning? Choose 3 answers
- A. Performance optimization
- B. Point in time snapshots
- C. Quick provisioning of Dev and Test/QA environments
- D. Data backups
Answer: B,C,D
NEW QUESTION 36
True or False: Micro-partition metadata enables some operations to be completed without requiring Compute.
- A. True
- B. False
Answer: A
NEW QUESTION 37
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 38
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. Growth of storage and compute are tightly coupled together
- C. Multiple compute clusters can access stored data without contention
- D. Storage expands without the requirement to add more compute
Answer: A,C,D
NEW QUESTION 39
True or False: Users are able to see the result sets of queries executed by other users that share their same role.
- A. True
- B. False
Answer: B
NEW QUESTION 40
Which of the following statements is true of Snowflake micro-partitioning?
- A. Micro-partitioning is transparently completed using the ordering that occurs when the data is inserted/loaded
- B. Micro-partitioning has been known to introduce data skew
- C. Micro-partitioning: requires a partitioning schema to be defined up front
- D. Micro-partitioning can be disabled within a Snowflake account
Answer: A
NEW QUESTION 41
How would you determine the size of the virtual warehouse used for a task?
- A. 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
- B. 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
- C. 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
- D. 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
Answer: C
NEW QUESTION 42
How a Snowpipe charges calculated?
- A. Number of Pipes in account
- B. Total storage bucket size
- C. Per-second/per-core granularity
- D. Per-second/per Warehouse size
Answer: C
NEW QUESTION 43
Which of the following is true of Snowpipe via REST API? Choose 2 answers
- A. you can only use it on internal Stages
- B. Snowflake automatically manages the compute required to execute the Pipe's copy into commands
- C. Snowpipe keeps track of which files it has loaded
- D. All COPY INTO options are available fluting pipe creation
Answer: B,C
NEW QUESTION 44
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. Information Schema -> TASLE_HISTORY
- D. SHOW TABLES;
Answer: A,D
NEW QUESTION 45
Select the different types of Internal Stages: (Choose three.)
- A. Named Stage
- B. Schema Stage
- C. User Stage
- D. Table Stage
Answer: A,C,D
NEW QUESTION 46
......
COF-C01 Exam Dumps, COF-C01 Practice Test Questions: https://exams4sure.actualcollection.com/COF-C01-exam-questions.html