Nest 0 Cart
Nest Account
Popular Exams
All Categories...
Nest
Nest 0
Contact
Log In / Sign Up
Copyright 2024 © store. All rights reserved.
Home Snowflake SnowPro Core

Snowflake SnowPro Core Exam Practice Questions (P. 3)

  • Full Access (1152 questions)
  • Six months of Premium Access
  • Access to one million comments
  • Seamless ChatGPT Integration
  • Ability to download PDF files
  • Anki Flashcard files for revision
  • No Captcha & No AdSense
  • Advanced Exam Configuration
Get Contributor Access
Question #21
Which of the following statements describes a benefit of Snowflake's separation of compute and storage? (Choose all that apply.)
  1. A
    Growth of storage and compute are tightly coupled together
  2. B
    Storage expands without the requirement to add more compute
  3. C
    Compute can be scaled up or down without the requirement to add more storage
  4. D
    Multiple compute clusters can access stored data without contention

Correct Answer:
BCD
chatbot-img GPT-4o - Answer
In Snowflake, separating storage from compute allows flexibility and cost-efficiency. Specifically, storage can grow independent of compute resources, allowing for economical data scalability. Additionally, compute can be adjusted based on processing needs without altering storage, offering seamless performance scaling. Furthermore, the architecture supports multiple compute clusters accessing the same data without interference, enhancing concurrent data operations and analytics. These elements provide a highly adaptable platform catering to varying organizational needs.

Question #22
True or False: It is possible to unload structured data to semi-structured formats such as JSON and Parquet.
  1. A
    True
  2. B
    False

Correct Answer:
A
Reference:
https://docs.snowflake.com/en/user-guide/data-unload-prepare.html

Question #23
In which layer of its architecture does Snowflake store its metadata statistics?
  1. A
    Storage Layer
  2. B
    Compute Layer
  3. C
    Database Layer
  4. D
    Cloud Services Layer

Correct Answer:
D
Reference:
https://hevodata.com/blog/snowflake-architecture-cloud-data-warehouse/

Question #24
True or False: Data in fail-safe can be deleted by a user or the Snowflake team before it expires.
  1. A
    True
  2. B
    False

Correct Answer:
B
Reference:
https://blog.knoldus.com/ksnow-time-travel-and-fail-safe-in-snowflake/

Question #25
True or False: Snowflake's data warehouse was built from the ground up for the cloud in lieu of using an existing database or a platform, like Hadoop, as a base.
  1. A
    True
  2. B
    False

Correct Answer:
B
Reference:
https://docs.snowflake.com/en/user-guide/intro-key-concepts.html

Question #26
Which of the following statements are true of Virtual Warehouses? (Choose all that apply.)
  1. A
    Customers can change the size of the Warehouse after creation
  2. B
    A Warehouse can be resized while running
  3. C
    A Warehouse can be configured to suspend after a period of inactivity
  4. D
    A Warehouse can be configured to auto-resume when new queries are submitted

Correct Answer:
BC
Reference:
https://docs.snowflake.com/en/user-guide/warehouses-multicluster.html

Question #27
The PUT command: (Choose two.)
  1. A
    Automatically creates a File Format object
  2. B
    Automatically uses the last Stage created
  3. C
    Automatically compresses files using Gzip
  4. D
    Automatically encrypts files

Correct Answer:
CD
Reference:
https://docs.snowflake.com/en/sql-reference/sql/put.html

Question #28
Which type of table corresponds to a single Snowflake session?
  1. A
    Temporary
  2. B
    Transient
  3. C
    Provisional
  4. D
    Permanent

Correct Answer:
A
chatbot-img GPT-4o - Answer
Temporary tables in Snowflake are specifically designed to exist solely within the session they were created. They disappear once the session ends, ensuring data privacy and session-specific calculations without affecting the broader database environment. This makes them perfectly suited for scenarios requiring temporary data storage that is session-bound.

Question #29
Which interfaces can be used to create and/or manage Virtual Warehouses?
  1. A
    The Snowflake Web Interface (UI)
  2. B
    SQL commands
  3. C
    Data integration tools
  4. D
    All of the above

Correct Answer:
B
Reference:
https://docs.snowflake.com/en/user-guide/warehouses.html

Question #30
When a Pipe is recreated using the CREATE OR REPLACE PIPE command:
  1. A
    The Pipe load history is reset to empty
  2. B
    The REFRESH parameter is set to TRUE
  3. C
    Previously loaded files will be ignored
  4. D
    All of the above

Correct Answer:
B
chatbot-img GPT-4o - Answer
When a pipe is recreated using the CREATE OR REPLACE PIPE command, contrary to the initial assumption, the REFRESH parameter is not involved. Instead, the load history of the pipe is reset. This is crucial because any previous load operations' history is removed, potentially affecting subsequent operations if files were not appropriately managed in the staging area. Therefore, when recreating a pipe, considering the management of previously and newly staged files is vital to prevent data duplication. This understanding aligns with Snowflake’s official documentation.

Previous Questions Next Questions

All Pages