Download Snowflake Key Concept Exam Questions and more Exams Computer Science in PDF only on Docsity!
Snowflake Key Concept Exam Questions
Which statements are true about storage relationships? Select the correct options from the list
A. Snowflake Tables are stored within Schemas. B. Snowflake Databases are stored within Warehouses C. Snowflake Warehouses are stored within Data Marts D. Snowflake Schemas are stored within Warehouses E. Snowflake Warehouses are stored within Databases F. Snowflake Schemas are stored within Databases - ✔ ✔ A. Snowflake Tables are stored within Schemas. F. Snowflake Schemas are stored within Databases When a warehouse is resized, which queries make use of the new size? Select the correct options from the list
A. Both current and subsequent queries B. Only currently running queries C. Only subsequent queries - ✔ ✔ C. Only subsequent queries Snowflake data storage costs are calculated based on:
Select the correct options from the list
A. Uncompressed Size B. Compressed Size C. Amount Stored on Last Day of Month D. Amount Stored on First Day of Month E. Amount Stored - Daily Average - ✔ ✔ B. Compressed Size E. Amount Stored - Daily Average Snowflake data storage costs include which types of data? Select the correct options from the list
A. Metadata B. Persistent data stored in permanent tables C. Data retained to enable data recovery (time travel and fail-safe) D. Cached results E. Semi-structured data - additional fees - ✔ ✔ B. Persistent data stored in permanent tables C. Data retained to enable data recovery (time travel and fail-safe) Snowflake compute costs depend on which of the following? Select the correct options from the list
Select the correct options from the list
A. Microsoft Cloud Native Accounts B. Snowflake-Hosted Accounts (on Amazon cloud infrastructure) C. Hybrid On-Premise + Cloud Installation D. Enterprise In-House VPC Installation E. On-Premise Custom Installation F. Snowflake-Hosted Accounts (on Azure cloud infrastructure) - ✔ ✔ B. Snowflake-Hosted Accounts (on Amazon cloud infrastructure) F. Snowflake-Hosted Accounts (on Azure cloud infrastructure) Which ONE of the following terms BEST describes Snowflake's Architecture? Select the correct options from the list
A. Shared Disk B. Shared Nothing C. Shared Data D. Shared Memory - ✔ ✔ C. Shared Data How often does Snowflake release new features? Select the correct options from the list
A. Bi-Annually B. Yearly C. Weekly D. Never - ✔ ✔ C. Weekly What common tasks for traditional on-premise database and IT staff, are not required with Snowflake? Select the correct options from the list
A. Maintaining metadata B. Maintaining statistics C. Maintaining the physical security of a server room (key cards, door locks, etc) D. Maintaining database objects - ✔ ✔ A. Maintaining metadata B. Maintaining statistics C. Maintaining the physical security of a server room (key cards, door locks, etc) Which of the following terms or phrases can also be used to describe Snowflake? Select the correct options from the list
