Get all the Information About Snowflake COF-C01 Exam 2022 Practice Test Questions
Check Real Snowflake COF-C01 Exam Question for Free (2022)
NEW QUESTION 96
The number of queries that a Virtual Warehouse can concurrently process is determined by: Choose 2 answers
- A. The CONCURRENT_QUERY_UMIT parameter set on the Snowflake account
- B. The tool that s executing the query
- C. The complexity of each query
- D. The size of the data required for each query
Answer: C,D
NEW QUESTION 97
What command is used to load files into an Internal Stage within Snowflake? Select one.
- A. COPY INTO
- B. TRANSFER
- C. PUT
- D. INSERT
Answer: C
NEW QUESTION 98
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 99
True or False: Once created, a micro-partition will never be changed.
- A. True
- B. False
Answer: A
NEW QUESTION 100
What are two ways to create and manage Data Shares in Snowflake? (Choose two.)
- A. Via the data_share=true parameter
- B. Via SQL commands
- C. Via Virtual Warehouses
- D. Via the Snowflake Web Interface (Ul)
Answer: B,D
NEW QUESTION 101
Data storage for individual tables can be monitored using which commands and/or object(s)? Choose 2 answers
- A. Information Schema -> TASLE_HISTORY
- B. SHOW STORAGE BY TABLE;
- C. SHOW TABLES;
- D. Information Schema -> TABLE_STORAGE_METRICS
Answer: C,D
NEW QUESTION 102
Select the different types of Internal Stages: (Choose three.)
- A. Schema Stage
- B. Table Stage
- C. Named Stage
- D. User Stage
Answer: B,C,D
NEW QUESTION 103
Which of the following best describes where Snowflake's metadata is stored?
- A. within the drivers
- B. In the Cloud Services Layer
- C. Inside the Virtual Warehouses
- D. Within the data files
Answer: B
NEW QUESTION 104
Increasing the size of a Virtual Warehouse from an X-Small to an X-Large is an example of:
- A. Scaling rhythmically
- B. Scaling out
- C. Scaling max
- D. Scaling up
Answer: D
NEW QUESTION 105
True or False: A table in Snowflake can only be queried using the Virtual Warehouse that was used to load the data.
- A. False
- B. True
Answer: A
NEW QUESTION 106
True or False: Snowpipe via RFST API can only reference External Stages as source.
- A. True
- B. False
Answer: A
NEW QUESTION 107
Which of the following statements is true of data loading?
- A. Marry files in the 10-lOOMB range tend to land In the 'sweet spot" for load parallelism Once loaded, there is no option to force a reload of an already loaded file
- B. The "deal file size for loading is 16MB to match micro-partition size
- C. Resizing the virtual warehouse from x-Small to Small will process a single file twice as fast
Answer: A
NEW QUESTION 108
The FLATEEN function is used to query which type of data in Snowflake?
- A. None of the above
- B. Structured data
- C. Semi-structured data
- D. Both of the above
Answer: C
NEW QUESTION 109
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. Snowflake automatically manages the compute required to execute the Pipe's copy into commands
- C. All COPY INTO options are available fluting pipe creation
- D. you can only use it on internal Stages
Answer: A,B
NEW QUESTION 110
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 is used when creating an Internal Stage
- C. The validation_mode option will validate data to be loaded by the copy statement without completing the load and will return possible errors
- 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 111
Which of the following statements are true of Virtual Warehouses? (Choose all that apply.)
- A. Customers can change the size of the Warehouse after creation
- B. A Warehouse can be configured to suspend after a period of inactivity
- C. A Warehouse can be configured to auto-resume when new queries are submitted
- D. A Warehouse can be resized while running
Answer: A,B,C,D
NEW QUESTION 112
Which of the following commands are not blocking operations?
Choose 2 answers
- A. COPY
- B. INSERT
- C. UPDATE
- D. MERGE
Answer: A,B
NEW QUESTION 113
When can a Virtual Warehouse start running queries?
- A. When its provisioning is complete
- B. 12am-5am
- C. Only during administrator defined time slots
- D. After replication
Answer: A
NEW QUESTION 114
When loading data into Snowflake, the COPY command supports: Choose 2 answers
- A. Aggregates
- B. Column reordering
- C. Joins
- D. Fitters
- E. Data type conversions
Answer: B,E
NEW QUESTION 115
True or False: When data share is established between a Data Provider and a data Consumer, the Data Consumer can extend that data share to other Data Consumers.
- A. False
- B. True
Answer: A
NEW QUESTION 116
Which of the following statements is true of Snowflake?
- A. It was built specifically for the cloud
- B. It was built as an on-premises solution and then ported to the cloud
- C. It's based on an Oracle Architecture
- D. It was built for Hadoop architecture
- E. It was designed as a hybrid database to allow customers to store data either on premises or in the cloud
Answer: A
NEW QUESTION 117
Select the three types of tables that exist within Snowflake.
Choose 3 answers
- A. Transient
- B. Provisioned
- C. Permanent
- D. Temporary
Answer: A,C,D
NEW QUESTION 118
......
Use Free COF-C01 Exam Questions that Stimulates Actual EXAM : https://www.trainingquiz.com/COF-C01-practice-quiz.html
Get Ready to Boost your Prepare for your COF-C01 Exam with 165 Questions: https://drive.google.com/open?id=1bY62Sy2Exn-k8hJfM3DecPa6Jx4n3Bbj
