SnowPro-Core Exam Question & Answers: Loading Files into Snowflake Internal Stage
12 Questions
0 Views

Choose a study mode

Play Quiz
Study Flashcards
Spaced Repetition
Chat to Lesson

Podcast

Play an AI-generated podcast conversation about this lesson

Questions and Answers

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?

<p>Amazon Web Services, Microsoft Azure Cloud, Google Cloud Platform (B)</p> Signup and view all the answers

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

<p>Include the SQL statements in the body of the CREATE TASK statement (B)</p> Signup and view all the answers

What is the purpose of an Internal Stage in Snowflake?

<p>To load data from external sources into Snowflake tables (B)</p> Signup and view all the answers

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

<p>Create a stored procedure that executes multiple SQL statements and invoke it from a task (A)</p> Signup and view all the answers

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

<p>Set a default role for the user and force an immediate password change (A)</p> Signup and view all the answers

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

<p>SECURITYADMIN, ACCOUNTADMIN (D)</p> Signup and view all the answers

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

<p>SnowSQL and ODBC (C)</p> Signup and view all the answers

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

<p>Installing and configuring hardware, physical security, and maintaining metadata and statistics (B)</p> Signup and view all the answers

What characteristics of micro-partitions in Snowflake are true?

<p>They are approximately 16MB in size, stored compressed only if COMPRESS=TRUE, and immutable (B)</p> Signup and view all the answers

More Like This

Use Quizgecko on...
Browser
Open
Browser
Browser