Docsity
Docsity

Prepare for your exams
Prepare for your exams

Study with the several resources on Docsity


Earn points to download
Earn points to download

Earn points by helping other students or get them with a premium plan


Guidelines and tips
Guidelines and tips

Snowflake Key Concept Exam Questions, Exams of Computer Science

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

2024/2025

Available from 03/24/2025

Shantelle
Shantelle 🇺🇸

5

(2)

3K documents

1 / 6

Toggle sidebar

This page cannot be seen from the preview

Don't miss anything!

bg1
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:
pf3
pf4
pf5

Partial preview of the text

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