SnowPro-Core Practice Exam and Study Guides - Verified By PracticeTorrent Updated 164 Questions
2022 Updated Verified Pass SnowPro-Core Study Guides & Best Courses
How to book the SnowPro Core Certification
To apply for the SnowPro Core Certification, You have to follow these steps:
- Attempt the exam whenever you want
- Click Enroll and log in to your Snowpro account
- Click Add to Cart and complete your registration/purchase
What is the duration, language, and format of SnowPro Core Certification
- No negative marking for wrong answers
- Duration of Exam: 120 minutes
- Type of Questions: Multiple choice (MCQs), multiple answers
- Language of Exam: English, Japanese, Korean
NEW QUESTION 15
As a best practice, clustering keys should only be defined on tables of which minimum size?
- A. Multi-Gigabyte (GB) Range
- B. Multi-Terabyte (TB) Range
- C. Multi-Kilobyte (KB) Range
- D. Multi-Megabyte (MB) Range
Answer: B
NEW QUESTION 16
Which is true of Snowflake network policies? A Snowflake network policy: (Choose two.)
- A. Restricts or enables access to specific IP addresses
- B. Is activated using an "ALTER DATABASE" command
- C. Is only available to customers with Business Critical Edition
- D. Is available to all Snowflake Editions
Answer: A,D
NEW QUESTION 17
Which of the following statements about data sharing are true?
choose 2 answers
- A. New objects created by a Data Provider are automatically shared with existing Data Consumers & Reader Accounts
- B. Shared databases are read-only
- C. All database objects can be included In a shared database
- D. Reader Accounts are created and funded by Data Prowlers
Answer: B,D
NEW QUESTION 18
True or False: Snowpipe via RFST API can only reference External Stages as source.
- A. True
- B. False
Answer: A
NEW QUESTION 19
Which of the following statements are true of Snowflake releases: (Choose two.)
- A. 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
- B. They roll up and release approximately monthly, but customers can request early release application
- C. During a release, new customer requests/queries/connections transparently move over to the newer version
- D. They happen approximately weekly
Answer: A,C
NEW QUESTION 20
Which of the following items does the Cloud services Layer manage?
Choose 4 answers
- A. user authentication
- B. external blob storage
- C. Query compilation and optimization
- D. Data security
- E. Metadata
Answer: A,C,D,E
NEW QUESTION 21
True or False: A Virtual Warehouse consumes Snowflake credits even when inactive.
- A. True
- B. False
Answer: B
NEW QUESTION 22
Which of the following are options when creating a Virtual Warehouse?
- A. Local SSD size
- B. Auto-resume
- C. User count
- D. Auto-suspend
Answer: B,D
NEW QUESTION 23
True or False: Each worksheet in the Snowflake Web Interface (UI) can be associated with different roles, databases, schemas, and Virtual Warehouses.
- A. True
- B. False
Answer: B
NEW QUESTION 24
Which of the following are options when creating a virtual Warehouse?
Choose 2 answers
- A. Auto-resume
- B. Auto-drop
- C. Auto resize
- D. Auto-suspend
Answer: A,D
NEW QUESTION 25
Which of the following statements describes a benefit of Snowflake's separation of compute and storage?
(Choose all that apply.)
- A. Growth of storage and compute are tightly coupled together
- B. Compute can be scaled up or down without the requirement to add more storage
- C. Multiple compute clusters can access stored data without contention
- D. Storage expands without the requirement to add more compute
Answer: B,C,D
NEW QUESTION 26
Which of the following statements is true of Snowflake micro-partitioning?
- A. Micro-partitioning has been known to introduce data skew
- B. Micro-partitioning is transparently completed using the ordering that occurs when the data is inserted/loaded
- C. Micro-partitioning can be disabled within a Snowflake account
- D. Micro-partitioning: requires a partitioning schema to be defined up front
Answer: B
NEW QUESTION 27
Which of the following statements is true of zero-copy cloning?
- A. All zero-copy clone objects inherit the privileges of their original objects
- B. Zero-copy clones increase storage costs as cloning the table requires storing its data twice
- C. Zero-copy cloning is licensed as an additional Snowflake feature
- D. At the instance/instant a clone is created, all micro-partitions in the original table and the clone are fully shared
Answer: D
Explanation:
Explanation/Reference: https://community.snowflake.com/s/question/0D50Z00009D8VOd/zero-copy-cloning-base-data
NEW QUESTION 28
When should you consider disabling auto-suspend for a Virtual Warehouse?
Choose 2 answers
- A. When users will be using compute at different times throughout a 24/7 period
- B. When managing a steady workload
- C. When you don't want to have to manually turn on the Warehouse each time a user needs it
- D. When the compute must be available with no delay or lag time
Answer: B,D
NEW QUESTION 29
The PUT command: (Choose two.)
- A. Automatically uses the last Stage created
- B. Automatically compresses files using Gzip
- C. Automatically creates a File Format object
- D. Automatically encrypts files
Answer: B,D
Explanation:
Explanation/Reference: https://docs.snowflake.com/en/sql-reference/sql/put.html
NEW QUESTION 30
Which statements are true of micro-partitions? (Choose two.)
- A. They are stored compressed only if COMPRESS=TRUE on Table
- B. They are immutable
- C. They are approximately 16MB in size
- D. They are only encrypted in the Enterprise edition and above
Answer: B,C
Explanation:
Explanation/Reference: https://medium.com/weareservian/seeing-snow-for-the-first-time-snowflake-adventures-part-1-
731ddc983c69
NEW QUESTION 31
......
Ultimate Guide to the SnowPro-Core - Latest Edition Available Now: https://www.practicetorrent.com/SnowPro-Core-practice-exam-torrent.html
2022 Updated Verified Pass SnowPro-Core Exam - Real Questions & Answers: https://drive.google.com/open?id=1HnvltYc_u8bTR7bBxerTJRkeD0um8AYB