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. 5)

  • 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 #41
Increasing the maximum number of clusters in a Multi-Cluster Warehouse is an example of:
  1. A
    Scaling rhythmically
  2. B
    Scaling max
  3. C
    Scaling out
  4. D
    Scaling up

Correct Answer:
D
chatbot-img GPT-4o - Answer
The correct term for increasing the maximum number of clusters in a multi-cluster warehouse in Snowflake is "scaling out." This action distributes the workload across more clusters rather than increasing the resources (like CPU and memory) of a single cluster, which would be "scaling up." It's imperative not to mix these two distinct methods of scaling, as each tackles different performance and capacity aspects.

Question #42
Which statement best describes Snowflake tables?
  1. A
    Snowflake tables are logical representations of underlying physical data
  2. B
    Snowflake tables are the physical instantiation of data loaded into Snowflake
  3. C
    Snowflake tables require that clustering keys be defined to perform optimally
  4. D
    Snowflake tables are owned by a user

Correct Answer:
A
Reference:
https://docs.snowflake.com/en/user-guide/tables-micro-partitions.html

Question #43
Which item in the Data Warehouse migration process does not apply in Snowflake?
  1. A
    Migrate Users
  2. B
    Migrate Schemas
  3. C
    Migrate Indexes
  4. D
    Build the Data Pipeline

Correct Answer:
C
chatbot-img GPT-4o - Answer
For the SnowPro Core exam, remember that Snowflake's architecture does not utilize traditional indexing methods like other databases. Instead, Snowflake organizes data into micro-partitions and uses metadata for processing queries efficiently, making the concept of migrating indexes non-applicable in their environment. So, understanding the unique storage and retrieval mechanisms in Snowflake is crucial.

Question #44
Snowflake provides two mechanisms to reduce data storage costs for short-lived tables. These mechanisms are: (Choose two.)
  1. A
    Temporary Tables
  2. B
    Transient Tables
  3. C
    Provisional Tables
  4. D
    Permanent Tables

Correct Answer:
AB
Reference:
https://docs.snowflake.com/en/user-guide/tables-storage-considerations.html

Question #45
What is the maximum compressed row size in Snowflake?
  1. A
    8KB
  2. B
    16MB
  3. C
    50MB
  4. D
    4000GB

Correct Answer:
B
chatbot-img GPT-4o - Answer
Snowflake indeed allows a maximum compressed row size of up to 16MB. This limit applies when dealing with semi-structured data types, like VARIANT, where each row can handle up to 16MB in size, inclusive of any other data within the same row. This size limitation is crucial for optimizing data processing and storage efficiency within the platform.

Question #46
Which of the following are main sections of the top navigation of the Snowflake Web Interface (UI)? (Choose three.)
  1. A
    Databases
  2. B
    Tables
  3. C
    Warehouses
  4. D
    Worksheets

Correct Answer:
ACD
Reference:
https://docs.snowflake.com/en/user-guide/snowflake-manager.html

Question #47
What is the recommended Snowflake data type to store semi-structured data like JSON?
  1. A
    VARCHAR
  2. B
    RAW
  3. C
    LOB
  4. D
    VARIANT

Correct Answer:
D
Reference:
https://docs.snowflake.com/en/sql-reference/data-types-semistructured.html

Question #48
Which of the following statements are true of Snowflake releases: (Choose two.)
  1. A
    They happen approximately weekly
  2. B
    They roll up and release approximately monthly, but customers can request early release application
  3. C
    During a release, new customer requests/queries/connections transparently move over to the newer version
  4. D
    A customer is assigned a 30 minute window (that can be moved anytime within a week) during which the system will be unavailable and customer is upgraded

Correct Answer:
CD
chatbot-img GPT-4o - Answer
The correct understanding of Snowflake's release management outlines that during updates, existing customer queries and connections are seamlessly handled without downtime because they're moved transparently to the newly updated version. Additionally, there is a designated upgrade window, typically 30 minutes, which customers can reschedule within a week for minor disruptions. This ensures continuity and reliability in service while deploying the latest functionalities and security updates. These mechanisms are crucial in the agile yet stable operational fabric of Snowflake, allowing businesses to adopt innovations swiftly without impacting their ongoing operations.

Question #49
Which of the following are common use cases for zero-copy cloning? (Choose three.)
  1. A
    Quick provisioning of Dev and Test/QA environments
  2. B
    Data backups
  3. C
    Point in time snapshots
  4. D
    Performance optimization

Correct Answer:
ABC
Reference:
https://community.snowflake.com/s/question/0D50Z00009C3VlMSAV/zero-copy-cloning

Question #50
If a Small Warehouse is made up of 2 servers/cluster, how many servers/cluster make up a Medium Warehouse?
  1. A
    4
  2. B
    16
  3. C
    32
  4. D
    128

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

Previous Questions Next Questions

All Pages