Snowflake certification Study guides, Class notes & Summaries

Which of the below are considered as best practices while loading data into Snowflake? A. Compress the source files B. If format is in CSV, convert them into ORC C. Split large files into smaller files D. Isolate data loading workload into its own virtual warehouse - Answer- A. Compress the source files B. Split large files into smaller files C. Isolate data loading workload into its own virtual warehosue how query processing is done in Snowflake? A. It is done using storage layer ...

Which of the following are true of Multi-cluster warehouses? Select all that apply. 1) Adds clusters automatically based on query activity 2) Sizes each cluster optimally based on the queries 3) Scales down when query activity slows 4) Multi-cluster warehouses will never auto-suspend - Answer- 1) Adds clusters automatically based on query activity 3) Scales down when query activity slows Which of the following terms best describes Snowflake's data base architecture? 1) Columnar shared...

True or False: Data Storage is independent from compute? correct answers True True or False: All virtual warehouses have access to all data? correct answers True True or False: Al interactions with data are initialized through the services layer? correct answers True True or False: Multi-Cluster Warehouses support high concurrency? correct answers True True or False: Warehouses can be dynamically expanded to adjust to workloads? correct answers True Which layer provides centralize...

True or False: Data Storage is independent from compute? correct answers True True or False: All virtual warehouses have access to all data? correct answers True True or False: Al interactions with data are initialized through the services layer? correct answers True True or False: Multi-Cluster Warehouses support high concurrency? correct answers True True or False: Warehouses can be dynamically expanded to adjust to workloads? correct answers True Which layer provides centralize...

Snowflake Certification Cheat Sheet Exam Questions And Answers What is Snowflake? (key features) - ANS Analytic data warehouse SaaS offering - No hardware/installation/patching - No ongoing maintenance/tuning - Can't run privately (on-prem/hosted) Runs completely in the Cloud (AWS, Azure, GCP) - Has its own VPC Decoupled compute and storage (scaled compute does not need scaled storage) Snowflake Pricing (what determines unit cost, pricing model, editions features) - ANS...

Snowflake Certification Exam/222 Questions and Answers

Snowflake Snowpro Core Certification – Q&A

Which of the following are true of Multi-cluster warehouses? Select all that apply. 1) Adds clusters automatically based on query activity 2) Sizes each cluster optimally based on the queries 3) Scales down when query activity slows 4) Multi-cluster warehouses will never auto-suspend correct answers 1) Adds clusters automatically based on query activity 3) Scales down when query activity slows Which of the following terms best describes Snowflake's data base architecture? 1) Columnar ...

Which of the below are considered as best practices while loading data into Snowflake? A. Compress the source files B. If format is in CSV, convert them into ORC C. Split large files into smaller files D. Isolate data loading workload into its own virtual warehouse correct answers A. Compress the source files B. Split large files into smaller files C. Isolate data loading workload into its own virtual warehosue how query processing is done in Snowflake? A. It is done using storage ...

What is Snowflake? (key features) correct answers Analytic data warehouse SaaS offering - No hardware/installation/patching - No ongoing maintenance/tuning - Can't run privately (on-prem/hosted) Runs completely in the Cloud (AWS, Azure, GCP) - Has its own VPC Decoupled compute and storage (scaled compute does not need scaled storage) Snowflake Pricing (what determines unit cost, pricing model, editions features) correct answers Unit costs for Credits and data storage determined ...