Ask Question
COF-R02: SnowPro Core Recertification
Snowflake
Exam Questions:
330
.png)
2.370 Learners
Related questions
A materialized view should be created when which of the following occurs? (Choose two.)
Unlock Premium Member
What is the default character set used when loading CSV files into Snowflake?
Explanation:
https://docs.snowflake.com/en/user-guide/intro-summaryloading.html#:~:text=For%20delimited%20files%20(CSV%2C%20TSV,encoding%20to%20use%20for%20loading.
For delimited files (CSV, TSV, etc.), the default character set is UTF-8. To use any other characters sets, you must explicitly specify the encoding to use for loading. For the list of supported character sets, see Supported Character Sets for Delimited Files (in this topic).
Which query profile statistics help determine if efficient pruning is occurring? (Choose two.)
A virtual warehouse's auto-suspend and auto-resume settings apply to which of the following?
Explanation:
https://docs.snowflake.com/en/user-guide/warehousesoverview.html#:~:text=Similarly%2C%20auto%2Dresume%20ensures%20that,individual%20clusters%20in%20the%20warehouse.
Which of the following terms best describes Snowflake’s database architecture?
Explanation:
https://www.snowflake.com/product/architecture/
Built from the ground up for the cloud, Snowflake’s unique multi-cluster shared data architecture delivers the performance, scale, elasticity, and concurrency today’s organizations require.
Which privilege is required for a role to be able to resume a suspended warehouse if auto-resume is not enabled?
What is the maximum total Continuous Data Protection (CDP) charges incurred for a temporary table?
Which of the following are best practices for loading data into Snowflake? (Choose three.)
A company's security audit requires generating a report listing all Snowflake logins (e.g.. date and user) within the last 90 days. Which of the following statements will return the required information?
What are the three layers that make up Snowflake’s architecture?
Choose 3 answer
Explanation:
Reference: https://docs.snowflake.com/en/user-guide/intro-key-concepts.html
Question