Validate your Skills with Updated SnowPro-Core Exam Questions & Answers and Test Engine
Tested & Approved SnowPro-Core Study Materials Download Free Updated 339 Questions
The SnowPro Core Certification Exam certification is widely recognized in the industry and has become a popular choice for professionals looking to validate their skills in data warehousing. SnowPro Core Certification Exam certification exam is designed to be challenging, and candidates need to have a strong understanding of Snowflake's architecture and features. The SnowPro-Core certification is a valuable asset for professionals looking to advance their careers in data warehousing and gain recognition for their expertise in Snowflake.
NEW QUESTION # 181
Which services does the Snowflake Cloud Services layer manage? (Choose two.)
- A. Compute resources
- B. Authentication
- C. Metadata
- D. Data storage
- E. Query execution
Answer: B,C
NEW QUESTION # 182
Which of the following statements about data sharing are true?
choose 2 answers
- A. All database objects can be included In a shared database
- B. Reader Accounts are created and funded by Data Prowlers
- C. New objects created by a Data Provider are automatically shared with existing Data Consumers & Reader Accounts
- D. Shared databases are read-only
Answer: B,D
NEW QUESTION # 183
True or False: Snowflake bills for a minimum of five minutes each time a Virtual Warehouse is started.
- A. True
- B. False
Answer: B
Explanation:
Reference: https://docs.snowflake.com/en/user-guide/credits.html
NEW QUESTION # 184
Which statements are true of micro-partitions?
Choose 2 answers
- A. They are stored compressed only if COMPRESS=TRUE on Table
- B. They are Immutable
- C. They are only encrypted in the Enterprise edition and above
- D. They are approximately 16MB in size
Answer: B,D
Explanation:
Reference: https://medium.com/weareservian/seeing-snow-for-the-first-time-snowflake-adventures-part-1-
731ddc983c69
NEW QUESTION # 185
Which of the following statements apply to Snowflake in terms of security? (Choose two.)
- A. Snowflake leverages a Role-Based Access Control (RBAC) model.
- B. Snowflake requires a user to configure an IAM user to connect to the database.
- C. All data in Snowflake is compressed.
- D. All data in Snowflake is encrypted.
- E. Snowflake can run within a user's own Virtual Private Cloud (VPC).
Answer: A,E
NEW QUESTION # 186
Which statement about billing applies to Snowflake credits?
- A. Credits are consumed based on the warehouse size and the time the warehouse is running
- B. Credits are consumed based on the number of credits billed for each hour that a warehouse runs
- C. Credits are billed per-minute with a 60-minute minimum
- D. Credits are used to pay for cloud data storage usage
Answer: A
Explanation:
Snowflake credits are used to pay for the consumption of resources on Snowflake. A Snowflake credit is a unit of measure, and it is consumed only when a customer is using resources, such as when a virtual warehouse is running, the cloud services layer is performing work, or serverless features are used.
https://docs.snowflake.com/en/user-guide/what-are-credits.html
NEW QUESTION # 187
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 only encrypted in the Enterprise edition and above
- D. They are approximately 16MB in size
Answer: B,D
Explanation:
Explanation/Reference: https://medium.com/weareservian/seeing-snow-for-the-first-time-snowflake-adventures-part-1-
731ddc983c69
NEW QUESTION # 188
What is the minimum Snowflake edition required to create a materialized view?
- A. Enterprise Edition
- B. Virtual Private Snowflake Edition
- C. Standard Edition
- D. Business Critical Edition
Answer: A
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%20require%20Enterprise%20Edition,upgrading%2C%20please%20contact%20Snowflake%20Support.
NEW QUESTION # 189
When can a Virtual Warehouse start running queries?
- A. Only during administrator defined time slots
- B. 12am-5am
- C. When its provisioning is complete
- D. After replication
Answer: C
Explanation:
https://docs.snowflake.com/en/user-guide/warehouses-overview.html
NEW QUESTION # 190
What is the following SQL command used for?
Select * from table(validate(t1, job_id => '_last'));
- A. To validate external table files in table t1 across all sessions
- B. To return errors from the last executed COPY command into table t1 in the current session
- C. To validate task SQL statements against table t1 in the last 14 days
- D. To validate a file for errors before it gets executed using a COPY command
Answer: B
NEW QUESTION # 191
True or False: Snowflake charges a premium for storing semi-structured data.
- A. True
- B. False
Answer: B
Explanation:
Reference:
https://snowflakecommunity.force.com/s/question/0D50Z00008ckwNuSAI/does-snowflakecharges- premium-for-storing-semi-structured-data
NEW QUESTION # 192
When should a multi-cluster warehouse be used in auto-scaling mode?
- A. When it is unknown how much compute power is needed
- B. When a large number of concurrent queries are run on the same warehouse
- C. If the runtime of the executed query is very slow
- D. If the select statement contains a large number of temporary tables or Common Table Expressions (CTEs)
Answer: B
NEW QUESTION # 193
When scaling up Virtual Warehouse by increasing Virtual Warehouse t-shirt size, you are primarily scaling for improved:
Select one.
- A. Concurrency
- B. Performance
Answer: B
Explanation:
Reference:
https://docs.snowflake.com/en/user-guide/warehouses-considerations.html#warehouse-resizing-improves-perform
NEW QUESTION # 194
Which data type can store more than one type of data structure?
- A. VARCHAR
- B. JSON
- C. BINARY
- D. VARIANT
Answer: D
NEW QUESTION # 195
In which scenarios would a user have to pay Cloud Services costs? (Select TWO).
- A. Compute Credits = 80 Credits Cloud Services = 5
- B. Compute Credits = 120 Credits Cloud Services = 10
- C. Compute Credits = 50 Credits Cloud Services = 10
- D. Compute Credits = 10 Credits Cloud Services = 9
- E. Compute Credits = 200 Credits Cloud Services = 26
Answer: A,B
NEW QUESTION # 196
What type of columns does Snowflake recommend to be used as clustering keys? (Select TWO).
- A. A column that is most actively used in selective filters
- B. A column with very high cardinality
- C. A VARIANT column
- D. A column with very low cardinality
- E. A column that is most actively used in join predicates
Answer: A,E
NEW QUESTION # 197
Which formats does Snowflake store unstructured data in? (Choose two.)
- A. XML
- B. BLOB
- C. GeoJSON
- D. Array
- E. Object
Answer: B,E
NEW QUESTION # 198
......
Regular Free Updates SnowPro-Core Dumps Real Exam Questions Test Engine: https://www.actualtests4sure.com/SnowPro-Core-test-questions.html
Practice Test Questions Verified Answers As Experienced in the Actual Test!: https://drive.google.com/open?id=1R9ZhQh7t53Zk7_ufNj5YO-z8cWZtci74
