PDF (New 2023) Actual Snowflake SnowPro-Core Exam Questions
Dumps Moneyack Guarantee - SnowPro-Core Dumps UpTo 90% Off
Snowflake SnowPro-Core Certification Exam is a challenging test that requires a deep understanding of Snowflake's architecture, features, and functionality. SnowPro-Core exam consists of multiple-choice questions and covers a broad range of topics, including database design, SQL queries, data loading, and data warehousing. SnowPro Core Certification Exam certification exam is designed to test the candidate's ability to use Snowflake to solve real-world business problems.
Snowflake SnowPro-Core certification exam is a rigorous exam that tests the candidates' knowledge of the Snowflake platform. SnowPro-Core exam covers a wide range of topics, including Snowflake architecture, data modeling, data loading and unloading, security and access control, and data warehousing best practices. Candidates who successfully pass the exam are awarded the SnowPro-Core certification, which is a testament to their skills and knowledge in using the Snowflake platform.
NEW QUESTION # 171
Snowflake provides two mechanisms to reduce data storage costs for short-lived tables. These mechanisms are:
Choose 2 answers
- A. Provisional Tables
- B. Permanent Tables
- C. Temporary Tables
- D. Transient Tables
Answer: C,D
NEW QUESTION # 172
Which of the following are best practice recommendations that should be considered when loading data into Snowflake? (Select TWO).
- A. Remove all dates and timestamps.
- B. Remove semi-structured data types
- C. Load files that are approximately 25 MB or smaller.
- D. Avoid using embedded characters such as commas for numeric data types
- E. Load files that are approximately 100-250 MB (or larger)
Answer: D,E
Explanation:
https://docs.snowflake.com/en/user-guide/data-load-considerations-prepare.html
NEW QUESTION # 173
Which Snowflake URL type is used by directory tables?
- A. Pre-signed
- B. File
- C. Virtual-hosted style
- D. Scoped
Answer: B
NEW QUESTION # 174
What happens to historical data when the retention period for an object ends?
- A. The object containing the historical data is dropped.
- B. The data moves to Fail-safe
- C. Time Travel on the historical data is dropped.
- D. The data is cloned into a historical object.
Answer: A
NEW QUESTION # 175
A Virtual Warehouse's auto-suspend and auto-resume settings apply to:
- A. The queries currently being run by the Virtual Warehouse
- B. The primary cluster in the Virtual Warehouse
- C. The database the Virtual Warehouse resides in
- D. The entire Virtual Warehouse
Answer: D
Explanation:
Explanation/Reference: https://docs.snowflake.com/en/user-guide/warehouses-overview.html
NEW QUESTION # 176
What can a Snowflake user do in the Activity section in Snowsight?
- A. Explore databases and objects.
- B. Create dashboards.
- C. Explore executed query performance.
- D. Write and run SQL queries.
Answer: C
NEW QUESTION # 177
True or False: Some queries can be answered through the metadata cache and do not require an active Virtual Warehouse.
- A. False
- B. True
Answer: B
Explanation:
Some aggregate queries are answered thru micro partitions metadata only not requiring any VW spin ups.
NEW QUESTION # 178
What is the minimum Snowflake edition required to create a materialized view?
- A. Enterprise Edition
- B. Virtual Private Snowflake Edition
- C. Business Critical Edition
- D. Standard Edition
Answer: A
Explanation:
Explanation
Materialized views require Enterprise Edition. To inquire about upgrading, please contact Snowflake Support
https://docs.snowflake.com/en/sql-reference/sql/create-materialized-view.html#:~:text=Materialized%20views%
NEW QUESTION # 179
Data storage for individual tables can be monitored using which commands and/or object(s)?
Choose 2 answers
- A. Information Schema -> TABLE_STORAGE_METRICS
- B. Information Schema -> TASLE_HISTORY
- C. SHOW TABLES;
- D. SHOW STORAGE BY TABLE;
Answer: B,C
NEW QUESTION # 180
What privileges are required to create a task?
- A. Many Snowflake DDLs are metadata operations only, and create task DDL can be executed without virtual warehouse requirement or task specific grants.
- B. The global privilege create task is required to create a new task.
- C. Tasks are created at the Application level and can only be created by the Account Admin role.
- D. The role must have access to the target schema and the create task privilege on the schema itself.
Answer: D
Explanation:
All tasks in a simple tree must have the same task owner (i.e. a single role must have the OWNERSHIP privilege on all of the tasks in the tree). All tasks in a simple tree must exist in the same schema.
https://docs.snowflake.com/en/user-guide/tasks-intro.html#creating-tasks
NEW QUESTION # 181
True or False: Snowflake charges additional fees to Data Providers for each Share they create.
- A. False
- B. True
Answer: B
Explanation:
Explanation/Reference: https://1amiydhcmj36tz3733v94f15-wpengine.netdna-ssl.com/wp-content/uploads/2017/08/ Enabling-new-products-and-services-with-Snowflake-Data-Sharing.pdf
NEW QUESTION # 182
Which of the following are benefits of micro-partitioning? (Select TWO)
- A. Micro-partitions cannot overlap in their range of values
- B. Micro-partitions can reduce the amount of I/O from object storage to virtual warehouses
- C. Micro-partitions can be defined on a schema-by-schema basis
- D. Micro-partitions are immutable objects that support the use of Time Travel.
- E. Rows are automatically stored in sorted order within micro-partitions
Answer: A,E
Explanation:
Explanation
https://docs.snowflake.com/en/user-guide/tables-clustering-micropartitions.html
NEW QUESTION # 183
Which command is used to unload data from a Snowflake table into a file in a stage?
- A. GET
- B. COPY INTO
- C. EXTRACT INTO
- D. WRITE
Answer: B
Explanation:
Explanation
https://docs.snowflake.com/en/user-guide/data-unload-snowflake.html#:~:text=Your%20User%20Stage-,Use%2
NEW QUESTION # 184
Which statement describes how Snowflake supports reader accounts?
- A. The users in a reader account can query data that has been shared with the reader account and can perform DML tasks.
- B. A consumer needs to become a licensed Snowflake customer as data sharing is only supported between Snowflake accounts.
- C. The SHOW MANAGED ACCOUNTS command will view all the reader accounts that have been created for an account.
- D. A reader account can consume data from the provider account that created it and combine it with its own data.
Answer: A
NEW QUESTION # 185
In the query profiler view for a query, which components represent areas that can be used to help optimize query performance? (Select TWO)
- A. Number of partitions scanned
- B. Percentage scanned from cache
- C. Bytes scanned
- D. Bytes sent over the network
- E. External bytes scanned
Answer: A,C
NEW QUESTION # 186
What is the minimum Snowflake edition that customers planning on storing protected information in Snowflake should consider for regulatory compliance?
- A. Standard
- B. Business Critical Edition
- C. Premier
- D. Enterprise
Answer: B
Explanation:
Explanation/Reference: https://docs.snowflake.com/en/user-guide/intro-editions.html
NEW QUESTION # 187
Which of the following connectors are available in the Downloads section of the Snowflake web Interface (UI)?
Choose 2 answers
- A. SnowSQL
- B. HIVE
- C. ODBC
- D. R
Answer: A,C
Explanation:
Reference: https://docs.snowflake.com/en/user-guide/connecting.html
NEW QUESTION # 188
Which of the following statements are true about Schemas in Snowflake? (Choose two.)
- A. Each Schema is contained within a Warehouse
- B. A Schema is a logical grouping of Database Objects
- C. A Database may contain one or more Schemas
- D. A Schema may contain one or more Databases
Answer: B,C
NEW QUESTION # 189
Which parameter prevents streams on tables from becoming stale?
- A. STALE_AFTER
- B. MAXDATAEXTENSIONTIMEINDAYS
- C. MTN_DATA_RETENTION_TTME_TN_DAYS
- D. LOCK_TIMEOUT
Answer: B
NEW QUESTION # 190
When is the result set cache no longer available? (Select TWO)
- A. When it has been 24 hours since the last query
- B. When another user executes the query
- C. When another warehouse is used to execute the query
- D. When the underlying data has changed
- E. When the warehouse used to execute the query is suspended
Answer: A,D
NEW QUESTION # 191
......
The SnowPro Core Certification exam is a valuable credential for professionals who work with Snowflake. It validates the skills and knowledge required to work effectively with Snowflake and can help professionals to advance their careers in the field of data analytics and business intelligence. With the growing demand for skilled Snowflake professionals, obtaining the SnowPro Core Certification is a smart investment for anyone looking to build a successful career in this field.
Updated Aug-2023 Pass SnowPro-Core Exam - Real Practice Test Questions: https://passleader.bootcamppdf.com/SnowPro-Core-exam-actual-tests.html