COF-C01 Exam Brain Dumps - Study Notes and Theory [Sep-2022]
100% Guaranteed Results COF-C01 Unlimited 165 Questions
NEW QUESTION 31
What parameter controls if the Virtual warehouse starts immediately after the CREATE WAREHOUSE statement?
- A. INITTIALLY_SUSPENDED = TRUE/FALSE
- B. START_AFTCR_CREATE = TRUE/FALSE
- C. START.TIME = CURRENT.DATE()
- D. START_TTIME = 60 // (seconds from now)
Answer: A
NEW QUESTION 32
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. All COPY INTO options are available fluting pipe creation
- D. Snowpipe keeps track of which files it has loaded
Answer: B,D
NEW QUESTION 33
Which of the following items does the Cloud services Layer manage? Choose 4 answers
- A. user authentication
- B. Data security
- C. Metadata
- D. external blob storage
- E. Query compilation and optimization
Answer: A,B,C,E
NEW QUESTION 34
Which of the following objects can be cloned? (Choose four.)
- A. Users
- B. Named File Formats
- C. Schemas
- D. Shares
- E. Databases
- F. Tables
Answer: B,C,E,F
NEW QUESTION 35
True or False: Snowflake's data warehouse was built from the ground up for the cloud in lieu of using an existing database or a platform, like Hadoop, as a base.
- A. False
- B. True
Answer: A
NEW QUESTION 36
Select the three types of tables that exist within Snowflake.
Choose 3 answers
- A. Permanent
- B. Transient
- C. Provisioned
- D. Temporary
Answer: A,B,D
NEW QUESTION 37
Increasing the size of a Virtual Warehouse from an X-Small to an X-Large is an example of:
- A. Scaling up
- B. Scaling max
- C. Scaling out
- D. Scaling rhythmically
Answer: A
NEW QUESTION 38
What is the minimum duration charged when starting a virtual warehouse?
- A. 1 second
- B. 1 day
- C. 1 minute
- D. 1 hour
Answer: C
NEW QUESTION 39
When a Pipe is recreated using the CREATE OR REPLACE PIPE command:
- A. The Pipe load history is reset to empty
- B. Previously loaded files will be ignored
- C. The REFRESH parameter is set to TRUE
- D. All of the above
Answer: A
NEW QUESTION 40
Which object allows you to limit the number of credits consumed within a Snowflake account?
- A. Resource Monitor
- B. Credit Consumption Tracker
- C. Warehouse Limit Parameter
- D. Account usage Tracking
Answer: A
NEW QUESTION 41
True or False: The user has to specify which cluster a query will run on in multi-clustering Warehouse.
- A. False
- B. True
Answer: A
NEW QUESTION 42
Which of the following objects is not covered by Time Travel?
- A. Databases
- B. Tables
- C. Stages
- D. Schemas
Answer: C
NEW QUESTION 43
Which of the following are options when creating a Virtual Warehouse?
- A. Auto-suspend
- B. User count
- C. Auto-resume
- D. Local SSD size
Answer: A,C
NEW QUESTION 44
Account-level storage usage can be monitored via:
- A. The Snowflake web interface (UI) in the Account -> Billing a usage section
- B. The Account usage Schema - > ACCOUNT_USAGE_METRICS View
- C. The snowflake wet Interface (UI) in the Databases section.
- D. The Information Schema -> ACCOUNT_USAGE_HISTORY View
Answer: B
NEW QUESTION 45
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 46
......
COF-C01 Dumps PDF - Want To Pass COF-C01 Fast: https://exam-hub.prepawayexam.com/Snowflake/braindumps.COF-C01.ete.file.html