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</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</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</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</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</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</p> Signup and view all the answers

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

    <p>SnowSQL and ODBC</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</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</p> Signup and view all the answers

    More Like This

    Use Quizgecko on...
    Browser
    Open
    Browser
    Browser