What is the purpose of the COPY INTO SQL command?

To load data from a stage into a table

To copy data into a virtual warehouse

To copy data from one table into another

To load data from a stage into a table

To duplicate all files on a stage

What does a red checkmark next to a cell in a Snowflake notebook signify?

The cell has completed execution successfully

What is the LIST command used for in Snowflake?

Lists all the files in a given stage.

Lists all the users assigned to a given role.

Lists all the files in a given stage.

Lists all the tables in a specific schema.

Lists all the privileges granted on a specific object.

What is the purpose of the Public Schema in Snowflake? (Choose any 2 options)

Providing a default schema for new objects

Storing shared resources accessible by all users

Providing a default schema for new objects

Schema to store Account level meta data

Storing shared resources accessible by all users

View SOL-C01 Exam Questions

Q: 1

Changing the size of a virtual warehouse from a Medium to a Large refers to what type of warehouse tuning?

Options

Q: 2

What are Snowflake customers responsible for?

Options

Correct Answer:

Explanation

Snowflake operates on a shared responsibility model as a Software-as-a-Service (SaaS) platform. Snowflake is responsible for managing all underlying infrastructure, including hardware, software installation, patches, and updates. The customer's primary responsibility is the data itself. This includes choosing what data to load into Snowflake, performing the loading and unloading operations, managing data transformations, and controlling access to that data through Snowflake's security features.

Why Incorrect

A. Snowflake is a fully managed service; it manages all hardware and physical infrastructure.

B. Snowflake automatically manages all software installation, patching, and version updates for the customer.

C. Snowflake's metadata layer automatically manages all metadata about database objects; customers do not manage this directly.

References

1. Snowflake Documentation. (n.d.). Snowflake Architecture. Retrieved from https://docs.snowflake.com/en/user-guide/intro-key-concepts. "Snowflake is a true SaaS offering... Snowflake manages all aspects of software installation and updates."

2. Snowflake Documentation. (n.d.). Key Concepts & Architecture. Retrieved from https://docs.snowflake.com/en/user-guide/intro-key-concepts#database-storage. "When data is loaded into Snowflake, Snowflake reorganizes that data into its internal optimized, compressed, columnar format." This highlights the customer's role in initiating the data load.

3. Snowflake Inc. (2020). The Snowflake Elastic Data Warehouse. In Proceedings of the 2020 ACM SIGMOD International Conference on Management of Data (p. 2155). https://doi.org/10.1145/3318464.3386125. The paper describes Snowflake as a "fully managed service," implying infrastructure management is handled by the vendor, leaving data management to the customer.

Q: 3

What are virtual warehouses in Snowflake?

Options

Q: 4

What is the name for a Snowflake account holder who shares data with other Snowflake accounts?

Options

Correct Answer:

Explanation

In the context of Snowflake's Secure Data Sharing, the account that creates a share object and makes its data available to other accounts is officially termed a "data provider." The provider maintains full ownership and control over the shared data, including granting and revoking access. The accounts that are granted access to the share and can query the data are known as "data consumers." This provider-consumer model is fundamental to how data is shared securely across different Snowflake accounts.

Why Incorrect

B. A data consumer is the account that receives or accesses the shared data, not the one that shares it.

C. "Data reader" is a descriptive term but not the official Snowflake terminology for an account in a sharing relationship.

D. A data administrator is a role within an account (e.g., ACCOUNTADMIN) responsible for management, not the term for the account itself in a sharing context.

References

- Snowflake Documentation. (n.d.). Introduction to Secure Data Sharing. In Secure Data Sharing. Retrieved from https://docs.snowflake.com/en/user-guide/data-sharing-intro. "With Secure Data Sharing, no actual data is copied or transferred between accounts. All sharing is accomplished through Snowflake’s unique services layer and metadata store. This is an important concept because it means that shared data does not take up any storage in a consumer account and, therefore, does not contribute to the consumer’s monthly data storage charges. The only charges to consumers are for the compute resources (i.e. virtual warehouses) used to query the shared data." The page further defines the roles of Provider and Consumer accounts.

Q: 5

What command can be used to load data from an external stage to a table?

Options

Premium Access Includes

FLASH OFFER

avail 10% DISCOUNT on YOUR PURCHASE