Snowflake COF-C01 Certification Exam Dumps with 165 Practice Test Questions
New COF-C01 Exam Dumps with High Passing Rate
NEW QUESTION 72
Which of the following are options when creating a virtual Warehouse? Choose 2 answers
- A. Auto-drop
- B. Auto resize
- C. Auto-suspend
- D. Auto-resume
Answer: C,D
NEW QUESTION 73
What is the minimum Snowflake edition that provides multi-cluster warehouses and up to 90 days of Time Travel?
- A. Enterprise
- B. Business Critical Edition
- C. Premier
- D. Standard
Answer: A
NEW QUESTION 74
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. Better query scheduling
- D. Double the numbers of servers In the compute duster
Answer: D
NEW QUESTION 75
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. False
- B. True
Answer: B
NEW QUESTION 76
Which item in the Data Warehouse migration process does not apply in Snowflake>
- A. Build the Data pipeline
- B. Migrate Users
- C. Migrate Indexes
- D. Migrate Schemas
Answer: C
NEW QUESTION 77
True or False: Some queries can be answered through the metadata cache and do not require an active Virtual Warehouse.
- A. False
- B. True
Answer: B
NEW QUESTION 78
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. COPY
- B. UPDATE
- C. SUM(<< column value >>)
- D. MIN(< < column value>>)
Answer: A,B,C
NEW QUESTION 79
When scaling up Virtual Warehouse by increasing Virtual Warehouse t-shirt size, you are primarily scaling for improved:
- A. Concurrency
- B. Performance
Answer: B
NEW QUESTION 80
When a Pipe is recreated using the CREATE OR REPLACE PIPE command:
- A. Previously loaded files will be ignored
- B. All of the above
- C. The REFRESH parameter is set to TRUE
- D. The Pipe load history is reset to empty
Answer: D
NEW QUESTION 81
What privileges are required to execute a task?
- A. Tasks run automatically and do run under any rote.
- B. A task is an account-level object and can only be executed by the Account Admin role.
- C. Tasks are stored in a special database called the utility database and require EXECUTE TASK privilege in the utility database.
- D. To execute a task, you need the EXECUTE TASK.
Answer: D
NEW QUESTION 82
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 83
How would you execute a series of SQL statements using Task?
- A. A stored procedure can have only one DML statement per stored procedure invocation and therefore you should sequence stored procedures calls in the task definition CREATE TASK mytask.... AS call stored_prc1(); call stored_proc2t);
- B. A stored procedure executing multiple SQL statements and invoke the stored procedure from the task. CREATE TASK mytask.... AS call stored_proc_multiple_statements_inside():
- C. include the SQL statements in the body of the task create task mytask.. as insert into target1 select., from stream_s1 where ..INSERT INTO target2 SELECT .. FROM stream .s1 where ..
- D. Create a task for each SQL statement (e.g. resulting in task1. task2, etc) and string the series of SQL statements by having a control task calling task 1, task 2 sequentially.
Answer: B
NEW QUESTION 84
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 85
On which of the following cloud platform can a Snowflake account be hosted? Choose 2 answers
- A. Oracle Cloud
- B. Private Virtual Cloud
- C. Microsoft Azure Cloud
- D. Amazon Web Services
Answer: C,D
NEW QUESTION 86
True or False: Pipes can be suspended and resumed.
- A. False
- B. True
Answer: B
NEW QUESTION 87
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 CONCURRENT_QUERY_UMIT parameter set on the Snowflake account
- C. The complexity of each query
- D. The size of the data required for each query
Answer: C,D
NEW QUESTION 88
Which of the following statements is true of Snowflake?
- A. It was built as an on-premises solution and then ported to the cloud
- B. It's based on an Oracle Architecture
- C. It was built for Hadoop architecture
- D. It was built specifically for the cloud
- E. It was designed as a hybrid database to allow customers to store data either on premises or in the cloud
Answer: D
NEW QUESTION 89
Which of the following languages can be used to implement Snowflake User Defined Functions (UDFs)? Choose 2 answers
- A. Java
- B. JavaScript
- C. Python
- D. SQL
Answer: B,D
NEW QUESTION 90
Select the different types of Internal Stages: (Choose three.)
- A. User Stage
- B. Table Stage
- C. Named Stage
- D. Schema Stage
Answer: A,B,C
NEW QUESTION 91
Which of the following statements are true of Snowflake releases: (Choose two.)
- A. A customer is assigned a 30 minute window (that can be moved anytime within a week) during which the system will be unavailable and customer is upgraded
- B. They roll up and release approximately monthly, but customers can request early release application
- C. They happen approximately weekly
- D. During a release, new customer requests/queries/connections transparently move over to the newer version
Answer: C,D
NEW QUESTION 92
How many shares can be consumed by single Data Consumer?
- A. Unlimited
- B. 0
- C. 1
- D. 100, but can be increased by contacting support
Answer: A
NEW QUESTION 93
......
Get COF-C01 Braindumps & COF-C01 Real Exam Questions: https://www.dumpsking.com/COF-C01-testking-dumps.html
Snowflake COF-C01 Actual Questions and Braindumps: https://drive.google.com/open?id=17aX80bPfuXZkJEWZP_1Xn0TdUUrMXLe3
