



Study with the several resources on Docsity
Earn points by helping other students or get them with a premium plan
Prepare for your exams
Study with the several resources on Docsity
Earn points to download
Earn points by helping other students or get them with a premium plan
Community
Ask the community for help and clear up your study doubts
Discover the best universities in your country according to Docsity users
Free resources
Download our free guides on studying techniques, anxiety management strategies, and thesis advice from Docsity tutors
A series of multiple-choice questions designed to test understanding of key concepts related to snowflake, a cloud-based data warehousing platform. The questions cover topics such as storage relationships, data storage costs, compute costs, saas attributes, architecture, release frequency, and common tasks not required with snowflake. It provides a valuable resource for individuals seeking to assess their knowledge of snowflake's core features and functionalities.
Typology: Exams
1 / 6
This page cannot be seen from the preview
Don't miss anything!
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