Updated Oct 12, 2022 Certification Exam COF-C01 Dumps - Practice Test Questions
Updated Verified COF-C01 dumps Q&As - Pass Guarantee or Full Refund
NEW QUESTION 18
How a Snowpipe charges calculated?
- A. Per-second/per-core granularity
- B. Total storage bucket size
- C. Per-second/per Warehouse size
- D. Number of Pipes in account
Answer: A
NEW QUESTION 19
Which formats are supported for unloading data from Snowflake? Choose 2 answers
- A. ORC
- B. Delimited (CSV, TSV, etc.)
- C. JSON
- D. Avro
Answer: B,C
NEW QUESTION 20
Which statement best describes '' clustering''?
- A. Clustering represents the way data is grouped together and stored within snowflake's micro-partitions
- B. Clustering can be disabled within a Snowflake account.
- C. The clustering key must be included on the COPV command when loading data into Snowflake.
- D. The database administrator must define the clustering methodology for each Snowflake table.
Answer: A
NEW QUESTION 21
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 22
Which of the following objects can be cloned? (Choose four.)
- A. Users
- B. Shares
- C. Databases
- D. Tables
- E. Schemas
- F. Named File Formats
Answer: C,D,E,F
NEW QUESTION 23
True or False: When active, a pipe requires a dedicated Virtual Warehouse to execute.
- A. False
- B. True
Answer: A
NEW QUESTION 24
Which of the following best describes where Snowflake's metadata is stored?
- A. In the Cloud Services Layer
- B. Inside the Virtual Warehouses
- C. Within the data files
- D. within the drivers
Answer: A
NEW QUESTION 25
Which of the following are options when creating a virtual Warehouse? Choose 2 answers
- A. Auto resize
- B. Auto-drop
- C. Auto-suspend
- D. Auto-resume
Answer: C,D
NEW QUESTION 26
As a best practice, clustering keys should only be defined on tables of which minimum size?
- A. Multi-Gigabyte (GB) Range
- B. Multi-Terabyte (TB) Range
- C. Multi-Megabyte (MB) Range
- D. Multi-Kilobyte (KB) Range
Answer: B
NEW QUESTION 27
True or False: It is possible to query data from an Internal or named External stage without loading the data into Snowflake.
- A. True
- B. False
Answer: A
NEW QUESTION 28
Which of the following statements are true about Schemas in Snowflake? (Choose two.)
- A. A Schema is a logical grouping of Database Objects
- B. A Schema may contain one or more Databases
- C. A Database may contain one or more Schemas
- D. Each Schema is contained within a Warehouse
Answer: A,C
NEW QUESTION 29
True or False: Snowpipe via RFST API can only reference External Stages as source.
- A. True
- B. False
Answer: A
NEW QUESTION 30
A deterministic query is run at 8am, takes 5 minutes, and the results are cached .
Which of the following statements are true? Choose 2 answers
- A. The same exact query will return the precomputed results if the underlying data hasn't changed and the results were last accessed within the previous 24 hour period
- B. The same exact query will return the precomputed results even if the underlying data has changed as long as the results were last accessed within the previous
- C. The exact query win ALWAYS return me precomputed result set for the RESULT_CACHE_ACTIVE = time period
- D. The ''24 hour'' on the percomputed results gets renewed every time the exact query is executed
Answer: B,C
NEW QUESTION 31
Which of the following statements describes a benefit of Snowflake's separation of compute and storage? (Choose all that apply.)
- A. Multiple compute clusters can access stored data without contention
- B. Storage expands without the requirement to add more compute
- C. Growth of storage and compute are tightly coupled together
- D. Compute can be scaled up or down without the requirement to add more storage
Answer: A,B,D
NEW QUESTION 32
Which of the following are options when creating a Virtual Warehouse?
- A. User count
- B. Local SSD size
- C. Auto-suspend
- D. Auto-resume
Answer: C,D
NEW QUESTION 33
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 34
Which are true of Snowflake roles?
- A. All grants to objects are given to roles, and never to users
- B. In order to do DML/DOL, a user needs to have selected a single role that has that specific access to the object and operation
- C. The public role controls at other roles
- D. Roles are a subset of users and users own objects In Snowflake
Answer: A,B
NEW QUESTION 35
......
Exam Engine for COF-C01 Exam Free Demo & 365 Day Updates: https://www.prep4surereview.com/COF-C01-latest-braindumps.html
COF-C01 PDF Questions and Testing Engine With 165 Questions: https://drive.google.com/open?id=1z6aozjbXa0b1hSmT5POVuVBk6-54JUvD
