SnowPro-Core Exam Question & Answers: Loading Files into Snowflake Internal Stage

Play an AI-generated podcast conversation about this lesson

Which command is used to load files into an Internal Stage within Snowflake?

COPY INTO

PUT (correct)

INSERT

TRANSFER

Which of the following operations are supported by the COPY command when loading data into Snowflake?

Joins and Filters

Data type conversions and Column reordering (correct)

Filters and Aggregates

Aggregates and Joins

Can Snowpipe via REST API reference Internal Stages as a source?

Depends on the cloud platform

False

Only for transient tables

True (correct)

On which cloud platforms can a Snowflake account be hosted?

Amazon Web Services, Microsoft Azure Cloud, Google Cloud Platform Signup and view all the answers

How would you execute a series of SQL statements using a Task in Snowflake?

Include the SQL statements in the body of the CREATE TASK statement Signup and view all the answers

What is the purpose of an Internal Stage in Snowflake?

To load data from external sources into Snowflake tables Signup and view all the answers

Which approach is recommended for executing multiple SQL statements in Snowflake?

Create a stored procedure that executes multiple SQL statements and invoke it from a task Signup and view all the answers

When creating a user in Snowflake, which of the following practices are advisable?

Set a default role for the user and force an immediate password change Signup and view all the answers

According to Snowflake's recommendations, which user roles should be enrolled in Multi-Factor Authentication (MFA)?

SECURITYADMIN, ACCOUNTADMIN Signup and view all the answers

Which connectors are available for download from the Snowflake web Interface (UI)?

SnowSQL and ODBC Signup and view all the answers

Which services does Snowflake automatically provide for customers, compared to on-premise systems?

Installing and configuring hardware, physical security, and maintaining metadata and statistics Signup and view all the answers

What characteristics of micro-partitions in Snowflake are true?

They are approximately 16MB in size, stored compressed only if COMPRESS=TRUE, and immutable Signup and view all the answers