[Mar-2023] The Best SnowPro Core COF-C01 Professional Exam Questions
Try 100% Updated COF-C01 Exam Questions [2023]
NEW QUESTION 78
True or False: Snowpipe via RFST API can only reference External Stages as source.
- A. True
- B. False
Answer: A
NEW QUESTION 79
What is the lowest Snowflake edition that offers Time Travel up to 90 days.
- A. standard Edition
- B. Business Critical Edition
- C. Enterprise Edition
- D. Premier Edition
Answer: C
NEW QUESTION 80
True or false: Snowflake enforces unique, primary key, and foreign key constraints during DML operations.
- A. True
- B. False
Answer: B
NEW QUESTION 81
True or False: A Snowflake account is charged for data stored in both Internal and External Stages.
- A. True
- B. False
Answer: B
NEW QUESTION 82
Which formats are supported for unloading data from Snowflake? Choose 2 answers
- A. Delimited (CSV, TSV, etc.)
- B. JSON
- C. Avro
- D. ORC
Answer: A,B
NEW QUESTION 83
What is the minimum duration charged when starting a virtual warehouse?
- A. 1 second
- B. 1 hour
- C. 1 day
- D. 1 minute
Answer: D
NEW QUESTION 84
Which of the following statements is true of data loading?
- A. The "deal file size for loading is 16MB to match micro-partition size
- B. 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
- C. Resizing the virtual warehouse from x-Small to Small will process a single file twice as fast
Answer: B
NEW QUESTION 85
True or False: It is possible for a user to run a query against the query result cache without requiring an active Warehouse.
- A. True
- B. False
Answer: B
NEW QUESTION 86
Which of the following are valid Snowflake Virtual Warehouse Scaling Policies? (Choose two.)
- A. Custom
- B. Standard
- C. Economy
- D. Optimized
Answer: B,C
NEW QUESTION 87
What happens when a Data Provider revokes privileges to a Share on an object in their source database?
- A. A static copy of the object at the time the privilege was revoked is created In the Data Consumers' accounts
- B. The Data Consumers stop seeing data updates and become responsible for storage charges for the object
- C. The object immediately becomes unavailable for all Data Consumers
- D. Any additional data arriving after this point in time will not be visible to Data Consumers
Answer: C
NEW QUESTION 88
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. During a release, new customer requests/queries/connections transparently move over to the newer version
- D. They happen approximately weekly
Answer: C,D
NEW QUESTION 89
True or False: When you create a custom role, it is a practice to immediately grant that role to ACCOUNTADMIN.
- A. True
- B. False
Answer: B
NEW QUESTION 90
True or False: Reader Accounts incur no additional Compute costs to the Data Provider since they are simply reading the shared data without making changes.
- A. True
- B. False
Answer: B
NEW QUESTION 91
Which of the following terms best describes Snowflake's database architecture?
- A. Cloud-native shared memory
- B. Multi-cluster, shared data
- C. Columnar shared nothing
- D. Shared disk
Answer: B
NEW QUESTION 92
Which statement best describes '' clustering''?
- A. Clustering represents the way data is grouped together and stored within snowflake's micro-partitions
- B. The clustering key must be included on the COPV command when loading data into Snowflake.
- C. The database administrator must define the clustering methodology for each Snowflake table.
- D. Clustering can be disabled within a Snowflake account.
Answer: A
NEW QUESTION 93
The Information Schema and Account Usage Share provide storage information for which of the following objects? (Choose three.)
- A. Users
- B. Tables
- C. Internal Stages
- D. Databases
Answer: B,C,D
NEW QUESTION 94
which of the following are valid approaches to loading data into a snowflake table? select all the below that apply.
- A. Bulk copy from an Internal Stage
- B. Continuous load using Snowpipe REST API
- C. Bulk copy from an External Stage
- D. The Snowflake Web Interface (UT) data loading wizard
Answer: A,B,C,D
NEW QUESTION 95
True or False: Snowflake charges additional fees to Data providers for each share they create.
- A. True
- B. False
Answer: A
NEW QUESTION 96
When a pipe is recreated using the CREATE on REPLAC PIPE command: Select one.
- A. Previously loaded files will be ignored
- B. All of the above
- C. The Pipe load history is reset to empty
- D. The REFRESH parameter is set to TRUE
Answer: C
NEW QUESTION 97
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 98
Data storage for individual tables can be monitored using which commands and/or object(s)? Choose 2 answers
- A. SHOW TABLES;
- B. Information Schema -> TABLE_STORAGE_METRICS
- C. SHOW STORAGE BY TABLE;
- D. Information Schema -> TASLE_HISTORY
Answer: A,B
NEW QUESTION 99
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 ''24 hour'' on the percomputed results gets renewed every time the exact query is executed
- C. The exact query win ALWAYS return me precomputed result set for the RESULT_CACHE_ACTIVE = time period
- D. 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
Answer: C,D
NEW QUESTION 100
Which of the following best describes where Snowflake's metadata is stored?
- A. Inside the Virtual Warehouses
- B. In the Cloud Services Layer
- C. Within the data files
- D. within the drivers
Answer: B
NEW QUESTION 101
True or False: Bulk unloading of data from Snowflake supports the use of a SELECT statement.
- A. True
- B. False
Answer: A
NEW QUESTION 102
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 103
......
COF-C01 Exam Questions Get Updated [2023] with Correct Answers: https://www.validbraindumps.com/COF-C01-exam-prep.html
Pass COF-C01 Exam - Real Questions and Answers: https://drive.google.com/open?id=14GF9jH41fnbAjSkQX58CWqUmbKF5iKaX