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

  • 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 #11
True or False: The COPY command must specify a File Format in order to execute.
  1. A
    True
  2. B
    False

Correct Answer:
A
Reference:
https://interworks.com/blog/hcalder/2018/07/26/the-basics-of-loading-data-into-snowflake/

Question #12
Which of the following commands sets the Virtual Warehouse for a session?
  1. A
    COPY WAREHOUSE FROM <<config file>>;
  2. B
    SET WAREHOUSE = <<warehouse name>>;
  3. C
    USE WAREHOUSE <<warehouse name>>;
  4. D
    USE VIRTUAL_WAREHOUSE <<warehouse name>>;

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

Question #13
Which of the following objects can be cloned? (Choose four.)
  1. A
    Tables
  2. B
    Named File Formats
  3. C
    Schemas
  4. D
    Shares
  5. E
    Databases
  6. F
    Users

Correct Answer:
ACEF
chatbot-img GPT-4o - Answer
The correct clonable objects in Snowflake are Databases, Schemas, Tables, and File Formats. While Tables, Schemas, and Databases are commonly cloned within Snowflake for development and testing purposes, File Formats can also be cloned to maintain data ingestion consistency across different environments. The misconception about cloning Users arises from a misunderstanding; Snowflake does not allow the cloning of Users due to unique identifiers and permissions associated with each user account. Shares, similar to Users, are not clonable, as they pertain more to controlled access management rather than structural database components.

Question #14
Which object allows you to limit the number of credits consumed within a Snowflake account?
  1. A
    Account Usage Tracking
  2. B
    Resource Monitor
  3. C
    Warehouse Limit Parameter
  4. D
    Credit Consumption Tracker

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

Question #15
Snowflake is designed for which type of workloads? (Choose two.)
  1. A
    OLAP (Analytics) workloads
  2. B
    OLTP (Transactional) workloads
  3. C
    Concurrent workloads
  4. D
    On-premise workloads

Correct Answer:
AB
Reference:
https://blog.couchbase.com/its-the-workload-stupid/

Question #16
What are the three layers that make up Snowflake's architecture? (Choose three.)
  1. A
    Compute
  2. B
    Tri-Secret Secure
  3. C
    Storage
  4. D
    Cloud Services

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

Question #17
Why would a customer size a Virtual Warehouse from an X-Small to a Medium?
  1. A
    To accommodate more queries
  2. B
    To accommodate more users
  3. C
    To accommodate fluctuations in workload
  4. D
    To accommodate a more complex workload

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

Question #18
True or False: Reader Accounts incur no additional Compute costs to the Data Provider since they are simply reading the shared data without making changes.
  1. A
    True
  2. B
    False

Correct Answer:
B
Reference:
https://interworks.com/blog/bdu/2020/02/05/zero-to-snowflake-secure-data-sharing/

Question #19
Which of the following connectors allow Multi-Factor Authentication (MFA) authorization when connecting? (Choose all that apply.)
  1. A
    JDBC
  2. B
    SnowSQL
  3. C
    Snowflake Web Interface (UI)
  4. D
    ODBC
  5. E
    Python

Correct Answer:
ABCDE
Reference:
https://docs.snowflake.com/en/user-guide/security-mfa.html

Question #20
True or False: Snowflake charges a premium for storing semi-structured data.
  1. A
    True
  2. B
    False

Correct Answer:
B
Reference:
https://snowflakecommunity.force.com/s/question/0D50Z00008ckwNuSAI/does-snowflake-charges-premium-for-storing-semi-structured-data

Previous Questions Next Questions

All Pages