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

  • 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 #31
What is the minimum Snowflake edition that customers planning on storing protected information in Snowflake should consider for regulatory compliance?
  1. A
    Standard
  2. B
    Premier
  3. C
    Enterprise
  4. D
    Business Critical Edition

Correct Answer:
D
Reference:
https://docs.snowflake.com/en/user-guide/intro-editions.html

Question #32
Select the three types of tables that exist within Snowflake. (Choose three.)
  1. A
    Temporary
  2. B
    Transient
  3. C
    Provisional
  4. D
    Permanent

Correct Answer:
ABD
Reference:
https://community.snowflake.com/s/article/Making-Transient-table-by-Default

Question #33
True or False: Snowpipe via REST API can only reference External Stages as source.
  1. A
    True
  2. B
    False

Correct Answer:
B
Reference:
https://community.snowflake.com/s/article/Making-Transient-table-by-Default

Question #34
True or False: A third-party tool that supports standard JDBC or ODBC but has no Snowflake-specific driver will be unable to connect to Snowflake.
  1. A
    True
  2. B
    False

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

Question #35
True or False: It is possible to load data into Snowflake without creating a named File Format object.
  1. A
    True
  2. B
    False

Correct Answer:
A
Reference:
https://docs.snowflake.com/en/user-guide/data-load-external-tutorial-create-file-format.html

Question #36
True or False: A table in Snowflake can only be queried using the Virtual Warehouse that was used to load the data.
  1. A
    True
  2. B
    False

Correct Answer:
B
chatbot-img GPT-4o - Answer
Yep, B is definitely correct. Here's the thing: in Snowflake, any virtual warehouse, regardless of who loaded the data, can query that same data. Even better, if the data is cached, querying doesn't even require a running warehouse—sweet deal for efficiency and savings!

Question #37
Which of the following statements are true of Snowflake data loading? (Choose three.)
  1. A
    VARIANT ג€nullג€ values are not the same as SQL NULL values
  2. B
    It is recommended to do frequent, single row DMLs
  3. C
    It is recommended to validate the data before loading into the Snowflake target table
  4. D
    It is recommended to use staging tables to manage MERGE statements

Correct Answer:
ACD
chatbot-img GPT-4o - Answer
Indeed, when dealing with data loading in Snowflake, it's pivotal to understand that VARIANT data types treat 'null' values differently than traditional SQL NULL values. This distinction is critical for handling semistructured data efficiently. Additionally, employing staging tables is a best practice for managing merge operations effectively, ensuring that data transformations are handled smoothly and reliably before hitting the target table. Lastly, always validate your data before loading to minimize errors and ensure data integrity. These practices are essential for leveraging Snowflake’s capabilities optimally.

Question #38
Which statements are true of micro-partitions? (Choose two.)
  1. A
    They are approximately 16MB in size
  2. B
    They are stored compressed only if COMPRESS=TRUE on Table
  3. C
    They are immutable
  4. D
    They are only encrypted in the Enterprise edition and above

Correct Answer:
AC
Reference:
https://medium.com/weareservian/seeing-snow-for-the-first-time-snowflake-adventures-part-1-731ddc983c69

Question #39
True or False: Query ID's are unique across all Snowflake deployments and can be used in communication with Snowflake Support to help troubleshoot issues.
  1. A
    True
  2. B
    False

Correct Answer:
B
chatbot-img GPT-4o - Answer
Query IDs in Snowflake are indeed unique identifiers assigned to each query across all Snowflake deployments. These IDs serve as a critical tool for tracking and managing queries within the system. When you face issues or unexpected results, sharing the Query ID with Snowflake Support can significantly ease the troubleshooting process. This unique ID allows the support team to pinpoint and analyze the exact query in question, facilitating a more efficient resolution.

Question #40
A deterministic query is run at 8am, takes 5 minutes, and the results are cached. Which of the following statements are true? (Choose two.)
  1. A
    The exact query will ALWAYS return the precomputed result set for the RESULT_CACHE_ACTIVE = time period
  2. B
    The same exact query will return the precomputed results if the underlying data hasn't changed and the results were last accessed within previous 24 hour period
  3. C
    The same exact query will return the precomputed results even if the underlying data has changed as long as the results were last accessed within the previous 24 hour period
  4. D
    The ג€24 hourג€ timer on the precomputed results gets renewed every time the exact query is executed

Correct Answer:
BD
chatbot-img GPT-4o - Answer
Correct, options B and D accurately reflect how Snowflake’s result cache works. For option B, it's vital to recognize that if there is no change to the underlying data and the cached results are accessed within 24 hours, the query will utilize the precomputed results. Option D correctly notes that each time the exact same query is executed, the 24-hour freshness timer for the cached results is reset, effectively renewing the availability of the cache if it's used within this timeframe. This ensures efficient data retrieval without repeated processing, given the specified conditions are met.

Previous Questions Next Questions

All Pages