Snowflake SnowPro Core Certification SNOWPRO-CORE Questions & Answers

• Question 11:

  True or False: Snowflake charges additional fees to Data providers for each share they create.

  A. True

  B. False

  Correct Answer: B

  "The costs for sharing data with Snowflake are minimal and straightforward. Data providers simply pay Snowflake for the data they store, and data consumers pay for the compute resources their queries consume."

• Question 12:

  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. Storage expands without the requirement to add more compute

  C. Compute can be scaled up or down without the requirement to add more storage

  D. Multiple compute clusters can access stored data without contention

  Correct Answer: BCD

  Reference: https://towardsdatascience.com/why-you-are-throwing-money-away-if-your-cloud-data-warehousedoesnt-separate-storage-and-compute-65d2dffd450f

• Question 13:

  True or False: All Snowflake table types include fail-safe storage.

  A. True

  B. False

  Correct Answer: B

• Question 14:

  True or False: When data share is established between a Data Provider and a data Consumer, the Data Consumer can extend that data share to other Data Consumers.

  A. True

  B. False

  Correct Answer: B

  Reference: https://docs.snowflake.com/en/user-guide/data-sharing-intro.html

• Question 15:

  Which of the following best describes where Snowflake's metadata is stored?

  A. Within the data files

  B. Inside the Virtual Warehouses

  C. In the Cloud Services Layer

  D. within the drivers

  Correct Answer: C

• Question 16:

  Which of the following statement is true of Snowflake? Select one.

  A. It was built specifically for the cloud

  B. it was built as an on-premises solution and then potted to the cloud

  C. It was designed as a hybrid database to allow customers to store data either on premises or in the cloud

  D. It was built for Hadoop architecture

  E. It's based on an Oracle Architecture

  Correct Answer: A

• Question 17:

  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.

  A. True

  B. False

  Correct Answer: B

  https://docs.snowflake.com/en/user-guide/jdbc.html

  Snowflake provides a JDBC type 4 driver that supports core JDBC functionality. The JDBC driver must be installed in a 64-bit environment and requires Java 1.8 (or higher). The driver can be used with most client tools/applications that support JDBC for connecting to a database server.

• Question 18:

  Which Snowflake function will interpret an input string as a JSON document, and produce a VARIANT value?

  A. parse_json()

  B. json_extract_path_text()

  C. object_construct()

  D. flatten

  Correct Answer: A

• Question 19:

  Which statement describes how Snowflake supports reader accounts?

  A. A reader account can consume data from the provider account that created it and combine it with its own data.

  B. A consumer needs to become a licensed Snowflake customer as data sharing is only supported between Snowflake accounts.

  C. The users in a reader account can query data that has been shared with the reader account and can perform DML tasks.

  D. The SHOW MANAGED ACCOUNTS command will view all the reader accounts that have been created for an account.

  Correct Answer: D

  https://docs.snowflake.com/en/sql-reference/sql/show-managed-accounts.html

• Question 20:

  Which Snowflake tool would be BEST to troubleshoot network connectivity?

  A. SnowCLI

  B. SnowUI

  C. SnowSQL

  D. SnowCD

  Correct Answer: D

  https://docs.snowflake.com/en/user-guide/snowcd.html#:~:text=SnowCD%20(i.e.%20Snowflake%20Connectivity%20Diagnostic,their%20network%20connection%20to%20Snowflake.